FI-CA: runtime error DBIF_RSQL_INVALID_RSQL in various mass activities
A certain mass activity ends with runtime error DBIF_RSQL_INVALID_RSQL and exception CX_SY_OPEN_SQL_DB. In the long text of the runtime error you'll find the following 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.
In most cases the runtime error is related to too many selections. From a technical point of view you have to know that the program will create a dynamic SQL selection with all general selections. If the general selection screen contains too many selections then the SQL statement will be too large and the mass activity ends with the mentioned runtime error.
There are different options to prevent the runtime error. In general, try to prevent the usage of a large number of single selections and instead prefer the usage of fewer ranges. Some FI-CA mass activities (like transaction FPO4) serve the 'Preselection' option for business partner and contract account selection. And last but not least, it is useful to schedule the run with more intervals and with parallel jobs.
KBA 2117160 provides more information about this topic.