Kbase 18857: ODBC Error 893 Strent Request for More than 32K
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/08/2003 |
|
Status: Unverified
FACT(s) (Environment):
ODBC
SYMPTOM(s):
Problem accessing Progress database using SQL.
SQL89
SYSTEM ERROR: strent request for more than 32K. (893)
CAUSE:
The error means the 32K limit is exceeded, probably by the quantity of records requested in one single request. This cannot be solved by adding more physical memory or increasing the -B parameter.
FIX:
The way to solve this problem is in the application. You must make a commit after each x number of transactions.
For example, if you need a report that shows total sales for one
year and the request exceeds the 32K limit, one possible solution
is to commit each X transactions (3 or 6 months).
Store the (quarterly or half-year) values in variables and calculate the yearly total from these values.