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

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

book

Article ID: 164922

calendar_today

Updated On:

Products

Client Management Suite IT Management Suite Asset Management Suite

Issue/Introduction

The Symantec CMDB has been migrated to a new SQL server.  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

8.x

Cause

The credentials used for the connection have become invalid.

Resolution

On the NS console:
  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