L3 Support
  1. L3 Support
  2. LS-509

Inventory report reflecting blank in DB View for all circles

        Details

        • Customer:
          Airtel India
        • Defect Category:
          Integration
        • Classification:
          Query

          Description

          data in the database view “V_Inventory_Report” is appearing as empty across all circles.

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            Srishti Kashyap added a comment -

            checked the version against v_inventory_report dbview in DB_VIEW_CONF. Checked the other tables and dbviews used in procedure. Tested on DB clone. Requested Access to PROD DB checked there. Found version name to be missing in DB_VIEW_CONF for NE_VIEW dbview. Shared the script for same.
            Dear Team,
            Requesting you to please execute the following SQL script across all circles:
            update DB_VIEW_CONF set value='FULL_DL_OLD' where VIEW_NAME = 'NE_VIEW';
            Note: Kindly make sure to replace 'FULL_DL_OLD' with the correct active version name applicable for each circle before executing the script.
            Please confirm once done.

            Show
            Srishti Kashyap added a comment - checked the version against v_inventory_report dbview in DB_VIEW_CONF. Checked the other tables and dbviews used in procedure. Tested on DB clone. Requested Access to PROD DB checked there. Found version name to be missing in DB_VIEW_CONF for NE_VIEW dbview. Shared the script for same. Dear Team, Requesting you to please execute the following SQL script across all circles: update DB_VIEW_CONF set value='FULL_DL_OLD' where VIEW_NAME = 'NE_VIEW'; Note: Kindly make sure to replace 'FULL_DL_OLD' with the correct active version name applicable for each circle before executing the script. Please confirm once done.
            Hide
            Permalink
            Priyasha Tiwari added a comment -

            fixed

            Show
            Priyasha Tiwari added a comment - fixed
            Cancel

              People

              • Assignee:
                Priyasha Tiwari
                Reporter:
                Priyasha Tiwari
              • Votes:
                0 Vote for this issue
                Watchers:
                2 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 - 5 hours
                  5h

                    Drag and Drop