Personalization or Count Failed | Community
Skip to main content
Level 2
February 12, 2021
Solved

Personalization or Count Failed

  • February 12, 2021
  • 1 reply
  • 2162 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
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
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