Loading
search-img
Title
Known Issue: "ApplicationsByFileEvidence" or "Create temp table ApplicationsByFileEvidence" steps may run slowly on SQL Server 2019 unless compatibility level on the compliance database is set to 110 (SQL Server 2012) or earlier (IOK-703164)

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

Was this helpful?
Support Hub
Product
FlexNet Manager Suite
Deployment type
On-premises
Visibility
Guest
URL Name
known-issue-applicationsbyfileevidence-or-create-temp-table-applicationsbyfileevidence-steps-may-run-slowly-on-sql-server-2019-unless-compatibility-level-on-the-compliance-database-is-set-to-110-sql-server-2012-or-earlier-iok-703164

Related Articles

Create a case with Support
0/255
Upload Attachment
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to cancel the case creation?

Are you sure you want to close this case

Get Hotline support
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.
Book an Appointment
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)
+1.800.374.4353
CONTACT US REVENERA.COM FLEXERA.com
© 2026 Flexera Software. All Rights Reserved.
Privacy policy Terms and conditions Flexera Community Contact Us
Loading
Known Issue: "ApplicationsByFileEvidence" or "Create temp table ApplicationsByFileEvidence" steps may run slowly on SQL Server 2019 unless compatibility level on the compliance database is set to 110 (SQL Server 2012) or earlier (IOK-703164)