Getting a exception, and I'm stumped
"Neville van Deventer" <[email protected]> Fri, 16 Sep 2005 03:12:12 +0200
| Newsgroups | gmane.comp.java.enhydra.shark |
|---|---|
| Message-ID | <[email protected]> |
Hi List, I Started getting this exception, and I Don't know why, I've been using this XPDL For a while, and now I've started "Trimming" The Process Definitions, and I'm getting this exception Any Ideas ??? I've Nukked my database a few times already and it has not helped. Thanks Neville van Deventer Total Wrapper Time = 78 2005-09-16 02:59:54,499: Process[key=20_lawEnforcementPackage_assignInspectorProcess,mgrname=lawEnfor cementPackage#2#assignInspectorProcess] - Activity[Id=132_20_lawEnforcementPackage_assignInspectorProcess_assignInspec torProcess_Act23, ba=null, ActDefId=assignInspectorProcess_Act23] is completed. 2005-09-16 02:59:54,499: Process[key=20_lawEnforcementPackage_assignInspectorProcess,mgrname=lawEnfor cementPackage#2#assignInspectorProcess] - Activity[Id=133_20_lawEnforcementPackage_assignInspectorProcess_assignInspec torProcess_Act15, ba=null, ActDefId=assignInspectorProcess_Act15] is created 2005-09-16 02:59:54,499: Limit value is not set, not setting limit agent 2005-09-16 02:59:54,499: Activity[Id=133_20_lawEnforcementPackage_assignInspectorProcess_assignInspec torProcess_Act15, ba=null, ActDefId=assignInspectorProcess_Act15] - Executing tool [id=userAutoProcessWithRequest] userAutoProcessWithRequest Wrapper Class Called for User "neville" Package:lawEnforcementPackage Process:confirmContraventionProcess Request:11 Starting Process for User neville 2005-09-16 02:59:54,499: SharkConnectionImpl -> User neville is logged on 2005-09-16 02:59:55,030: Process [key=24_lawEnforcementPackage_confirmContraventionProcess,mgrname=lawEnforce mentPackage#2#confirmContraventionProcess] is created 2005-09-16 02:59:55,046: Rollback of Shark transaction happened. java.sql.SQLException: Cannot insert duplicate key row in object 'ProcessData' with unique index 'I1_ProcessData'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364 ) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2708) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2150) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:587) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:43 8) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:421) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedSt atement.java:397) at com.lutris.appserver.server.sql.standard.StandardDBConnection.executeUpdate( StandardDBConnection.java:467) at com.lutris.appserver.server.sql.CoreDO.executeInsert(CoreDO.java:345) at com.lutris.dods.builder.generator.dataobject.GenericDO.executeInsert(Generic DO.java:352) at org.enhydra.shark.instancepersistence.data.ProcessDataDO.executeInsert(Proce ssDataDO.java:2269) at com.lutris.appserver.server.sql.standard.StandardDBTransaction.write(Standar dDBTransaction.java:654) at com.lutris.appserver.server.sql.standard.StandardDBTransaction.commit(Standa rdDBTransaction.java:296) at org.enhydra.shark.transaction.SharkDODSTransaction.commit(SharkDODSTransacti on.java:59) at org.enhydra.shark.SharkUtilities.commitTransaction(SharkUtilities.java:692) at org.enhydra.shark.SharkConnectionImpl.createProcess(SharkConnectionImpl.java :179) at za.gov.tshwane.shark.SharkServer.userNewProcess(SharkServer.java:1985) at za.gov.tshwane.shark.SharkServer.userAutoProcess(SharkServer.java:1832) at za.gov.tshwane.shark.wrapper.commonSharkWrapper.userProcessStart(commonShark Wrapper.java:30) at za.gov.tshwane.shark.wrapper.userAutoProcessWithRequest.execute(userAutoProc essWithRequest.java:37) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.enhydra.shark.toolagent.JavaClassToolAgent.invokeApplication(JavaClassTo olAgent.java:53) at org.enhydra.shark.toolagent.DefaultToolAgent.invokeApplication(DefaultToolAg ent.java:72) at org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.invokeApplication(ToolAgen tManagerImpl.java:211) at org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.run(ToolAgentManagerImpl.j ava:96) at org.enhydra.shark.ToolAgentManagerImpl.executeActivity(ToolAgentManagerImpl. java:67) at org.enhydra.shark.WfActivityImpl.runTool(WfActivityImpl.java:1269) at org.enhydra.shark.WfActivityImpl.startActivity(WfActivityImpl.java:1212) at org.enhydra.shark.WfActivityImpl.activate(WfActivityImpl.java:1157) at org.enhydra.shark.WfProcessImpl.startActivity(WfProcessImpl.java:816) at org.enhydra.shark.WfProcessImpl.queueNext(WfProcessImpl.java:997) at org.enhydra.shark.WfProcessImpl.run(WfProcessImpl.java:703) at org.enhydra.shark.WfProcessImpl.activity_complete(WfProcessImpl.java:862) at org.enhydra.shark.WfActivityImpl.finish(WfActivityImpl.java:373) at org.enhydra.shark.WfActivityImpl.complete(WfActivityImpl.java:326) at org.enhydra.shark.WfActivityWrapper.complete(WfActivityWrapper.java:391) at org.enhydra.shark.WfActivityWrapper.complete(WfActivityWrapper.java:359) at za.gov.tshwane.shark.SharkServerMultiThread.sharkCompleteAssignment(SharkSer verMultiThread.java:307) at za.gov.tshwane.shark.SharkServerMultiThread.userCompleteAssignment(SharkServ erMultiThread.java:1944) at za.gov.tshwane.shark.SharkServerMultiThread.userProcess(SharkServerMultiThre ad.java:1889) at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at za.gov.tshwane.shark.webserver.WebService.remoteInvoke(WebService.java:121) at za.gov.tshwane.shark.webserver.WebService.doPost(WebService.java:56) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126 ) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105 ) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav a:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo rkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:684) at java.lang.Thread.run(Unknown Source) org.enhydra.shark.api.TransactionException: Cannot insert duplicate key row in object 'ProcessData' with unique index 'I1_ProcessData'. at org.enhydra.shark.transaction.SharkDODSTransaction.commit(SharkDODSTransacti on.java:70) at org.enhydra.shark.SharkUtilities.commitTransaction(SharkUtilities.java:692) at org.enhydra.shark.SharkConnectionImpl.createProcess(SharkConnectionImpl.java :179) at za.gov.tshwane.shark.SharkServer.userNewProcess(SharkServer.java:1985) at za.gov.tshwane.shark.SharkServer.userAutoProcess(SharkServer.java:1832) at za.gov.tshwane.shark.wrapper.commonSharkWrapper.userProcessStart(commonShark Wrapper.java:30) at za.gov.tshwane.shark.wrapper.userAutoProcessWithRequest.execute(userAutoProc essWithRequest.java:37) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.enhydra.shark.toolagent.JavaClassToolAgent.invokeApplication(JavaClassTo olAgent.java:53) at org.enhydra.shark.toolagent.DefaultToolAgent.invokeApplication(DefaultToolAg ent.java:72) at org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.invokeApplication(ToolAgen tManagerImpl.java:211) at org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.run(ToolAgentManagerImpl.j ava:96) at org.enhydra.shark.ToolAgentManagerImpl.executeActivity(ToolAgentManagerImpl. java:67) at org.enhydra.shark.WfActivityImpl.runTool(WfActivityImpl.java:1269) at org.enhydra.shark.WfActivityImpl.startActivity(WfActivityImpl.java:1212) at org.enhydra.shark.WfActivityImpl.activate(WfActivityImpl.java:1157) at org.enhydra.shark.WfProcessImpl.startActivity(WfProcessImpl.java:816) at org.enhydra.shark.WfProcessImpl.queueNext(WfProcessImpl.java:997) at org.enhydra.shark.WfProcessImpl.run(WfProcessImpl.java:703) at org.enhydra.shark.WfProcessImpl.activity_complete(WfProcessImpl.java:862) at org.enhydra.shark.WfActivityImpl.finish(WfActivityImpl.java:373) at org.enhydra.shark.WfActivityImpl.complete(WfActivityImpl.java:326) at org.enhydra.shark.WfActivityWrapper.complete(WfActivityWrapper.java:391) at org.enhydra.shark.WfActivityWrapper.complete(WfActivityWrapper.java:359) at za.gov.tshwane.shark.SharkServerMultiThread.sharkCompleteAssignment(SharkSer verMultiThread.java:307) at za.gov.tshwane.shark.SharkServerMultiThread.userCompleteAssignment(SharkServ erMultiThread.java:1944) at za.gov.tshwane.shark.SharkServerMultiThread.userProcess(SharkServerMultiThre ad.java:1889) at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at za.gov.tshwane.shark.webserver.WebService.remoteInvoke(WebService.java:121) at za.gov.tshwane.shark.webserver.WebService.doPost(WebService.java:56) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126 ) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105 ) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav a:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo rkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:684) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Cannot insert duplicate key row in object 'ProcessData' with unique index 'I1_ProcessData'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364 ) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2708) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2150) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:587) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:43 8) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:421) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedSt atement.java:397) at com.lutris.appserver.server.sql.standard.StandardDBConnection.executeUpdate( StandardDBConnection.java:467) at com.lutris.appserver.server.sql.CoreDO.executeInsert(CoreDO.java:345) at com.lutris.dods.builder.generator.dataobject.GenericDO.executeInsert(Generic DO.java:352) at org.enhydra.shark.instancepersistence.data.ProcessDataDO.executeInsert(Proce ssDataDO.java:2269) at com.lutris.appserver.server.sql.standard.StandardDBTransaction.write(Standar dDBTransaction.java:654) at com.lutris.appserver.server.sql.standard.StandardDBTransaction.commit(Standa rdDBTransaction.java:296) at org.enhydra.shark.transaction.SharkDODSTransaction.commit(SharkDODSTransacti on.java:59) ... 50 more org.enhydra.shark.api.client.wfbase.BaseException: Cannot insert duplicate key row in object 'ProcessData' with unique index 'I1_ProcessData'. at org.enhydra.shark.SharkUtilities.commitTransaction(SharkUtilities.java:696) at org.enhydra.shark.SharkConnectionImpl.createProcess(SharkConnectionImpl.java :179) at za.gov.tshwane.shark.SharkServer.userNewProcess(SharkServer.java:1985) at za.gov.tshwane.shark.SharkServer.userAutoProcess(SharkServer.java:1832) at za.gov.tshwane.shark.wrapper.commonSharkWrapper.userProcessStart(commonShark Wrapper.java:30) at za.gov.tshwane.shark.wrapper.userAutoProcessWithRequest.execute(userAutoProc essWithRequest.java:37) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.enhydra.shark.toolagent.JavaClassToolAgent.invokeApplication(JavaClassTo olAgent.java:53) at org.enhydra.shark.toolagent.DefaultToolAgent.invokeApplication(DefaultToolAg ent.java:72) at org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.invokeApplication(ToolAgen tManagerImpl.java:211) at org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.run(ToolAgentManagerImpl.j ava:96) at org.enhydra.shark.ToolAgentManagerImpl.executeActivity(ToolAgentManagerImpl. java:67) at org.enhydra.shark.WfActivityImpl.runTool(WfActivityImpl.java:1269) at org.enhydra.shark.WfActivityImpl.startActivity(WfActivityImpl.java:1212) at org.enhydra.shark.WfActivityImpl.activate(WfActivityImpl.java:1157) at org.enhydra.shark.WfProcessImpl.startActivity(WfProcessImpl.java:816) at org.enhydra.shark.WfProcessImpl.queueNext(WfProcessImpl.java:997) at org.enhydra.shark.WfProcessImpl.run(WfProcessImpl.java:703) at org.enhydra.shark.WfProcessImpl.activity_complete(WfProcessImpl.java:862) at org.enhydra.shark.WfActivityImpl.finish(WfActivityImpl.java:373) at org.enhydra.shark.WfActivityImpl.complete(WfActivityImpl.java:326) at org.enhydra.shark.WfActivityWrapper.complete(WfActivityWrapper.java:391) at org.enhydra.shark.WfActivityWrapper.complete(WfActivityWrapper.java:359) at za.gov.tshwane.shark.SharkServerMultiThread.sharkCompleteAssignment(SharkSer verMultiThread.java:307) at za.gov.tshwane.shark.SharkServerMultiThread.userCompleteAssignment(SharkServ erMultiThread.java:1944) at za.gov.tshwane.shark.SharkServerMultiThread.userProcess(SharkServerMultiThre ad.java:1889) at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at za.gov.tshwane.shark.webserver.WebService.remoteInvoke(WebService.java:121) at za.gov.tshwane.shark.webserver.WebService.doPost(WebService.java:56) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126 ) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105 ) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav a:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo rkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:684) at java.lang.Thread.run(Unknown Source) Caused by: org.enhydra.shark.api.TransactionException: Cannot insert duplicate key row in object 'ProcessData' with unique index 'I1_ProcessData'. at org.enhydra.shark.transaction.SharkDODSTransaction.commit(SharkDODSTransacti on.java:70) at org.enhydra.shark.SharkUtilities.commitTransaction(SharkUtilities.java:692) ... 49 more Caused by: java.sql.SQLException: Cannot insert duplicate key row in object 'ProcessData' with unique index 'I1_ProcessData'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364 ) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2708) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2150) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:587) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:43 8) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:421) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedSt atement.java:397) at com.lutris.appserver.server.sql.standard.StandardDBConnection.executeUpdate( StandardDBConnection.java:467) at com.lutris.appserver.server.sql.CoreDO.executeInsert(CoreDO.java:345) at com.lutris.dods.builder.generator.dataobject.GenericDO.executeInsert(Generic DO.java:352) at org.enhydra.shark.instancepersistence.data.ProcessDataDO.executeInsert(Proce ssDataDO.java:2269) at com.lutris.appserver.server.sql.standard.StandardDBTransaction.write(Standar dDBTransaction.java:654) at com.lutris.appserver.server.sql.standard.StandardDBTransaction.commit(Standa rdDBTransaction.java:296) at org.enhydra.shark.transaction.SharkDODSTransaction.commit(SharkDODSTransacti on.java:59) ... 50 more 2005-09-16 02:59:55,077: SharkConnectionImpl -> User neville with connection key 31 is logged off Total AutoProcess Start Time = 578 2005-09-16 02:59:55,077: Process[key=20_lawEnforcementPackage_assignInspectorProcess,mgrname=lawEnfor cementPackage#2#assignInspectorProcess] - Activity[Id=133_20_lawEnforcementPackage_assignInspectorProcess_assignInspec torProcess_Act15, ba=null, ActDefId=assignInspectorProcess_Act15] is completed. 2005-09-16 02:59:55,077: Process[key=20_lawEnforcementPackage_assignInspectorProcess,mgrname=lawEnfor cementPackage#2#assignInspectorProcess] - Activity[Id=134_20_lawEnforcementPackage_assignInspectorProcess_assignInspec torProcess_Act6, ba=null, ActDefId=assignInspectorProcess_Act6] is created 2005-09-16 02:59:55,077: Limit value is not set, not setting limit agent
message-footer.txt
(text/plain, 271 B)
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws