SAP Knowledge Base Article - Preview

2973781 - SQL message: ORA-00060: while executing a delete job for a CO-PA archiving object

Symptom

While executing a delete job from the archiving object COPAA_XXXX, the below dump is displayed.

"DBSQL_SQL_ERROR" CX_SY_OPEN_SQL_DB
"RK4AXXXX_DEL" bzw. RK4XXXXB_DEL
"DELETE_RECORDS"

SQL error "SQL code: 0" occurred while accessing table "CE1XXXX".    (XXXX: operating concern).

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

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • Controlling (CO)
  • SAP R/3
  • SAP R/3 Enterprise 
  • SAP ERP Central Component
  • SAP ERP
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA Finance
  • SAP S/4HANA

Product

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 all versions ; SAP S/4HANA Finance all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

Sara, deletion runs, Actual line items, , KBA , CO-PA , Profitability Analysis , How To

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.