Post reply

Cube Process Error -- Urgent

  • December 3, 2009 at 4:09 am

    #228291

    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

  • February 12, 2010 at 12:14 am

    #1117891

    Hi

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

    Regards

    Christo

  • February 12, 2010 at 12:36 am

    #1117894

    Maybe this[/url] can be of help.

    Regards,

    Willem
    http://wschampheleer.wordpress.com[/url]

  • February 12, 2010 at 1:51 am

    #1117911

    Thanks

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

    Regards

    Christo

  • February 12, 2010 at 1:55 am

    #1117913

    Great! Thank you for your feedback.

    Regards,

    Willem
    http://wschampheleer.wordpress.com[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply