This is part of the daily database maintenance (Designer: Base Data > General > Schedules > Daily maintenance tasks) Is it getting reset (does is stay in the queue)? If not, your good!
When it processing in the dbqueue its stuck. Every time staying on the Processing = 1. I dont why but this problem for a working the other process. The schedule is a daily, repeat every day 1 time.
If you open object browser and look in the table qbmdbqueuecurrent and look for this dbqueue task, it will show which table it is trying to reindex. My guess is that the table is too large and causes the dbqueue task to be stuck. In newer versions of Identity Manager we skip tables bigger than 1 GB in size.
As per the official documentation: "Reindexing of tables does not take place anymore if they are larger than 1 GB or have more than 1 million data records. Maintenance of these tables must be performed by the database administrator within maintenance periods."
