[LS-504] Fatal error during import in AS and HR circles Created: 14/Jul/25  Updated: 20/Jan/26  Due: 14/Jul/25  Resolved: 20/Jan/26

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

Type: Bug Priority: Normal
Reporter: Basant Kumar Assignee: Srishti Kashyap
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: 0 minutes
Time Spent: 7 hours
Original Estimate: Not Specified

Customer:
Airtel India
Planned Start:
Planned End:
Actual Start:
Date of Baselining:

 Description   

Dear Team,

We are experiencing a fatal error while saving imported data in the AS and HR circles. This issue is affecting application stability and causing the NEP application to crash.
Kindly review the error details below and provide your recommendations to resolve the issue.

 Comments   
Comment by Basant Kumar [ 14/Jul/25 ]

Dear Team,

We are experiencing a fatal error while saving imported data in the AS and HR circles. This issue is affecting application stability and causing the NEP application to crash.
Kindly review the error details below and provide your recommendations to resolve the issue.

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.3.7.RELEASE.jar:4.3.7.R
ELEASE]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) [spring-aop-4.3.7.RELEASE.jar:4.3.7.RELEASE]
at com.sun.proxy.$Proxy2008.saveToDatabase(Unknown Source)
at com.mobinets.nps.services.imtDataInput.impl.ImtCreateWS.saveToDatabase(ImtCreateWS.java:81) [nps_kernel.jar:]
at com.mobinets.nep.npt.db.SaveRunner.run(SaveRunner.java:54) [npt_server.jar:]
at com.mobinets.nep.npt.db.ThreadSaveContainer$1.run(ThreadSaveContainer.java:77) [npt_server.jar:]
Caused by: java.sql.BatchUpdateException: ORA-02291: integrity constraint (ASSAM.FK_TRAFFIC_TRLINK) violated - parent key not found

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:11190) [ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:244) [ojdbc7-12.1.0.2.jar:12.1.0.1.0]
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1135) [c3p0-0.9.2.1.jar:0.9.2.1]
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) [hibernate-core-5.1.10.Final.jar:5.1.10.Final]
... 33 more

2025-07-11 03:51:19,821 INFO [stdout] (AsyncAppender-Dispatcher-Thread-98) 03:51:19-[FATAL][SaveRunner][Thread-113] Error while it will may calling savin
g instances database
2025-07-11 03:51:19,822 ERROR [com.mobinets.nep.npt.db.ThreadSaveContainer] (Thread-113) Error while saving: java.lang.RuntimeException: com.mobinets.nep.
npt.service.model.NptException: com.mobinets.nps.model.exception.NpsException: org.hibernate.exception.ConstraintViolationException: could not execute bat
ch
at com.mobinets.nep.npt.db.SaveRunner.run(SaveRunner.java:66) [npt_server.jar:]
at com.mobinets.nep.npt.db.ThreadSaveContainer$1.run(ThreadSaveContainer.java:77) [npt_server.jar:]
Caused by: com.mobinets.nep.npt.service.model.NptException: com.mobinets.nps.model.exception.NpsException: org.hibernate.exception.ConstraintViolationExce
ption: could not execute batch
... 2 more

Comment by Anonymous [ 15/Jul/25 ]

Checked the logs and respective missing parent key in DB...data present there..added logs for tracking for future.

Comment by Srishti Kashyap [ 20/Aug/25 ]

Build 3.7.71.478 is released removing logs applied for it due to performance problem its creating.

Comment by Basant Kumar [ 20/Jan/26 ]

issue fixed

Generated at Fri Apr 17 09:37:29 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.