Reconcile failure on step 'GetUniversalApplicationInstalledInstallerEvidence-CreateIndexes' due to maximum length exceeded

Title

Symptoms:

With SCCM import, the reconcile fails with an error similar to the one below:

Failed to execute Reader 'GetUniversalApplicationInstalledInstallerEvidence-CreateIndexes' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\sms\InstallerEvidence.xml, at step line 2
Error: Operation failed. The index entry of length 910 bytes for the index 'IX_InstallerEvidence' exceeds the maximum length of 900 bytes.
Warning! The maximum key length is 900 bytes. The index 'IX_UniversalInstalledInstallerEvidence' has maximum length of 1056 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'IX_InstallerEvidence' has maximum length of 1056 bytes. For some combination of large values, the insert/update operation will fail.
The statement has been terminated.

Diagnosis:

This is due to the combined string of the installer evidence, version, and publisher being too long.
This usually occurs if the any of the above values are modified or the installation was repackaged.

Solution:

This issue has bee resolved in FNMS 2019 R2.3.

Workaround:

The queries below can be used on the SCCM database to identify which entry and machine this evidence is coming from.
If possible, please remove the evidence. If it is modified from the default value, there is a high chance this will not map to any existing entry in the library.

SELECT DATALENGTH(DisplayName0) + DATALENGTH(Version0) + DATALENGTH(Publisher0), c.name00, arpd.*
FROM dbo.v_GS_ADD_REMOVE_PROGRAMS AS arpd
LEFT OUTER JOIN Computer_System_data AS c
ON c.MachineID = arpd.ResourceID
WHERE DATALENGTH(DisplayName0) + DATALENGTH(Version0) + DATALENGTH(Publisher0) > 900

SELECT DATALENGTH(DisplayName0) + DATALENGTH(Version0) + DATALENGTH(Publisher0), c.name00, arpd.*
FROM dbo.v_GS_ADD_REMOVE_PROGRAMS_64 AS arpd
LEFT OUTER JOIN Computer_System_data AS c
ON c.MachineID = arpd.ResourceID
WHERE DATALENGTH(DisplayName0) + DATALENGTH(Version0) + DATALENGTH(Publisher0) > 900

Was this helpful?

Support Hub

Product

FlexNet Manager Suite

Deployment type

On-premises

Visibility

Guest

URL Name

reconcile-failure-on-step-getuniversalapplicationinstalledinstallerevidence-createindexes-due-to-maximum-length-exceeded

Are you sure you want to cancel the case creation?

Case closed successfully

Action performed successfully

Upload Attachment

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 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.

Symptoms:

Diagnosis:

Solution:

Workaround:

Related Articles

Please wait...

Case id: 00001065