Data Connector Import/Export not working after migrating Symantec_CMDB to a new SQL server

Products

• Client Management Suite
• IT Management Suite
• Asset Management Suite

Issue/Introduction

The Symantec CMDB has been migrated to a new SQL server and when trying to use the Data Connector Import/Export functionality it is not working and the following errors are seen:

Cannot initialize the data source object of OLE DB provider ""OraOLEDB.Oracle"" for linked server ""xxxxxxx"".
OLE DB provider ""OraOLEDB.Oracle"" for linked server ""xxxxxxxx"" returned message ""ORA-01017: invalid username/password; logon denied"".
   [System.Data.OleDb.OleDbException @ Microsoft OLE DB Provider for SQL Server]
   at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr)
   at System.Data.OleDb.OleDbDataReader.NextResult()
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
   at Altiris.Connector.DataSource.OleDbDataSource.GetColumns(Boolean bForImport)
   at Altiris.Connector.DataSource.DataSourceBaseItem.get_ImportColumns()
   at Altiris.Connector.ImportExportRules.ResourceImport.GenerateColumnsList(ResourceDataMapping mapping, IDataSource dataSource, String filterExpressionString, Boolean isChunked)
   at Altiris.Connector.ImportExportRules.ResourceImport.StartImport_Full(ResourceDataConnectorRule itemTask, ResourceDataMapping mapping, IDataSource dataSource, ResourceImportResults results, DateTime lastImportDt, Boolean bAllowResourceDeletes, Boolean bAllowResourceCreates, Boolean bAllowResourceUpdates, String[] trusteeMemberships, Guid retiredAssetStateGuid, Boolean bLoggingEnabled, Boolean bTestOnly)

Environment

ITMS 8.x

Cause

The credentials used for the connection had become invalid.

Resolution

On the SMP Console do the following:

1. Navigate to Settings>Notification Server>Connector>Data Sources
2. Re-enter the user name and password under the Data Source Configuration section and Save