SAP Knowledge Base Article - Preview

1186745 - SQL Deadlocks and Isolation Level for Web Intelligence

Symptom

  • NO Locks from Table
  • 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 11) 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 platform
  • Web Intelligence
  • Information Design Tool (IDT)
  • Universe Design Tool (UDT)

Product

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

Keywords

biSL NO Locks , database isolation transaction level , deadlock , dead lock victim , read committed , uncommitted , KBA , BI-RA-WBI , Web Intelligence , BI-BIP-SL , Semantic Layer , BI-BIP-IDT , Information design tool , BI-BIP-UDT , Universe Design Tool , 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.