Kbase P175564: Error 7519 on queries using database name before table name after a dump/load
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/18/2010 |
|
Status: Unverified
SYMPTOM(s):
Error 7519 on queries using database name before table name after a dump/load
Table/View/Synonym not found (7519)
FACT(s) (Environment):
table exists but owner of those tables are different from what is used on the query
not using set schema command
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
Missing Synonyms in the new database
FIX:
Use sqlschema with -s option to dump synonyms and load it into new database.
e.g: sqlschema -o myOutputFile -s %.% -u <user-name> -a <password> progress:T:<hostname>:<port>:<dbmane>