Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

Hi All,

I got dump as

Database error text........: "ORA-00060: deadlock detected while waiting for

resource"

Internal call code.........: "[RSQL/RDUP/NRIV ]"

Please check the entries in the system log (Transaction SM21).

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "READ_NRIV" "(FORM)", nor was it propagated by a RAISING clause.

Can u ppl tell me how to get correct this?

Edited by: Bala Chandar on Jul 20, 2009 11:01 AM

5 REPLIES 5

g_srivastava
Active Contributor
0 Kudos

Hi Bala,

Please check the SAP Note Number 722188 and SAP Note Number 590370.Hope your query resolves soon.

Have a best day ahead.

0 Kudos

Hi Srivastava,

Its mentioned with partitioning , wt I have 2 do exactly, can u be a bit more in detail plz...?

Edited by: Bala Chandar on Jul 20, 2009 11:32 AM

Edited by: Bala Chandar on Jul 20, 2009 11:39 AM

Edited by: Bala Chandar on Jul 20, 2009 11:50 AM

Edited by: Bala Chandar on Jul 20, 2009 12:02 PM

0 Kudos

Hi Bala,

Please check the following thread which contains the solution for the same error.Hope it will help you a bit.

Link: [List|https://www.sdn.sap.com/irj/scn/advancedsearch?query=ora-00060].

Have a best day ahead.

former_member189845
Active Participant
0 Kudos

Hi Bala,

Same type of dump we got when we trigger the DTP which in process chain to load data from DSO to Info cube. And the load had processed with 225 data package and at 164th data package we got this error and except 164th data package all data package processed successfully

And the request was red. So we had done processed manually by clicking the icon. So all its been green and successfully loaded.

So when you do process manual the particular data package which got failed will be process successfully  

0 Kudos

Delete the Index and load to Info Cube. This error wont appear again.