Skip to Content
0
Former Member
Oct 24, 2013 at 10:29 AM

ORA-00060: deadlock detected while waiting for resource

6719 Views

HI,

I have getting short dump(ST22) when i run my DTP.

In the short dump it says , ORA-00060 error. i have applied the sap note 84348, but still am facing the issue. i am attaching a part of the dump

I have checked that DTP is running in

Processing mode :- parallel extration and processing

Extraction mode :- Full

Parallel Extration is checked.

And number of parallel batch jobs is 3.

SAPNW 7.3

Database :- oracle 11g

And we are using partition table

After the batch job completion(some failed due to dump and oters finished. ) the request is showing in yellow but when i access the request id to check which datapackage fails it turns red. is it due to the locks ??

Tried to run the DTP in process chain but same issue.

Need your help.

below is part of dump which i found relevant, can post more if anybody require more data to analyse the issue.

Error analysis

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 "WRITE_ICFACT" "(FORM)", nor was it propagated by a RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

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

Database Interface Information

C 1 Client NLS setting (by OCINlsGetInfo(con=1)): 'AMERICAN_AMERICA.UTF16' [dboci.c#2854]
C 1 Client NLS setting (by OCINlsGetInfo(con=1)): 'AMERICAN_AMERICA.UTF16' [dboci.c#2854]
C 1 Logon as OPS$-user to get SAPSR3's password [dbsloci.c#12550]
C 1 Connecting as /@BD4 on connection 1 (nls 0) ... (dbsl 720 291112, UNICODE[2]) [dbsloci.c#15268
C 1 Starting user session: OCISessionBegin(con=1, usr='/', svc=0616AE48, srv=07F3E258, usr=0689C48
C 1 OCIStmtExecute() failed with -1=OCI_ERROR [dboci.c#4454]
C 1 SQL error 942: [dboci.c#4455]
C 1 Could not read session ID from V$MYSTAT. rc=-1. [dbsloci.c#16115]
C 1 Now '/@BD4' is connected: con=1, nls=0, session=-1, time='2013-10-24 14:12:00' [dbsloci.c#1529
C 1 OCIStmtExecute() failed with -1=OCI_ERROR [dboci.c#4454]
C 1 SQL error 1031: [dboci.c#4455]
C E ORA-1031 when updating table SAPUSER [dbsloci.c#15929]
C 1 Got SAPSR3's password from OPS$-user [dbsloci.c#12557]
C 1 Disconnecting from connection 1 ... [dbsloci.c#15355]
C 1 Closing user session (con=1, svc=0616AE48, usr=0689C488) [dboci.c#3371]
C 1 Disconnected (con=1) from ORACLE. [dbsloci.c#15372]
C 1 Connecting as SAPSR3/<pwd>@BD4 on connection 1 (nls 0) ... (dbsl 720 291112, UNICODE[2]) [dbsl
C 1 Starting user session: OCISessionBegin(con=1, usr='SAPSR3', svc=0616AE48, srv=07F3E258, usr=06
C 1 Now 'SAPSR3/<pwd>@BD4' is connected: con=1, nls=0, session=658, time='2013-10-24 14:12:00' [db
C 1 DB instance BD4 is running on SIDCDEV01 with ORACLE version 11.2.0.3.0 since SEP 08, 2013, 01:
C 1 con=1, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8 [dbsloci.c#15730]
C 1 Nls CharacterSet NationalCharSet EnvHp ErrHp
C 1 0 UTF16 AL16UTF16 07F34010 07F3B
B 1 Connection 1 opened (DBSL handle 1) [dbcon.c#4312]
C 1 OCIStmtExecute() failed with -1=OCI_ERROR [dboci.c#4454]
C 1 SQL error 60: [dboci.c#4455]
C E Error 60 in stmt_execute() from oci_execute_stmt(), orpc=942 [dbsloci.c#17261]
C E ORA-00060 occurred at SQL stmt (parse error offset=0) [dbsloci.c#17262]
C 1 Dump statement cache: [dbsloci.c#17262]
C 1 sc_p=0000000007F04D20,no=32,idc_p=0000000007F23820,con=0,act=1,slen=116,smax=1024,#vars=15,stm
C 1 INSERT INTO "/BI0/F0JVA_C01" VALUES(:A0 ,:A1 ,:A2 ,:A3 ,:A4 ,:A5 ,:A6 ,:A7 ,:A8 ,:A9 ,:A10 ,:A
C 1 12 ,:A13 ,:A14 ); [dbsc.c#2318]
C 1 Dump statement cache: [dbsloci.c#12251]
C 1 sc_p=0000000007F04D20,no=32,idc_p=0000000007F23820,con=0,act=1,slen=116,smax=1024,#vars=15,stm
C 1 Dumping stmt. cache (DBSL private attributes): [dbsloci.c#16677]
C 1 sc=07F04D20, scp=07F0F310, ups_sc=0000NULL, stp=64F481E8, r_c=0 [dbsloci.c#16679]
C 1 prep=0, lit=0, nsql=0, lobret_cnt=0, fae_cnt=0, xop=78, dbcount=942 [dbsloci.c#16684]
C 1 IN : col_cnt=15, row_max=942, row_xcnt=942, row_pcnt=0, row_i=0, row_total=942, [dbsloci.c#16
C 1 row_upto=4294967295, row_size=108, vda_max=32, bound=1, itp=07EE7560, vda_arr=64FB8A40 [d
C 1 lob_cnt=0, lob_max=0, lob_pw_cnt=0, lob_arr=0000NULL, rows_ret=0 [dbsloci.c#16708]

OUT: col_cnt=58, row_max=92, row_xcnt=0, row_pcnt=0, row_i=0, row_total=0, [dbsloci.c#16694]

row_upto=0, row_size=1292, vda_max=128, bound=0, itp=0000NULL, vda_arr=653B30A0 [dbsloci.

lob_cnt=0, lob_max=0, lob_pw_cnt=0, lob_arr=0000NULL, rows_ret=0 [dbsloci.c#16708]

INSERT INTO "/BI0/F0JVA_C01" VALUES(:A0 ,:A1 ,:A2 ,:A3 ,:A4 ,:A5 ,:A6 ,:A7 ,:A8 ,:A9 ,:A10 ,:A

12 ,:A13 ,:A14 ); [dbsc.c#2318]

***LOG BYO=> deadlock aborts transaction [dbsh#1190]

SQL code: 60, SQL text: ORA-00060: deadlock detected while waiting for resource [dbsh.c#1198]

***LOG BY4=> sql error 60 performing INS on table /BI0/F0JVA_C01 [dbtran#7

***LOG BY0=> ORA-00060: deadlock detected while waiting for resource [dbtran#7634]

dbtran ERROR LOG (hdl_dbsl_error): DbSl 'INS' [dbtran.c#7698]

RSLT: {dbsl=99, tran=1} [dbtran.c#7698]

FHDR: {tab='/BI0/F0JVA_C01', fcode=130, mode=1, bpb=0, dbcnt=0, crsr=0, [dbtran.c#7698]

hold=0, keep=1, xfer=1, pkg=0, upto=0, init:b=0, [dbtran.c#7698]

init:p=0000000000000000, init:#=0, wa:p=0000000000000000, wa:#=92} [dbtran.c#7698]

dbtran ERROR LOG (hdl_dbsl_error): DbSl 'INS' [dbtran.c#7729]

STMT: {stmt:#=0, bndfld:#=0, prop=0x1, distinct=0, [dbtran.c#7729]

fld:#=15, alias:p=0000000000000000, fupd:#=0, tab:#=0, where:#=0, [dbtran.c#7729]

groupby:#=0, having:#=0, order:#=0, primary=0, hint:#=0} [dbtran.c#7729]

CRSR: {tab='', id=0, hold=0, prop=0x10004, max.in@0=0, fae:blk=0, [dbtran.c#7729]

con:id=0, con:vndr=5, val=2, [dbtran.c#7729]

key:#=9, xfer=1, xin:#=942, row:#=0, upto=0, wa:p=0X000007DF0876E53C} [dbtran.c#7729]