Loading
search-img
Reading data from SCCM may fail at InsertIntoTempApplicationFile step when SCCM import is run on the application and server and the collation of the SCCM database is different from the collation of the compliance database
Description

Summary

The inventory import process may fail at the InsertIntoTempApplicationFile step when reading inventory data from SCCM with logging similar to the following:

2016-04-07 21:52:36,150 [INFO ]   Importing from 'JTSMS' [type: SMS] (primary connection)
[...]
2016-04-07 21:52:56,073 [INFO ]     InsertIntoTempApplicationFile (Transfer from FNMP to source 'JTSMS')
2016-04-07 21:52:58,491 [INFO ]       Failed to execute Reader 'InsertIntoTempApplicationFile' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\sms\FileEvidence.xml
Error: The locale id '1033' of the source column 'FileName' and the locale id '1041' of the destination column 'FileName' do not match.

This occurs if the collation settings on columns in the SCCM database are different from the default database collation.

Workaround

Edit and modify the following file on the FlexNet Manager Suite batch server: C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\sms\FileEvidence.xml

Find the InsertIntoTempApplicationFile reader in this file.

The default query for this reader looks similar to the following (exact details may vary based on your version of FlexNet Manager Suite):

DECLARE @EscapeChar nchar(1)
SET @EscapeChar = '\'

SELECT
	CASE WHEN CHARINDEX('%', fe.FileName) <> 0 THEN 1 ELSE 0 END AS HasWildcards,
	FileName = REPLACE(REPLACE(REPLACE(REPLACE(fe.FileName, @EscapeChar, @EscapeChar + @EscapeChar), '_', @EscapeChar + '_'), '[', @EscapeChar + '['), ']', @EscapeChar + ']'),
	FileVersion = REPLACE(REPLACE(REPLACE(REPLACE(fe.FileVersion, @EscapeChar, @EscapeChar + @EscapeChar), '_', @EscapeChar + '_'), '[', @EscapeChar + '['), ']', @EscapeChar + ']'),
	Company = REPLACE(REPLACE(REPLACE(REPLACE(fe.Company, @EscapeChar, @EscapeChar + @EscapeChar), '_', @EscapeChar + '_'), '[', @EscapeChar + '['), ']', @EscapeChar + ']'),
	Description = REPLACE(REPLACE(REPLACE(REPLACE(fe.Description, @EscapeChar, @EscapeChar + @EscapeChar), '_', @EscapeChar + '_'), '[', @EscapeChar + '['), ']', @EscapeChar + ']')
FROM dbo.FileEvidence AS fe
WHERE fe.FileEvidenceID IN (SELECT FileEvidenceID FROM dbo.SoftwareTitleFileEvidence AS stfe)

Add the clause COLLATE database_default to the relevant column in the SELECT statement that is identified in the error message. For example:

DECLARE @EscapeChar nchar(1)
SET @EscapeChar = '\'

SELECT
	CASE WHEN CHARINDEX('%', fe.FileName) <> 0 THEN 1 ELSE 0 END AS HasWildcards,
	FileName = REPLACE(REPLACE(REPLACE(REPLACE(fe.FileName, @EscapeChar, @EscapeChar + @EscapeChar), '_', @EscapeChar + '_'), '[', @EscapeChar + '['), ']', @EscapeChar + ']') COLLATE database_default,
	FileVersion = REPLACE(REPLACE(REPLACE(REPLACE(fe.FileVersion, @EscapeChar, @EscapeChar + @EscapeChar), '_', @EscapeChar + '_'), '[', @EscapeChar + '['), ']', @EscapeChar + ']'),
	Company = REPLACE(REPLACE(REPLACE(REPLACE(fe.Company, @EscapeChar, @EscapeChar + @EscapeChar), '_', @EscapeChar + '_'), '[', @EscapeChar + '['), ']', @EscapeChar + ']'),
	Description = REPLACE(REPLACE(REPLACE(REPLACE(fe.Description, @EscapeChar, @EscapeChar + @EscapeChar), '_', @EscapeChar + '_'), '[', @EscapeChar + '['), ']', @EscapeChar + ']')
FROM dbo.FileEvidence AS fe
WHERE fe.FileEvidenceID IN (SELECT FileEvidenceID FROM dbo.SoftwareTitleFileEvidence AS stfe)
Fix status
This issue is still open but not currently scheduled to be addressed.
Was this helpful?
Support Hub
Product
FlexNet Manager Suite
Affected functionality
Integration: SCCM,Inventory import (read/write/export)
Visibility
Guest
URL Name
reading-data-from-sccm-may-fail-at-insertintotempapplicationfile-step-when-sccm-import-is-run-on-the-application-and-server-and-the-collation-of-the-sccm-database-is-different-from-the-collation-of-the-compliance-database-IOJ-1758508

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)

Revenera Assistant

Revenera Assistant
+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
Reading data from SCCM may fail at InsertIntoTempApplicationFile step when SCCM import is run on the application and server and the collation of the SCCM database is different from the collation of the compliance database