During the installation of Identity Manager version 8.1, the following error might appear:
"Processing Step 'ATT CheckInsertJob (insert post processing jobs)' failed. 4 - SQL Command failed. Error during execution of statement: exec QBM_PJobCreate_HOFireEvent 'AttestationPolicy', '1=1', 'RebuildWhereClause', 'f283aff3-8ae1-4cee-9a72-aa4bde566757' 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."
Please ensure that the SQL Server version meets or exceeds the below documented versions:
- SQL Server 2016 SP2 CU4+
- SQL Server 2017 CU12+
- Database Compability Level =130
Please refer to the Release Notes for more information: Minimum requirements for the database server.
To determine the build number of SQL Server:
- Confirm from the System Overview: SELECT * FROM QBMVSystemOverview
- Or using the following: SELECT @@VERSION AS 'SQL Server Version';
SQL Server 2017 build versions are available here.