L3 Support
  1. L3 Support
  2. LS-776

RE: KSA - NEP Inventory sync issue vs NEP DB View

        Details

        • Type: CR CR
        • Status: Cancelled Cancelled (View Workflow)
        • Priority: Normal Normal
        • Resolution: Unresolved
        • Component/s: NEP
        • Labels:
          None Labels
        • Customer:
          Zain KSA 3.X

          Description

          From: Suleiman Kiplangat <Suleiman.K@cybermak.net>
          Sent: Friday, November 7, 2025 3:10 PM
          To: Daljeet Singh Virdi <Daljeet.Virdi@mobinets.com>; Abir Messaikeh <Abir.Messaikeh@nuiva.com>
          Cc: ALM Support <ALM.Support@cybermak.net>; support <support@mobinets.com>; Kosi Ali <Kosi.A@cybermak.net>; Marwan Yousef <Marwan@cybermak.net>
          Subject: RE: KSA - NEP Inventory sync issue vs NEP DB View

          +++ updating subject.

          From: Suleiman Kiplangat <Suleiman.K@cybermak.net>
          Sent: Friday, November 7, 2025 3:43 PM
          To: Daljeet Singh Virdi <Daljeet.Virdi@mobinets.com>; Abir Messaikeh <Abir.Messaikeh@nuiva.com>
          Cc: ALM Support <ALM.Support@cybermak.net>; support <support@mobinets.com>; Kosi Ali <Kosi.A@cybermak.net>; Marwan Yousef <Marwan@cybermak.net>
          Subject: NEP Inventory sync issue vs NEP DB View vs
          Importance: High

          Dear Daljeet/Abir,

          Kindly note that we have identified an issue where the NEP Inventory report is not syncing to the NEP DB view as expected.
          Site matching was done earlier, resolved on Inventory, but still reporting Auto_Site in DB View.

          Sample nodes with an issue in the DB view but okay in Inventory..

          AQQ2170_01
          AQQ2331_01
          AQQ2424_01
          AQQ2425_01
          AQQ2426_01_NNN
          BAH2152_01
          BHAB2124
          BHMF2137
          BHMF2336_02
          BHS2361_NNN
          BRQ2219_02
          BSA2313_01
          BSA2313_02
          BSA2316
          BSA2318
          HJR2254
          HLA2419_01
          JDJZ2071_01
          JDJZ2418
          MTB2377
          MUMA2070
          MUMA2337
          QLW2370_NNN
          QLW2374_01
          QLW2376_01
          SRA2353_01
          SRA2353_02
          SRA2355
          SRA2359_01
          SRA2359_02
          SRA2362_01
          SRA2362_02
          SRA2362_03
          TBL2297_01
          TBL2319
          TBL2328_01_NNN
          TNM2082_01
          TNM2088_01
          TNM2093

          We request your urgent support to resolve this ASAP.

          Best regards,

          Suleiman Kiplangat
          ALM Support Team
          CyberMAK Information Systems

            Activity

            Descending order - Click to sort in ascending order
            Hide
            Permalink
            Bessem Manita added a comment -

            Dear Manjit,
            As mentioned earlier by Abir, the API was disabled, so it’s better to keep it as is and handle the DB refresh separately.
            Kindly proceed with creating a new cron job specifically for the DB refresh as done below.

            call REFRESH_ASSET_VIEWS();

            BR,

            Show
            Bessem Manita added a comment - Dear Manjit, As mentioned earlier by Abir, the API was disabled, so it’s better to keep it as is and handle the DB refresh separately. Kindly proceed with creating a new cron job specifically for the DB refresh as done below. call REFRESH_ASSET_VIEWS(); BR,
            Hide
            Permalink
            added a comment -

            The following script was executed on the KSA database to refresh the database view:

            EXEC DBMS_MVIEW.REFRESH('NE_VIEW');

            Show
            added a comment - The following script was executed on the KSA database to refresh the database view: EXEC DBMS_MVIEW.REFRESH('NE_VIEW');
            Cancel

              People

              • Assignee:
                Mustapha Al-Hage
                Reporter:
                Manjit Kumar
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  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, 9 minutes
                  1d 9m

                    Drag and Drop