SAP Knowledge Base Article - Preview

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

Symptom

  • 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).


Read more...

Environment

FI-CA - Contract Accounts Receivable and Payable

Product

SAP Contract Accounts Receivable and Payable all versions

Keywords

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 , Contract Accounting , 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

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.