-
Title
Problem with SQL Server 2019 CU2: "QBM_PDBQueueProcess_Main unlimited is only allowed as an agent job" -
Description
On attempting to install One Identity Manager you may repeatedly see this error:
"QBM_PDBQueueProcess_Main unlimited is only allowed as an agent job"E.g.:
"50000 0 detected in (SRV=SQLSERVER, DB=1IM) Procedure QBM_PDBQueueProcess_Main, Line 30 50000 0 starting QBM_PDBQueueProcess_Main unlimited is only allowed as an agent job [SQLSTATE 42000] (Error 50000) Job 'QBM_PWatchDog on OneIM' started successfully. [SQLSTATE 01000] (Message 14243). The step failed." -
Cause
This is a known issue with SQL Server 2019 CU2. As per Microsoft:
There is a known issue with SQL Server Agent in SQL Server 2019 CU2. This will be fixed in the next CU release (SQL Server 2019 CU3).
* If you are using SQL Server 2019 SQL Server Agent, it is advised to skip this CU upgrade, and wait for SQL Server 2019 CU3.
* If you have already applied SQL Server 2019 CU2 and are experiencing issues with SQL Server Agent, please revert to SQL Server 2019 CU1.
Cumulative Update 2 for SQL Server 2019
-
Resolution
As the Microsoft article points out:
- If you are using SQL Server 2019 SQL Server Agent, it is advised to skip this CU upgrade, and wait for SQL Server 2019 CU3.
- If you have already applied SQL Server 2019 CU2 and are experiencing issues with SQL Server Agent, please revert to SQL Server 2019 CU1.