Environment
NetIQ Analysis Center 2.x
Situation
OLAP Processing job fails on step 8: SQL Server does not exist or access denied.
OLAP Processing job fails when a data source is deleted or the Data Mart database is unavailable.
Error: 'Error [NetIQETL] EXCEPTION System.Runtime.InteropServices.COMException (0x80045703): [SQL-DMO][Microsoft][ODBC SQL Server Driver][SQL Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. at SQLDMO._Database2.ExecuteImmediate(String Command, SQLDMO_EXEC_TYPE ExecType, Object Length) at NetIQ.CreateDatabase.SQLSCRIPT.Execute()SQL Statement Error'
OLAP Processing job fails when a data source is deleted or the Data Mart database is unavailable.
Error: 'Error [NetIQETL] EXCEPTION System.Runtime.InteropServices.COMException (0x80045703): [SQL-DMO][Microsoft][ODBC SQL Server Driver][SQL Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. at SQLDMO._Database2.ExecuteImmediate(String Command, SQLDMO_EXEC_TYPE ExecType, Object Length) at NetIQ.CreateDatabase.SQLSCRIPT.Execute()SQL Statement Error'
Resolution
Restart the Microsoft SQL Server and Microsoft SQL Server Agent services on the Data Mart server and rerun the OLAP processing job.
Cause
The Data Mart is not available for continued processing of the data.
Additional Information
Formerly known as NETIQKB53226