Kbase P135049: Running a simple FOR EACH from WebSpeed workshop causes 1461 error against Oracle DataServer but run
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/09/2008 |
|
Status: Unverified
SYMPTOM(s):
Running a simple FOR EACH from WebSpeed workshop causes 1461 error against Oracle DataServer but running from the 4GL/ABL GUI and character client the query runs fine
Schema Holder does not match database schema (1461)
FACT(s) (Environment):
The Schema holder is created using user A
The WebSpeed agent connection parameters uses user B to connect to the schema holder
The 4GL/ABL GUI or character client uses user A to connect to the schema holder
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
Oracle DataServer
CAUSE:
The userid supplied on the WebSpeed agent startup parameter to connect to the Oracle instance is different (B) than the userid (A) who actually owns the Oracle instance
FIX:
Use correct userid (A) and the password to connect to the Oracle instance on the WebSpeed agent startup parameters