none
Errors in the OLAP storage engine RRS feed

  • General discussion

  • Job is scheduled to process a cube. The job failed with the below errors:

    Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim ID', Name of 'Dim ID' was being processed.  
    End Error  Error: 2015-01-02 02:17:52.73     
    Code: 0xC11F000D     
    Source: Process Dimensions Analysis Services Execute DDL Task     
    Description: Errors in the OLAP storage engine: An error occurred while the 'HID' attribute of the 'Dim ID' dimension from the database was being processed.  
    End Error  Error: 2015-01-02 02:17:52.75     
    Code: 0xC1060000     
    Source: Process Dimensions Analysis Services Execute DDL Task     
    Description: OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.  
    End Error  Error: 2015-01-02 02:17:52.76     
    Code: 0xC11F000C     
    Source: Process Dimensions Analysis Services Execute DDL Task     
    Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Nme', Name of 'Dim Nme' was being processed.  
    End Error  Error: 2015-01-02 02:17:52.76     
    Code: 0xC11F000D     
    Source: Process Dimensions Analysis Services Execute DDL Task    

    Description: Errors in the OLAP storage engine: An error occurred while the 'NME' attribute of the 'Dim Nme' dimension from the database was being processed.  
    End Error  Error: 2015-01-02 02:17:52.78     
    Code: 0xC1060000     
    Source: Process Dimensions Analysis Services Execute DDL Task     
    Description: OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.  
    End Error  Error: 2015-01-02 02:17:52.78     
    Code: 0xC11F000C     
    Source: Process Dimensions Analysis Services Execute DDL Task     
    Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Ky', Name of 'Dim Ky' was being processed.  
    End Error  Error: 2015-01-02 02:17:52.79     
    Code: 0xC11F000D     
    Source: Process Dimensions Analysis Services Execute DDL Task     Description: Errors in the OLAP storage engine: An error occurred while the 'KY' attribute of the 'Dim Ky' dimension from the database was being processed.  
    End Error  Error: 2015-01-02 02:17:52.81     
    Code: 0xC11F000D     
    Source: Process Dimensions Analysis Services Execute DDL Task     
    Description: Errors in the OLAP storage engine: An error occurred while the 'Id' attribute of the 'Dim Txt' dimension from the database was being processed.  
    End Error  Error: 2015-01-02 02:17:52.81     
    Code: 0xC11F000D     
    Source: Process Dimensions Analysis Services Execute DDL Task     
    Description: Errors in the OLAP storage engine: An error occurred while the 'Id' attribute of the 'VWIprve' dimension from the database was being processed.  
    End Error  DTExec: The package execution returned DTSER_FAILURE (1).  
    Started:  1:00:22 AM  
    Finished: 2:18:02 AM  
    Elapsed:  4660.47 seconds.  The package execution failed.  The step failed.

    Please help!!!!!!


    Friday, January 2, 2015 1:38 PM

All replies

  • Hi,

    According to your description, you create a SSIS package to process SSAS cube, the problem is that you are experiencing the error "Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Nme', Name of 'Dim Nme' was being processed“ while executing the job, right?

    Based on my research, the issue can be caused by that you haven't set a primary key in your dimension table. Here is a blog that describe this issue, please see:
    http://blogs.microsoft.co.il/barbaro/2014/03/03/errors-in-the-olap-storage-engine-processing-a-large-dimension/

    Regards


    Charlie Liao
    TechNet Community Support

    Monday, January 5, 2015 2:01 AM
    Moderator
  • Hi Charlie,

    Thanks for your time and prompt reply.

    Yes, The error was shown while executing the job.

    Will go through the link and then sort a way out.

    Regards,

    NG


    Monday, January 5, 2015 2:59 PM