Kbase P7823: Large select of data in Progress 9.1C causes Oracle error 10
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/12/2003 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1C
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Progress 9.1C22
Large select of data in Progress 9.1C causes Oracle error 1043
oerr ora 1043
01043, 00000, "user side memory corruption [%s], [%s], [%s], [%s]"
// *Cause: The application code corrupted some of the usr memory used by oracle
// *Action: Make sure that the application code is not overwriting memory.
Error did not occur in Progress 8.3x
Using skip-schema-check parameter to connect to ORACLE
CHANGE:
Upgraded Oracle DataServer from 8.3x to 9.1C22
CAUSE:
The schema holder may have inaccurate size information that caused memory to be overwritten. However, the exact cause is truly unknown at the time of this writing.
FIX:
Try to:
1. Remove the skip-schema-check connection parameter from the connection parameter.
2. After the removing the parameter, run the procedure. If the procedure runs OK it will get the correct schema size in the cache.
3. Then add the skip-schema-check back to the connection parameter again.