SAP Knowledge Base Article - Preview

1944924 - Deadlock ORA-00060 during parallel loading/activation of BW ODS object

Symptom

The following dump happens when you are loading to/from a DSO or when you are activating a DSO:

Category               Installation error
Runtime Errors         DBSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB

Short Text: SQL error "SQL code: 0" occurred while accessing table table_name.

Database error text: "SQL message: ORA-00060: deadlock detected while waiting for resource"


Read more...

Environment

SAP BW Systems with Oracle database

Product

SAP NetWeaver all versions

Keywords

Caller 70, DEADLOCK, dump, ora0060, bitmap, indexes, DBIF_RSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB, RSDRO108, RSDRO 108, RSM1185, RSM1 185, PROCESS_BUFFER_TABLES , KBA , BW-WHM-DBA-DSO , DataStore Object (classic) , BW-SYS-DB-ORA , BW ORACLE , BC-DB-ORA , Oracle , Problem

About this page

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

Search for additional results

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