SOLVED
Home

SCOM 2016 and DPM 2016 MP - Data Warehouse failed to deploy database component

%3CLINGO-SUB%20id%3D%22lingo-sub-86370%22%20slang%3D%22en-US%22%3ESCOM%202016%20and%20DPM%202016%20MP%20-%20Data%20Warehouse%20failed%20to%20deploy%20database%20component%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-86370%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20getting%20the%20following%20errors%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EData%20Warehouse%20failed%20to%20deploy%20database%20component.%20Failed%20to%20deploy%20Data%20Warehouse%20component.%20The%20operation%20will%20be%20retried.%3CBR%20%2F%3E%26nbsp%3BException%20'DeploymentException'%3A%20Failed%20to%20perform%20Data%20Warehouse%20component%20deployment%20operation%3A%20Install%3B%20Component%3A%20DataSet%2C%20Id%3A%20'34f57e9b-2777-8c69-a5a6-fbc8d0f1824f'%2C%20Management%20Pack%20Version-dependent%20Id%3A%20'e3a96ce5-bfb2-07b8-ef66-4c711a6606c7'%3B%20Target%3A%20DataSet%2C%20Id%3A%20'3f4f9eb6-e811-4b90-a117-bf5fc4809b7b'.%20Batch%20ordinal%3A%208%3B%20Exception%3A%20Violation%20of%20UNIQUE%20KEY%20constraint%20'UN_StandardDatasetAggregationStorage_BaseTableName'.%20Cannot%20insert%20duplicate%20key%20in%20object%20'dbo.StandardDatasetAggregationStorage'.%20The%20duplicate%20key%20value%20is%20(tbl_DPM_BackupEvents).%3CBR%20%2F%3E%26nbsp%3BThe%20statement%20has%20been%20terminated.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%26nbsp%3BOne%20or%20more%20workflows%20were%20affected%20by%20this.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%26nbsp%3BWorkflow%20name%3A%20Microsoft.SystemCenter.DataWarehouse.Deployment.Component%3C%2FP%3E%3CP%3E%26nbsp%3BInstance%20name%3A%20Data%20Warehouse%20Synchronization%20Service%3C%2FP%3E%3CP%3E%26nbsp%3BInstance%20ID%3A%20%7B5F80CF0E-D4C5-E494-E0EB-FAF66CE1AA40%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-101085%22%20slang%3D%22en-US%22%3ERe%3A%20SCOM%202016%20and%20DPM%202016%20MP%20-%20Data%20Warehouse%20failed%20to%20deploy%20database%20component%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-101085%22%20slang%3D%22en-US%22%3E%3CP%3EUninstalling%20the%20DPM2016%20management%20packs%2C%20then%20running%20the%20SQL%20Script%20in%20the%20following%20article%20and%20reinstalling%20the%20MP's%2C%26nbsp%3Bfixed%20this%20problem%20for%20my%20system.%26nbsp%3B%20Even%20though%20script%20was%20written%20for%20older%20version.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgetblogpost.pendlenet.co.uk%2Fdata-warehouse-errors-after-upgrading-dpm-2012-r2-management-packs-to-dpm-2016%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgetblogpost.pendlenet.co.uk%2Fdata-warehouse-errors-after-upgrading-dpm-2012-r2-management-packs-to-dpm-2016%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-98095%22%20slang%3D%22en-US%22%3ERe%3A%20SCOM%202016%20and%20DPM%202016%20MP%20-%20Data%20Warehouse%20failed%20to%20deploy%20database%20component%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-98095%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20looked%20at%20the%20table%3F%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-98089%22%20slang%3D%22en-US%22%3ERe%3A%20SCOM%202016%20and%20DPM%202016%20MP%20-%20Data%20Warehouse%20failed%20to%20deploy%20database%20component%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-98089%22%20slang%3D%22en-US%22%3E%3CP%3EMine%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CP%20class%3D%22description%22%3EData%20Warehouse%20failed%20to%20deploy%20database%20component.%20Failed%20to%20deploy%20Data%20Warehouse%20component.%20The%20operation%20will%20be%20retried.%3CBR%20%2F%3EException%20'DeploymentException'%3A%20Failed%20to%20perform%20Data%20Warehouse%20component%20deployment%20operation%3A%20Install%3B%20Component%3A%20DataSet%2C%20Id%3A%20'34f57e9b-2777-8c69-a5a6-fbc8d0f1824f'%2C%20Management%20Pack%20Version-dependent%20Id%3A%20'e3a96ce5-bfb2-07b8-ef66-4c711a6606c7'%3B%20Target%3A%20DataSet%2C%20Id%3A%20'7e2f3e3f-c784-4567-a957-bfa615122176'.%20Batch%20ordinal%3A%208%3B%20Exception%3A%20Violation%20of%20UNIQUE%20KEY%20constraint%20'UN_StandardDatasetAggregationStorage_BaseTableName'.%20Cannot%20insert%20duplicate%20key%20in%20object%20'dbo.StandardDatasetAggregationStorage'.%20The%20duplicate%20key%20value%20is%20(tbl_DPM_BackupEvents).%3CBR%20%2F%3EThe%20statement%20has%20been%20terminated.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EOne%20or%20more%20workflows%20were%20affected%20by%20this.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EWorkflow%20name%3A%20Microsoft.SystemCenter.DataWarehouse.Deployment.Component%3CBR%20%2F%3E%3CBR%20%2F%3EInstance%20name%3A%20Data%20Warehouse%20Synchronization%20Service%3CBR%20%2F%3E%3CBR%20%2F%3EInstance%20ID%3A%20%7B6D2D6306-8886-7721-DE34-95A850188022%7D%3CBR%20%2F%3E%3CBR%20%2F%3EManagement%20group%3A%20xxxxx%20-%20Blocked%20out%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-98088%22%20slang%3D%22en-US%22%3ERe%3A%20SCOM%202016%20and%20DPM%202016%20MP%20-%20Data%20Warehouse%20failed%20to%20deploy%20database%20component%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-98088%22%20slang%3D%22en-US%22%3E%3CP%3Eyeah%2C%20exact%20same%20I%20think%2C%20I%20have%20to%20wait%20for%20it%20to%20cycle%20again%2C%20mine%20appears%20and%20then%20disappears%20from%20console.%26nbsp%3B%20I'll%20post%20next%20time%20it%20comes%20up.%26nbsp%3B%20Is%20your's%20a%20new%20installation%20like%20mine%3F%26nbsp%3B%20Could%20this%20just%20be%20file%20build%20per%20group%20in%20DPM%20or%20something%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-98087%22%20slang%3D%22en-US%22%3ERe%3A%20SCOM%202016%20and%20DPM%202016%20MP%20-%20Data%20Warehouse%20failed%20to%20deploy%20database%20component%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-98087%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20also%20having%20the%20same%20issue.%26nbsp%3B%20Error%20Appears%2C%20disappears%2C%20but%20keeps%20coming%20up.%26nbsp%3B%20DPM%20MP's%20seem%20to%20be%20the%20problem%2C%20but%20haven't%20found%20a%20resolution%20yet.%26nbsp%3B%20Yet%20DPM%20reports%20all%20information(Failures%20as%20I%20haven't%20changed%20alerts(VERY%20Few))%2C%20volumes%2C%20storage%2C%20systems%20covered%2C%20etc.%26nbsp%3B%20Haven't%20been%20able%20to%20find%20any%20info%20on%20this%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-89876%22%20slang%3D%22en-US%22%3ERe%3A%20SCOM%202016%20and%20DPM%202016%20MP%20-%20Data%20Warehouse%20failed%20to%20deploy%20database%20component%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-89876%22%20slang%3D%22en-US%22%3E%3CP%3Esame%20problem%20here%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Andre van den Berg
Occasional Contributor

We are getting the following errors:

 

 

Data Warehouse failed to deploy database component. Failed to deploy Data Warehouse component. The operation will be retried.
 Exception 'DeploymentException': Failed to perform Data Warehouse component deployment operation: Install; Component: DataSet, Id: '34f57e9b-2777-8c69-a5a6-fbc8d0f1824f', Management Pack Version-dependent Id: 'e3a96ce5-bfb2-07b8-ef66-4c711a6606c7'; Target: DataSet, Id: '3f4f9eb6-e811-4b90-a117-bf5fc4809b7b'. Batch ordinal: 8; Exception: Violation of UNIQUE KEY constraint 'UN_StandardDatasetAggregationStorage_BaseTableName'. Cannot insert duplicate key in object 'dbo.StandardDatasetAggregationStorage'. The duplicate key value is (tbl_DPM_BackupEvents).
 The statement has been terminated.


 One or more workflows were affected by this.


 Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component

 Instance name: Data Warehouse Synchronization Service

 Instance ID: {5F80CF0E-D4C5-E494-E0EB-FAF66CE1AA40

6 Replies

I'm also having the same issue.  Error Appears, disappears, but keeps coming up.  DPM MP's seem to be the problem, but haven't found a resolution yet.  Yet DPM reports all information(Failures as I haven't changed alerts(VERY Few)), volumes, storage, systems covered, etc.  Haven't been able to find any info on this issue.

 

yeah, exact same I think, I have to wait for it to cycle again, mine appears and then disappears from console.  I'll post next time it comes up.  Is your's a new installation like mine?  Could this just be file build per group in DPM or something?

Mine

Data Warehouse failed to deploy database component. Failed to deploy Data Warehouse component. The operation will be retried.
Exception 'DeploymentException': Failed to perform Data Warehouse component deployment operation: Install; Component: DataSet, Id: '34f57e9b-2777-8c69-a5a6-fbc8d0f1824f', Management Pack Version-dependent Id: 'e3a96ce5-bfb2-07b8-ef66-4c711a6606c7'; Target: DataSet, Id: '7e2f3e3f-c784-4567-a957-bfa615122176'. Batch ordinal: 8; Exception: Violation of UNIQUE KEY constraint 'UN_StandardDatasetAggregationStorage_BaseTableName'. Cannot insert duplicate key in object 'dbo.StandardDatasetAggregationStorage'. The duplicate key value is (tbl_DPM_BackupEvents).
The statement has been terminated.


One or more workflows were affected by this.


Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component

Instance name: Data Warehouse Synchronization Service

Instance ID: {6D2D6306-8886-7721-DE34-95A850188022}

Management group: xxxxx - Blocked out

Have you looked at the table?  

Solution

Uninstalling the DPM2016 management packs, then running the SQL Script in the following article and reinstalling the MP's, fixed this problem for my system.  Even though script was written for older version.

https://getblogpost.pendlenet.co.uk/data-warehouse-errors-after-upgrading-dpm-2012-r2-management-pac...

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies