Skip to Main Content
Forums

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

GG Error of unique key,

user237694Sep 16 2010 — edited Sep 16 2010
Hi,

While setting up goldengate i have come accross the following error in the error log. This error occurs when extract in started.

2010-08-06 18:53:58 INFO OGG-00476 Oracle GoldenGate Capture for Oracle, ext-a.prm: Gathering metadata for [SEND.SOURCE] not successful even though object was resolved, retrying [3] times with 1 second interval.
2010-08-06 18:53:59 WARNING OGG-00455 Oracle GoldenGate Capture for Oracle, ext-a.prm: Problem in resolving [SEND.SOURCE]: OCI error (904-ORA-00904: "VISIBILITY": invalid identifier) building query to fetch unique key, SQL < SELECT key.key_name, key.column_name, key.descend FROM (SELECT c.constraint_name key_name, c.column_name column_name, c.position position, >, try to fix this issue in order to avoid possible fatal error.
2010-08-06 18:53:59 INFO OGG-00476 Oracle GoldenGate Capture for Oracle, ext-a.prm: Gathering metadata for [SEND.SOURCE] not successful even though object was resolved, retrying [2] times with 1 second interval.
2010-08-06 18:54:00 WARNING OGG-00455 Oracle GoldenGate Capture for Oracle, ext-a.prm: Problem in resolving [SEND.SOURCE]: OCI error (904-ORA-00904: "VISIBILITY": invalid identifier) building query to fetch unique key, SQL < SELECT key.key_name, key.column_name, key.descend FROM (SELECT c.constraint_name key_name, c.column_name column_name, c.position position, >, try to fix this issue in order to avoid possible fatal error.

2010-08-06 19:07:13 ERROR OGG-00521 Oracle GoldenGate Capture for Oracle, ext-a.prm: Object was resolved, however in the same resolution call both DDL history and database metadata resolution failed, cannot recover, SCN [489507], object id [51514].

note that my table does contain unique key

Any ideas? Stuck at this stage :(

thanks
Salman
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 14 2010
Added on Sep 16 2010
#goldengate
6 comments
1,606 views