Wait activity and loss of the data in the workflow

Forum|Forum|1 year ago
April 9, 2024
2 replies
1238 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

Marcel_Szimonisz

Author

Community Advisor

Hello @marcel_szimonisz

Looks like the temp table was picked by Database clean up WF.

What value do you see here in the workflow properties

Hello @_manoj_kumar_,

Thanks for stopping by, I have set this option to 30. We have raised support ticket I assume its product issue. You cannot purge temp table on running workflow. There might be maybe another custom process that does this.

Marcel