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.

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

  • 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.

Reply
  • 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.

Children
No Data