Return
-
Title
Basic Conflict Resolution fails on update when target row does not exist -
Description
Conflict Resolution fails to resolve conflict with ORA-1403 on update conflict when target row does not exist. -
Cause
software bug with basic conflict resolution - The problem appears to be that we don't have any exception handling in place to trap (and ignore) the ORA-1403 generated by select * into new from <table> where <key-cols> = <key-values>
-
Resolution
WORKAROUND:
Use generic conflict resolution instead.
STATUS:
Waiting for fix in a future release of Shareplex for Oracle -
Defect ID
ST19437