[LS-842] error during the import process in WB,UW,KL circle, causing the NEP to go down daily. - Mobinets-JIRA

Details

Type: Bug
Status: Rejected (View Workflow)
Priority: Urgent
Resolution: Fixed
Component/s: NEP
Labels:
- NEP_D
- Labels

Customer:

Airtel India

Description

As Checked, we are encountering an error during the import process in WB,UW,KL circle, causing the NEP to go down daily.
This issue has been occurring for the past two days.

Please find the below error for your reference.
Kindly review and provide your suggestions.
sourceLocalTransactionCoordinatorImpl.java:231) [hibernate-core-5.1.10.Final.jar:5.1.10.Final]
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65) [hibernate-core-5.1.10.Final.jar:5.1.10.Final]
at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:582) [spring-orm-4.3.7.RELEASE.jar:4.3
.7.RELEASE]
... 13 more
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (WEST_BENGAL.SYS_C00186224) violated

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]
... 30 more

2025-12-25 20:31:02,078 INFO [stdout] (AsyncAppender-Dispatcher-Thread-102)
2025-12-25 20:31:02,305 INFO [stdout] (AsyncAppender-Dispatcher-Thread-102) 20:31:02-[ERROR][SqlExceptionHelper][Thread-117] ORA-00001: unique constraint
(WEST_BENGAL.SYS_C00186224) violated
2025-12-25 20:31:02,318 INFO [stdout] (AsyncAppender-Dispatcher-Thread-102)
2025-12-25 20:31:02,319 ERROR [com.mobinets.nep.npt.db.ThreadSaveContainer] (Thread-117) Error while saving: java.lang.RuntimeException: com.mobinets.nep.
npt.service.model.NptException: com.mobinets.nps.model.exception.NpsException: org.springframework.dao.DataIntegrityViolationException: could not execute
batch; SQL [update MANUFACTURER set CHANGEDATE=?, CHANGEDBY=?, EXTERNAL_CODE=?, INSERTEDBY=?, INSERTDATE=?, NET_STATUS=?, SUBNETSTATUS=?, CatalogID=?, isD
efault=?, Name=? where ManufacturerID=?]; constraint [WEST_BENGAL.SYS_C00186224]; nested exception is org.hibernate.exception.ConstraintViolationException
: could not execute batch
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.springframework.dao.DataIntegrityViolationE
xception: could not execute batch; SQL [update MANUFACTURER set CHANGEDATE=?, CHANGEDBY=?, EXTERNAL_CODE=?, INSERTEDBY=?, INSERTDATE=?, NET_STATUS=?, SUBNETSTATUS=?, CatalogID=?, isDefault=?, Name=? where ManufacturerID=?]; constraint [WEST_BENGAL.SYS_C00186224]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute batch
... 2 more
Caused by: com.mobinets.nps.model.exception.NpsException: org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [update MA

Attachments

server-25-12-2025-21-00.log_KL.tgz

30/Dec/25 6:03 AM

25 kB

Priyasha Tiwari
server-25-12-2025-21-00.log_UW.tgz

30/Dec/25 6:03 AM

565 kB

Priyasha Tiwari
server-25-12-2025-21-00.log_WB.tgz

30/Dec/25 6:03 AM

49 kB

Priyasha Tiwari

Activity

Ascending order - Click to sort in descending order

Permalink

Srishti Kashyap logged work - 26/Dec/25 12:00 AM

Time Spent:

2 hours

checked logs rerequested logs asking db requeste

Permalink

Basant Kumar logged work - 26/Dec/25 12:00 AM

Time Spent:

1 hour

i shared logs from WB,UW,KL for fatal error during goes down to NEP daily .

Bkumar made changes - 26/Dec/25 6:19 AM

Field	Original Value	New Value
Gantt Options		Milestone (set to milestone: having a due date but zero effort)
Planned Start		2025-12-26 24:00 (milestone: set planned start date to due date)
Planned End		2025-12-26 24:00 (milestone: set planned end date to due date)

Basant Kumar made changes - 26/Dec/25 6:19 AM

Assignee

Khaled Khalil [ kkhalil ]

Srishti Kashyap [ skashyap ]

Srishti Kashyap made changes - 29/Dec/25 6:18 AM

Remaining Estimate		0 minutes [ 0 ]
Time Spent		2 hours [ 7200 ]
Worklog Id	287412 [ 287412 ]

Srishti Kashyap made changes - 29/Dec/25 6:18 AM

Baseline Start		2025-12-26 24:00 (set baseline based of initial work logging)
Baseline End		2025-12-26 24:00 (set baseline based of initial work logging)

Priyasha Tiwari made changes - 30/Dec/25 6:00 AM

Labels

NEP_D

Priyasha Tiwari made changes - 30/Dec/25 6:01 AM

Description

As Checked, we are encountering an error during the import process in WB,UW,KL circle, causing the NEP to go down daily.
This issue has been occurring for the past two days.

As Checked, we are encountering an error during the import process in WB,UW,KL circle, causing the NEP to go down daily.
This issue has been occurring for the past two days.

Please find the below error for your reference.
Kindly review and provide your suggestions.
sourceLocalTransactionCoordinatorImpl.java:231) [hibernate-core-5.1.10.Final.jar:5.1.10.Final]
        at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65) [hibernate-core-5.1.10.Final.jar:5.1.10.Final]
        at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:582) [spring-orm-4.3.7.RELEASE.jar:4.3
.7.RELEASE]
        ... 13 more
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (WEST_BENGAL.SYS_C00186224) violated

        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]
        ... 30 more

2025-12-25 20:31:02,078 INFO [stdout] (AsyncAppender-Dispatcher-Thread-102)
2025-12-25 20:31:02,305 INFO [stdout] (AsyncAppender-Dispatcher-Thread-102) 20:31:02-[ERROR][SqlExceptionHelper][Thread-117] ORA-00001: unique constraint
(WEST_BENGAL.SYS_C00186224) violated
2025-12-25 20:31:02,318 INFO [stdout] (AsyncAppender-Dispatcher-Thread-102)
2025-12-25 20:31:02,319 ERROR [com.mobinets.nep.npt.db.ThreadSaveContainer] (Thread-117) Error while saving: java.lang.RuntimeException: com.mobinets.nep.
npt.service.model.NptException: com.mobinets.nps.model.exception.NpsException: org.springframework.dao.DataIntegrityViolationException: could not execute
batch; SQL [update MANUFACTURER set CHANGEDATE=?, CHANGEDBY=?, EXTERNAL_CODE=?, INSERTEDBY=?, INSERTDATE=?, NET_STATUS=?, SUBNETSTATUS=?, CatalogID=?, isD
efault=?, Name=? where ManufacturerID=?]; constraint [WEST_BENGAL.SYS_C00186224]; nested exception is org.hibernate.exception.ConstraintViolationException
: could not execute batch
        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.springframework.dao.DataIntegrityViolationE
xception: could not execute batch; SQL [update MANUFACTURER set CHANGEDATE=?, CHANGEDBY=?, EXTERNAL_CODE=?, INSERTEDBY=?, INSERTDATE=?, NET_STATUS=?, SUBNETSTATUS=?, CatalogID=?, isDefault=?, Name=? where ManufacturerID=?]; constraint [WEST_BENGAL.SYS_C00186224]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute batch
        ... 2 more
Caused by: com.mobinets.nps.model.exception.NpsException: org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [update MA

Hide

Permalink

Priyasha Tiwari added a comment - 30/Dec/25 6:03 AM

ERROR DETAIL AND LOGS ATTACHED

Show

Priyasha Tiwari added a comment - 30/Dec/25 6:03 AM ERROR DETAIL AND LOGS ATTACHED

Priyasha Tiwari made changes - 30/Dec/25 6:03 AM

Attachment		server-25-12-2025-21-00.log_KL.tgz [ 125101 ]
Attachment		server-25-12-2025-21-00.log_UW.tgz [ 125102 ]
Attachment		server-25-12-2025-21-00.log_WB.tgz [ 125103 ]

Basant Kumar made changes - 30/Dec/25 10:39 AM

Time Spent	2 hours [ 7200 ]	3 hours [ 10800 ]
Worklog Id	287549 [ 287549 ]

Permalink

Priyasha Tiwari logged work - 31/Dec/25 12:00 AM

Time Spent:

3 hours

internal call with L3 and L2 team and logs validation and issue analysis

Hide

Permalink

Srishti Kashyap added a comment - 31/Dec/25 5:32 AM

found exception during trying update of SAMSUNG manufacturer manual by gui..when retested on PROD didnt found same error. ITs resolved.

Show

Srishti Kashyap added a comment - 31/Dec/25 5:32 AM found exception during trying update of SAMSUNG manufacturer manual by gui..when retested on PROD didnt found same error. ITs resolved.

Srishti Kashyap made changes - 31/Dec/25 5:32 AM

Status	Open Bug [ 10108 ]	Rejected [ 10100 ]
Assignee	Srishti Kashyap [ skashyap ]	Basant Kumar [ bkumar ]
Resolution		Fixed [ 1 ]

Hide

Permalink

Khaled Khalil added a comment - 31/Dec/25 11:15 AM

to check the constraint on test platform and prod why we have that issue and if it can happen on other circle / schema

Show

Khaled Khalil added a comment - 31/Dec/25 11:15 AM to check the constraint on test platform and prod why we have that issue and if it can happen on other circle / schema

Priyasha Tiwari made changes - 02/Jan/26 4:47 AM

Time Spent	3 hours [ 10800 ]	6 hours [ 21600 ]
Worklog Id	287904 [ 287904 ]

Transition

Time In Source Status

Execution Times

Last Executer

Last Execution Date

Open Bug

Rejected

4d 23h 12m

Srishti Kashyap

31/Dec/25 5:32 AM

Invalid license: EXPIRED

People

Assignee:

Basant Kumar

Reporter:

Basant Kumar

Rejected By:

Srishti Kashyap

Votes:

0 Vote for this issue

Watchers:

4 Start watching this issue

Dates

Due:

26/Dec/25

Created:

26/Dec/25 6:19 AM

Updated:

02/Jan/26 4:47 AM

Resolved:

31/Dec/25 5:32 AM

Planned Start:

26/Dec/25 12:00 AM

Planned End:

26/Dec/25 12:00 AM

Actual Start:

26/Dec/25 12:00 AM

Date of Baselining:

29/Dec/25 6:18 AM

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

Agile

View on Board

Drag and Drop