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, the following 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"

In systems running on DB6 database, the following runtime error (short dump) might occur:

Category Resource Shortage
Runtime Errors DBIF_REPO_SQL_ERROR
SQL error "-99999" occurred when accessing program "SAPLFAGL_ITEMS_SELECT_BW "

Error Text of the Database: "CLI0106E Connection is closed. SQLSTATE=08003"
"FAGL_BLOCK_SELECT_RANGES"


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
  • SAP S/4HANA

Product

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 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

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.