14 Replies Latest reply on Jan 29, 2016 12:49 PM by Krunal Thanki

    Reconciliation not happening for BMC_Product

      Share This:

      Hi,

       

      Recently we have a strange issue on reconciliation, as few of the product is not getting reconciled. Below are the steps we implemented

       

      1) Use AI job to pull data from BBCA for BMC_Product & BMC_HostedSystemComponent (Product to machine realtionship) under staging dataset BMC.STAGE.PRODUCT

      2) Created a reconciliation job with only activity as a identification and attached a qualification group with condition to consider only BMC_Product & BMC_HostedSystemComponent

       

      When we ran the job, out of 8000 records, only 3000 got identified, rest all have still reconciliation ID as a 0

       

      We want to understand, where we went wrong.

        • 1. Re: Reconciliation not happening for BMC_Product
          Gustavo del Gerbo

          Hi Krunal,

           

          You will need to attach the RE Job logs for that particular run.

          • 2. Re: Reconciliation not happening for BMC_Product

            Hi Gustavo,

             

            Thanks for the response.

             

            I ran the job couple of mins back, below is the only error. Job is not even considering all CIs which are not identified. (Recon ID = 0)

             

            [2016/01/20 13:04:16.0840] [ ERROR ] [TID: 0000003732]  : Failed in getting parent instance for instance <OI-9FDE998806454D578D76C055CD0FA324> of class <BMC.CORE:BMC_ComputerSystem>::

            [2016/01/20 13:04:16.0840] [ ERROR ] [TID: 0000003732]  : ARERR[120006] Instance not found.

            [2016/01/20 13:04:16.0840] [ ERROR ] [TID: 0000003732]  : OI-9FDE998806454D578D76C055CD0FA324

            [2016/01/20 13:04:16.0840] [ ERROR ] [TID: 0000003732]  : ARERR[120006] Instance not found.

            [2016/01/20 13:04:16.0840] [ ERROR ] [TID: 0000003732]  : OI-9FDE998806454D578D76C055CD0FA324

            1 of 1 people found this helpful
            • 3. Re: Reconciliation not happening for BMC_Product
              Gustavo del Gerbo

              Krunal,

               

              BMC_Product is a weak class. A Product exists because a Computer has it. To identify Products we use the Parent Computer Class REID. It is advisable that you identify and merge your products when you identify and merge your Computer Systems.

              • 4. Re: Reconciliation not happening for BMC_Product

                Hi Gustavo,

                 

                CI in BMC_ComputerSystem is already reconciled in past.

                 

                E.g.

                BMC_ComputerSystem = Machine 1

                BMC_Product = PRD1 & PRD2

                BMC_HostedSystemComponents = Machine 1 <=> InstalledSoftware<=> PRD1, Machine 1 <=> InstalledSoftware<=> PRD2,

                 

                Machine 1 was reconciled already and has Recon ID but where in PRD1, PRD2 and BMC_HostedSystemComponents entries do not have Recon ID generated.

                • 5. Re: Reconciliation not happening for BMC_Product
                  Gustavo del Gerbo

                  Do these computer system exist in BMC.STAGE.PRODUCT?

                  • 6. Re: Reconciliation not happening for BMC_Product

                    Yes it does exist. I will again ran the job in dwbug mode to get more detail.

                    • 7. Re: Reconciliation not happening for BMC_Product
                      Gustavo del Gerbo

                      It is strange that they exist. You can see the Recon Engine trying to find the parent for one of the Product CIs:

                      [2016/01/20 13:04:16.0840] [ ERROR ] [TID: 0000003732]  : Failed in getting parent instance for instance <OI-9FDE998806454D578D76C055CD0FA324> of class <BMC.CORE:BMC_ComputerSystem>::

                      [2016/01/20 13:04:16.0840] [ ERROR ] [TID: 0000003732]  : ARERR[120006] Instance not found.

                      [2016/01/20 13:04:16.0840] [ ERROR ] [TID: 0000003732]  : OI-9FDE998806454D578D76C055CD0FA324

                      • 8. Re: Reconciliation not happening for BMC_Product

                        Hi Gustavo,

                         

                        Yes, it is really strange. Today I have ran the job with DEBUG and log files are almost 15 MB in size, but below is the initial summary,

                         

                         

                         

                        [2016/01/21 16:16:26.3970] [ INFO  ] [TID: 0000005220]  : Running activities for job: BBCA Product Identification

                        [2016/01/21 16:16:26.3970] [ INFO  ] [TID: 0000005220]  : Running activity: Identification

                        [2016/01/21 16:16:26.3970] [DETAILS] [TID: 0000005220]  : Chunk size is <Default = 100000>

                        [2016/01/21 16:16:26.5370] [ INFO  ] [TID: 0000005220]  : Auto-Identify Master Dataset: Yes

                        [2016/01/21 16:16:26.5680] [ INFO  ] [TID: 0000005220]  : Dataset <BMC Configuration Import> is participating in this Activity and is marked as Auto-Identify True

                        [2016/01/21 16:16:28.9550] [DETAILS] [TID: 0000005220]  : Using <BMC Asset> as the master dataset

                        [2016/01/21 16:16:29.0330] [ INFO  ] [TID: 0000005220]  : Computing total CI's to be process in Identification Activity

                        [2016/01/21 16:16:37.6910] [ INFO  ] [TID: 0000005220]  : Working class: BMC.CORE:BMC_Product

                        [2016/01/21 16:16:37.6910] [ INFO  ] [TID: 0000005220]  : Working dataset: BMC Configuration Import

                        [2016/01/21 16:16:37.6910] [DETAILS] [TID: 0000005220]  : Getting instance ids which are not identified

                        [2016/01/21 16:16:37.6910] [ INFO  ] [TID: 0000005220]  : Qualification: 'ReconciliationIdentity' = "0" AND 'Model' LIKE "%Adobe%"

                        [2016/01/21 16:16:45.4130] [ INFO  ] [TID: 0000005220]  : Working class: BMC.CORE:BMC_HostedSystemComponents

                        [2016/01/21 16:16:45.4130] [ INFO  ] [TID: 0000005220]  : Working dataset: BMC Configuration Import

                        [2016/01/21 16:16:45.4130] [DETAILS] [TID: 0000005220]  : Getting instance ids which are not identified

                        [2016/01/21 16:16:45.4130] [ INFO  ] [TID: 0000005220]  : Qualification: 'Source.ClassId' = "BMC_COMPUTERSYSTEM" AND 'Destination.ClassId' = "BMC_PRODUCT" AND 'ModifiedDate' >=  "01/11/2016 2:00 AM"

                        [2016/01/21 16:16:54.4610] [ INFO  ] [TID: 0000005220]  : Total CI's to be process in Identification Activity : 34775

                        [2016/01/21 16:16:54.4770] [ INFO  ] [TID: 0000005220]  : Working class: BMC.CORE:BMC_Product

                        [2016/01/21 16:16:54.4770] [ INFO  ] [TID: 0000005220]  : Working dataset: BMC Configuration Import

                        [2016/01/21 16:16:54.4770] [DETAILS] [TID: 0000005220]  : Getting instance ids which are not identified

                        [2016/01/21 16:16:54.4770] [ INFO  ] [TID: 0000005220]  : Qualification: 'ReconciliationIdentity' = "0" AND 'Model' LIKE "%Adobe%"

                        [2016/01/21 16:16:58.8450] [ INFO  ] [TID: 0000005220]  : Number of instances which are to be identified are <6407>

                        [2016/01/21 16:16:58.8450] [DETAILS] [TID: 0000005220]  : <Chunking = 1> Start processing instance <1>

                        [2016/01/21 16:16:58.8450] [DETAILS] [TID: 0000005220]  : Identifying instances and its sub-objects

                        [2016/01/21 16:16:58.8450] [DETAILS] [TID: 0000005220]  : Getting all attributes which are being used in all the rules

                        [2016/01/21 16:16:58.8450] [DETAILS] [TID: 0000005220]  : Getting attribute values for  <1000> instances

                        [2016/01/21 16:17:45.8010] [DETAILS] [TID: 0000005220]  : Assigning parent instance <class = BMC.CORE:BMC_ComputerSystem, instance id = OI-70b33e1cabc547e4bf1fd96f0822ada7> to a thread for identification

                        [2016/01/21 16:17:45.8010] [DETAILS] [TID: 0000005220]  : Assigning parent instance <class = BMC.CORE:BMC_ComputerSystem, instance id = OI-0DB47FBB16F94C42A364D9B5820CC2F2> to a thread for identification

                        [2016/01/21 16:17:45.8010] [DETAILS] [TID: 0000001756]  : Started identifying instance <class = BMC.CORE:BMC_ComputerSystem, instance id = OI-70b33e1cabc547e4bf1fd96f0822ada7>

                        [2016/01/21 16:17:45.8010] [DETAILS] [TID: 0000009628]  : Started identifying instance <class = BMC.CORE:BMC_ComputerSystem, instance id = OI-0DB47FBB16F94C42A364D9B5820CC2F2>

                        [2016/01/21 16:17:45.8010] [DETAILS] [TID: 0000009628]  : Identifying sub-tree for class <BMC.CORE:BMC_ComputerSystem> and id <OI-0DB47FBB16F94C42A364D9B5820CC2F2>

                        [2016/01/21 16:17:45.8010] [DETAILS] [TID: 0000001756]  : Identifying sub-tree for class <BMC.CORE:BMC_ComputerSystem> and id <OI-70b33e1cabc547e4bf1fd96f0822ada7>

                        [2016/01/21 16:17:45.8170] [DETAILS] [TID: 0000009628]  : Loading the tree

                        [2016/01/21 16:17:45.8170] [DETAILS] [TID: 0000001756]  : Loading the tree

                        [2016/01/21 16:17:45.8320] [ ERROR ] [TID: 0000005220]  : Failed in getting parent instance for instance <OI-9FDE998806454D578D76C055CD0FA324> of class <BMC.CORE:BMC_ComputerSystem>::

                        [2016/01/21 16:17:45.8320] [ ERROR ] [TID: 0000005220]  : ARERR[120006] Instance not found.

                        [2016/01/21 16:17:45.8320] [ ERROR ] [TID: 0000005220]  : OI-9FDE998806454D578D76C055CD0FA324

                        [2016/01/21 16:17:45.8320] [ ERROR ] [TID: 0000005220]  : ARERR[120006] Instance not found.

                        [2016/01/21 16:17:45.8320] [ ERROR ] [TID: 0000005220]  : OI-9FDE998806454D578D76C055CD0FA324

                        [2016/01/21 16:17:45.9100] [ INFO  ] [TID: 0000005220]  : Working class: BMC.CORE:BMC_HostedSystemComponents

                        [2016/01/21 16:17:45.9100] [ INFO  ] [TID: 0000005220]  : Working dataset: BMC Configuration Import

                        [2016/01/21 16:17:45.9100] [DETAILS] [TID: 0000005220]  : Getting instance ids which are not identified

                        [2016/01/21 16:17:45.9100] [ INFO  ] [TID: 0000005220]  : Qualification: 'Source.ClassId' = "BMC_COMPUTERSYSTEM" AND 'Destination.ClassId' = "BMC_PRODUCT" AND 'ModifiedDate' >=  "01/11/2016 2:00 AM"

                        [2016/01/21 16:17:46.0040] [DETAILS] [TID: 0000009628]  : No unidentified sub objects found for this instance

                        [2016/01/21 16:17:48.7500] [ INFO  ] [TID: 0000001756]  : Cancelled the processing of rest of the sub-tree of class = BMC.CORE:BMC_Processor as this class is not auto identifiable

                        [2016/01/21 16:17:48.7500] [ TRACE ] [TID: 0000001756]  : Found matching rule group <Manual Idtification> for class <BMC.CORE:BMC_Product> in dataset <BMC Configuration Import>

                        [2016/01/21 16:17:48.7500] [ TRACE ] [TID: 0000001756]  : Group id REHAA5V0C7WF6ANNHNSVBTJWRL06IB <name = Manual Idtification> for class BMC.CORE:BMC_Product and dataset BMC Configuration Import can be auto-identified

                        • 9. Re: Reconciliation not happening for BMC_Product
                          Gustavo del Gerbo

                          Please go to Baseelement and make a search where instanceID = OI-9FDE998806454D578D76C055CD0FA324

                           

                          What do you get?

                          • 10. Re: Reconciliation not happening for BMC_Product

                            Hi Gustavo,

                             

                            Good Morning,

                             

                            I tried searching that CI but it says -

                            No matches were found for your qualification. (ARWARN 9296)
                            • 11. Re: Reconciliation not happening for BMC_Product
                              Gustavo del Gerbo

                              But nonetheless the child CI has this marked as the parent CI.

                              I believe there must be some relationship marking this CI.

                              Please go to BaseRelationship form and make a search where either Source or Destination Instance ID is = OI-9FDE998806454D578D76C055CD0FA324

                              • 12. Re: Reconciliation not happening for BMC_Product

                                This instance id in different dataset with BMC_Monitor class.

                                • 13. Re: Reconciliation not happening for BMC_Product
                                  Gustavo del Gerbo

                                  So you must have some cross-dataset relationships.

                                  Those are relationships that reference CIs from different dataset. Like source is in dataset A and destination in Dataset B.

                                  We discourage these relationships since they lead to weird error like this one. The only case a cross-dataset relationship is allowed is during Sandbox promotion, where the relationship will temporarily point to a CI in BMC.ASSET just before the promotion happens.

                                  You should get rid of these relationships.

                                  • 14. Re: Reconciliation not happening for BMC_Product

                                    Hi Gustavo,

                                     

                                    We have fixed this issue by changing identification rule. We were using "Attribute value" instead of "Attribute name". After apply this change, job has ran the successfully and we could able to resolve the issue.

                                     

                                    Thanks for your support on this discussion.