Database cleanup workflow fails.

[hce8]

Hi Team,

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

database error 

Any Idea what could be the issue

help appreciated.

[Jonathon_wodnicki · Accepted solution]

Hi,

Have you tried running the drop command in the log?

Thanks,

-Jon

[hce8]

hi woodnicki,

Is this a good approach to drop this manually?

because i dont know what schema/object is this table linked with.

Also

A simple query on table is taking a lot of time.

[Jonathon_wodnicki]

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-sta...

[hce8]

Hi jon,

Adobe has suggested us there are few long running queries hampering tasks.

We need to kill them first.

Is there any specific query to find and kill them.

Thanks