SAP Knowledge Base Article - Preview

2397636 - 0FI_GL_14 delta performance: composite reference

Symptom

You notice a long running process when extracting delta data with DataSource 0FI_GL_14.

In extreme cases, the poor performance might result in the following runtime error (short dump):

Category ABAP Programming Error
Runtime Errors TIME_OUT
ABAP Program SAPLFAGL_ITEMS_SELECT_BW
"TIME_OUT" " "
"SAPLFAGL_ITEMS_SELECT_BW" or "LFAGL_ITEMS_SELECT_BWU01"
"FAGL_GET_LINE_ITEMS"

In systems running on Oracle database, another runtime error (short dump) might occur:

Category Installation Errors
Runtime Errors DBIF_RSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
SQL error 1555 when accessing table "FAGLFLEXA".

Error Text of the Database: "ORA-01555: snapshot too old: rollback segment number (...) too small"

Read more...

Environment

  • Source System of BW system
  • SAP R/3
  • SAP R/3 Enterprise 4.7
  • SAP ERP Central Component
  • SAP ERP
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA

Product

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

Keywords

0FI_GL_14, delta, hang, delay, stuck, slowness, DBIF_RSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB, FAGLFLEXA, 1555, SAPLFAGL_ITEMS_SELECT_BW, LFAGL_ITEMS_SELECT_BWU01, FAGL_GET_LINE_ITEMS, ORA-01555, performance, OPEN_CURSOR, JOIN_FLEXA_BKPF_AEDAT, JOIN_FLEXA_BKPF , KBA , BW-BCT-FI-GL , BW only - General Ledger , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.