Strange Exception while Updating XPDL File on MySQL
Alexander Malic <[email protected]> Fri, 24 Feb 2006 13:57:36 +0100
| Newsgroups | gmane.comp.java.enhydra.shark |
|---|---|
| Message-ID | <OF0C8BA781.816465A2-ONC125711F.00459EFE-C125711F.0046E64F@workflow.at> |
hi,
i updated to latest cvs-version. got allmost everything running (apart of
our jawe integration).
it's now working sometimes and sometimes not.
don't know exactly where the problem does come from, but i think it has
something with the next xpdl-version to do.
greets, alex
Caused by: java.sql.SQLException: Data Object error: null
at
org.enhydra.shark.repositorypersistence.data.NextXPDLVersionDO.getUpdateStatement(
NextXPDLVersionDO.java:3157)
at com.lutris.appserver.server.sql.CoreDO.executeUpdate(
CoreDO.java:393)
at
com.lutris.dods.builder.generator.dataobject.GenericDO.executeUpdate(
GenericDO.java:328)
at
org.enhydra.shark.repositorypersistence.data.NextXPDLVersionDO.executeUpdate(
NextXPDLVersionDO.java:2278)
at com.lutris.appserver.server.sql.CoreDO.executeInsert(
CoreDO.java:340)
at
com.lutris.dods.builder.generator.dataobject.GenericDO.executeInsert(
GenericDO.java:352)
at
org.enhydra.shark.repositorypersistence.data.NextXPDLVersionDO.executeInsert(
NextXPDLVersionDO.java:2269)
at
com.lutris.appserver.server.sql.standard.StandardDBTransaction.write(
StandardDBTransaction.java:654)
at
org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.updateNextVersion(
DODSRepositoryPersistenceManager.java:234)
at
org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.uploadXPDL(
DODSRepositoryPersistenceManager.java:75)
... 80 more
writing...
----------------------------------------------------------------------------------------------------
here's the data of the relevant tables
select * from xpdls order by XPDLId,XPDLVersion
XPDLId XPDLVersion XPDLClassVersion XPDLUploadTime
oid version
----------------- -------------- -------------------
--------------------- ------- ----------
SP_Berechtigung 1 1138615207000 2006-02-24
12:32:27.0 1000050 0
SP_Berechtigung 2 1138615207000 2006-02-24
13:09:43.0 1000407 0
SP_Berechtigung 3 1138615207000 2006-02-24
13:10:40.0 1000416 0
SP_Fehlzeit 1 1138615207000 2006-02-24
12:32:23.0 1000042 0
SP_Fehlzeit 2 1138615207000 2006-02-24
13:10:17.0 1000413 0
SP_Fehlzeit 3 1138615207000 2006-02-24
13:10:58.0 1000419 0
SP_Folgefehlgrund 1 1138615207000 2006-02-24
12:32:25.0 1000046 0
SP_Folgefehlgrund 2 1138615207000 2006-02-24
13:08:54.0 1000401 0
SP_Folgefehlgrund 3 1138615207000 2006-02-24
13:09:10.0 1000404 0
SP_Folgefehlgrund 4 1138615207000 2006-02-24
13:09:57.0 1000410 0
SP_Folgefehlgrund 5 1138615207000 2006-02-24
13:13:38.0 1000546 0
SP_Folgefehlgrund 6 1138615207000 2006-02-24
13:18:33.0 1000549 0
SP_Zeitkorrektur 1 1138615207000 2006-02-24
12:32:19.0 1000037 0
SP_Zeitkorrektur 2 1138615207000 2006-02-24
13:11:43.0 1000422 0
select * from nextxpdlversions order by XPDLId
XPDLId NextVersion oid version
----------------- -------------- ------- ----------
SP_Berechtigung 4 1000049 2
SP_Fehlzeit 4 1000041 2
SP_Folgefehlgrund 7 1000045 5
SP_Zeitkorrektur 3 1000036 1
----- Forwarded by Alexander Malic/Workflow on 24.02.2006 13:37 -----
Alexander Malic <[email protected]>
21.02.2006 17:13
Please respond to
[email protected]
To
[email protected]
cc
Subject
Fw: [shark] Strange Exception while Updating XPDL File on MySQL
hi,
it seams only to occour only on windows platforms when trying to upload a
xpdl a second time. after restarting the application it is again possible
to upload the xpdl (only for one time).
i'm developing on os-x with mysql -> no problems
a sample xpdl is attached in the mail.
btw: i'm using shark 1.1-2 with mysql 4.1.13
thanks in advance,
Alexander Malic
workflow EDV-GmbH
Gabriel Gruber/Workflow
20.02.2006 15:02
To
[email protected]
cc
Subject
Fw: [shark] Strange Exception while Updating XPDL File on MySQL
----- Forwarded by Gabriel Gruber/Workflow on 20.02.2006 15:02 -----
Gabriel Gruber <[email protected]>
17.02.2006 09:32
Please respond to
[email protected]
To
[email protected]
cc
Subject
[shark] Strange Exception while Updating XPDL File on MySQL
Hello All,
has anybody seen such an Exception?
It occurs while updating an existing XPDL on a MySQL Database.
Interestingly it does not occur on MS SQL Server...
Any Ideas?
Thanx in Advance,
Gabriel Gruber,
Workflow EDV GmbH, Austria
______________
org.enhydra.shark.api.client.wfbase.BaseException:
DODSRepositoryPersistenceManager -> The upload of xpdl SP_Zeitkorrektur
failed
at org.enhydra.shark.PackageAdmin.openPackage(PackageAdmin.java:814)
at
org.enhydra.shark.PackageAdmin.updatePackage(PackageAdmin.java:298)
at
org.enhydra.shark.PackageAdmin.updatePackage(PackageAdmin.java:277)
at
at.workflow.webdesk.wf.sharkimpl.WfProcessDefinitionDAOImpl.uploadXpdl(WfProcessDefinitionDAOImpl.java:891)
at
at.workflow.webdesk.wf.sharkimpl.WfProcessDefinitionDAOImpl.uploadXpdlDoc(WfProcessDefinitionDAOImpl.java:845)
at
at.workflow.webdesk.wf.sharkimpl.WfProcessDefinitionDAOImpl.uploadSimpleProcessDefinition(WfProcessDefinitionDAOImpl.java:835)
at
at.workflow.webdesk.wf.sharkimpl.WfImpl.uploadSimpleProcessDefinition(WfImpl.java:512)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy15.uploadSimpleProcessDefinition(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:174)
at
org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:197)
at
org.mozilla.javascript.Interpreter.interpret(Interpreter.java:3026)
at
org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2164)
at
org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:140)
at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:304)
at
org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2769)
at
org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2145)
at
org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:140)
at org.mozilla.javascript.Context.call(Context.java:497)
at
org.mozilla.javascript.ScriptableObject.callMethod(ScriptableObject.java:1496)
at
org.mozilla.javascript.ScriptableObject.callMethod(ScriptableObject.java:1466)
at
org.apache.cocoon.components.flow.javascript.fom.FOM_JavaScriptInterpreter.handleContinuation(FOM_JavaScriptInterpreter.java:843)
at
org.apache.cocoon.components.treeprocessor.sitemap.CallFunctionNode.invoke(CallFunctionNode.java:123)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:46)
at
org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTypeNode.java:138)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:46)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:130)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:138)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:92)
at
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:234)
at
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:176)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:243)
at org.apache.cocoon.Cocoon.process(Cocoon.java:608)
at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1123)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.jspbook.GZIPFilter.doFilter(Unknown Source)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:172)
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by:
org.enhydra.shark.api.internal.repositorypersistence.RepositoryException:
DODSRepositoryPersistenceManager -> The upload of xpdl SP_Zeitkorrektur
failed
at
org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.uploadXPDL(DODSRepositoryPersistenceManager.java:95)
at
org.enhydra.shark.PackageAdmin.copyPackagesToInternalPackagesRepository(PackageAdmin.java:881)
at org.enhydra.shark.PackageAdmin.openPackage(PackageAdmin.java:765)
... 80 more
Caused by: com.lutris.appserver.server.sql.DBRowUpdateException: Update
failed: Table NextXPDLVersions id=1006601 has version 0 where object has
version 1.
at
com.lutris.appserver.server.sql.CoreDO.seeWhatHappened(CoreDO.java:438)
at
com.lutris.appserver.server.sql.CoreDO.executeUpdate(CoreDO.java:405)
at
com.lutris.dods.builder.generator.dataobject.GenericDO.executeUpdate(GenericDO.java:328)
at
org.enhydra.shark.repositorypersistence.data.NextXPDLVersionDO.executeUpdate(NextXPDLVersionDO.java:2278)
at
com.lutris.appserver.server.sql.CoreDO.executeInsert(CoreDO.java:340)
at
com.lutris.dods.builder.generator.dataobject.GenericDO.executeInsert(GenericDO.java:352)
at
org.enhydra.shark.repositorypersistence.data.NextXPDLVersionDO.executeInsert(NextXPDLVersionDO.java:2269)
at
com.lutris.appserver.server.sql.standard.StandardDBTransaction.write(StandardDBTransaction.java:654)
at
org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.updateNextVersion(DODSRepositoryPersistenceManager.java:239)
at
org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.uploadXPDL(DODSRepositoryPersistenceManager.java:80)
... 82 more
--
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
--
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
Berechtigung.xpdl
(application/octet-stream, 19.7 KB) - not displayed
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