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
Solved! Go to Solution.
Views
Replies
Total Likes
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.
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.
Thank you for you response @David_Loyd
What do you mean by "RecProcState" please? is it a column in the uploaded data?
Thanks
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
Hi @Ofattah,
Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.
Thanks!
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Likes
Replies