none
Cube processing failing with event IDs 33573 and 33566

    Question

  • SCSM 2012 SP1

    SQL 2008 Analysis Services on the DW server.

    In prep for the SP1 upgrade I moved all the DW server databases off of this DW server to a remote SQL2012 server by following the DW database move document.

    Since upgrading to SP1 the CubeProcessing jobs have been failing with the following IDs:

    Log Name:      Operations Manager
    Source:        Data Warehouse
    Date:          5/13/2013 3:01:00 AM
    Event ID:      33573
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      MW247-PRDSQLLDC.wire.pvt
    Description:
    
    Message : An Exception was encountered while trying during cube processing.  Message=  Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055129594, Description: Server: The current operation was cancelled because another operation in the transaction failed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'CalendarDate' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'DayNumberInMonth' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'CalendarMonth' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'WeekNumberInYear' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'MonthNumber' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'DayOfWeek' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'YearNumber' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..      
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Data Warehouse" />
        <EventID Qualifiers="49152">33573</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2013-05-13T07:01:00.000000000Z" />
        <EventRecordID>400593</EventRecordID>
        <Channel>Operations Manager</Channel>
        <Computer>MW247-PRDSQLLDC.wire.pvt</Computer>
        <Security />
      </System>
      <EventData>
        <Data> Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055129594, Description: Server: The current operation was cancelled because another operation in the transaction failed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'CalendarDate' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'DayNumberInMonth' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'CalendarMonth' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'WeekNumberInYear' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'MonthNumber' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'DayOfWeek' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1056571392, Description: OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1055784860, Description: Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932980, Description: Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed..       Processing error encountered - Location: , Source: Microsoft SQL Server 2008 Analysis Services Code: -1054932979, Description: Errors in the OLAP storage engine: An error occurred while the 'YearNumber' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed..      </Data>
      </EventData>
    </Event>

    Log Name:      Operations Manager
    Source:        Data Warehouse
    Date:          5/13/2013 3:01:38 AM
    Event ID:      33566
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      MW247-PRDSQLLDC.wire.pvt
    Description:
    
    Message : An Exception was encountered while trying to process a cube.  Cube Name: SystemCenterSoftwareUpdateCube Exception Message: Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    Server: The current operation was cancelled because another operation in the transaction failed.
    Internal error: The operation terminated unsuccessfully.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'CalendarDate' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'WeekNumberInYear' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'DayOfWeek' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'DayNumberInMonth' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'CalendarMonth' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'MonthNumber' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
     Stack Trace:    at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
       at Microsoft.AnalysisServices.AnalysisServicesClient.Process(IMajorObject obj, ProcessType type, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, ImpactDetailCollection impact, XmlaWarningCollection warnings)
       at Microsoft.AnalysisServices.Server.Process(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
       at Microsoft.AnalysisServices.Server.SendProcess(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
       at Microsoft.AnalysisServices.ProcessableMajorObject.Process(ProcessType processType, ErrorConfiguration errorConfiguration, XmlaWarningCollection warnings)
       at Microsoft.SystemCenter.Warehouse.Olap.OlapCube.ProcessDimensions(ICollection`1 dimensions, Server server, HashSet`1 asDimsProcessed, Int32 dimProcessingInterval, Boolean forceProcess, Boolean parallelProcess, Boolean useXmlaCommands)
       at Microsoft.SystemCenter.Warehouse.Olap.OlapCube.Process(ManagementPackCube mpCube).
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Data Warehouse" />
        <EventID Qualifiers="49152">33566</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2013-05-13T07:01:38.000000000Z" />
        <EventRecordID>400594</EventRecordID>
        <Channel>Operations Manager</Channel>
        <Computer>MW247-PRDSQLLDC.wire.pvt</Computer>
        <Security />
      </System>
      <EventData>
        <Data>SystemCenterSoftwareUpdateCube</Data>
        <Data>Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    Server: The current operation was cancelled because another operation in the transaction failed.
    Internal error: The operation terminated unsuccessfully.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'CalendarDate' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'WeekNumberInYear' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'DayOfWeek' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'DayNumberInMonth' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'CalendarMonth' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'MonthNumber' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed.
    </Data>
        <Data>   at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
       at Microsoft.AnalysisServices.AnalysisServicesClient.Process(IMajorObject obj, ProcessType type, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, ImpactDetailCollection impact, XmlaWarningCollection warnings)
       at Microsoft.AnalysisServices.Server.Process(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
       at Microsoft.AnalysisServices.Server.SendProcess(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
       at Microsoft.AnalysisServices.ProcessableMajorObject.Process(ProcessType processType, ErrorConfiguration errorConfiguration, XmlaWarningCollection warnings)
       at Microsoft.SystemCenter.Warehouse.Olap.OlapCube.ProcessDimensions(ICollection`1 dimensions, Server server, HashSet`1 asDimsProcessed, Int32 dimProcessingInterval, Boolean forceProcess, Boolean parallelProcess, Boolean useXmlaCommands)
       at Microsoft.SystemCenter.Warehouse.Olap.OlapCube.Process(ManagementPackCube mpCube)</Data>
      </EventData>
    </Event>

    I think the key here is the line:

    OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001."

    which looks to me like the Analysis Services database is still trying to connect to the DWDatamart database using the old connection string in the DWDatamart datasource for the DWASDatabase.  But I've change the data source to reflect the new location of the DWDatamart database:

    Provider=SQLNCLI10.1;Data Source=NEWDWDATABASEServer;Integrated Security=SSPI;Initial Catalog=DWDataMart

    Also, if I show that connection string by clicking on the "..." and hit "Test Connection" it says the connection succeeded.

    The data source is set to use the SCSM Analysis Services service account.

    Is there anywhere else I could have missed that specifies an Analysis Services connection to the DWDatamart database besides in the data sources?

    Monday, May 13, 2013 1:44 PM

Answers

All replies

  • No one wants to touch this one? LOL.  Don't blame you.
    Wednesday, May 15, 2013 7:52 PM
  • SO I've since upgraded SSAS to 2012 on the DW server.  I've also changed the SQL providers on the AS data sources to SQL11.0 but my cubes are still failing to process with the same error.'

    I have successfully tested the connection on each data source to the DW warehouse databases on the external SQL 2012 server.

    Thursday, July 04, 2013 6:19 PM
  • I'll bite, I found an article which may prove to help you quite a bit. It addresses both the Event IDs and offers some pretty solid insight into your situation:

    http://dougsigmon.wordpress.com/2012/11/02/scsm-2012-cubes-steady-state-not-achievable-via-the-scsm-2012-console/


    Let me know how it works for ya

    Thursday, July 04, 2013 7:15 PM
  • Thanks for the pointer.

    I did take a look at that article but couldn't fine anything directly applicable to my situation.  It seems in my case (assuming that the error isn't a red herring) that it's related to some problem with the SSAS on the DW server not being able to talk to the DWDataMart database on the remote SQL server.

    Yet I've changed the data sources on SSAS to point to the new server and the "Test Connection" button for each data source succeeds.

    Thursday, July 04, 2013 7:36 PM
  • I should add,

    I tried processing the cubes directly on the SSAS server and some of the Measure Groups do process successfully.

    For instance, for the SystemCenterWorkItemCube several Measure Groups, e.g. WorkItemRelatesToConfigItem, process.

    But it then fails with"


        Processing Cube 'SystemCenterWorkItemsCube' completed.
            Start time: 7/4/2013 3:30:33 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:06
            Processing Measure Group 'ComputerDim' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'ConfigItemDim' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'CreatedByUserDim' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'IncidentIsAboutService' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'RelatedWorkItemDim' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'ReleaseAssignedToUser' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'ReleaseSLAInstanceInformation' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'ServiceContainsComputer' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
                Processing Partition 'ServiceContainsComputer' completed.
                    Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'SLAConfigurationDim' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemCreatedByUser' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemDim' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemGroupContainsWorkItem' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemGroupDim' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemHasBillableTime' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemIsAboutComputer' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemIsAboutComputer_ConfigItemDim' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemRelatesToConfigItem' completed.
                Start time: 7/4/2013 3:30:40 PM; End time: 7/4/2013 3:30:40 PM; Duration: 0:00:00
    Errors and Warnings from Response
        Internal error: The operation terminated unsuccessfully.
        OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
        Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
        Errors in the OLAP storage engine: An error occurred while processing the 'ServiceContainsComputer' partition of the 'ServiceContainsComputer' measure group for the 'SystemCenterWorkItemsCube' cube from the DWASDataBase database.
        Server: The current operation was cancelled because another operation in the transaction failed.

    Thursday, July 04, 2013 7:40 PM
  • 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.

    This is where I believe your issue lies, there's a solution posted within the following blog here:

    http://geekswithblogs.net/LifeLongTechie/archive/2012/06/21/ssas-processing-error-client-unable-to-establish-connection-08001-encryption.aspx

    Seems to be a small trivial correction


    • Marked as answer by JayScovill Tuesday, August 13, 2013 12:54 PM
    Thursday, July 04, 2013 8:05 PM
  • Do you think that after all my searching I should have found that article? Well, I didn't and you did.  Thanks, that definitely helped but it hasn't completely solved the problem.

    It appears to have eliminated the error with regards to client encryption.  But the others still remain:

        Processing Cube 'SystemCenterWorkItemsCube' completed.
            Start time: 7/4/2013 4:17:36 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:06
            Processing Measure Group 'ComputerDim' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'ConfigItemDim' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'CreatedByUserDim' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'IncidentIsAboutService' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'RelatedWorkItemDim' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'ReleaseAssignedToUser' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'ReleaseSLAInstanceInformation' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'ServiceContainsComputer' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
                Processing Partition 'ServiceContainsComputer' completed.
                    Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'SLAConfigurationDim' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemCreatedByUser' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemDim' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemGroupContainsWorkItem' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemGroupDim' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemHasBillableTime' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemIsAboutComputer' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemIsAboutComputer_ConfigItemDim' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
            Processing Measure Group 'WorkItemRelatesToConfigItem' completed.
                Start time: 7/4/2013 4:17:43 PM; End time: 7/4/2013 4:17:43 PM; Duration: 0:00:00
    Errors and Warnings from Response
        Internal error: The operation terminated unsuccessfully.
        OLE DB error: OLE DB or ODBC error.
        Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DWDataMart', Name of 'DWDataMart'.
        Errors in the OLAP storage engine: An error occurred while processing the 'ServiceContainsComputer' partition of the 'ServiceContainsComputer' measure group for the 'SystemCenterWorkItemsCube' cube from the DWASDataBase database.
        Server: The current operation was cancelled because another operation in the transaction failed.

    It's possible there are more than a few things wrong seeing as there seems to be more than one error message.  The one I'm really scratching my head about is the references to the ServiceContainsComputer measure group, etc. 

    Thursday, July 04, 2013 8:19 PM

  •     OLE DB error: OLE DB or ODBC error.

    I was thinking this was the issue earlier before I linked the previous article, thought it would resolve the whole issue, but are you sure you have the correct permissions for the Run As account? The account you are using to run Analysis Services must have the public role and datareader rights on the Project Server Reporting database.
    Thursday, July 04, 2013 10:30 PM
  • The service account that SSAS is running as has db_datareader and public permissions on the CMDWDataMart,DWDataMart and OMDWDatamart databases.

    Because some of the Measure Groups do appear to get processed when I process the cubes from within SSAS I'm wondering now if the problem is really with whatever attributes of the dimensions it's failing on for each particular cube rather than really any kind of connectivity problem to the database.

    I've already had to go through and remove the primary key on a whole bunch of tables in the DWStagingandConfig database because of a semi-successful SP1 upgrade.  There were a lot of DW managment pcks that were stuck in a Failed and Waiting deployment status because primary keys for a lot of tables already existed.  According to another blog post explaining the problem it was probably a result of me not properly stopping the DW jobs before the upgrade.  That is all corrected now and all my management packs are in a Completed deployment status.

    But it makes me wonder if this is related to that also.  It may be time to give MS a call.  I've been struggling with this off and on for a month now and am really no closer to solution.


    • Edited by JayScovill Friday, July 05, 2013 1:30 PM spelling
    Friday, July 05, 2013 1:29 PM

  •     Errors in the OLAP storage engine: An error occurred while processing the 'ServiceContainsComputer' partition of the 'ServiceContainsComputer' measure group for the 'SystemCenterWorkItemsCube' cube from the DWASDataBase database.
      

    The DW jobs shouldn't be affecting this in my opinion.

    I believe you may need to try to process each dimension independently, and then try full cube processing again.

    If any of the dims fail, you should get an error message pointing you to the main problem as the error is also indicating "The current operation was cancelled because another operation in the transaction failed."

    Friday, July 05, 2013 2:17 PM
  • For example, I went into your original post and took another look at the code.

    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DateDim', Name of 'DateDim' was being processed.Errors in the OLAP storage engine: An error occurred while the 'MonthNumber' attribute of the 'DateDim' dimension from the 'DWASDataBase' database was being processed. Stack Trace:

    I believe you may need to resolve all these dim errors individually first.
    Friday, July 05, 2013 2:22 PM
  • Just wanted to update that it turned out it was just a matter of switching from the SQL 11.0 Native provider to the OLEDB for SQL provider as instructed by MS support.

    I had done this before as suggested but I was still getting an error.  The only difference this time was that I changed the authentication for the data sources in SSAS to use the service account instead of explicitly specifying the credentials to use.  They are the same credentials (the SSAS service account) but it's working now.

    I also used Travis Wright's run-etl.ps1 script to run everything in the correct order.  I don't know if that made any difference but that script completes now whereas before it would exit at one of the cube processing jobs with a job in unexpected state error.

    Now, the only outstanding issue is that my Extract, Transform and MPSync jobs don't run as scheduled.  All the load jobs and cube processing jobs run fine with no error.

    The Extract, Transform and MPSync jobs are all in good status with no errors so I have yet to figure out why they aren't running at all.  They run fine manually.

    Tuesday, August 13, 2013 12:59 PM