As you can see in the screen shot, everything is failing.  I have tried un-registering and regerstering the data warehouse but I get the same results. There arent any relevent events on the SCSM server, but the data warehouse has the following:

Event 33537:

Deployment related exception has been caught during ETL. This is either due to a failure in Deployment or we have exceeded the number of retry attempts. Work item will be marked as failed.

Additional information:

ETLModule: etlMod=NULL

RetryAttempts: 0

WorkItem:  WorkItemId = 35013940, processModuleId = 11694, isDirty = True, BatchId = 115291, status = Failed, RetryCount = 0, ErrorCount = 1925, TakenTime = 12/20/2013 19:30:45, Module = ModuleName = LoadDWDataMartReleaseType, ModuleType = System, ModuleDescription = Deployment Execution Step, ProcessCategoryName = Load, ProcessName = Load.Common, DeletedBatchId=0

Exception details:

Exception type: Microsoft.EnterpriseManagement.Common.ObjectNotFoundException

Exception message: An object of class ManagementPackWarehouseModuleType with ID 28be8a8c-772c-4d5a-94df-2e30784497d7 was not found.

Stack trace:

   at Microsoft.EnterpriseManagement.DataWarehouseManagement.GetWarehouseModuleType(Guid id)

   at Microsoft.SystemCenter.Warehouse.Utility.Store.GetWarehouseModule(Guid id)

   at Microsoft.SystemCenter.Etl.ETLModule.GetModule(WorkItem etlWI)

   at Microsoft.SystemCenter.Etl.ETLModule.OnDataItem(DataItemBase dataItem, DataItemAcknowledgementCallback acknowledgedCallback, Object acknowledgedState, DataItemProcessingCompleteCallback completionCallback, Object completionState)

Events 33333:

Data Access Layer rejected retry on SqlError:

Request: CreateSolutionPackImportMessage -- (TransactionId=e5fad4da-21d2-41d9-b818-97c6efb299bb), (Message=PABEAGUAcABsAG8AeQBtAGUAbgB0AE0AZQBzAHMAYQBnAGUAIAB4AG0AbABuAHMAPQAnAGgAdAB0AHAAOgAvAC8AcwBjAGgAZQBtAGEAcwAuAG0AaQBjAHIAbwBzAG8A...), (RETURN_VALUE=-1)

Class: 0

Number: 3621

Message: The statement has been terminated.

And

Data Access Layer rejected retry on SqlError:

Request: CreateSolutionPackImportMessage -- (TransactionId=e5fad4da-21d2-41d9-b818-97c6efb299bb), (Message=PABEAGUAcABsAG8AeQBtAGUAbgB0AE0AZQBzAHMAYQBnAGUAIAB4AG0AbABuAHMAPQAnAGgAdAB0AHAAOgAvAC8AcwBjAGgAZQBtAGEAcwAuAG0AaQBjAHIAbwBzAG8A...), (RETURN_VALUE=-1)

Class: 16

Number: 266

Message: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.

And a lot of these...

Message: Failed to create BaseModule InstanceWrapper

 Module name: TransformChangeImpact

 Process: Transform

 Entity type: Outrigger

 Entity name: ChangeImpact

 Entity GUID: dcb7f8f8-a4e4-876e-9cd8-dd98f7aab4d1

 Field warehouse source ID value: 1

 Module GUID: 82e2491e-d690-c73c-b794-807346fa8a7e

 

Message: Failed to create BaseModule InstanceWrapper

 Module name: LoadOMDWDataMartIncidentResolutionCategory

 Process: Load

 Entity type: Outrigger

 Entity name: IncidentResolutionCategory

 Entity GUID: b668ce94-7450-6adc-2ad0-b9104c82b86b

 Field warehouse source ID value: 1

 Module GUID: 5d0ed3d3-068b-9315-d637-79d4ce8a5fe1

At first (after some google-ing) I figured it was due o bad DB grooming. I tried following these instructions:

http://social.technet.microsoft.com/Forums/systemcenter/en-US/5919b0d7-4510-4d96-a043-89092655cc06/error-in-transformcommon-etl-job?forum=dwreportingdashboards

and I did this...

http://support.microsoft.com/kb/2853442

But it still fails.

Any suggestions?

We're running 2012 sp1 on SQL 2008R2.

Do you have MPs that have failed deployments? If yes, right click on them and click on "Restart Deployment". You kind of have to figure out the sequence if there are dependencies. If the deployment fails, post the error message from the event log (Operations Manager log source)

If you recently upgraded to 2012 R2, you may want to execute the script from the release notes (http://technet.microsoft.com/en-us/library/dn299381.aspx)

• Edited by salpad Tuesday, December 24, 2013 4:28 PM

Hi Pete Barbuto,

I'm facing almost the same problem, any luck with you to fix this issue? Does the SQL script solved it?

( https://technet.microsoft.com/en-us/library/dn299381.aspx ) 

Awaiting for your reply

Best Regards

• Edited by Khaled Mostafa Gaafar Elzayady Thursday, January 22, 2015 10:25 AM

This was a long time ago and I don't recall the exact environment that I was working in. Chances are the scripts did not work and I didn't find an actual fix or I would have posted the solution, I'm pretty good about doing that. Most likely I ended up re-installing the DW.