Personalization or Count Failed

Avatar

Avatar

Sinhue

Avatar

Sinhue

Sinhue

12-02-2021

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.

 

Captura de Pantalla 2021-02-11 a la(s) 20.46.12.png

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

15-02-2021

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

Answers (0)