Return
-
Title
Message: "Warning: 13007 - NO_UNIQUE_KEY_WITH_LONG found on object id: xxxx" in event_log -
Description
Activation of the config file generated the following messages in the event_log. Activation completed successfully and did not produce any other errors.
Warning: 13007 - NO_UNIQUE_KEY_WITH_LONG found on object id: xxxx
-
Cause
This warning message means that there is no primary/unique key for the specified LONG/LOB table, and as a result Shareplex will use all columns as keys except LONG/LOB type column.
-
Resolution
Check with the DBA to see if using all columns except LONG/LOB will produce uniqueness for sure. If the DBA cannot guarantee uniqueness then target may end up with out of sync. Shareplex recommends to create either a PK or a UK on these tables to avoid the out of sync possibility.