L3 Support
  1. L3 Support
  2. LS-824

Zain IQ | Missing SN issue in Unmapped Report

        Details

        • Type: Bug Bug
        • Status: Closed Closed (View Workflow)
        • Priority: Normal Normal
        • Resolution: Fixed
        • Component/s: NEP
        • Labels:
          None Labels
        • Customer:
          Zain Iraq

          Description

          Kindly support to check the serial (6924070504103000490) not available in the unmapped report.
          The item is available in the passive inventory and not available in both FR , WO and unmapped Report.
          We have also run the unmapped sync and still not appearing.

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            Manjit Kumar logged work - 16/Dec/25 12:00 AM
            • Time Spent:
              2 hours, 30 minutes
               

              Checked the log and shared to L3 and also generate XML manual.

            Permalink
            Daljeet Singh Virdi logged work - 16/Dec/25 12:00 AM - edited
            • Time Spent:
              2 hours
               

              Issue raised with l3 team

            DSVirdi made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2025-12-19 24:00 (milestone: set planned start date to due date)
            Planned End 2025-12-19 24:00 (milestone: set planned end date to due date)
            Daljeet Singh Virdi made changes -
            Attachment INV.png [ 124200 ]
            Daljeet Singh Virdi made changes -
            Attachment UN and FR.png [ 124201 ]
            Manjit Kumar made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 2 hours, 30 minutes [ 9000 ]
            Worklog Id 286143 [ 286143 ]
            Manjit Kumar made changes -
            Baseline Start 2025-12-19 24:00 (set baseline based of initial work logging)
            Baseline End 2025-12-19 24:00 (set baseline based of initial work logging)
            Permalink
            Daljeet Singh Virdi logged work - 17/Dec/25 12:00 AM
            • Time Spent:
              2 hours
               

              Discuss with L3 regarding the issue and script provided for the same , same script provided to L2 to deploy the same

            Permalink
            Manjit Kumar logged work - 17/Dec/25 12:00 AM
            • Time Spent:
              1 hour
               

              Shared script executed after working hours.

            Bessem Manita made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Bessem Manita made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Assignee Khaled Khalil [ kkhalil ] Bessem Manita [ bmanita ]
            Hide
            Permalink
            Bessem Manita added a comment -

            Dear Daljeet,
            As discussed by the teams, the same RFID '10120476' assigned to a shared node was equal to RFID value of passive node '10113859'. Since SN, RFID, and TAG cannot be duplicated in the FR report, this prevented the new item from being inserted.

            Please find attached a script that will clean this item. During the next FR sync, the data should be saved correctly.
            Kindly review and confirm if we are encountering any similar mismatches between SN, RFID, and TAG in the FR report compared to the Additional Info report.

            Show
            Bessem Manita added a comment - Dear Daljeet, As discussed by the teams, the same RFID '10120476' assigned to a shared node was equal to RFID value of passive node '10113859'. Since SN, RFID, and TAG cannot be duplicated in the FR report, this prevented the new item from being inserted. Please find attached a script that will clean this item. During the next FR sync, the data should be saved correctly. Kindly review and confirm if we are encountering any similar mismatches between SN, RFID, and TAG in the FR report compared to the Additional Info report.
            Bessem Manita made changes -
            Attachment unmapped_clean.txt [ 124313 ]
            Bessem Manita made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Bessem Manita made changes -
            Status To Be Released [ 10400 ] Implementation in progress [ 10016 ]
            Bessem Manita made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Bessem Manita [ bmanita ] Daljeet Singh Virdi [ dsvirdi ]
            Permalink
            Daljeet Singh Virdi logged work - 18/Dec/25 12:00 AM
            • Time Spent:
              1 hour, 30 minutes
               

              Validate the resolution and ask closure from the custmoer

            Daljeet Singh Virdi made changes -
            Time Spent 2 hours, 30 minutes [ 9000 ] 4 hours, 30 minutes [ 16200 ]
            Worklog Id 286342 [ 286342 ]
            Daljeet Singh Virdi made changes -
            Worklog Id 286342 [ 286342 ]
            Daljeet Singh Virdi made changes -
            Time Spent 4 hours, 30 minutes [ 16200 ] 6 hours, 30 minutes [ 23400 ]
            Worklog Id 286347 [ 286347 ]
            Permalink
            Manjit Kumar logged work - 19/Dec/25 12:00 AM - edited
            • Time Spent:
              1 hour, 30 minutes
               

              Made old backup tables list and drop tables which are old backup.

            Manjit Kumar made changes -
            Time Spent 6 hours, 30 minutes [ 23400 ] 7 hours, 30 minutes [ 27000 ]
            Worklog Id 286505 [ 286505 ]
            Manjit Kumar made changes -
            Time Spent 7 hours, 30 minutes [ 27000 ] 1 day, 30 minutes [ 30600 ]
            Worklog Id 286508 [ 286508 ]
            Manjit Kumar made changes -
            Time Spent 1 day, 30 minutes [ 30600 ] 1 day, 1 hour [ 32400 ]
            Worklog Id 286508 [ 286508 ]
            Manjit Kumar made changes -
            Worklog Id 286508 [ 286508 ]
            Permalink
            Daljeet Singh Virdi logged work - 30/Dec/25 12:00 AM - edited
            • Time Spent:
              3 hours
               

              L3 provided script and asked cybermak to check the same

            Hide
            Permalink
            Abir Messaikeh added a comment -

            resolved with script

            we will need a permanent solution to be tracked in ticket LS-849

            Show
            Abir Messaikeh added a comment - resolved with script we will need a permanent solution to be tracked in ticket LS-849
            Abir Messaikeh made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Assignee Daljeet Singh Virdi [ dsvirdi ] Abir Messaikeh [ amessaikeh ]
            Abir Messaikeh made changes -
            Status QA In Progress [ 10015 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            Daljeet Singh Virdi made changes -
            Time Spent 1 day, 1 hour [ 32400 ] 1 day, 2 hours, 30 minutes [ 37800 ]
            Worklog Id 288007 [ 288007 ]
            Daljeet Singh Virdi made changes -
            Time Spent 1 day, 2 hours, 30 minutes [ 37800 ] 1 day, 4 hours [ 43200 ]
            Worklog Id 288043 [ 288043 ]
            Daljeet Singh Virdi made changes -
            Time Spent 1 day, 4 hours [ 43200 ] 1 day, 5 hours, 30 minutes [ 48600 ]
            Worklog Id 288043 [ 288043 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Bug Open Bug Dev Scheduled Dev Scheduled
            		1d 4h 13m 1 Bessem Manita 17/Dec/25 8:01 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		5s 1 Bessem Manita 17/Dec/25 8:01 AM
            To Be Released To Be Released Implementation in progress Implementation in progress
            		11s 1 Bessem Manita 17/Dec/25 1:07 PM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		5h 5m 2 Bessem Manita 17/Dec/25 1:07 PM
            To Be Released To Be Released Ready for QA Ready for QA
            		8s 1 Khaled Khalil 17/Dec/25 1:07 PM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		13d 35m 1 Abir Messaikeh 30/Dec/25 1:43 PM
            QA In Progress QA In Progress Closed Closed
            		5s 1 Abir Messaikeh 30/Dec/25 1:43 PM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Abir Messaikeh
                Reporter:
                Daljeet Singh Virdi
              • Votes:
                0 Vote for this issue
                Watchers:
                3 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, 5 hours, 30 minutes
                  1d 5h 30m

                    Drag and Drop