2462701 - Job /SDF/UPL_PERIODIC_EXT_JOB fails with ORA-00054 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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


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     statement (len=24) for table '                              ':
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.



  • SAP Systems based on NetWeaver;
  • Oracle Database;


SAP NetWeaver all versions


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 , BC-DWB-TOO-COV , Coverage Analyzer , SV-SMG-CCM , Custom Code Management , 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.