Task Persistence Monitor - 100 %

[Sai Kumar Valluri]

Hi Team,

We have a situation where we are seeing all tasks stuck in Progress.
And I see that when we see monitor it shows below:

We tried to run cleanup in progress tasks, even that gets stuck. Even Wildfly restart did not help.

Any suggestions to fix this ?

Thanks,
Sai

[Scott Owens]

I suggest reviewing the following:

Article title: Task Persistence Database and In Progress Tasks: Use, Performance and Troubleshooting

https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=10220

Article title: Task Persistence Database Disk Space Sizing

https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=32151

Article title: Cleaning up Task Persistence DB of unnecessary data

https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=46396

------------------------------
Best regards,

Scott Owens
Sr Support Engineer
Enterprise Software Division
Broadcom Inc.
------------------------------

[Rinat Matityahu]

Hi Sai
The Task Persistence Monitor can be very confusing.

Essentially, it is running a stored procedure at the background, to check the current size (in use) vs allocated size
For SQL, we are using the following logic

    EXEC sp_spaceused 'tasksession12_5'
    EXEC sp_spaceused 'event12_5'
    EXEC sp_spaceused 'object12_5'

 For Oracle, we are using a similar logic via a slightly longer query. 

It is pretty straight forward but as long as the DB is configured to auto grow (by a reasonable size each time) - we are most likely OK.
Do you still have tasks stuck in progress? Assuming you don't - does the monitor still show 100% usage of the tables?

Regards
Rinat

[orawan tharavuth]

Hi Sai,,

May i know, which IDM version that u re using?  I've got the same issue about Task stuck inprogress in IDM VApp 14.1

Thanks,
Ann

[Sai Kumar Valluri]

I am on 14.2.0

Thanks,

Sai