Error installing Job Server

We are installing version 8.1 of the product and we have a serious problem when installing or defining the Job Server. The error code is as follows:

Error during execution of statement: 
insert into QBMServerHasDeployTarget (UID_QBMDeployTarget, UID_QBMServer, xdateinserted, xuserinserted, xdateupdated, xuserupdated, xobjectkey) 
values ('ADS-AA65D060C911BA5666BA87CC037603FD', '32a4d52f-b77d-4c94-b830-c26d95229c06', GetUTCDate(), N'cccAdmin', GetUTCDate(), N'cccAdmin', '<Key><T>QBMServerHasDeployTarget</T><P>ADS-AA65D060C911BA5666BA87CC037603FD</P><P>32a4d52f-b77d-4c94-b830-c26d95229c06</P></Key>')
The database connection was broken.
Cannot continue the execution because the session is in the kill state.
A severe error occurred on the current command.  The results, if any, should be discarded.

We have tried to make the insert both with the viAdmin user and with a system user created by us.

The database is SQL Server 2016 SP2 CU6

Can you give us a hand?

Any additional information you need to tell us.

Thank you.

Regards.

  • I would check the SQL Server logs and search for a hint why the SQL session was ended by the SQL server.

  • We saw the similar exceptions thrown on SQL DB 2017 when installing v8.1, and the problem was gone after we applied the latest CU to SQL. You might find some posts online related to your errors. HTH.

  • Hi!

    Thanks for the quick response. I have checked the log and this is the error:

    Error: 17310, Severity: 20, State: 1.
    2019-06-12 12:28:53.20 Server      A user request from the session with SPID 54 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
    2019-06-12 12:28:53.40 spid53      ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL13.INSTDEV1\MSSQL\LOG\SQLDump2052.txt
    2019-06-12 12:28:53.40 spid53      SqlDumpExceptionHandler: Process 53 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
    2019-06-12 12:28:53.40 spid53      * *******************************************************************************
    2019-06-12 12:28:53.40 spid53      *
    2019-06-12 12:28:53.40 spid53      * BEGIN STACK DUMP:
    2019-06-12 12:28:53.40 spid53      *   06/12/19 12:28:53 spid 53
    2019-06-12 12:28:53.40 spid53      *
    2019-06-12 12:28:53.40 spid53      *
    2019-06-12 12:28:53.40 spid53      *   Exception Address = 00007FFCEF153274 Module(sqllang+00000000000D3274)
    2019-06-12 12:28:53.40 spid53      *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
    2019-06-12 12:28:53.40 spid53      *   Access Violation occurred reading address 0000000000000000
    2019-06-12 12:28:53.40 spid53      * Input Buffer 510 bytes -
    2019-06-12 12:28:53.40 spid53      *         5   insert into QBMServerHasDeployTarget (UID_QBMDeployTarget, UI
    2019-06-12 12:28:53.40 spid53      *  D_QBMServer, xdateinserted, xuserinserted, xdateupdated, xuserupdated, x
    2019-06-12 12:28:53.40 spid53      *  objectkey) values ('ADS-AA65D060C911BA5666BA87CC037603FD', 'c99c797c-598
    2019-06-12 12:28:53.40 spid53      *  e-44b5-a332-7c34e67498a1', GetUTCDate(), N'cccAdmin', GetUTCDate(), N'cc
    2019-06-12 12:28:53.40 spid53      *  cAdmin', '<Key><T>QBMServerHasDeployTarget</T><P>ADS-AA65D060C911BA5666B
    2019-06-12 12:28:53.40 spid53      *  A87CC037603FD</P><P>c99c797c-598e-44b5-a332-7c34e67498a1</P></Key>')
    2019-06-12 12:28:53.40 spid53      *  
    2019-06-12 12:28:53.40 spid53      *

    Thanks in advance.

  • Hi!

    Thank you for the quick response, I will try to install the latest update to the DB instance

    Regards.