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 , ABAP Syntax, Compiler, Runtime , BC-DB-ORA-DBA , Database Administration with Oracle , 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 ONE Support launchpad (Login required).

Search for additional results

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