com.bea.ld.dsmediator.DataServiceException

Optimistic locking failure, update count for object WellCommon is 0, it should be 1. workItemId= 5306 AND typeId= 14 AND substanceId= 12 AND potentialSour= false AND classificationId= 11 AND orientationId= 10 AND afeNumber= 372 AND nonOp= false AND operationTypeId= 2 AND authorityId= 8 AND pad is NULL AND surfaceLocationSystem is NULL AND surfaceLocation is NULL AND bottomHoleLocationSystem is NULL AND bottomHoleLocation is NULL

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web3

  • via Oracle Community by 666705, 1 year ago
    Optimistic locking failure, update count for object WellCommon is 0, it should be 1. workItemId= 5306 AND typeId= 14 AND substanceId= 12 AND potentialSour= false AND classificationId= 11 AND orientationId= 10 AND afeNumber= 372 AND nonOp= false AND
  • via Oracle Community by 666705, 1 year ago
    java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__EmployeeDetails__6383C8BA'. Cannot insert duplicate key in object 'EmployeeDetails'. Severity 14, State 1, Procedure 'PC-P41403 null', Line 1
  • via Oracle Community by 666705, 1 year ago
    Primary key on Object ALDSP_TAB is not defined.
  • Stack trace

    • com.bea.ld.dsmediator.DataServiceException: Optimistic locking failure, update count for object WellCommon is 0, it should be 1. workItemId= 5306 AND typeId= 14 AND substanceId= 12 AND potentialSour= false AND classificationId= 11 AND orientationId= 10 AND afeNumber= 372 AND nonOp= false AND operationTypeId= 2 AND authorityId= 8 AND pad is NULL AND surfaceLocationSystem is NULL AND surfaceLocation is NULL AND bottomHoleLocationSystem is NULL AND bottomHoleLocation is NULL at com.bea.ld.dsmediator.update.JDBCAdaptor.save(JDBCAdaptor.java:176) at com.bea.ld.dsmediator.update.DataServiceMediator.submit(DataServiceMediator.java:500) at com.bea.ld.dsmediator.update.DataServiceMediator.nestedSubmit(DataServiceMediator.java:1871) at com.bea.ld.dsmediator.update.DataServiceMediator.executeUpdatePlan(DataServiceMediator.java:1828) at com.bea.ld.dsmediator.update.DataServiceMediator.submit(DataServiceMediator.java:511) at com.bea.ld.dsmediator.update.DataServiceMediator.submit(DataServiceMediator.java:227) at com.bea.ld.ServerBean.submit(ServerBean.java:529) at com.bea.ld.Server_ydm4ie_EOImpl.submit(Server_ydm4ie_EOImpl.java:964) at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:166) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:290) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:248) at com.bea.ld.Server_ydm4ie_EOImpl_815_WLStub.submit(Unknown Source) at com.bea.dsp.dsmediator.client.XmlDataServiceBase.submitInternal(XmlDataServiceBase.java:177) at com.bea.dsp.dsmediator.client.XmlDataServiceBase.submit(XmlDataServiceBase.java:93) at com.bea.dsp.dsmediator.client.XmlDataServiceBase.submit(XmlDataServiceBase.java:77) at com._3esi.platform.data.server.impl.AldspServiceManager.invokeSubmit(AldspServiceManager.java:133) at com._3esi.platform.data.server.servlet.EsiPlatformDataServlet.handleRequest(EsiPlatformDataServlet.java:133) at com._3esi.platform.data.server.servlet.EsiPlatformDataServlet.doPost(EsiPlatformDataServlet.java:86) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1072) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:348) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6981) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3892) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2766) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.