Business objects locking database tables

[Former Member]

when running a report in webi it is locking the database tables.

Is this a normal behavior with BO ? or do we need to set anything to avoid this behavior.

Please guide me. Thanks in advance

[Former Member · Accepted solution]

Hi Surendra,

This issue is might be due to dirty reead set on the connection level following solution might be helpful for resolving the issue.

Edit the SBO file for your RDBMS. These files are located in the RDBMS folder under the BusinessObjects folder. The available parameters are:

Lock Mode=

This is for Oracle. Set it to four ("4") (default) to receive an error message, or zero ("0") for the user to wait for resources.

TxnIsolation=

This is for any ODBC database and Informix Connect (when set to 256 or 257).

Set this value to zero ("0") to use no isolation or one ("1") for uncommitted 'dirty' read for ODBC, or 256 for a dirty read for I-Connect.

Note: Try the setting of zero ("0") first, and if it does not work then use one ("1"). Here are some other settings for this parameter:

2 = read committed. Specifies that each row is committed once it is retrieved.

4 = repeatable read. Specifies that each row has a shared lock during a transaction. Another process may acquire a shared lock, but no other transaction may modify the selected row until the previous transaction is committed or rolled back.

8 = serializable. Specifies that each row has a shared lock during a transaction. Another process may acquire a shared lock, but no other transaction may modify the selected row until the previous transaction is committed or rolled back. Serializable is used for an ANSI-compliant database.

Regards,

Sarbhjeet Kaur

[Former Member · Accepted solution]

Thanks Sarabjeet