Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Personalization or Count Failed

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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