ORA-00060 deadlocks when loading data into InfoCubes

When running DTPs on infocubes with an Oracle DB, a shor dump can occur wit as message:

Runtime error: DBIF_RSQL_SQL_ERROR
Exception: CX_SY_OPEN_SQL_DB
Short text: SQL error 60 while accessing table “/BIC/F<cube name>”
What happened: Database error text: “ORA-00060: deadlock detected while waiting for resource#ORA-00060: deadlock detected while waiting for resource”

This type of errer is explained in Note 631668 – DEADLOCK when loading data into InfoCubes.

 

Solution: Drop cube index before running DTP and recreate index after.

Leave a Reply