Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Database cleanup workflow fails.

hce8
Level 2
Level 2

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.

1 Accepted Solution
wodnicki
Correct answer by
Community Advisor
Community Advisor

Hi,

 

Have you tried running the drop command in the log?

 

Thanks,

-Jon

View solution in original post

0 Replies
wodnicki
Correct answer by
Community Advisor
Community Advisor

Hi,

 

Have you tried running the drop command in the log?

 

Thanks,

-Jon

View solution in original post

hce8
Level 2
Level 2

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.

 

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-sta...
hce8
Level 2
Level 2

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