Task #8909
SIT MSS: Error Upon Update Service List
| Status: | Closed - End of life cycle | Start date: | December 03, 2018 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | December 05, 2018 | |
| Assignee: | % Done: | 100% | ||
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
As per reported by Bella on 3rd December 2018:
- Update service list masih error
com.ibm.websphere.ce.cm.DuplicateKeyException: One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "DBO.IB_SERVICE_LIST" from having duplicate values for the index key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=3.62.56
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:627)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:686)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2267)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1191)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:819)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
History
#1
Updated by Rayvandy Gabbytian almost 6 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 100
Fixed, due to duplicate OID
#2
Updated by Rayvandy Gabbytian over 5 years ago
- Status changed from Development / Work In Progress to Closed - End of life cycle