Kbase P155380: Getting oracle error ora -1007 intermittently in the WebSpeed server log file after upgrade to OE10.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/23/2010 |
|
Status: Unverified
SYMPTOM(s):
Getting oracle error ora -1007 intermittently in the WebSpeed server log file after upgrade to OE10.1B03
ORACLE error -1007 see "ORACLE Error Messages and Codes Manual". (1252)
ORA-01007: variable not in select list
FACT(s) (Environment):
The WebSpeed agent is connected three oracle instances
The cursor parameter -c is set to 500 on each of the schema holder's meta-schema - on the other connection parameters
All Supported Operating Systems
Oracle DataServer
OpenEdge 10.1x
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Increase the -c to 1000 on the each schema holder's connection parameters on the meta-schema.
Or,
use -c 1000 on the ABL/WebSpeed client's startup parameters