Regresar
-
Título
Error in the Database Compiler: "The DB queue processor was not active for more than one hour" -
Descripción
During compilation following error message is generated:
"The DB queue processor was not active for more than one hour. Pending operations will not be executed. Close the application and contact the database administrator." -
Causa
The SQL Agent is not running correctly. The most likely source of the error is the Agent job QBM_PWatchDog. The error gets generated as a check of the status of the SQL Server Agent. -
Resolución
Run the following SQL statement. It should return a value of "1":
select top 1 1--h.run_date, h.run_time, h.run_status,from msdb..sysjobs j join msdb..sysjobhistory h on j.job_id = h.job_idwhere j.name = dbo.QBM_FGIServerAgentJobName('QBM_PWatchDog')and j.enabled = 1and h.run_status = 1 -- succeededand dateadd(mi,(h.run_time % 10000) / 100, dateadd(hh,h.run_time / 10000,CONVERT(datetime, left(convert(varchar(64), h.run_date), 8), 112))) > dateadd(hh, -1, getdate());
If the value returned is not "1", there is a problem with the agent job QBM_PWatchDog. Try to restart that job manually. If it fails, there will be an error.
The most likely cause of the error is inadequate permissions. Ensure that the QBM_PWatchDog job has the correct owner, and that the owner has all the required server roles, including sysadmin.