Olivier Da Silva Blog's

Articles, Tips et News sur les Technologies Microsoft et plus particulièrement l'ensemble de la gamme System Center (SCCM, SCOM, SCVMM, SCSM, Orchestrator, App Controller, SCDPM)

Si le management pack Data Warehouse System Center Data Warehouse Base Library a son déploiement en échec suite à la mise à jour de votre plateforme SCSM 2012 vers le SP1.

Analysez les logs Operations Manager du serveur SCSM Data Warehouse et vous devrez remarquer les erreurs suivantes.

Table ‘BillableTimeHasWorkingUserFact_2013_Feb’ already has a primary key defined on it
Table ‘ComputerHasPrimaryUserFact_2013_Feb’ already has a primary key defined on it
Table ‘ComputerHostsLogicalDiskFact_2013_Feb’ already has a primary key defined on it
Table ‘ComputerHostsNetworkAdapterFact_2013_Feb’ already has a primary key defined on it
Table ‘ComputerHostsOperatingSystemFact_2013_Feb’ already has a primary key defined on it
Table ‘ComputerHostsPhysicalDiskFact_2013_Feb’ already has a primary key defined on it
Table ‘ComputerHostsProcessorFact_2013_Feb’ already has a primary key defined on it
Table ‘ConfigItemGroupContainsEntitiesFact_2013_Feb’ already has a primary key defined on it
Table ‘ConfigItemImpactsCustomersFact_2013_Feb’ already has a primary key defined on it
Table ‘ConfigItemOwnedByUserFact_2013_Feb’ already has a primary key defined on it
Table ‘ConfigItemRelatesToConfigItemFact_2013_Feb’ already has a primary key defined on it
Table ‘ConfigItemServicedByUserFact_2013_Feb’ already has a primary key defined on it
Table ‘GroupContainsConfigItemFact_2013_Feb’ already has a primary key defined on it
Table ‘ServiceContainsConfigItemFact_2013_Feb’ already has a primary key defined on it
Table ‘ServiceImpactsUserFact_2013_Feb’ already has a primary key defined on it
Table ‘WorkItemAboutConfigItemFact_2013_Feb’ already has a primary key defined on it
Table ‘WorkItemAffectedUserFact_2013_Feb’ already has a primary key defined on it
Table ‘WorkItemAssignedToUserFact_2013_Feb’ already has a primary key defined on it
Table ‘WorkItemCreatedByUserFact_2013_Feb’ already has a primary key defined on it
Table ‘WorkItemGroupContainsWorkItemFact_2013_Feb’ already has a primary key defined on it
Table ‘WorkItemHasBillableTimeFact_2013_Feb’ already has a primary key defined on it
Table ‘WorkItemHasParentWorkItemFact_2013_Feb’ already has a primary key defined on it
Table ‘WorkItemImpactsServiceFact_2013_Feb’ already has a primary key defined on it
Table ‘WorkItemRelatesToConfigItemFact_2013_Feb’ already has a primary key defined on it
Table ‘WorkItemRelatesToWorkItemFact_2013_Feb’ already has a primary key defined on it

Pour résoudre ce problème, vous devez supprimer les primary keys ci-dessus dans la base de données DWRepository et relancer le déploiement du management pack System Center Data Warehouse Base Library au sein de la console SCSM 2012.

Facebook Like
Anonymous