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
                    LadaVarga

                    Hello,

                     

                    It will match VolumeID because of this part of query. (NetObject LIKE 'V%').

                    Maybe Volumeid was not propagated to DeletedVolumes.

                    Same for interfaces.


                    Please open support ticket and paste support ticket number here, we will provide query, which delete unused pollers.


                    Thanks

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

                        Hello,

                         

                        Thanks for your response. But I still think that the stored procedure is not working as it should. The (NetObject LIKE 'V%') part will filter out records whose NetObject does not begin with 'V", however, the second part of the where clause will not get satisfied as the netobjectid (the part which says SUBSTRING(NetObject, 3, 10)) will never match the actual volumeid  in DeletedVolumes. NetObjectId and the VolumeId are not one and the same. In fact, the stored procedure will delete the wrong pollers if a match is found.


                        Thanks,

                  • 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.