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.