Compare failed with ORA-00908 (95269)

Incorrect SQL statement was created during a compare session. 

           00: Constraint violation avoidance process activated
000: Oracle Error 908: ORA-00908: missing NULL keyword
000: Error 908 calling OCIStmtExecute (de_oci_getOneElement,L1143)
000: Error 908 calling SELECT COUNT(*) FROM "XXXX"."YYYY" WHERE CONDITIONCODE IS NULLSITEID='cccc' AND ITEMSETID='CCCC' 

Compare missed an "AND" in the sql statement after the " IS NULL".

Example of the incorrect SQL where compare missed an "AND" after " IS NULL" in  ( "IS NULLSITEID='cccc"):

00: Constraint violation avoidance process activated
000: Oracle Error 908: ORA-00908: missing NULL keyword
000: Error 908 calling OCIStmtExecute (de_oci_getOneElement,L1143)
000: Error 908 calling SELECT COUNT(*) FROM "XXXX"."YYYY" WHERE CONDITIONCODE IS NULLSITEID='cccc' AND ITEMSETID='CCCC'
 

Example of what the correct statement would look like: ( "... WHERE CONDITIONCODE IS NULL AND SITEID='cccc'  ...).

Issue has been fixed in 7.6.3.26. Please upgrade SharePlex to 7.6.3.26 or a later version.