Hello,
After recreating my Data Warehouse database the Cube jobs fail. The cube errors are below as well as the Event ID's from the SQL server. Any help would be greatly appreciated!
Cube Error:
SQL Server Errors:
Technology Tips and News
Hello,
After recreating my Data Warehouse database the Cube jobs fail. The cube errors are below as well as the Event ID's from the SQL server. Any help would be greatly appreciated!
Cube Error:
SQL Server Errors:
I don't know what I did but the 2 event viewer errors above no longer appear. Now the below event appears. So confused right now.
Thanks for the info, unfortunately it did not work. I've done some more investigation and found out the issue seems to be in the database itself.
The error in event viewer is OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DateDim'.; 42S02.)
I tracked that down in the database dims and attempted to process the DIM in SQL Management Studio and this is where it fails. (Screenshot beloiw) It fails in the CalendarDate every time I process the DIM. Sometimes that is the only failure, other times one of the other dimensions also fails.
I don't know what I did but the 2 event viewer errors above no longer appear. Now the below event appears. So confused right now.
I don't know what I did but the 2 event viewer errors above no longer appear. Now the below event appears. So confused right now.
I don't know what I did but the 2 event viewer errors above no longer appear. Now the below event appears. So confused right now.