Apr 11, 2022
08:18 AM
1 Kudo
We have created a Business adapter to update the Device Role details in my environment like Production, Test, Development, etc.,. I have mapped the Environment field with Computer->Role field in Business adapter and ran the import. The import failed with the below Error. Error: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Please let me know if anyone has faced the same issue. Best Regards Venu Gopal
... View more
Labels
- Labels:
-
Business Adapters
Mar 16, 2022
12:34 PM
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.ActionExecuter.ReaderExecuter.Execute() 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. Best Regards Venu Gopal
... View more
Mar 16, 2022
12:25 PM
I am facing the same error in my environment but we are using the ILMT DB2 database (temadb) not SQL. Can you please provide the installerevidence for ILMT DB 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. 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.ActionExecuter.ReaderExecuter.Execute() at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ProcessExecution(ComplianceReader p_ComplianceReader, Tenant p_Tenant, IExecutionContext p_Context) Best Regards Venu Gopal
... View more
Latest posts by venujuturi
Subject | Views | Posted |
---|---|---|
308 | Apr 11, 2022 08:18 AM | |
224 | Mar 16, 2022 12:34 PM | |
593 | Mar 16, 2022 12:25 PM |
Activity Feed
- Got a Kudo for Unable to update Device Role using a Business adapter. Apr 12, 2022 08:32 AM
- Posted Unable to update Device Role using a Business adapter on FlexNet Manager Forum. Apr 11, 2022 08:18 AM
- Posted ILMT import Failed to execute Reader 'SendInstallerEvidence' Error: Invalid object name 'sam.software_facts' for ILMT DB2 on FlexNet Manager Forum. Mar 16, 2022 12:34 PM
- Posted Re: ILMT import Failed to execute Reader 'SendInstallerEvidence' Error: Invalid object name 'sam.software_facts' on FlexNet Manager Knowledge Base. Mar 16, 2022 12:25 PM