Compare fails due to Oracle Error 936: ORA-00936: missing expression
The compare server log (*desvr* log) logged the following:
00: Error 936 calling OCIStmtExecute (de_oci_getOneElement,L1165)
000: Error 936 calling SELECT COUNT(*) FROM "CLIN01"."PATIENT_EPISODE" WHERE (de_oci_getOneElement,L944)
000: Oracle Error 936: ORA-00936: missing expression
Product defect, compare client encountered constraint violation when querying for unique constraint indexes.
WORKAROUND:
1. Delete the unique constraint on the target.
2. Retry the compare on source.
STATUS:
Issue fixed in version 7.5.2.50 and above.
The latest version of SharePlex can be downloaded at:
https://support.quest.com/es-es/shareplex/download-new-releases
