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 SuiteIT Management SuiteAsset 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:
Navigate to Settings | Notification Server | Connector | Data Sources
Re-enter the user name and password under the data source configuration section and save