Title

ILMT import Failed to execute Reader 'SendInstallerEvidence' Error: Invalid object name 'sam.software_facts'

Symptoms

The inventory reading process reading data from an ILMT database running on SQL Server fails with an error similar to the following:

SendInstallerEvidence (Transfer data from source 'ILMT' to FNMP) (VersionFrom: 9.2.3)
  Failed to execute Reader 'SendInstallerEvidence' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\ilmt sql\InstallerEvidence.xml, at step line 3
Error: Invalid object name 'sam.software_facts'.

Alternatively, if the ILMT database is running on DB2 then the error would be similar to the following:

SendInstallerEvidence (Transfer data from source 'ILMT' to FNMP) (VersionFrom: 9.2.3)
  Failed to execute Reader 'SendInstallerEvidence' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\ilmt\InstallerEvidence.xml, at step line 1
Error: [DB2/LINUXX8664] SQL0204N  "SAM.SOFTWARE_FACTS" is an undefined name.  SQLSTATE=42704

Cause

The ILMT database schema (in both SQL Server and DB2 databases) changed in version 9.2.20, necessitating a change to the queries used by FlexNet Manager Suite to retrieve installer evidence data.

Resolution

FlexNet Manager Suite 2021 R1 and later provide out-of-the-box support for the ILMT 9.2.20 database schema changes, so one option to resolve this issue is to upgrade your FlexNet Manager Suite installation.

Alternatively, perform the following steps to apply an update to the reader queries.

If you are using ILMT with a SQL Server database:

Make a backup copy of the following files in the C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\ILMT SQL directory on your batch server (so that the original versions of these files can be restored in the case of a problem):
- InstallerEvidence.xml
- reader.config
Download the ILMT SQL.zip file attached to this article and extract its contents into the above directory.

If you are using ILMT with a DB2 database:

Make a backup copy of the following files in the C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\ILMT directory on your batch server (so that the original versions of these files can be restored in the case of a problem):
- InstallerEvidence.xml
- reader.config
Download the ILMT.zip file attached to this article and extract its contents into the above directory.

Other notes

The change to add support for ILMT 9.2.20 is tracked with reference number IOJ-2182680.

Was this helpful?

Support Hub

Product

FlexNet Manager Suite

Deployment type

On-premises

Visibility

Guest

URL Name

ilmt-import-failed-to-execute-reader-sendinstallerevidence-error-invalid-object-name-sam-software-facts

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

Cause

Resolution

Other notes

Related Articles

Please wait...

Case id: 00001065