Kbase P63282: Error 1461 when running application after updating Oracle schema
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/10/2008 |
|
Status: Verified
SYMPTOM(s):
Error 1461 when running application after updating Oracle schema
Schema Holder does not match database schema (1461)
In the generated delta df for schema holder, the foreign-owner information for the tables were blank
FACT(s) (Environment):
Error occurs after running delta SQL Progress to Oracle utility and applying the output files to Oracle and schema holder
Schema update includes addition of four tables
Error occurs when application is run under different user than the user that running delta sql utility
Oracle tables created under user A but application run by user B
User B has necessary privileges to access the tables
Application original migrated under user A
Application was running under user B OK prior to schema update
Delta SQL utility was run under user A
The SQL file generated was applied to Oracle by user A
During delta SQL process, owner information was left empty
Progress 8.x
Progress 9.x
OpenEdge 10.x
Oracle DataServer
All Supported Operating Systems
CAUSE:
During delta SQL process, owner information was left empty. Therefore, when the delta df was loaded into schema holder, the foreign-owner was blank.
When foreign-owner is blank, it treats the currently connected user (user B) as the owner and tries to compare tables definition in schema holder and in Oracle.
In this case, because the foreign owner field is blank, the DataServer assumes the user who has connected to the Oracle database is the owner user B, instead of user A. When the DataServer tries to compare the schema, it can not and returns error 1461.
FIX:
1. Drop the new tables from Oracle and schema holder
2. Redo the delta sql process, enter owner information as User A.