Summary
Significant performance issues may affect reconcile time, especially during the ApplicationsByFileEvidence step, when using FlexNet Manager Suite with SQL server 2019.
Reproduction
A new install of FlexNet Manager Suite with a set of demo data and SQL 2019 in default compatibility mode was measured to take over 3 hours to complete reconcile, with the ApplicationsByFileEvidence step taking over two hours to complete. Once the compatibility mode was set to 2012, subsequent reconcile completed in 12 minutes.
Workaround
Set the SQL database compatibility mode to 110 (SQL 2012). See View or change the compatibility level of a database for assistance.
Fix status
This issue is still open but not currently scheduled to be addressed.
Other information
Affected components: Database, Inventory import (read/write/export)
Master issue ID: IOK-703164
Also known as: ITAM-664
Related Articles
"ApplicationsByFileEvidence" or "Create temp table ApplicationsByFileEvidence" steps may run slowly on SQL Server 2019 unl… 5Number of Views SQL Server edition not recognized if SQL Server WMI provider is inaccessible 115Number of Views BMC Discovery import may fail with error if SQL Server database compatibility level is below 130: "Invalid object name 'ST… 7Number of Views Restore FlexNet Manager Suite databases on a new SQL Server instance 61Number of Views mgsDatabaseCreate misidentifies SQL Server 2016 database compatibility level 4Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago