SAP Knowledge Base Article - Preview

2462701 - Job /SDF/UPL_PERIODIC_EXT_JOB fails with ORA-00054

Symptom

The batchjob /SDF/UPL_PERIODIC_EXT_JOB is failing frequently with error ORA-00054. In the developer trace (dev_w* files), the errors are similar to the following:

C  check2: OCIStmtExecute() failed with -1=OCI_ERROR
C          SQL error 54:
C  *** ERROR => Error 54 in exec_immediate() from oci_execute_stmt(), orpc=0
 [dbsloci.c    13594]
C  {root-id=00215A9B03A81ED6BA811FE49FFA6257}_{conn-id=587665F33E3605F7E10000000ABD1C23}_5
C  *** ERROR => ORA-00054 occurred at SQL stmt (parse error offset=15)
 [dbsloci.c    13595]
C  {root-id=00215A9B03A81ED6BA811FE49FFA6257}_{conn-id=587665F33E3605F7E10000000ABD1C23}_5
C  Dump statement cache (after SQL error):
C  sc_p=7e019f8,no=125,idc_p=(nil),con=0,act=0,slen=24,smax=1024,#vars=0,stmt=86bb3d0,table=
C  TRUNCATE TABLE "COVRES" ;
C     statement (len=24) for table '                              ':
C         TRUNCATE TABLE "COVRES"
C     exec_immediate() -> orc=54, 99=DBSL_ERR_DB
C  head_p=7ffdf07f33b0, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1011
C  *** ERROR => ^^ Ds_exec_imm() -> err=1=DS_SQLERR
 [dbdsoci.c    1024]
C  {root-id=00215A9B03A81ED6BA811FE49FFA6257}_{conn-id=587665F33E3605F7E10000000ABD1C23}_5
B  ***LOG BY2=> sql error 54 performing EXE [dbds         578]
B  ***LOG BY0=> ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired [dbds         578]
B  ***LOG BY2=> sql error 54 performing EXE [dbacds       1154]

PS: all numbers, except for the ORA error 54, may vary from system to system. The error will never be exactly the same.


Read more...

Environment

  • SAP Systems based on NetWeaver;
  • Oracle Database;

Product

SAP NetWeaver all versions

Keywords

RSCVR_TRIGGER_COLLECT, NW, ORCL, CCM, NOWAIT, scheduled job, daily, periodic job, 00054, COVRES, ORA, TRUNCATE , KBA , BC-DB-ORA , Oracle , BC-ABA-LA , Syntax, Compiler, Runtime , BC-DB-ORA-DBA , Database Administration , SV-SMG-CCM , Custom Code Management , BC-DWB-TOO-COV , Coverage Analyzer , 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.