Kbase 19793: Error 5635: Select Into with a Large Number of Unavailable R
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Technically Reviewed
FACT(s) (Environment):
Progress 8.3B
FACT(s) (Environment):
Progress 9.1A
SYMPTOM(s):
SQL-89 is being used
Error 5635 appears when the Select statement used with Into option does not find a large number of specified records.
SYSTEM ERROR: -s exceeded. Raising STOP condition and attempting to write stack trace to file 'procore'. Consider increasing -s startup parameter. (5635)
CAUSE:
Run this piece of code to add records in the table to duplicate the problem:
def var i as int.
Do i = 1 to 9900:
create customer.
end.
Run this code to see the error number:
define variable t-num as integer no-undo.
for each customer no-lock:
select count(*) into t-num from order where
order.cust-num =
customer.cust-num.
end.
display t-num.
The error:
SYSTEM ERROR: -s exceeded. Raising STOP condition and
attempting to write stack trace to file 'procore'. Consider
increasing -s startup
parameter. (5635)
FIX:
1) If 'into t-num' is commented out, code works fine.
2) Increasing '-s' helps get rid of the error.
The problem is fixed in Progress 8.3C and 9.1B.