SAP Knowledge Base Article - Preview

1186745 - SQL Deadlocks and Isolation Level for Web Intelligence

Symptom

  • Sql Server Deadlocks on Webi
  • How do you change the database transaction isolation level for a Microsoft SQL Server database connection to Read Uncommitted?
  • The following error occurs when running a report based on MS SQL: 
Database Error (Microsoft SQL Server Native Client 10) Transaction
(Process ID 110) was deadlocked on lock | Communication Buffer
resources with another process that has been chosen as deadlock victim.
Rerun the transaction (IES 10901) ( Error: INF)

Read more...

Environment

  • SAP BusinessObjects Business Intelligence
  • Web Intelligence

Product

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

Keywords

biSL bi41 bi4.0 bi4.1 bi4.x database isolation transaction level deadlock dead lock victim ms sql server read committed uncommitted , KBA , BI-RA-WBI , Web Intelligence , BI-BIP-SL , Semantic Layer , 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.