Kbase P133420: Oracle Error 604 Loading .d File
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/03/2010 |
|
Status: Unverified
SYMPTOM(s):
Getting error 1252 and ORACLE error 604 when loading data during ProtoOra
ORACLE error see "ORACLE Error Messages and Codes Manual". (1252)
ORACLE error 604 see "ORACLE Error Messages and Codes Manual". (1252)
error or-00604:"error occurred at recursive SQL level"
//*Cause: An error occurred while processing a reCursive SQL statement
// (a statement applying to internal dictionary tables).
Error 1461 also generated loading 0 length .d file
Schema holder does not match database schema -- file field . (1461)
Error 6483 also generated when running "verify table definitions"
Please also verify you have SELECT privileges on the needed system tables and the proper version of ORACLE (7 or 8) was selected when the schema holder was created (328) (6483)
FACT(s) (Environment):
Oracle open_cursors parameter is set to 640
Progress data server cursor startup parameter is set to 1920
OpenEdge 10.1B
Oracle DataServer
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Lower -c startup parameter to match open_cursors, for example set -c to 630, and reconnect with new -c value