Personalization or Count Failed

[Sinhue]

Hi,

I created a recurring campaign few months ago, that campaign works perfectly 2 week ago, but today I realized that the email activity had launched an error, I tried to restart many times the wf and create a new campaign with a new wf but the issue persisted, and I don't find an answer to solve my problem.

I think the problem is related whit the database or the configuration but Im not sure of that.

 

Audit Log

02/12/2021 4:49:47 AM XSV-350122 An error occurred and the process has been stopped.
02/12/2021 4:49:47 AM SOP-330011 Error while executing the method 'PrepareTargetImpl' of service 'nms:delivery'.
02/12/2021 4:49:47 AM ed.
02/12/2021 4:49:47 AM WDB-200001 SQL statement 'INSERT INTO wkDlv_221212518T (iPLeadsId, tsEvent, sTargetCode, iDeliveryId, iTargetDataId, sAddress, dMessageWeight) (SELECT COALESCE(P1.iPLeadsId , 0), TIMESTAMP WITH TIME ZONE '2021-02-12 04:49:47.308Z', E'__MAIN__', 221212518, W0.iTargetDataId, W2.sVin, P1.sEmail, 5 FROM wkf76464521_532536_1_ALL W0, NmxPLeads P1 JOIN wkf76464521_532536_1_ALL W2 ON (W2.iId = P1.iPLeadsId) WHERE (W2.iTargetDataId = W0.iTargetDataId) AND ((P1.iPLeadsId = W0.iId)))' could not be execut
02/12/2021 4:49:47 AM PGS-220000 PostgreSQL error: ERROR: INSERT has more expressions than target columns LINE 1: ... 221212518, W0.iTargetDataId, W2.sVin, P1.sEmail, 5 FROM wkf... ^
02/12/2021 4:49:47 AM Loading typology rules (step: javascript/preTarget)...
02/12/2021 4:49:47 AM Initializing delivery process...

I really appreciate if anybody could help me.

Thanks.

SL.

[Jonathon_wodnicki · Accepted solution]

Hi,

The error message is complaining about W2.sVin not being in the destination table.

Look over workflow to make sure queries and enrichments are working as expected wrt the @vin field.

Thanks,

-Jon