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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy