Environment
NetIQ Analysis Center 2.6
Situation
Microsoft OLE DB Provider for SQL Server (80040e37): Invalid object name 'dbo.Data_yyyymmdd'
Resolution
You can manually remove the affected table with the now outdated information.
Use this procedure to complete the workaround:
- Disable and allow to finish/fail all the ETL and OLAP Processing jobs.
- Backup all the AC databases.
- Execute the following T-SQL in the Data Mart database having the problem:
DELETE Data_FactManager WHERE TableName = 'Data_yyyymmdd'
(NOTE: Where yyyymmdd is the actual date, as seen in the error.) - Manually start the ETL and OLAP Processing jobs for the problem Data Source.
NetIQ is aware of this issue, and has addressed this in a Analysis Center 2.7
Cause
It is likely that a machine has been added to a data source that has not been rebooted since before monthly and/or daily aggregation began inside Analysis Center. The original table had already been dropped due to aggregation; the data is collected from the System Uptime counter and a new table is created for that data.
Another scenario includes an existing machine is set to collect System Uptime data and its last reboot was prior to aggregation inside Analysis Center.