1 Reply Latest reply on Apr 5, 2018 11:22 PM by EZ

    EPM ISM app store package troubleshooting

    EZ Apprentice

      Hello there, I just upgraded ISM on premise to 2017.3 to take advantage of the OOTB integrations into LDMS / IEM. The first thing i was trying to get working is to do the data import into ISM CMDB. My log has this entry:

       

      Mapping Details: Source Object: CompSystem Source Object: Computer Source Object: Memory Source Object: Processor Error message:SQLConnector.GetKeys - Failed to retrieve key values from SQL serverSystem.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Computer'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at FRS.Integration.Connection.SQLConnector.GetKeys(SyncDef syncDef) ClientConnectionId:79ae262b-71a2-4fb9-a40e-1b25dab443bf Error Number:208,State:1,Class:16 Exception details:System.ApplicationException: SQLConnector.GetKeys - Failed to retrieve key values from SQL serverSystem.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Computer'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at FRS.Integration.Connection.SQLConnector.GetKeys(SyncDef syncDef) ClientConnectionId:79ae262b-71a2-4fb9-a40e-1b25dab443bf Error Number:208,State:1,Class:16 at FRS.Integration.Connection.SQLConnector.GetKeys(SyncDef syncDef) at FRS.Integration.Connection.SQLConnector.GetEnumerator(SyncDef syncDef) at FRS.Integration.Transformation.IntegrationManager.Sync(Object arg)

       

      Any help would greatly be appreciated. I have also logged a ticket with support and consulted local Ivanti Presales, but this feature is too new, so i am expanding the audience.