Cube Process Error -- Urgent

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Cube Process Error -- Urgent

Cube Process Error -- Urgent

Rate Topic

Display Mode

Topic Options

Author

Message

JoyKing

Posted Thursday, December 03, 2009 4:09 AM

SSC Rookie

Group: General Forum Members
Last Login: Sunday, April 21, 2013 8:02 PM
Points: 38, Visits: 429

Hi Team,

I am creating sample cube with one single table.

Table Name: Test_Cube
ID int Primary key
State Varchar(50)
Year Varchar(50),
Sales Int
Quantity Int

Table has 100 records.

Steps followed:
Create Datasource
Create Data source view
Create Dimension (State, Year)
Create Cube
Deployed successfully

While processing showing below error.

Processing Dimension 'State_Year' completed successfully.
Start time: 12/3/2009 3:57:23 PM; End time: 12/3/2009 3:57:23 PM; Duration: 0:00:00
Processing Dimension Attribute '(All)' completed successfully.
Start time: 12/3/2009 3:57:23 PM; End time: 12/3/2009 3:57:23 PM; Duration: 0:00:00
Processing Dimension Attribute 'State' completed successfully.
Start time: 12/3/2009 3:57:23 PM; End time: 12/3/2009 3:57:23 PM; Duration: 0:00:00
Processing Dimension Attribute 'Year' completed successfully.
Start time: 12/3/2009 3:57:23 PM; End time: 12/3/2009 3:57:23 PM; Duration: 0:00:00
Errors and Warnings from Response
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Errors in the high-level relational engine. The following exception occurred while an operation was being performed on a data source view: Could not load type 'ComparisonBySelector`2' from assembly 'System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' due to value type mismatch..
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Test Cube', Name of 'State_Year' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'State' attribute of the 'State_Year' dimension from the 'Analysis Services Project2' database was being processed.
Server: The operation has been cancelled.

Thanks in advance,
Keerthy

Post #828040

Christo Wolmarans

Posted Friday, February 12, 2010 12:14 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, June 19, 2012 5:02 AM
Points: 488, Visits: 348

Hi

I am getting the exact same error when processing my cube as well. does anyone have any advise?

Regards
Christo

Post #864466

wschampheleer

Posted Friday, February 12, 2010 12:36 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 2:02 AM
Points: 846, Visits: 303

Maybe this can be of help.

Regards,

Willem
http://wschampheleer.wordpress.com

Post #864469

Christo Wolmarans

Posted Friday, February 12, 2010 1:51 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, June 19, 2012 5:02 AM
Points: 488, Visits: 348

Thanks

That solved the problem. I did a restart on the server and it's working again.

Regards
Christo

Post #864491

wschampheleer

Posted Friday, February 12, 2010 1:55 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 2:02 AM
Points: 846, Visits: 303

Great! Thank you for your feedback.

Regards,

Willem
http://wschampheleer.wordpress.com

Post #864493

« Prev Topic | Next Topic »

Permissions