none
cubes RRS feed

  • Question

  • hello.

    I installed scsm 2019 and move existing tickets from my scsm2012r2. After i installed dw I found that change and Activity management Cube are failing. I was using this article https://social.technet.microsoft.com/wiki/contents/articles/37780.scsm-datawarehouse-jobs-failing.aspx but no any success. There is no any issue with memory or cpu

    I checked the logs and seeing this warning The attribute key cannot be found when processing: Table: 'ChangeRequestDim', Column: 'ChangeRequest_ScheduledStartDate__DateKey', Value: '20990831'. The attribute is 'DateKey'..     Down bellow are the sequence of the logs.  

    1. ERROR 33573

    Message : An Exception was encountered while trying during cube processing.  Message=  Processing error encountered - Location: , Source: Microsoft SQL Server 2016 Analysis Services Code: -1054932986, Description: Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation..       Processing error encountered - Location: , Source: Microsoft SQL Server 2016 Analysis Services Code: -1054932978, Description: Errors in the OLAP storage engine: An error occurred while processing the 'ChangeRequestDim' partition of the 'ChangeRequestDim' measure group for the 'SystemCenterChangeAndActivityManagementCube' cube from the DWASDataBase database..       Processing error encountered - Location: , Source: Microsoft SQL Server 2016 Analysis Services Code: -1056964601, Description: Internal error: The operation terminated unsuccessfully..       Processing error encountered - Location: , Source: Microsoft SQL Server 2016 Analysis Services Code: -1055129594, Description: Server: The current operation was cancelled because another operation in the transaction failed..    

    2, Warning   33574

    Message : Cube Processing workitem has failed.

    This is most likely caused by the DWDataMart (primary datamart) being out of sync from other marts.

    This is an intermittent problem and will resolve on its own as the Load jobs complete their runs.

    However, to work around this issue, administrators can manually start the Load.Common load job, wait for it to complete and then start the Cube processing job.

    3.Warning 33573

    Message : An Exception was encountered while trying during cube processing.  Message=  Processing warning encountered - Location: , Source: Microsoft SQL Server 2016 Analysis Services Code: 1092550657, Description: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'ChangeRequestDim', Column: 'ChangeRequest_ScheduledStartDate__DateKey', Value: '20990831'. The attribute is 'DateKey'..     

    4. Error 33583

    Cube Processing Message: Processing for measure group ChangeRequestDim failed

    5.  Error 33583

    Cube Processing Message: Processing Measure Groups encountered error for cube: SystemCenterChangeAndActivityManagementCube

    6. Error 33583

    Cube Processing Message: Processing for cube SystemCenterChangeAndActivityManagementCube did not succeed

    7. error 33566

    Message : An Exception was encountered while trying to process a cube.  Cube Name: SystemCenterChangeAndActivityManagementCube Exception Message: An exception occurred while processing the cube.  Please see the event viewer log for more information.  Cube:  SystemCenterChangeAndActivityManagementCube Stack Trace:    at Microsoft.SystemCenter.Warehouse.Olap.OlapCube.Process(ManagementPackCube mpCube).

    8. error 33580

    Job Failed. JobName = Process.SystemCenterChangeAndActivityManagementCube;  JobCategory = CubeProcessing; BatchId = 9331; WorkitemId = 1913565; ModuleName = Process_SystemCenterChangeAndActivityManagementCube; ErrorDetails = <Errors><Error EventTime="2019-07-09T14:11:50.9913551Z">An exception occurred while processing the cube.  Please see the event viewer log for more information.  Cube:  SystemCenterChangeAndActivityManagementCube</Error></Errors>;

    9. error 33580

    Job Failed. JobName = Microsoft.SystemCenter.Orchestration.Configuration.BB154DA0-BF6E-47B4-8A16-5569E7FE222C;  JobCategory = Deployment; BatchId = 9360; WorkitemId = 1916778; ModuleName = MPDeployment; ErrorDetails = <Errors><Error EventTime="2019-07-09T14:21:32.3981539Z">2019-07-09T14:21:32.3981539Z - Value cannot be null.

    Parameter name: id</Error></Errors>;

    910 error 33580

    Job Failed. JobName = Microsoft.SystemCenter.Orchestration.Configuration.484038BC-1CC8-477A-AB15-EABC36E145C0;  JobCategory = Deployment; BatchId = 9361; WorkitemId = 1916779; ModuleName = MPDeployment; ErrorDetails = <Errors><Error EventTime="2019-07-09T14:21:33.7262759Z">2019-07-09T14:21:33.7262759Z - Value cannot be null.

    Parameter name: id</Error></Errors>;

    Tuesday, July 9, 2019 3:47 PM

All replies