Update data error

7 replies
2733 views
Translate All

Hello,

I'm working on a workflow where I have to upload->update the data in a table then send a delivery but it's giving me the error below.

Do you have an idea please where the problem is?

Thanks

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

David_LoydAccepted solution

Adobe Employee

I would start with verifying that RecProcState for the inbound population is all populated with the correct data type and values before the expression is evaluated. Essentially data in that field for a specific recipient is not letting the expression be evaluated. With these type of errors you have break down the data structure for each activity to figure where things have gone wrong.

David_Loyd

Accepted solution

Adobe Employee

I would start with verifying that RecProcState for the inbound population is all populated with the correct data type and values before the expression is evaluated. Essentially data in that field for a specific recipient is not letting the expression be evaluated. With these type of errors you have break down the data structure for each activity to figure where things have gone wrong.

Translate

O

OfattahAuthor

Level 2

Thank you for you response @david_loyd

What do you mean by "RecProcState" please? is it a column in the uploaded data?

Thanks

Translate

David_Loyd

Adobe Employee

In the error logs this statement is failing to be evaluated "WHERE W.iRecProcState >= -1".

the W.i is just SQL stuff. RecProcState is either a custom field on some custom data schema, or it is a custom expression in an enrichment or other activity within the workflow.

Start by checking the update activity, this is field listed there? If not in the update activity check other activities in the workflow.

Translate