Diagnosis The selection criteria for a value range table cause a length overrun. You have entered selection criteria for locations or stock items with avalue range table. To execute the LIME query, the values in the valuerange table are converted to a logical condition that is used togenerate the SQL statement. The total permitted length of an SQL statement - depending on thedatabase system - is restricted. By expanding the value range table, thesize restriction of the SQL statement was exceeded. System Response The system could not execute the LIME query. Procedure The length of the generated SQL statement generally depends on thenumber of entries in the value range table. It is standard for 50 materials to be processed in a LIME query tooptimize peformance (for example, for 120 selected materials, three LIMErequests are executed). To reduce the number of materials for each LIME query, the programswitches the relevant selection field to "Changeable". Enter a smaller value than the one displayed and execute the programagain. When you next call this program, the corresponding selection field willbe hidden. |