DBQueue not getting any process

Question

Hello, 
 
 I might a problem with DBqueue. All the environment was working fine until I realized that no DBQueue calculations are getting made. I tried to publish a new item in the IT Shop and I spotted that is in the state 'Does not apply yet' when I tried to add it to a shelf. Digging into the problem I came to the conclusion that not new DB process are getting into the DBQueue. 
 
 I don't know what should I check in order to fix this problem. 
 
 Thanks, 
 Adrian Perez

Barry Jackson · Accepted Answer

Hi Adrian, 
 
It sounds like triggers have been disabled on your database. 
 
You can verify this in SQL Server Studio ..... choose any of the 1IM tables and look at the Triggers folder. If the icons have a red arrow pointing down they are disabled. 
 
You can re-enable all triggers using this command: 
 
exec QBM_PTriggerEnable '%','%' 
 
HTH, Barry.

Markus Weiss-Ehlers · Answer

Try to follow the steps in the troubleshooting section DBQueue Processor does not process tasks of the installation guide. 
 https://support.oneidentity.com/technical-documents/identity-manager/8.0/installation-guide/27#TOPIC-864264

Barry Jackson · Answer

Hi Adrian, 
 
It's nigh on impossible to say what caused it .... I have noticed it can happen sometimes when you are doing a schema extension and for some reason the process does not complete cleanly. 
 
And as Trevor Pike says, if you're still not seeing items in the DBQueue check your SQLAgent is running and check the state of the DBQueue slots (Jobs) in Server Studio. 
 
Regards, Barry.