Adobe Campaign Classic v7 & Campaign v8

Ofattah · 12/14/21

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

David_Loyd · 12/14/21

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.

View solution in original post

David_Loyd · 12/14/21

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.

Ofattah · 12/14/21

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 · 12/14/21

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.

Ofattah · 12/14/21

@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

David_Loyd · 12/14/21

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.