6.1.11

SAP Note 17375 - Update termination "Too complicated SQL statement"

Symptom:

Update termination with the message "SQL statement too complex" and the error number ADA-1101 in program SAPLGLIV.
This note is relevant for all ADABAS customers using any release following Release 2.2C.

Cause and prerequisites

The update statement is too long in the ADABAS environment.

Solution
Make the changes listed below in Include program FGIDBF33, then run program SAPFGIDB. Because the changes may have far-reaching circumstances, please test its effects before implementing the change in your production system. Changes may only be made when other users are not posting transactions in a productive system.
FORM CREATE_UPDATE_USED.
************ Control constants *****************************************
* ANZ: Nbr of periods updated with one update statement
* NO_IF: if flagged no if is generated before the update
* DATA: ANZ LIKE T800A-FLDGR VALUE 17, "<-- delete ---
* DATA: ANZ LIKE T800A-FLDGR VALUE 09, "<-- insert ---
NO_IF(1) TYPE C VALUE ' '. ***********************************************************************

No comments:

Post a Comment