Update data error

Forum|Forum|4 years ago
December 14, 2021
2 replies
2678 views

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.

Best answer by David_Loyd

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.

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

David_Loyd

Adobe Employee

@david_loyd

Thank you again,

There are only two activities : Upload and update and there's no such field in both activities. But before that error I have this one : invalid user.table.column... which is not normal because I have always used this table

Thanks

Was anything copied over from another workflow? The temp table of the workflow thinks that field is present. If you are 110% that field is not in existing activity (or the advance JS in activities), I would re-create that workflow from scratch in a new workflow canvas. Don't copy and past anything.

Perhaps look up up the table your are writing to in data schemas and make sure that field is not present. Maybe someone edited the actual table structure.