SAP Knowledge Base Article - Preview

2117160 - runtime error DBIF_RSQL_INVALID_RSQL in various FI-CA mass transactions

Symptom

In various FI-CA mass activities a runtime error with the following information is raised:

  • Runtime Error: DBIF_RSQL_INVALID_RSQL or DBSQL_STMNT_TOO_LARGE
  • Exception: CX_SY_OPEN_SQL_DB
  • Short Text: Error in module RSQL of the database interface or Open SQL command is too big
  • Possible error causes:
    • The maximum size of an SQL statement was exceeded.
    • The statement contains too many input variables.
    • The input data requires more space than is available.


Read more...

Environment

  • Release: SAP R/3 4.6C and following
  • FI-CA - Contract Accounts Receivable and Payable

Product

SAP Contract Accounts Receivable and Payable 4.64 ; SAP Contract Accounts Receivable and Payable 4.71 ; SAP Contract Accounts Receivable and Payable 4.72 ; SAP ERP 6.0 ; SAP enhancement package 1 for SAP ERP 6.0 ; SAP enhancement package 2 for SAP ERP 6.0 ; SAP enhancement package 3 for SAP ERP 6.0 ; SAP enhancement package 4 for SAP ERP 6.0 ; SAP enhancement package 5 for SAP ERP 6.0 ; SAP enhancement package 6 for SAP ERP 6.0 ; SAP enhancement package 7 for SAP ERP 6.0

Keywords

FP03DM, FP03M, FPCC0002, FPCC0026, FPCC0029, FPCC0034, FPCI, FPRV, FPRW, FPARDOCMASS, SELECT .... WHERE ... IN range_tab, maximale Größe eines SQL-Statements, Verwendung einer zu großen Tabelle in einem IN [range tab] Konstrukt, Laufzeitfehler, Abbruch, Kurzdump, Dump, Programm mit Fehler abgebrochen, Massenaktivitäten, Massenlauf, Intervalle, Prozesse, Jobs, Parallelisierung, dynamische SELECT-Anweisung, SQL-Befehl, zu viele Einzelselektionen, Selektion einschränken, Vorauswahl , KBA , 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 , XX-PROJ-FI-CA , obsolete: Please use Component FI-CA instead , FI-CA , Contract Accounts Receivable and Payable , Problem

About this page

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

Search for additional results

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