ILMT import Failed to execute Reader 'SendInstallerEvidence' Error: Invalid object name 'sam.software_facts' for ILMT DB2
ILMT import is failed stating that failed to execute reader 'SendInstallerEvidence'. We are facing the below error under the path C:\ProgramData\Flexera Software\Compliance\Logging\ComplianceReader. We are trying to connect to ILTM DB2 (temadb) in our environment.
2022-03-15 23:00:51,330 [INFO ] 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
2022-03-15 23:00:51,330 [INFO ] All retries have been attempted for Reader 'SendInstallerEvidence'
2022-03-15 23:00:51,330 [INFO ] Completed with error in 0 seconds.
2022-03-15 23:00:51,330 [ERROR] System.Data.OleDb.OleDbException (0x80040E37): [DB2/LINUXX8664] SQL0204N "SAM.SOFTWARE_FACTS" is an undefined name. SQLSTATE=42704
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at ManageSoft.Compliance.Importer.Logic.DatabaseSourceConnection.CreateDataReader(Reader readerStep, IExecutionContext context)
at ManageSoft.Compliance.Importer.Logic.XML.SourceToTarget.GetReader(IExecutionContext context, ISourceConnection sourceConn)
at ManageSoft.Compliance.Importer.Logic.XML.SourceToTarget.ProcessStep(IExecutionContext context)
at ManageSoft.Compliance.Importer.Logic.XML.Reader.Execute(IExecutionContext context)
at ManageSoft.Compliance.Importer.Logic.ActionExecuter.ReaderExecuter.ExecuteSingleReader(Reader reader, Int32 procedureOrder, Version sourceDatabaseVersion)
at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ProcessExecution(ComplianceReader p_ComplianceReader, Tenant p_Tenant, IExecutionContext p_Context)
Please let me know if anyone had experienced the same issue and let me know the correct InstallerEvidence for ILMT DB2 databse.
What version of FNMS are you currently using? It appears that there was an enhancement added to get customers past this in FNMS 2021 R1 but it may have only been for ILMT SQL instances.
There is also a KB article related to this here: https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/ILMT-import-Failed-to-execute-Reader-SendInstallerEvidence-Error/ta-p/189119.
I do see that the support team has had success with getting ILMT DB2 customers past this issue so it would probably be best to go with the route of opening a support case to help get you the assistance you need.