I am busy with setting up a new On-Prem FNMS solution. When I run the SQL script to create the Compliance DB it fails with the following error:
There was an error while attempting to run 'ComplianceProcedure.sql'. Cannot continue the execution because the session is in the kill state.
mgsDatabaseCreate -a WindowsNT -s DBserver-name\instance name -d
FNMSInventory -i InventoryManagerDatabaseCreation.xml - Successful
mgsDatabaseCreate -a WindowsNT -s DBserver-name\instance name -d
FNMSCompliance -i ManageSoftDatabaseCreation.xml - Successful
mgsDatabaseCreate -a WindowsNT -s DBserver-name\instance name -d
FNMSCompliance -i ComplianceDatabaseCreation.xml - Failed
‎Feb 24, 2022 06:34 AM
In our documentation, it mentioned that If you are using Microsoft SQL Server 2016, ensure that at least SP1 has been installed. This update
addresses a defect in SQL Server that triggers a fatal error, as documented in https://support.microsoft.com/en-au/
help/3173976/fix-fatal-error-when-you-run-a-query-against-the-sys-sysindexes-view-in-sql-server-2016.
Also if you manage to finish the db setup might consider checking this one as well for SQL server 2016
https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/quot-Execution-Timeout-Expired-quot-error-with-FlexNet-Manager/ta-p/186919
‎Feb 24, 2022 10:00 AM
Please share SQL logs to check further.
‎Feb 24, 2022 07:38 AM
@FrediG - You likely have not set all of the documented requirements for SQL Server 2017/2019. See the following KB Article for more details:
https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/Requirements-for-hosting-FlexNet-Manager-Suite-databases-on-SQL/ta-p/169557
‎Feb 24, 2022 07:58 AM
Hi,
I am running SQL Server 2016.
‎Feb 24, 2022 08:06 AM
For SQL Server 2016:
1) Make sure that CLR is enabled
2) A minimum of SQL Server 2016 Service Pack 1 must be installed
May also want to see if you get feedback from other community members.
‎Feb 24, 2022 10:04 AM
In our documentation, it mentioned that If you are using Microsoft SQL Server 2016, ensure that at least SP1 has been installed. This update
addresses a defect in SQL Server that triggers a fatal error, as documented in https://support.microsoft.com/en-au/
help/3173976/fix-fatal-error-when-you-run-a-query-against-the-sys-sysindexes-view-in-sql-server-2016.
Also if you manage to finish the db setup might consider checking this one as well for SQL server 2016
https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/quot-Execution-Timeout-Expired-quot-error-with-FlexNet-Manager/ta-p/186919
‎Feb 24, 2022 10:00 AM