Kbase 20427: Error 6483 occurs when trying to pull schema definitions from ORACLE and database link is selected
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/02/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
Oracle DataServer
SYMPTOM(s):
Error 6483 occurs when trying to pull schema definitions from ORACLE
Error 6483 occurs when attempting to Update/Add Table Definitions from ORACLE
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)
Unable to locate index '<indexname>' on table '<tablename>' for procedure '<procedure>'. (7967)
Unable to locate index '_seq-name on table '_Sequence' for procedure 'prodict/ora/_ora_lkg.p'. (7967)
Error below appears in the dataserv.lg file:
error text: ORA-28546: connection initialization failed, probable Net8 admin error ----
Oracle Database links exist
When performing an update "Links to Distributed Database" menu appears;
Example
@DBNAME_LINK
@DBNAME2_LINK
A database link is selected
Userid has all the correct SELECT privilleges against system table on current database
CAUSE:
If the database links are selected, the schema pull will try to pull schema information from both databases, if the user does not have sufficient priviledge against linked database or if the linked database is of a different version (e.g., original database is V8 or 9 and linked database is V7), you will receive the error.
This is because between 7 and 8 there was a change in field names for some of the system tables.
FIX:
Do not select a database link when trying to update or add objects within the schema holder.
When the "Links to Distributed Database" menu appears, do not select any link, simply press OKAY. This will allow you to bypass the database link selection so that you can obtain the ORACLE object list.