Personalization or Count Failed | Community
Skip to main content
New Participant
February 12, 2021
Solved

Personalization or Count Failed

  • February 12, 2021
  • 1 reply
  • 2157 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

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 @624996 field.

 

Thanks,

-Jon

1 reply

Jonathon_wodnicki
Jonathon_wodnickiAccepted solution
New Participant
February 16, 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 @624996 field.

 

Thanks,

-Jon