Database cleanup workflow fails. | Community

Level 2

Solved

Database cleanup workflow fails.

Forum|Forum|6 years ago
December 31, 2019
1 reply
2811 views

Hi Team,

We have observed that our database cleanup workflow stops at this process(PFA screenshot) and hangs on it forever.

Any Idea what could be the issue

help appreciated.

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 Jonathon_wodnicki

Hi,

Have you tried running the drop command in the log?

Thanks,

-Jon

Jonathon_wodnicki

Community Advisor

Accepted solution

Community Advisor

Hi,

Have you tried running the drop command in the log?

Thanks,

-Jon

Jonathon_wodnicki

Community Advisor

Community Advisor

It's an orphaned target table from workflow id=322915481. Dropping it will fix your immediate problem, beyond that you can look into altering the DropTableIfExists() function to bump the statement timeout: https://stackoverflow.com/questions/55427534/is-there-a-way-to-override-the-server-configuration-statement-timeout-on-azure