2451768 - FPG1M/FPG1: Runtime Error DBSQL_SQL_ERROR NRIV / performance issue

• In transactions 
    FPG1 (Transfer of FI-CA Totals Records to General Ledger) 
      or 
    FPG1M (General Ledger Transfer - Mass Run)
  one of the following symptoms occur:
  
  - a dump is raised:
  

  Category               Installation error
  Runtime Errors      DBSQL_SQL_ERRO
  Except.                  CX_SY_OPEN_SQL_DB

  |Short Text
  |   SQL error "SQL code: 131" occurred while accessing table "NRIV".
  |   Database error text: "SQL message: transaction rolled back by lock wait
  |   timeout: Lock timeout occurs while waiting RECORD_LOCK of mode
  |   EXCLUSIVE...

  
  |Error analysis
  |   An exception has occurred which is explained in more detail below. The
  |   exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in
  |   procedure
  |   "READ_NRIV" "(FORM)", nor was it propagated by a RAISING clause.
  |   Since the caller of the procedure could not have anticipated this
  |   exception, the current program was terminated.
  |   The reason for the exception is:
  |   Database error text: SQL message: transaction rolled back by lock wait
  |   timeout: Lock timeout occurs while waiting RECORD_LOCK of mode
  |   EXCLUSIVE(TRANSACTION_ID=..., UPDATE_TRANSACTION_ID=...)
  |   Return value of the database layer: "SQL dbsl rc: 99"
  |   "DBSQL_SQL_ERROR" CX_SY_OPEN_SQL_DB

  |   "SAPLSNR3" bzw. LSNR3F01
  |   "READ_NRIV"

  |>>>>>|      SELECT SINGLE FOR UPDATE * FROM  nriv
  |  231|             INTO  ls_nriv
  |  232|             WHERE object    = ls_nriv-object
  |  233|               AND subobject = ls_nriv-subobject
  |  234|               AND nrrangenr = ls_nriv-nrrangenr
  |  235|               AND toyear    = ls_nriv-toyear.

  |PS_NRIV-OBJECT
  |    RF_BELEG
  |PS_NRIV-SUBOBJECT
  |    1035
  |PS_NRIV-NRRANGENR
  |    01

  - the performance is bad (due to access of table NRIV with object RF_BELEG).

FI-CA - Contract Accounts Receivable and Payable

RFKKGL00, AC_DOCUMENT_POST, SAPLRWCL, FI_DOCUMENT_POST, NUMBER_GET_NEXT, READ_NRIV, NRIV, Event 1767, FKK_SAMPLE_1767, FKK_TRANSFER_MASS, Short Dump, Übernahme der FI-CA Summensätze in das Hauptbuch, Übernahme Hauptbuch - Massenlauf, Abstimmschlüssel, Zeitpunkt, FKK_SAMPLE_0943, Laufzeitfehler , KBA , XX-PROJ-FI-CA , obsolete: Please use Component FI-CA instead , IS-U-CA , Contract Accounts Receivable and Payable , IS-T-CA , Contract Accounting , FS-CD , Collections and Disbursements , IS-PS-CA , Public Sector Contract Accounting , IS-M-CA , Contract Accounts Receivable and Payable , FI-CAX , Non-industry specific contract accounts receivable, payable , Problem