[LS-684] Zain Kuwait saving to DB error Created: 02/Oct/25 Updated: 05/Dec/25 Due: 02/Oct/25 Resolved: 05/Dec/25 |
|
| Status: | Cancelled |
| Project: | L3 Support |
| Component/s: | NEP |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Urgent |
| Reporter: | Mohamad Merheb | Assignee: | Mustapha Al-Hage |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Customer: |
Zain Kuwait
|
| Planned Start: | |
| Planned End: |
| Description |
|
Error while saving data to DB after the xml import process on test server which lead to process unbinding and application shutdown. 2025-10-02 02:59:09,945 ERROR [com.mobinets.nps.dao.impl.NetworkUpdateDAO] (Thread-126) Failed SaveOrUpdate com.mobinets.nps.model.nodeinterfaces.NodeSlot.: org.hibernate.exception.ConstraintViolationException: could not execute batch Caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (ZAINKW_SEP30.FK_SLOTID_SHELFID) violated - parent key not found link to server log: https://we.tl/t-WH55iklxtb 2025-10-02 02:59:10,394 ERROR [com.mobinets.nps.services.imtDataInput.impl.ImtCreateWS] (Thread-126) Unavailable Service 'Save to Database'.: org.hibernate.exception.ConstraintViolationException: could not execute batch |
| Comments |
| Comment by Abir Messaikeh [ 24/Oct/25 ] |
|
Constraint was removed to allow import to be done |
| Comment by Abir Messaikeh [ 24/Oct/25 ] |
|
L3 to confirm if we can re-establish the constraint. |
| Comment by Mustapha Al-Hage [ 27/Nov/25 ] |
|
Please note that the constraint is re-established. Try to import the XML and confirm if the issue is still persisting |
| Comment by Abir Messaikeh [ 05/Dec/25 ] |
|
import is OK with constraint also as checked |