2903081 - DBSQL_SQL_ERROR or TIME_OUT dump when running payroll with declustering

• You execute a payroll run that includes declustering of the payroll results.
• After some time, the execution results in one of the following dumps:

1. DBSQL_SQL_ERROR 

Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
 

Short Text
 SQL error "SQL code: -51" occurred while accessing table &
What happened?
 Database error text: "SQL message: POS(1) Lock request timeout"


OR

Short Text
 SQL error "SQL code: -911" occurred while accessing table "P2RX_BT". 
What happened?
 Database error text: "SQL message: SQL0911N  The current transaction has been rolled back because
 of a deadlock or timeout.  Reason code "2" SQLSTATE=40001 row=1"  

2. TIME_OUT
   

   Category ABAP Programming Error
   Runtime Errors TIME_OUT
   ABAP Program CL_HRDCT_DATA=================CP
   
   Short Text
     Time limit exceeded
    
   What happened?
     Program "CL_HRDCT_DATA=================CP" has exceeded the maximum
     uninterrrupted runtime and has
     therefore been terminated.

• If the program is executed in the background, you will see the following message in the job log:
  

  Internal session terminated with a runtime error DBSQL_SQL_ERROR (see ST22)

Read more...

• Human Capital Management (HCM)
• SAP enhancement package for SAP ERP
• SAP enhancement package for SAP ERP, version for SAP HANA

SAP ERP 6.0 ; SAP ERP Central Component 6.0 ; SAP enhancement package 7 for SAP ERP 6.0 ; SAP enhancement package 8 for SAP ERP 6.0 ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

DBSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB, MaxDB, st22, dump, internal session terminated, runtime error, lock request timeout, sql code, -51 , KBA , PY-XX-PYP , Payroll Control Center , Problem