Symptom
The following error occurs during the delta extraction of 0EC_PCA_3:
Error during delta extraction: DataSource 0EC_PCA_3 RODPS_SAPI 012
START_EXTRACTION 0EC_PCA_3 RSQU 052
INIT_PHASE 0EC_PCA_3
Exception occurred in line 1.111 of include GP_GLX_GLPCA (program GP_GLX_GLPCA) SODQ140
Exception UNCAUGHT_EXCEPTION occurred in line 1.043 of include GP_GLX_GLPCA (program GP_GLX_GLPCA) SODQ 140
Exception occurred in line 224 of include CL_RODPS_DATASOURCE_MODEL=====CM006 (program CL_RODPS_DATASOURCE_MODEL=====CP)
Meanwhile, if checking the dev trace of the extraction ODQR*D job, you'll see the error below:
C ORA-01555: snapshot too old: rollback segment number 15 with name "_SYSSMU15_xxxxxxxxxx$" too small
C *** ERROR => Error 1555 in stmt_fetch() from oci_fetch_stmt(), orpc=3651
C *** ERROR => ORA-01555 occurred at SQL stmt (parse error offset=54525952)
The same ORA-01555 may also occur on any other datasources.
Read more...
Environment
- Target independent ( SAP NetWeaver, SAP BW/4HANA...)
- SAP R/3
- SAP R/3 Enterprise
- SAP ERP
- SAP ERP Central Component
- SAP enhancement package for SAP ERP
- SAP enhancement package for SAP ERP, version for SAP HANA
- SAP S/4HANA
Product
SAP BW/4HANA all versions ; SAP ERP Central Component all versions ; SAP ERP all versions ; SAP NetWeaver 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
KBA , BC-DB-ORA , Oracle , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , BW-BCT-EC-PCA , BW only - Profit Center Accounting , 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.
SAP Knowledge Base Article - Preview