Details

    • Customer:
      OMAN-Tel
    • Defect Category:
      Improper Test Plan

      Description

      As you know we automate the process of adding routers in Planning to our IP dump collection list via DB View NE_PLANNED_ROUTERS_VIEW. But now we are NOT getting new routers added in planning in the DB view. This is hindering the automation process of adding planning IPs to our collection list. See below sample IPs which were added recently and still not present in DB view. Accordingly we need you to review the DB script and inform us what is the issue and fix it

      attached the script used on PROD

      1. ne_planned_routers_view.sql
        3 kB
        Salem Dannawi
      1. IP1.png
        152 kB
      2. IP2.png
        71 kB
      3. IP3.png
        71 kB
      4. IP4.png
        69 kB

        Activity

        Hide
        Diana Hamdouche added a comment -

        Dears,

        Routers reported as missing from the "NE_PLANNED_ROUTERS_VIEW " are not appearing due to non-compliance with the required inclusion criteria.
        To be included in mentioned view, each router must have the following conditions:
        1.An interface of type "LoopBackInterface" with the name "LOOPBACK0".
        2.An Additional Info with the attribute "NE_Network_Position".
        3.A valid WAN IP assigned.

        Routers that meet all the above criteria will be visible in the "NE_PLANNED_ROUTERS_VIEW" accordingly.

        Show
        Diana Hamdouche added a comment - Dears, Routers reported as missing from the "NE_PLANNED_ROUTERS_VIEW " are not appearing due to non-compliance with the required inclusion criteria. To be included in mentioned view, each router must have the following conditions: 1.An interface of type "LoopBackInterface" with the name "LOOPBACK0". 2.An Additional Info with the attribute "NE_Network_Position". 3.A valid WAN IP assigned. Routers that meet all the above criteria will be visible in the "NE_PLANNED_ROUTERS_VIEW" accordingly.
        Hide
        Abir Messaikeh added a comment -

        As discussed with Hassan , we need to remove the condition of Valid WAN IP as it is not always the case we have wan IP for routers we are adding in planning
        so kindly plan for same

        Show
        Abir Messaikeh added a comment - As discussed with Hassan , we need to remove the condition of Valid WAN IP as it is not always the case we have wan IP for routers we are adding in planning so kindly plan for same
        Hide
        Hassan Abdine added a comment -

        The view is designed to show a list of routers in Planning version, highlighting their details, but excluding any routers that currently exist in the Actual Network version (matching based on router object id:

        Show
        Hassan Abdine added a comment - The view is designed to show a list of routers in Planning version, highlighting their details, but excluding any routers that currently exist in the Actual Network version (matching based on router object id:

          People

          • Assignee:
            Salem Dannawi
            Reporter:
            Salem Dannawi
            Rejected By:
            Hassan Abdine
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:
              Resolved:
              Planned Start:
              Planned End:
              Actual Start:
              Date of Baselining:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 1 day, 3 hours
              1d 3h

                Drag and Drop