SAP Knowledge Base Article - Preview

3808161 - Long-running mapping in informatica with ORA-01555

Symptom

  • A data integration/mapping task that typically completes within a minute takes significantly longer to finish.
  • The following error appears in logs: "FnName: Fetch Optimize -- [Informatica][ODBC Oracle Wire Protocol driver][Oracle]ORA-01555: snapshot too old: rollback segment number 17 with name "_SYSSMU17_2193005587$" too small"


Read more...

Environment

  • SAP Sales Performance Management
  • Incentive Management

Product

SAP Incentive Management all versions

Keywords

ORA-01555, snapshot too old, long running mapping, slow mapping, informatica, ODBC Oracle Wire Protocol driver, Fetch Optimize, database statistics, gather stats, EXT schema, TCMP schema, runtime delay, mapping performance, oracle undo, incentive management , KBA , CEC-SAL-COM-INT , Application Integration , 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.