Kbase P181981: 4GL/ABL/SQL: Errors (5635) and (279) executing SQL GRANT and COMMIT statements
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/02/2011 |
|
Status: Unverified
SYMPTOM(s):
4GL/ABL/SQL: Errors (5635) and (279) executing SQL GRANT and COMMIT statements
SYSTEM ERROR: -s exceeded. Raising STOP condition and attempting to write stack trace to file 'procore'. Consider increasing -s startup parameter. (5635)
SYSTEM ERROR: stkpush: stack overflow. Increase the -s parameter. (279)
Some simultaneously running 4GL/ABL clients receive error shortly after the SQL GRANT and COMMIT statements are executed.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
The execution of the SQL GRANT and COMMIT statements changes the database schema timestamp. If a 4GL/ABL client happens to be executing code that requires the schema cache to be refreshed, queries on the meta-schema tables that use the the stack allocated by -s are perfomred internally. If the stack size happens to be low for that client, the above errors will be generated.
FIX:
Increase the value of the Client Session Stack Size (-s) startup parameter to a value sufficient to accommodate the running 4GL/ABL clients.