2397636 - 0FI_GL_14 delta performance: composite reference

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. SQ7
CLI0108E or SQL30081N

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

Category               Installation error
Runtime Errors         DBSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB

SQL error "SQL code: -911" occurred while accessing table "ROOSPRMSC".

Database error text: "SQL message: SQL0911N  The current transaction has been
 rolled back because of a deadlock or timeout.  Reason code "68".
 SQLSTATE=40001 row=1"

"DBSQL_SQL_ERROR" CX_SY_OPEN_SQL_DB
"SAPLRSA8" bzw. LRSA8U11
"RSA1_DELTA_REQUEST_WRITE"

Read more...

• 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

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

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