Wait activity and loss of the data in the workflow

Forum|Forum|1 year ago
April 9, 2024
2 replies
1235 views

Hello,

can wait cause that after the workflow is activated again we will loose the transition data?

At first glance it looks like the data has been purged

PGS-220000 PostgreSQL error: ERROR:  relation "wkf405343339_662_1" does not exist
LINE 1: ... || E' (' || COALESCE(R1.sEmail, '') || E')' FROM wkf4053433...
                                                             ^

What do you think?

Marcel

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

ParthaSarathy

Community Advisor

Hi @marcel_szimonisz ,

I think this particular workflow's Keep the interim result checkbox is disabled in workflow property tab. So with this configuration, when you try to 'display the target' after the Workflow goes into finished state, then the workflow will throw this error (as temporary table gets deleted in the end of the workflow).

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

Marcel_Szimonisz

Author

Community Advisor

Hello @parthasarathy ,

thanks for stopping by. The think is the workflow is failed state. So normally I would see the data on failed transition.

Marcel

ParthaSarathy

Community Advisor

@marcel_szimonisz , this particular error is because of the reason temporary table got deleted. You can investigate around how this workflow's temp table got deleted.

Few possible ways are disabling the 'keep interim result' checkbox, or you're checking the data of the workflow which had ran before the day mentioned in 'History in days' of workflow property (Execution tab). Example, if the 'History of days' is 7 days, and if the workflow went to failed state before 2 weeks, by now the temp table must got deleted, so there is a possibility of this error.

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups