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

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

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

issue fixed