Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Issue when updating a recipient in a workflow

Avatar

Avatar
Validate 1
Level 2
jose_miguelm677
Level 2

Likes

8 likes

Total Posts

17 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
jose_miguelm677
Level 2

Likes

8 likes

Total Posts

17 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
jose_miguelm677
Level 2

20-02-2019

Hello,

I am currently experiencing an issue when doing something as simple as using a query to select a single recipient and then trying to udpate its email with a update activity. For some reason, the workflow is returning the following error "cannot modify column of non-key preserved table" and the SQL:

02/19/2019 1:13:34 AM writer WDB-200002 SQL statement 'UPDATE (SELECT iRecProcState Ign FROM wkf621559747_605_1 out, NmsRecipient tgt WHERE iRecProcState >= 0  AND out.iPKey_1=tgt.iRecipientId AND ((COALESCE(tgt.sEmail,N'###NL###')=COALESCE(out.sFld742326736,N'###NL###')

02/19/2019 1:13:34 AM writer ))) Upd SET Upd.Ign = -1' could not be executed (error in position 240: 'Upd.Ign').

Last week I didn't get this error at all... it appeared this week.

Appreciate any help you can provide.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 25
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct Reply

53 solutions
Top badges earned
Give Back 25
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Give Back 25
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct Reply

53 solutions
Top badges earned
Give Back 25
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
Venu_Reddy
MVP

20-02-2019

Hello,

Please check whether the recipient email is a primary key or not. You can't update this activity if the email is primary key in Recipient schema and check the operation in update activity is only insert or both (insert/update).

And make sure that the data type is same for both source and destination.

Regards,

Venu

Answers (0)