Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cube Process Error -- Urgent Expand / Collapse
Author
Message
Posted Thursday, December 3, 2009 4:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 11, 2013 5:24 AM
Points: 40, Visits: 431
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
Posted Friday, February 12, 2010 12:14 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 21, 2014 7:30 AM
Points: 488, Visits: 349
Hi

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

Regards
Christo
Post #864466
Posted Friday, February 12, 2010 12:36 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!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
Posted Friday, February 12, 2010 1:51 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 21, 2014 7:30 AM
Points: 488, Visits: 349
Thanks

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

Regards
Christo
Post #864491
Posted Friday, February 12, 2010 1:55 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!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 »

Add to briefcase

Permissions Expand / Collapse