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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Issue when updating a recipient in a workflow

jose_miguelm677
Level 2
Level 2

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.

1 Accepted Solution
Venu_Reddy
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

1 Reply
Venu_Reddy
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post