10 Replies Latest reply on Jul 17, 2014 3:01 PM by nhakimjee

    Deleting a node does not delete assigned pollers

    nhakimjee

      Hello all,

       

      I deleted a node and related interfaces via the UI. However, I can still query the Pollers assigned to node via WSQL. What would be the correct way to delete a node which would ensure all the related data is cleaned up (i.e. pollers etc)? How do I delete assigned pollers for a node in the UI?

       

      Thanks,

       

      Nuruddin

        • Re: Deleting a node does not delete assigned pollers
          RichardLetts

          it's part of the nightly database cleanup -- there is a stored procedure [dbm_Pollers_DeleteOrphans] that cleans them up.

            • Re: Deleting a node does not delete assigned pollers
              nhakimjee

              Thank you for the response Richard. I checked the database via SWQL today morning and I found that the node pollers have been deleted. However, the volume and interface pollers are still there. Is the stored procedure supposed to delete all poller types or just the node ones? Any ideas how I would go about debugging this issue?

               

              Thanks,

               

              Nuruddin

              • Re: Deleting a node does not delete assigned pollers
                nhakimjee

                Hi Richard,

                 

                I looked at dbm_Pollers_DeleteOrphans, this is the sql in it:

                 

                DELETE FROM Pollers

                  WHERE (NetObject LIKE 'V%')

                   AND (SUBSTRING(NetObject, 3, 10) IN (SELECT VolumeId FROM DeletedVolumes))

                 

                 

                  DELETE FROM Pollers

                  WHERE (NetObject LIKE 'N%')

                   AND (SUBSTRING(NetObject, 3, 10) IN (SELECT NodeId FROM DeletedNodes))

                 

                From the above I do not think that the netobjectid (SUBSTRING(NetObject, 3, 10)) will match the volumeid in DeletedVolumes, unless the volumeId is the nodeId. The same is the case for deleting the interface pollers:

                 

                DELETE FROM Pollers

                  WHERE (NetObjectType = 'I' OR NetObjectType = 'IW')

                  AND (NetObjectID IN (SELECT InterfaceId FROM DeletedInterfaces))

                 

                Am I correct in this thinking?

                 

                Thanks,

                 

                Nuruddin

              • Re: Deleting a node does not delete assigned pollers
                derhally

                What version of Orion are you using?  

                 

                The SQL you found should be fine.  If you run the Orion  Database Maintenance app and force it to run, does it clean up your pollers table?

                  • Re: Deleting a node does not delete assigned pollers
                    nhakimjee

                    Where would I find the Orion version info that I am using? In the rest api I build my client with v3. This is what I get from the license details in the Web UI:

                    Main Orion Server Details

                     

                    Orion

                     

                    Module NameOrion Platform
                    Version2014.1.0
                    Service PackNone
                    Nodes currently monitored53
                    Total nodes in licenseunlimited
                    Volumes currently monitored234
                    Total volumes in licenseunlimited

                     

                    NCM

                     

                    Product NameNetwork Configuration Manager
                    Version7.3
                    Service PackNone
                    LicenseProduction
                    Allowed number of nodesunlimited
                    Current number of nodes50

                     

                    NPM

                     

                    LicenseProduction
                    Product NameNetwork Performance Monitor
                    Version10.7
                    Service PackNone
                    Current number of interfaces932
                    Allowed number of interfacesunlimited

                     

                    Where would I find the Orion Database Maintenance App? Currently, only the node pollers get deleted, the volume and interface pollers do not get deleted.