SAP Knowledge Base Article - Preview

1790406 - Does Transaction Isolation Level READ UNCOMMITTED Impact CMS Connections?

Symptom

  • Does the Transaction Isolation level READ UNCOMMITTED in .SBO file affect the CMS database?
  • What if the CMS database uses the same ODBC connection?
  • For dirty reads from reporting database following parameter is set in the ODBC.SBO JDBC.SBO or SqlSRV.sbo

<Parameter Name="Transaction Isolation Level">READ UNCOMMITTED</Parameter>

Does it affect the CMS database which is set to READ Committed by default?


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform
  • Web Intelligence

Product

SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

biSL deadlocks dead locks , KBA , BI-BIP-SL , Semantic Layer , BI-RA-WBI , Web Intelligence , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.