Details
-
Type:
Bug
-
Status:
Reopened
(View Workflow)
-
Priority:
Normal
-
Resolution: Not Fixed
-
Component/s: NEP
-
Labels:None Labels
-
Customer:OMAN-Tel
-
Product:NEP
Description
Dear @Abir Messaikeh, @Khaled Khalil,
We've found that some vendor tickets aren't being created because of an "Empty Description" error. We inserted CF_Pull into the Description template in the NEP_KQI table when these KQIs were created. Please review and let us know your recommendations.
Logs and NEP_KQI table exported sheet attached in link for your reference.
server.log.2025-06-30.gz
server.log.2025-06-30.gz:2025-06-30 22:22:05,549 ERROR [com.mobinets.nep.model.uttticket.controller.TroubleTicketsProcessingHandler] (org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-5) Error While Creating UttTicket for kqi name Huawei CPE Outdated dumps data, Diplay Name Huawei IP CPE Outdated dumps data , Empty Description
server.log.2025-06-30.gz:2025-06-30 22:21:21,773 ERROR [com.mobinets.nep.model.uttticket.controller.TroubleTicketsProcessingHandler] (org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-5) Error While Creating UttTicket for kqi name Cisco CPE Outdated dumps data, Diplay Name Cisco IP CPE Outdated dumps data , Empty Description
server.log.2025-06-30.gz:2025-06-30 20:20:58,480 ERROR [com.mobinets.nep.model.uttticket.controller.TroubleTicketsProcessingHandler] (org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-4) Error While Creating UttTicket for kqi name Cisco CPE Outdated dumps data, Diplay Name Cisco IP CPE Outdated dumps data , Empty Description
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2025-07-31 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2025-07-31 24:00 (milestone: set planned end date to due date) |
| Assignee | Khaled Khalil [ kkhalil ] | Marwan Kanaan [ mkanaan ] |
| Status | Open Bug [ 10108 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Abir Messaikeh [ amessaikeh ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Status | QA In Progress [ 10015 ] | Reopened [ 4 ] |
| Assignee | Abir Messaikeh [ amessaikeh ] | Khaled Khalil [ kkhalil ] |
| Resolution | Not Fixed [ 10200 ] |
| Status | Reopened [ 4 ] | Dev Scheduled [ 10014 ] |
| Assignee | Khaled Khalil [ kkhalil ] | Mustapha Al-Hage [ malhage ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Assignee | Mustapha Al-Hage [ malhage ] | Khaled Khalil [ kkhalil ] |
| Assignee | Khaled Khalil [ kkhalil ] | Mustapha Al-Hage [ malhage ] |
-
- Time Spent:
- 4 hours
-
Exploring DB + implemented logic
-
- Time Spent:
- 4 hours
-
Investigating the issue further by querying data from the PROD and resolving the connection issue with the BI platform.
| Assignee | Mustapha Al-Hage [ malhage ] | Marwan Kanaan [ mkanaan ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 4 hours [ 14400 ] | |
| Worklog Id | 279569 [ 279569 ] |
| Baseline Start | 2025-07-31 24:00 (set baseline based of initial work logging) | |
| Baseline End | 2025-07-31 24:00 (set baseline based of initial work logging) |
| Time Spent | 4 hours [ 14400 ] | 1 day [ 28800 ] |
| Worklog Id | 279570 [ 279570 ] |
-
- Time Spent:
- 2 hours
-
discuess with hassan and still blocked because the data and trying to solve the issue
| Time Spent | 1 day [ 28800 ] | 1 day, 5 hours [ 46800 ] |
| Worklog Id | 279620 [ 279620 ] |
| Status | Implementation in progress [ 10016 ] | Dev Paused [ 10017 ] |
| Time Spent | 1 day, 5 hours [ 46800 ] | 1 day, 7 hours [ 54000 ] |
| Worklog Id | 279812 [ 279812 ] |
| Worklog Id | 279620 [ 279620 ] |
| Worklog Id | 279812 [ 279812 ] |
| Remaining Estimate | 0 minutes [ 0 ] | 1 hour [ 3600 ] |
| Time Spent | 1 day, 7 hours [ 54000 ] | 1 day, 6 hours [ 50400 ] |
| Worklog Id | 279620 [ 279620 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Abir Messaikeh [ amessaikeh ] |
-
- Time Spent:
- 1 day
-
investigate the code and realise the logic and making a documentation about the kqi and bi
| Remaining Estimate | 1 hour [ 3600 ] | 0 minutes [ 0 ] |
| Time Spent | 1 day, 6 hours [ 50400 ] | 2 days, 6 hours [ 79200 ] |
| Worklog Id | 285790 [ 285790 ] |
-
- Time Spent:
- 4 hours
-
invistigate the issue and fixed bi data not coming issue
-
- Time Spent:
- 4 hours
-
fixed data issue not coming and start working on a fix
| Time Spent | 2 days, 6 hours [ 79200 ] | 3 days, 2 hours [ 93600 ] |
| Worklog Id | 288913 [ 288913 ] |
| Status | Dev Paused [ 10017 ] | Implementation in progress [ 10016 ] |
| Assignee | Abir Messaikeh [ amessaikeh ] | Marwan Kanaan [ mkanaan ] |
-
- Time Spent:
- 1 day
-
find the root cause and prevent the empty desc to generate anymore and provide a clean up for kqi tables
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Attachment | 20260116_TRUNCATE_AND_DELETE_CORRUPTED_DATA.sql [ 126314 ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Abir Messaikeh [ amessaikeh ] |
| Attachment | 20260116_TRUNCATE_AND_DELETE_CORRUPTED_DATA.sql [ 126314 ] |
| Attachment | 20260119_TRUNCATE_AND_DELETE_CORRUPTED_DATA.sql [ 126411 ] |
| Time Spent | 3 days, 2 hours [ 93600 ] | 4 days, 2 hours [ 122400 ] |
| Worklog Id | 289206 [ 289206 ] |
| Time Spent | 4 days, 2 hours [ 122400 ] | 4 days, 6 hours [ 136800 ] |
| Worklog Id | 289428 [ 289428 ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Status | QA In Progress [ 10015 ] | Reopened [ 4 ] |
| Assignee | Abir Messaikeh [ amessaikeh ] | Khaled Khalil [ kkhalil ] |
| Assignee | Khaled Khalil [ kkhalil ] | Marwan Kanaan [ mkanaan ] |
-
- Time Spent:
- 4 hours
-
investigate why the process of kqi dumps not working and replay the same to L2 to fix the configuration on prod
| Status | Reopened [ 4 ] | Dev Scheduled [ 10014 ] |
| Attachment | image (2).png [ 127802 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Abir Messaikeh [ amessaikeh ] |
| Time Spent | 4 days, 6 hours [ 136800 ] | 1 week, 2 hours [ 151200 ] |
| Worklog Id | 291126 [ 291126 ] |
| Worklog Id | 291126 [ 291126 ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Status | QA In Progress [ 10015 ] | Reopened [ 4 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Khaled Khalil [ kkhalil ] |
| Assignee | Khaled Khalil [ kkhalil ] | Marwan Kanaan [ mkanaan ] |
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
18m 59s | 1 | Marwan Kanaan | 07/Jul/25 7:25 AM | |||||
|
5d 18h 22m | 1 | Marwan Kanaan | 09/Oct/25 5:25 AM | |||||
|
98d 3h 24m | 1 | Marwan Kanaan | 15/Jan/26 7:50 AM | |||||
|
17d 9h 37m | 2 | Marwan Kanaan | 09/Feb/26 5:18 AM | |||||
|
1d 5h 28m | 3 | Marwan Kanaan | 09/Feb/26 10:42 AM | |||||
|
4d 5h 23m | 3 | Marwan Kanaan | 09/Feb/26 10:42 AM | |||||
|
1h 34m | 3 | Khaled Khalil | 09/Feb/26 11:29 AM | |||||
|
143d 13h 18m | 3 | Abir Messaikeh | 03/Apr/26 4:35 PM | |||||
|
1m 26s | 3 | Abir Messaikeh | 03/Apr/26 4:36 PM |
|
Links Hierarchy |
Documentation
|
Documentation
Please find below the formal technical guidelines to be strictly adhered to during the process of creating Key Quality Indicators (KQIs) to ensure system consistency and to prevent known issues such as empty description errors.
1. KQI Main Categories
During the KQI creation process, the following three primary KQI categories are to be used:
OutdatedDumpsData
AbnormalDumpsFilesCount
SFTP_SSHConnectionFailure
2. Configuration Guidelines for Each Category
2.1. OutdatedDumpsData
When working under the OutdatedDumpsData category:
The Description Template must be explicitly set to one of the following:
PhyLogNotSeparated
PhyLogSeparated
This is mandatory to avoid empty description generation, as the process relies on the template to determine the description format.
Additional Configuration:
If the template is set to PhyLogSeparated, it is imperative to configure the NEP_DUMPS_KQI_KEY table such that the KQI_FILE_TYPE column is set to either Logical or Physical.
If using PhyLogNotSeparated, this additional configuration is not required.
2.2. SFTP_SSHConnectionFailure
When working under the SFTP_SSHConnectionFailure category:
The Description Template must be one of the following:
CF_Push
CF_Pull
CF_WithAttachment
Note:
There is no requirement to set the KQI_FILE_TYPE column in the NEP_DUMPS_KQI_KEY table for this category.
2.3. AbnormalDumpsFilesCount
When working under the AbnormalDumpsFilesCount category:
The Description Template must be strictly set to:
PhyLogSeparated
Additional Configuration:
As with OutdatedDumpsData, it is mandatory to configure the NEP_DUMPS_KQI_KEY table such that the KQI_FILE_TYPE column is set to either Logical or Physical to ensure proper operation.
3. Important Notes
Failure to comply with the above configuration standards will result in empty descriptions due to the dependency of the description generation process on the correctly set templates and corresponding data in the database.
Please ensure these requirements are reviewed and implemented carefully during each KQI creation to maintain data integrity and prevent processing failures.
Should you require any clarifications or technical assistance regarding these configurations, please do not hesitate to reach out.
No Patch Need For This Bug
Best regards,