Support Article

Campaign fails at output stage with ORA-00936 error

SA-38024

Summary



Campaign execution fails at output stage after upgrade from CMD 6.6.1 to CMD 6.7.


Error Messages



preparing input sql for parsing
DATABASE error -936
DATABASE ERROR = ORA-00936: missing expression
,code -936


Steps to Reproduce



Re-queue or create new campaign.


Root Cause



FORMAT_FUNCTION_ID column value was NULL in the original Constructed Field's CONS_FLD_DET table, which created data inconsistency in the Constructed Field and Extract Template related tables.

Resolution



Update the FORMAT_FUNCTION_ID column value in CONS_FLD_DET table with the following SQL statement:

update cons_fld_det set format_function_id = 0 where cons_id in (X,Y) and format_function_id is null;

Published May 15, 2017 - Updated June 1, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.