Campaign fails at output stage with ORA-00936 error
SummaryCampaign execution fails at output stage after upgrade from CMD 6.6.1 to CMD 6.7.
Error Messagespreparing input sql for parsing
DATABASE error -936
DATABASE ERROR = ORA-00936: missing expression
Steps to ReproduceRe-queue or create new campaign.
Root CauseFORMAT_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.
ResolutionUpdate 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