[LS-409] Error Report is not Appearing after 21st of May 2025 in ZAIN KSA Production 3.x Created: 26/May/25  Updated: 05/Jun/25  Due: 26/May/25  Resolved: 05/Jun/25

Status: Closed
Project: L3 Support
Component/s: NEP
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Normal
Reporter: Azmat Ali Assignee: Azmat Ali
Resolution: Fixed Votes: 0
Labels: AI_All_incidents, ZAINKSAAUDIT
Remaining Estimate: 0 minutes
Time Spent: 1 day
Original Estimate: Not Specified

Attachments: Zip Archive 20250527_Clean_Import_tables.zip     PNG File NEP Error Report Snap.png     File Re_ Error Report is not appearing on ZAIN KSA production 3.x LS-409.eml     PNG File Screenshot 2025-05-27 100739.png     PNG File XML Name Snap.png     File server.log.2025-05-23.tgz     File server.log.2025-05-24.tgz    
Customer:
Zain KSA 3.X
Planned Start:
Planned End:
Actual Start:
Date of Baselining:

 Description   

Error Report is not Appearing after 21st of May 2025 in ZAIN KSA Production 3.x

 Comments   
Comment by Azmat Ali [ 26/May/25 ]

Khaled Khalil, Please assign someone to get check the same.

Comment by Diana Hamdouche [ 27/May/25 ]

The issue was clear in logs
Based on this error, please find the below:
148 XML imports are currently present in the importer_report table with IMPORT_DATE < '15-MAY-25'.
Each of these imports has associated error details stored in the import_error table.

These tables are exceeded their table space and need to be cleaned.
A cleanup script has been prepared to safely delete all records older than 15-MAY-25 from both tables.
Please, apply it carefully

Generated at Tue Jan 06 10:48:28 EET 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.