Troubleshooting the Data Warehouse: Job(s) fail after importing a custom management pack

Troubleshooting the Data Warehouse: Job(s) fail after importing a custom management pack

  • Comments 1

This is the latest in “Troubleshooting the Data Warehouse” series. The goal of this series is to not only help you troubleshoot specific issues you may be experiencing but also teach you more about the data warehouse. For a complete list of posts in the series, check out Troubleshooting the Data Warehouse: An overview.

 

The symptom

 

One or more data warehouse jobs start failing after importing a custom management pack to Service Manager and synchronizing it to the Data Warehouse

The troubleshooting steps

 

To troubleshoot the above issue, please verify things in the following orders

1. Check the event log to ensure the root cause is the custom management pack

·         In Data Warehouse Management Server, open Operations Manager event log.

·         Find the event which is related to this job failure.

·         Determine the failure is related to the custom management pack you just imported.

2. Remove the custom management pack and recover from the failure

If the failure is related to the custom management pack, you should remove it and let the rest of the data warehouse operate as usual. You can fix the MP and reimport it later.

·         Uninstall the custom management pack via the Service Manager console

·         Run MP Sync job

·         Verify that this custom management pack is not in the Data Warehouse > Management Packs

·         After MP Sync job is completed, resume the failed job either from UI or cmdlet

·         You should be good to go

3. Fix and reimport the custom management pack

·         First you must remove the custom management pack and recover from the failure (step 2 above)

·         Fix the custom management pack

·         Import the custom management pack with fix into Service Manager, run MP Sync job to sync it to Data Warehouse

 

 

Leave a Comment
  • Please add 7 and 4 and type the answer here:
  • Post
  • hey I need a help:

    I've created a custom mp "Signature.Request": with the following class:

    <ClassTypes>

           <ClassType ID="Signature.FullfilmentClass" Accessibility="Public" Abstract="false" Base="WorkItem!System.WorkItem" Hosted="false" Singleton="false" Extension="false">

             <Property ID="Classification" Type="enum" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" EnumType="Classification" />

             <Property ID="Resolution" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="4000" MinLength="0" Required="false" Scale="0" />

             <Property ID="RequestRisk" Type="enum" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="false" Scale="0" EnumType="Risk" />

             <Property ID="Notes" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="8192" MinLength="0" Required="false" Scale="0" />

             <Property ID="RequestType" Type="enum" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="true" Scale="0" EnumType="RequestType" />

             <Property ID="TitleName" Type="string" AutoIncrement="false" Key="false" CaseSensitive="false" MaxLength="256" MinLength="0" Required="true" Scale="0" />

           </ClassType>

    </ClassTypes>

    and the relationship:

    <RelationshipTypes>

           <RelationshipType ID="AffectedComputer" Accessibility="Public" Abstract="false" Base="System!System.Reference">

             <Source ID="Source_95867301_599f_4506_bd69_53c765228d3a" MinCardinality="0" MaxCardinality="2147483647" Type="Signature.FullfilmentClass" />

             <Target ID="Target_a64f3261_6824_4a72_919b_c4da699aec48" MinCardinality="0" MaxCardinality="1" Type="System!System.Computer" />

           </RelationshipType>

    </RelationshipTypes>

    I want to create a report for this class:

    so I put a reference into the datawarehouse mp named " Signature.Request.DataWarehouse " to my work item class above :

    <Reference Alias="Request">

           <ID>Signature.Request</ID>

           <Version>1.0.0.1</Version>

           <PublicKeyToken>f5de3f4af6b36ef8</PublicKeyToken>

    </Reference>

    and the outriggers dimensions and facts attributes are :

    <Warehouse>

       <Outriggers>

         <Outrigger ID="Class" Accessibility="Public">

           <Attribute ID="ClassName" PropertyPath="$Context/Property[Type='Request!Signature.FullfilmentClass']/Classification$" />

         </Outrigger>

       </Outriggers>

       <Dimensions>

         <Dimension ID="Signature.FullfilmentDim" Accessibility="Public" InferredDimension="true" Target="Request!Signature.FullfilmentClass" HierarchySupport="Exact" Reconcile="false">

           <InclusionAttribute ID="Classification" PropertyPath="$Context/Property[Type='Request!Signature.FullfilmentClass']/Classification$" SlowlyChangingAttribute="false" />

           <InclusionAttribute ID="Resolution" PropertyPath="$Context/Property[Type='Request!Signature.FullfilmentClass']/Resolution$" SlowlyChangingAttribute="false" />

           <InclusionAttribute ID="RequestRisk" PropertyPath="$Context/Property[Type='Request!Signature.FullfilmentClass']/RequestRisk$" SlowlyChangingAttribute="false" />

           <InclusionAttribute ID="Notes" PropertyPath="$Context/Property[Type='Request!Signature.FullfilmentClass']/Notes$" SlowlyChangingAttribute="false" />

           <InclusionAttribute ID="RequestType" PropertyPath="$Context/Property[Type='Request!Signature.FullfilmentClass']/RequestType$" SlowlyChangingAttribute="false" />

           <InclusionAttribute ID="TitleName" PropertyPath="$Context/Property[Type='Request!Signature.FullfilmentClass']/TitleName$" SlowlyChangingAttribute="false" />

         </Dimension>

       </Dimensions>

       <Facts>

         <RelationshipFact ID="AffComputer" Accessibility="Public" Domain="DWBase!Domain.ConfigurationManagement" TimeGrain="Daily" SourceType="Request!Signature.FullfilmentClass">

           <Relationships RelationshipType="Request!AffectedComputer" TargetDimension="Signature.FullfilmentDim" />

         </RelationshipFact>

       </Facts>

    </Warehouse>

    I sealed this mp and imported it to the scsm console .. everything work fine .. the datawarehouse job mpsyncjob import it .. but the deployment failed .. I check the the server manager/ event viewer / microsoft / operations manager .. warnings and errors are thrown .. kindly check them below :

    the first warning :

    Log Name : Operations Manager

    Source Deployment

    Event ID : 33403  ... with the details below:

    EventData

      CreateAndDropIndexSignature.FullfilmentDim

      Signature.Request.DataWarehouse

      1.0.0.2

      Install

      System.Data.SqlClient.SqlException: Incorrect syntax near '.'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EnterpriseManagement.DataAccessLayer.SqlRetryHandler.ExecuteReader(ExecuteArguments executeArguments, QueryResults& queryResults) at Microsoft.EnterpriseManagement.DataAccessLayer.SqlRetryHandler.Execute[T](ExecuteArguments executeArguments, RetryPolicy retryPolicy, GenericExecute`1 genericExecute) at Microsoft.EnterpriseManagement.DataAccessLayer.SqlRetryHandler.ExecuteReader(SqlCommand sqlCommand, IList`1 prologEpilogList, IList`1 projection, QueryDefinition queryDefinition, RetryPolicy retryPolicy) at Microsoft.EnterpriseManagement.DataAccessLayer.QueryRequest.Execute(SqlNotificationRequest sqlNotificationRequest) at Microsoft.EnterpriseManagement.DataAccessLayer.QueryRequest.Execute() at Microsoft.SystemCenter.ResourceAccessLayer.SqlDbWriter.AddResource(IResource resource) at Microsoft.SystemCenter.ResourceAccessLayer.SqlResourceStore.AddResource(IResource resource) at Microsoft.SystemCenter.DeploymentEngine.SqlDeployer.Install() at Microsoft.SystemCenter.DeploymentEngine.ExecutionManager.Run(DeployerBase deployer) at Microsoft.SystemCenter.DeploymentEngine.ExecutionManager.Run(IXPathNavigable instance)

    after many tries to deploy the mp ... a final error is thrown with the following description:

    Log Name: Operations Manager

    Source : Deployment

    Event ID : 33410

    and with the following details:

    EventData

      CreateViewForEntitySignature.FullfilmentDim_DWDataMart

      Signature.Request.DataWarehouse

      1.0.0.2

      Install

      Could not find object 'Signature.FullfilmentDimvw' or you do not have permission.

    PS:in the DWStagingAndConfig a " dbo.MT_Signature$FullfilmentClass " table is created

      in the DWRepository and DWDataMart a " dbo.Signature.FullfilmentDim " table is created but still empty .. the record aren't sync to be shown into the report

    I appreciate your reply

    Thanks in advance

Page 1 of 1 (1 items)