SAP Knowledge Base Article - Preview

2449979 - Large Initial Load fails and Framework log prints error ORA-1555 – snap shot too old

Symptom

  • With large Initial Load, when executing a reptask/flowggaph or via SQL, we get output like

SAP DBTech JDBC: [403]: internal error: Remote execution error: Error occured when getting next row from ResultSet for query.

  • DPAgent framework.trc file will print error saying:

Error occurred when getting next row from ResultSet.
java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number xx with name "xxxxxxxx" too small


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA 1.0 smart data integration ; SAP HANA 1.0, platform edition ; SAP HANA smart data integration 2.0 ; SAP HANA, platform edition 2.0

Keywords

ORA-1555, OracleLogReader Adapter, OracleECCAdapter , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.