זמן ריצה איטי בשאילתה דרך BO

1344187 - How To Force The Business Objects Reports And Queries Not To Lock Database Tables
Symptom
How to avoid database table locking while running WebIntelligence reports or DesktopIntelligence reports created on a universe.
Environment
• SAP BusinessObjects Enterprise XIR2
• SAP BusinessObjects Enterprise XIR3.0
• SAP BusinessObjects Enterprise XIR3.1
• SAP BusinessObjects Enterprise BI 4
Reproducing the Issue
1. Run a long running Web Intelligence report
2. Run a second Web Intelligence report.
3. Note the second report waits for the first to complete.
Cause
By default the database transaction level in a Universe connection is set to the Isolation Level ‘Read Committed’, which applies a read lock on the database tables while running the reports. For the Reporting database connections it is possible to change the transaction level.
NOTE: It is currently only possible to set a global parameter for each database reporting used. This cannot be set at the universe level or at the connection level. This does not apply to the CMS database!
Resolution
Log on to the Business Objects Server machine and apply the following settings to set ‘Transaction Isolation Level’ for Business Objects
1) To force Business Objects not to lock SQL server database tables we have to set its isolation level to ‘READ UNCOMMITTED’.
2) To set this you have to modify/add the following parameter in rdbms.sbo data access configuration file based on the connection used at universe level. This file may be different depending on the database connection. For example Oracle will be oracle.sbo. For MSSQL – odbc.sbo (if using ODBC connection type) , oledb.sob (if using OLEDB connection)
<Parameter Name="Transaction Isolation Level">READ UNCOMMITTED</Parameter>
3) <rdbms>.sbo file can be found in the following directory, please take a back of the existing file before you make the changes mentioned
R2: <Installation Directory>:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\rdbms
R3: <Installation Directory>:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\rdbms
BI4: <Installation Directory>:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\rdbms
4) To make these changes effect, you have to restart ‘CMS server’, ‘the Connection Servers’, ‘Webi Report Server’ from ‘Central Configuration Manager’ (CCM).