-
Título
"Database error 515" when starting the Job Service -
Descripción
"Database error 515" error is generated when starting the Job Service.
Full Error message:
[821002] Error requesting queue '\xxx' for database 'xxx.xxx.xxx\1IM'.
[810023] Error during execution of statement: exec QBM_PJobQueueLoad N'\xxx', 30, -1, 0, N'', N'd7308664-5cde-4a46-8473-71ce8de7a24a'
[810143] Database error 50000: re-throw in Procedure QBM_PJobCreate_HOFireEvent_B, Line 34
[810143] Database error 50000: re-throw in Procedure QBM_PJobCreate_HOFireEvent_L, Line 27
[810143] Database error 50000: re-throw in Procedure QBM_PJobCreate_HOFireEvent, Line 29
[810143] Database error 50000: re-throw in Procedure QBM_PJobCreate, Line 45
[810143] Database error 515: detected in (SRV=xxx, DB=1IM) Procedure QBM_PJobCreate, Line 36
[810143] Database error 515: Cannot insert the value NULL into column 'Queue', table '1IM.dbo.JobQueue'; column does not allow nulls. INSERT fails. -
Causa
A required Job server function such as "Master SQL server" or "Update server" is not assigned in Designer. -
Resolución
Mark one of the Job servers as "Master SQL server" (or other function, as required) in Designer, e.g.:
For version 8.x and up the server function of Master SQL server no longer exists, for these versions please use SQL processing server.