Details
-
Type:
Bug
-
Status:
Closed
(View Workflow)
-
Priority:
Normal
-
Resolution: Fixed
-
Component/s: Financial
-
Labels:None Labels
-
Customer:Zain Kuwait
Description
Customer has raised issue for the attached nodes SN present in the Unmapped and FR as well.
After did analysis , it has been observed that the asset first Financialised under Active Inventory later it got decommissioned and again inserted via Generic Connector with same SN but sync didn't work and result in two different records present in both Unmapped and Financial Report with same SN.
Kindly check and do rectify the same.
Attachments
Activity
|
Links Hierarchy |
 Documentation
|
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
56d 21h 1m | 1 | Wajdi Jomaa | 11/Jul/25 5:55 AM | |||||
|
6s | 1 | Wajdi Jomaa | 11/Jul/25 5:55 AM | |||||
|
49d 4h 52m | 1 | Wajdi Jomaa | 29/Aug/25 10:48 AM | |||||
|
1h 48m | 1 | Khaled Khalil | 29/Aug/25 12:37 PM | |||||
|
56d 2h 28m | 1 | Abir Messaikeh | 24/Oct/25 3:05 PM | |||||
|
44d 18h 6m | 1 | Daljeet Singh Virdi | 08/Dec/25 8:11 AM |
| Time Spent | 1 week, 4 days, 2 hours, 40 minutes [ 268800 ] | 1 week, 4 days, 6 hours, 40 minutes [ 283200 ] |
| Worklog Id | 290371 [ 290371 ] |
-
- Time Spent:
- 4 hours
-
Duplicate sn check
| Time Spent | 1 week, 4 days, 10 minutes [ 259800 ] | 1 week, 4 days, 2 hours, 40 minutes [ 268800 ] |
| Worklog Id | 289154 [ 289154 ] |
| Time Spent | 1 week, 3 days, 6 hours, 10 minutes [ 252600 ] | 1 week, 4 days, 10 minutes [ 259800 ] |
| Worklog Id | 289143 [ 289143 ] |
| Time Spent | 1 week, 3 days, 5 hours, 10 minutes [ 249000 ] | 1 week, 3 days, 6 hours, 10 minutes [ 252600 ] |
| Worklog Id | 289137 [ 289137 ] |
-
- Time Spent:
- 1 hour
-
Customer raised issue for the past ticket discuss with and asked him to provide the details with snippet or close the ticket
-
- Time Spent:
- 2 hours
-
Discussion with Medhat and WIfred differnet time over email regarding the way forward on this ticket
-
- Time Spent:
- 2 hours, 30 minutes
-
Validate the same and raised issue with L3
| Status | QA In Progress [ 10015 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] |
| Link | This issue relates to MOB-7319 [ MOB-7319 ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Assignee | Daljeet Singh Virdi [ dsvirdi ] | Abir Messaikeh [ amessaikeh ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Wajdi Jomaa [ wjomaa ] | Daljeet Singh Virdi [ dsvirdi ] |
| Attachment | fixqueriesls384.txt [ 116515 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Time Spent | 1 week, 3 days, 1 hour, 10 minutes [ 234600 ] | 1 week, 3 days, 5 hours, 10 minutes [ 249000 ] |
| Worklog Id | 275100 [ 275100 ] |
-
- Time Spent:
- 4 hours
-
Data Validation of Active, Passive and IT Import. Also confirm customer to proceed with patch deployment
| Time Spent | 1 week, 3 days, 10 minutes [ 231000 ] | 1 week, 3 days, 1 hour, 10 minutes [ 234600 ] |
| Worklog Id | 274821 [ 274821 ] |
| Description |
Customer has raised issue for the attached nodes SN present in the Unmapped and FR as well.
After did analysis , it has been observed that the asset first Financialised under Active Inventory later it got decommissioned and again inserted via Generic Connector with same SN but sync didn’t work and result in two different records present in both Unmapped and Financial Report with same SN. Kindly check and do rectify the same. |
Customer has raised issue for the attached nodes SN present in the Unmapped and FR as well.
After did analysis , it has been observed that the asset first Financialised under Active Inventory later it got decommissioned and again inserted via Generic Connector with same SN but sync didn't work and result in two different records present in both Unmapped and Financial Report with same SN. Kindly check and do rectify the same. |
| Date of Baselining | 06/Jun/25 1:17 PM | 06/Jun/25 1:17 PM |
| Component/s | Financial [ 16400 ] | |
| Component/s | NEP [ 16200 ] |
| Time Spent | 1 week, 2 days, 7 hours, 10 minutes [ 227400 ] | 1 week, 3 days, 10 minutes [ 231000 ] |
| Worklog Id | 274719 [ 274719 ] |
| Time Spent | 1 week, 2 days, 4 hours [ 216000 ] | 1 week, 2 days, 7 hours, 10 minutes [ 227400 ] |
| Worklog Id | 274718 [ 274718 ] |
-
- Time Spent:
- 3 hours, 10 minutes
-
Testing
| Time Spent | 1 week, 2 days [ 201600 ] | 1 week, 2 days, 4 hours [ 216000 ] |
| Worklog Id | 274236 [ 274236 ] |
| Time Spent | 1 week, 1 day, 7 hours [ 198000 ] | 1 week, 2 days [ 201600 ] |
| Worklog Id | 274114 [ 274114 ] |
| Time Spent | 1 week, 1 day, 6 hours [ 194400 ] | 1 week, 1 day, 7 hours [ 198000 ] |
| Worklog Id | 274113 [ 274113 ] |
| Worklog Id | 274112 [ 274112 ] |
| Time Spent | 1 week, 7 hours [ 169200 ] | 1 week, 1 day, 6 hours [ 194400 ] |
| Worklog Id | 274112 [ 274112 ] |
General preview of work related to this issue:
- Financial records with serial numbers were stored in nep_history_reference table with status is_decomissioned false, even if the asset having the serial number no longer exists, we fixed this issue by changing the status of is_decomissioned to true for all financial records
- Changing Object id of a network element will lead to duplicates in history (one with old name, one with new name) same for physical configuration applied to this element, we fixed this issue in code, + cleanup scrip to clean records with old names
- if we have 2 network element of different types with same object id, physical configuration for both elements will have the same name in history we fixed this issue by adding an infix to physical configuration in history that specifies the type of network element (scripts + code) for example : "Cabinet_IDU_objecitd/c1_version"
- Clean data in unmapped report with cleanup scripts then add serial number to passive nodes + sync process to fix data
patch needed: 3.7.1.688 + upgrade directly to 3.7.1.689
Show
Wajdi Jomaa
added a comment - - edited General preview of work related to this issue:
Financial records with serial numbers were stored in nep_history_reference table with status is_decomissioned false, even if the asset having the serial number no longer exists, we fixed this issue by changing the status of is_decomissioned to true for all financial records
Changing Object id of a network element will lead to duplicates in history (one with old name, one with new name) same for physical configuration applied to this element, we fixed this issue in code, + cleanup scrip to clean records with old names
if we have 2 network element of different types with same object id, physical configuration for both elements will have the same name in history we fixed this issue by adding an infix to physical configuration in history that specifies the type of network element (scripts + code) for example : "Cabinet_IDU_objecitd/c1_version"
Clean data in unmapped report with cleanup scripts then add serial number to passive nodes + sync process to fix data
patch needed: 3.7.1.688 + upgrade directly to 3.7.1.689
| Time Spent | 4 days, 7 hours [ 140400 ] | 1 week, 7 hours [ 169200 ] |
| Worklog Id | 273818 [ 273818 ] |
| Time Spent | 3 days, 7 hours [ 111600 ] | 4 days, 7 hours [ 140400 ] |
| Worklog Id | 273811 [ 273811 ] |
| Time Spent | 3 days, 3 hours [ 97200 ] | 3 days, 7 hours [ 111600 ] |
| Worklog Id | 273810 [ 273810 ] |
| Time Spent | 2 days, 3 hours [ 68400 ] | 3 days, 3 hours [ 97200 ] |
| Worklog Id | 273803 [ 273803 ] |
| Time Spent | 1 day, 3 hours [ 39600 ] | 2 days, 3 hours [ 68400 ] |
| Worklog Id | 273802 [ 273802 ] |
-
- Time Spent:
- 1 day
-
Worked with L3 to run query and troubleshooting for issue which caused db issue.
-
- Time Spent:
- 1 day
-
Run the query and take output of all Zain OPCOS and shared to dev team.
| Labels | ZAIN |
| Labels | ZAIN |
| Component/s | NEP [ 16200 ] |
-
- Time Spent:
- 1 hour
-
Coordinate with L3 and L2 for the errors related to testing and new script provided by L3 and asked L2 to deploy the same
-
- Time Spent:
- 1 hour
-
Testing document finalize and shared with Dev team
-
- Time Spent:
- 7 hours
-
Testing different scenerios also nep went down and reported to L2 and restart the nep and again start doing testing and make document
-
- Time Spent:
- 4 hours
-
Worked with dev team to monitor the query output, due to this partition was full which free the disk space.
-
- Time Spent:
- 1 day
-
Patch has been applied and monitor the server next day, also run the script over the weekend.
-
- Time Spent:
- 1 day
-
Checked the application status and analyze the log for all zain OPCOS and share the reports.
| Time Spent | 1 day [ 28800 ] | 1 day, 3 hours [ 39600 ] |
| Worklog Id | 272508 [ 272508 ] |
| Time Spent | 4 hours [ 14400 ] | 1 day [ 28800 ] |
| Worklog Id | 272206 [ 272206 ] |
-
- Time Spent:
- 4 hours
-
Validate the Passive Data and update the Serial number manually for the assets, also delete few assets manually as told by Dev team, then engage cybermak to run the script and nep restart, after reatrt check nep ok or not
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Status | Open Bug [ 10108 ] | Dev Scheduled [ 10014 ] |
Dear @Wajdi Jomaa,
As discussed over chat that there are still some unsolved duplicates which are not reported by customer but exist in the network.
Could you pl provide me the ETA ,as I need to share update on this ticket with customer.
Show
Daljeet Singh Virdi
added a comment - Dear @Wajdi Jomaa,
As discussed over chat that there are still some unsolved duplicates which are not reported by customer but exist in the network.
Could you pl provide me the ETA ,as I need to share update on this ticket with customer.
-
- Time Spent:
- 3 hours
-
Validate the duplicate sn and have call with L3 to discuss the duplication in the network
| Baseline Start | 2025-05-20 24:00 (set baseline based of initial work logging) | |
| Baseline End | 2025-05-20 24:00 (set baseline based of initial work logging) |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 4 hours [ 14400 ] | |
| Worklog Id | 268927 [ 268927 ] |
-
- Time Spent:
- 4 hours
-
Run the script and restart the nep after working hours.
| Assignee | Khaled Khalil [ kkhalil ] | Wajdi Jomaa [ wjomaa ] |
| Attachment | Sync issue in Unmapped and FR.docx [ 109103 ] |
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2025-05-20 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2025-05-20 24:00 (milestone: set planned end date to due date) |
Tested Fine on Test platform,Patch deployement pending on prod , later will ask customer for the closure