November 16, 2007 at 6:11 am
:exclamationmark: I am in desparate need of help with this.
I have a cube that has worked fine for months and is suddenly failing. There have been no changes made to the cube or the underlying fact table. My predessor, the creator of the cube, has a SQL Agent job set up that does a full process on the cube nightly so now it's shot.
Everything runs nicely until I reach the end and then I receive the following errors:
Initiating transaction in Database 'DM_CC'
Processing Cube 'Leads' failed. No changes have been made to the database.
Processing Partition 'WriteBack' failed. No changes have been made to the database.
Data source provider error: Invalid column name 'SUM_CustomerCount'.;42S22;Invalid column name 'SUM_LitWft'.;42S22;Invalid column name 'SUM_LitWfc'.;42S22;Invalid column name 'SUM_LitSzt'.;42S22;Invalid column name 'SUM_LitSzc'.;42S22;Invalid column name 'SUM_Claims'.;42S22;Invalid column name 'SUM_Requests'.;42S22;Invalid column name 'SUM_UnitsOwned'.;42S22;Invalid column name 'Day_L12'.;42S22;Invalid column name 'Month_L11'.;42S22;Invalid column name 'Year_L10'.;42S22;Invalid column name 'WebSource_L8'.;42S22;Invalid column name 'ContactMedia_L6'.;42S22;Invalid column name 'SourceMedia_L4'.;42S22;Invalid column name 'Demoprofile_L2'.;42S22; Time:11/16/2007 7:01:54 AM
As I said, no changes have been made, so I have no idea where the 'invalid column name' errors are coming from. They're not part of the fact table and I can't find them defined anywhere.
Help is needed quickly as I have users breathing down my neck as we approach the end of year.
November 26, 2007 at 11:06 pm
have you checked permissions or tried recreating the CUBE?
November 27, 2007 at 6:00 am
I stumbled on the answer, it had to be re-created from scratch. Thanks anyway.
Tim
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply