6 Replies Latest reply on Sep 16, 2019 8:46 AM by Brice-Emmanuel Loiseaux

    CMDBsync not picking up companies

    Matt Lambie
      Share This:

      anyone else seeing Discovery (11.1) not updating Companies from CMDB 9.1.4 patch 2?

       

      Our CMDB has been patched recently and now we cannot pull customers but sync is still pushing data.

       

      CMDB team advised updated jar files and looking at them, the versions differ from those on the appliance.

       

       

       

      ./java/integrations-ui/WEB-INF/lib/graph-cmdbapi-8.1.jar

      ./java/integrations-ui/WEB-INF/lib/cmdbbol-8.1.jar

      ./java/integrations/atrium2/java/cmdbapi-2.0.jar

      ./java/integrations/atrium2/linux/bin/cmdbapi20.jar

      ./java/integrations/lib/cmdbapi-2.0.jar

      ./java/integrations/lib/graph-cmdbapi-8.1.jar

      ./java/integrations/lib/cmdbbol-8.1.jar

      ./java/export-ui/WEB-INF/lib/graph-cmdbapi-8.1.jar

      ./java/export-ui/WEB-INF/lib/cmdbbol-8.1.jar

       

       

        • 1. Re: CMDBsync not picking up companies
          Matt Lambie

          [tideway@xyz Files for ADDM]$ java -jar /usr/tideway/java/export-ui/WEB-INF/lib/cmdbbol-8.1.jar

          Name: BMC Atrium CMDB BOL Java API

          Version: 8.1.00

          Vendor: BMC Software, Inc.

          Build Number: ${DSTAMP}-${TSTAMP}

           

          [tideway@xyz Files for ADDM]$ java -jar cmdbbol91.jar

          Name: BMC Atrium CMDB BOL Java API

          Version: 9.1.04

          Vendor: BMC Software, Inc.

          Build Number: ${DSTAMP}-${TSTAMP}

          • 2. Re: CMDBsync not picking up companies
            Brice-Emmanuel Loiseaux

            This is a red herring. Discovery gracefully uses 8.1 version CMDB API libraries in front of all CMDB upper versions including 9.1.4 patch 2.

            2 of 2 people found this helpful
            • 3. Re: CMDBsync not picking up companies
              Duncan Grisby

              In case people think we have been slow to update the CMDB jars, we are using the old versions because they work with newer CMDBs, but the newer client jars do not work with older CMDB versions.

               

              Are there any pertinent errors in tw_cmdbsync_exporter.log?

              3 of 3 people found this helpful
              • 4. Re: CMDBsync not picking up companies
                Matt Lambie

                I would have to agree with you - I set up a vanilla ADDM instance and cmdbsync - pulled thousands of Companies.

                 

                Now suspecting it is the number of Companies being pulled is causing the timeouts.

                 

                How do we limit the scope of the query to add in Type=Customer & Enabled so we are only trying to pull the 50 odd customers aligned with the ADDM service account?

                • 5. Re: CMDBsync not picking up companies
                  Matt Lambie

                  THanks for the update Duncan. That all makes sense.

                   

                  As Brice-Emmanuel stated, it is a red herring.

                   

                  It was a few things hitting at the same time that pushed us down this rabbit hole:

                   

                  CMDB was patched to 9.1.04 patch 2

                  BPPM connectivity broke and was only resolved with some updated jar files

                  ADDM stopped pulling Compaines and everyone jumped on the bandwagon!

                   

                  Looking at CMDB & ADDM this morning, I can see that ADDM is trying to pull tens of thousands of Companies rather than the 50ish that are aligned to the connection account and I am wondering if that is the cause of the timeouts in the logs.

                   

                  Do you have any pointers to where the query is so we can add a couple of filters to it pdq?

                  • 6. Re: CMDBsync not picking up companies
                    Brice-Emmanuel Loiseaux

                    The query against COM:Company has the following qualification in Discovery:

                    'Company Type' LIKE "%Operating Company%" OR

                    'Company Type' LIKE "%Customer%" OR

                    'Company Type' LIKE "%Generic Contact%" OR

                    'Company Type' LIKE "%Service Provider%" OR

                    'Company Type' LIKE "%Organizational Unit%"