Problem unloading packages - SharkWebClient and EJB on JBoss

[20mithrandir]

Hi guys!

I'm running the SharkWebClient with Shark configured as EJB (from XPDL4JBoss-community-2.4-1) on JBoss 4.2.3 and Microsoft SQL Server Express 2005.

I configured the Shark Database with the script from 'SharkDbUtil' and deployed the EAR on JBoss. Using the SharkWebClient I am able to create groups and users, to load packages and run processes. Everything seems to work properly.

But when I'm trying to unload a package there's always an SQL Error.

Test scenario:
1) Recreate Shark DB
2) Load Package (e.g. 'test-Extensions.xpdl')
3) Unload Package


Error Message:
Problems during package closing!: Couldn't write transaction: java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict occurred in database "shark2", table "dbo.SHKXPDLData", column 'XPDL'.
 
Stack Trace:
org.enhydra.shark.webclient.presentation.PresentationException: Problems during package closing!: Couldn't write transaction: java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict occurred in database "shark2", table "dbo.SHKXPDLData", column 'XPDL'.
at org.enhydra.shark.webclient.presentation.PackageHandlerPO.handleUnload(PackageHandlerPO.java:180)
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:585)
at org.enhydra.shark.webclient.presentation.BasePO.getPageContentForEvent(BasePO.java:478)
at org.enhydra.shark.webclient.presentation.BasePO.handleEvent(BasePO.java:328)
at org.enhydra.shark.webclient.presentation.BasePO.run(BasePO.java:194)
at com.lutris.appserver.server.httpPresentation.HttpPresentationManager.runPresentationObj(HttpPresentationManager.java:479)
at com.lutris.appserver.server.httpPresentation.HttpPresentationManager.Run(HttpPresentationManager.java:252)
at com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.serviceDirect(HttpPresentationServlet.java:680)
at com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.service(HttpPresentationServlet.java:805)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:595)

Caused by: org.enhydra.shark.api.internal.instancepersistence.PersistenceException: Couldn't write transaction: java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict occurred in database "shark2", table "dbo.SHKXPDLData", column 'XPDL'.
at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessMgrObject(DODSPersistentManager.java:3576)
at org.enhydra.shark.instancepersistence.DODSPersistentManager.restoreProcessMgr(DODSPersistentManager.java:1501)
at org.enhydra.shark.SharkUtilities.getProcessMgr(SharkUtilities.java:630)
at org.enhydra.shark.PackageAdmin.removeManagersForPackage(PackageAdmin.java:1052)
at org.enhydra.shark.PackageAdmin.closePackage(PackageAdmin.java:509)
at org.enhydra.shark.ws.PackageAdministrationWrapper.closePackage(PackageAdministrationWrapper.java:449)
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:585)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
at $Proxy169.closePackage(Unknown Source)
at org.enhydra.shark.webclient.presentation.PackageHandlerPO.handleUnload(PackageHandlerPO.java:153) ... 31 more

Caused by: com.lutris.dods.builder.generator.query.DataObjectException: Couldn't write transaction: java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict occurred in database "shark2", table "dbo.SHKXPDLData", column 'XPDL'.
at org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery._runQuery(ProcessDefinitionQuery.java:691)
at org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.runQuery(ProcessDefinitionQuery.java:642)
at org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.getNextDO(ProcessDefinitionQuery.java:1417)
at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessMgrObject(DODSPersistentManager.java:3573) ... 71 more ***

Caused by: com.lutris.dods.builder.generator.query.DataObjectException: Couldn't write transaction: java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict occurred in database "shark2", table "dbo.SHKXPDLData", column 'XPDL'.
at org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery._runQuery(ProcessDefinitionQuery.java:691)
at org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.runQuery(ProcessDefinitionQuery.java:642)
at org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.getNextDO(ProcessDefinitionQuery.java:1417)
at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessMgrObject(DODSPersistentManager.java:3573)
at org.enhydra.shark.instancepersistence.DODSPersistentManager.restoreProcessMgr(DODSPersistentManager.java:1501)
at org.enhydra.shark.SharkUtilities.getProcessMgr(SharkUtilities.java:630)
at org.enhydra.shark.PackageAdmin.removeManagersForPackage(PackageAdmin.java:1052)
at org.enhydra.shark.PackageAdmin.closePackage(PackageAdmin.java:509)
at org.enhydra.shark.ws.PackageAdministrationWrapper.closePackage(PackageAdministrationWrapper.java:449)
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:585)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
at $Proxy169.closePackage(Unknown Source)
at org.enhydra.shark.webclient.presentation.PackageHandlerPO.handleUnload(PackageHandlerPO.java:153)
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:585)
at org.enhydra.shark.webclient.presentation.BasePO.getPageContentForEvent(BasePO.java:478)
at org.enhydra.shark.webclient.presentation.BasePO.handleEvent(BasePO.java:328)
at org.enhydra.shark.webclient.presentation.BasePO.run(BasePO.java:194)
at com.lutris.appserver.server.httpPresentation.HttpPresentationManager.runPresentationObj(HttpPresentationManager.java:479)
at com.lutris.appserver.server.httpPresentation.HttpPresentationManager.Run(HttpPresentationManager.java:252)
at com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.serviceDirect(HttpPresentationServlet.java:680)
at com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.service(HttpPresentationServlet.java:805)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:595) org.enhydra.shark.api.internal.instancepersistence.PersistenceException: Couldn't write transaction: java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict occurred in database "shark2", table "dbo.SHKXPDLData", column 'XPDL'.
at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessMgrObject(DODSPersistentManager.java:3576)
at org.enhydra.shark.instancepersistence.DODSPersistentManager.restoreProcessMgr(DODSPersistentManager.java:1501)
at org.enhydra.shark.SharkUtilities.getProcessMgr(SharkUtilities.java:630)
at org.enhydra.shark.PackageAdmin.removeManagersForPackage(PackageAdmin.java:1052)
at org.enhydra.shark.PackageAdmin.closePackage(PackageAdmin.java:509)
at org.enhydra.shark.ws.PackageAdministrationWrapper.closePackage(PackageAdministrationWrapper.java:449)
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:585)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
at $Proxy169.closePackage(Unknown Source)
at org.enhydra.shark.webclient.presentation.PackageHandlerPO.handleUnload(PackageHandlerPO.java:153)
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:585)
at org.enhydra.shark.webclient.presentation.BasePO.getPageContentForEvent(BasePO.java:478)
at org.enhydra.shark.webclient.presentation.BasePO.handleEvent(BasePO.java:328)
at org.enhydra.shark.webclient.presentation.BasePO.run(BasePO.java:194)
at com.lutris.appserver.server.httpPresentation.HttpPresentationManager.runPresentationObj(HttpPresentationManager.java:479)
at com.lutris.appserver.server.httpPresentation.HttpPresentationManager.Run(HttpPresentationManager.java:252)
at com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.serviceDirect(HttpPresentationServlet.java:680)
at com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.service(HttpPresentationServlet.java:805)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:595)

Caused by: com.lutris.dods.builder.generator.query.DataObjectException: Couldn't write transaction: java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict occurred in database "shark2", table "dbo.SHKXPDLData", column 'XPDL'.
at org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery._runQuery(ProcessDefinitionQuery.java:691)
at org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.runQuery(ProcessDefinitionQuery.java:642)
at org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.getNextDO(ProcessDefinitionQuery.java:1417)
at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessMgrObject(DODSPersistentManager.java:3573) ... 71 more


I'd really appreciate it if someone could explain this behavior to me. I don't think I'm doing anything wrong. The same error occurs when I'm using a test-client (command-line) and simply call the 'closePackage' method on a 'PackageAdministration' object. What kind of configuration step might I be overlooking?

Thanks in advance and bye, Peter

[Sasa Bojanic]

Hi,

do you have process instances in your database based on the XPDL you try
to unload?
If so you need to terminate and delete them.

However, in the case of MSQL/MSQL2005, you will also need to manually
change the configuration in Shark.conf in order to be able to delete
process instances using Shark Web Client application.

You need to find the following entry in Shark.conf (in
%JBOSS_HOME%\server\default\sharkFiles\conf\Shark.conf):

DatabaseManager.ConfigurationDir

and set the value to the location of DODSs' configuration directory
inside your JBoss installation, e.g:
d:/jboss-4.0.2/server/default/sharkFiles/conf/dods


Greetings,
Sasa.


20mithrandir wrote:

> Hi guys!
>
> I'm running the SharkWebClient with Shark configured as EJB (from
> XPDL4JBoss-community-2.4-1) on JBoss 4.2.3 and Microsoft SQL Server Express
> 2005.
>
> I configured the Shark Database with the script from 'SharkDbUtil' and
> deployed the EAR on JBoss. Using the SharkWebClient I am able to create
> groups and users, to load packages and run processes. Everything seems to
> work properly.
>
> But when I'm trying to unload a package there's always an SQL Error.
>
> Test scenario:
> 1) Recreate Shark DB
> 2) Load Package (e.g. 'test-Extensions.xpdl')
> 3) Unload Package
>
>
> Error Message:
> Problems during package closing!: Couldn't write transaction:
> java.sql.SQLException: The DELETE statement conflicted with the REFERENCE
> constraint "SHKXPDLData_XPDL". The conflict occurred in database "shark2",
> table "dbo.SHKXPDLData", column 'XPDL'.
>  
> Stack Trace:
> org.enhydra.shark.webclient.presentation.PresentationException: Problems
> during package closing!: Couldn't write transaction:
> java.sql.SQLException: The DELETE statement conflicted with the REFERENCE
> constraint "SHKXPDLData_XPDL". The conflict occurred in database "shark2",
> table "dbo.SHKXPDLData", column 'XPDL'.
> at
> org.enhydra.shark.webclient.presentation.PackageHandlerPO.handleUnload(PackageHandlerPO.java:180)
> 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:585)
> at
> org.enhydra.shark.webclient.presentation.BasePO.getPageContentForEvent(BasePO.java:478)
> at
> org.enhydra.shark.webclient.presentation.BasePO.handleEvent(BasePO.java:328)
> at org.enhydra.shark.webclient.presentation.BasePO.run(BasePO.java:194)
> at
> com.lutris.appserver.server.httpPresentation.HttpPresentationManager.runPresentationObj(HttpPresentationManager.java:479)
> at
> com.lutris.appserver.server.httpPresentation.HttpPresentationManager.Run(HttpPresentationManager.java:252)
> at
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.serviceDirect(HttpPresentationServlet.java:680)
> at
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.service(HttpPresentationServlet.java:805)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
> at java.lang.Thread.run(Thread.java:595)
>
> Caused by:
> org.enhydra.shark.api.internal.instancepersistence.PersistenceException:
> Couldn't write transaction: java.sql.SQLException: The DELETE statement
> conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict
> occurred in database "shark2", table "dbo.SHKXPDLData", column
> 'XPDL'.
> at
> org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessMgrObject(DODSPersistentManager.java:3576)
> at
> org.enhydra.shark.instancepersistence.DODSPersistentManager.restoreProcessMgr(DODSPersistentManager.java:1501)
> at org.enhydra.shark.SharkUtilities.getProcessMgr(SharkUtilities.java:630)
> at
> org.enhydra.shark.PackageAdmin.removeManagersForPackage(PackageAdmin.java:1052)
> at org.enhydra.shark.PackageAdmin.closePackage(PackageAdmin.java:509)
> at
> org.enhydra.shark.ws.PackageAdministrationWrapper.closePackage(PackageAdministrationWrapper.java:449)
> 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:585)
> at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
> at
> org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
> at
> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
> at
> org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
> at
> org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
> at
> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
> at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
> at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
> at
> org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
> at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
> at
> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
> at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
> at org.jboss.ejb.Container.invoke(Container.java:960)
> at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at
> org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
> at
> org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
> at
> org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
> at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
> at
> org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
> at
> org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
> at
> org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
> at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
> at
> org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
> at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
> at $Proxy169.closePackage(Unknown Source)
> at
> org.enhydra.shark.webclient.presentation.PackageHandlerPO.handleUnload(PackageHandlerPO.java:153)
> ... 31 more
>
> Caused by: com.lutris.dods.builder.generator.query.DataObjectException:
> Couldn't write transaction: java.sql.SQLException: The DELETE statement
> conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict
> occurred in database "shark2", table "dbo.SHKXPDLData", column
> 'XPDL'.
> at
> org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery._runQuery(ProcessDefinitionQuery.java:691)
> at
> org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.runQuery(ProcessDefinitionQuery.java:642)
> at
> org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.getNextDO(ProcessDefinitionQuery.java:1417)
> at
> org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessMgrObject(DODSPersistentManager.java:3573)
> ... 71 more ***
>
> Caused by: com.lutris.dods.builder.generator.query.DataObjectException:
> Couldn't write transaction: java.sql.SQLException: The DELETE statement
> conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict
> occurred in database "shark2", table "dbo.SHKXPDLData", column
> 'XPDL'.
> at
> org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery._runQuery(ProcessDefinitionQuery.java:691)
> at
> org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.runQuery(ProcessDefinitionQuery.java:642)
> at
> org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.getNextDO(ProcessDefinitionQuery.java:1417)
> at
> org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessMgrObject(DODSPersistentManager.java:3573)
> at
> org.enhydra.shark.instancepersistence.DODSPersistentManager.restoreProcessMgr(DODSPersistentManager.java:1501)
> at org.enhydra.shark.SharkUtilities.getProcessMgr(SharkUtilities.java:630)
> at
> org.enhydra.shark.PackageAdmin.removeManagersForPackage(PackageAdmin.java:1052)
> at org.enhydra.shark.PackageAdmin.closePackage(PackageAdmin.java:509)
> at
> org.enhydra.shark.ws.PackageAdministrationWrapper.closePackage(PackageAdministrationWrapper.java:449)
> 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:585)
> at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
> at
> org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
> at
> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
> at
> org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
> at
> org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
> at
> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
> at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
> at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
> at
> org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
> at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
> at
> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
> at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
> at org.jboss.ejb.Container.invoke(Container.java:960)
> at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at
> org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
> at
> org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
> at
> org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
> at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
> at
> org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
> at
> org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
> at
> org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
> at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
> at
> org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
> at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
> at $Proxy169.closePackage(Unknown Source)
> at
> org.enhydra.shark.webclient.presentation.PackageHandlerPO.handleUnload(PackageHandlerPO.java:153)
> 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:585)
> at
> org.enhydra.shark.webclient.presentation.BasePO.getPageContentForEvent(BasePO.java:478)
> at
> org.enhydra.shark.webclient.presentation.BasePO.handleEvent(BasePO.java:328)
> at org.enhydra.shark.webclient.presentation.BasePO.run(BasePO.java:194)
> at
> com.lutris.appserver.server.httpPresentation.HttpPresentationManager.runPresentationObj(HttpPresentationManager.java:479)
> at
> com.lutris.appserver.server.httpPresentation.HttpPresentationManager.Run(HttpPresentationManager.java:252)
> at
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.serviceDirect(HttpPresentationServlet.java:680)
> at
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.service(HttpPresentationServlet.java:805)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
> at java.lang.Thread.run(Thread.java:595)
> org.enhydra.shark.api.internal.instancepersistence.PersistenceException:
> Couldn't write transaction: java.sql.SQLException: The DELETE statement
> conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict
> occurred in database "shark2", table "dbo.SHKXPDLData", column
> 'XPDL'.
> at
> org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessMgrObject(DODSPersistentManager.java:3576)
> at
> org.enhydra.shark.instancepersistence.DODSPersistentManager.restoreProcessMgr(DODSPersistentManager.java:1501)
> at org.enhydra.shark.SharkUtilities.getProcessMgr(SharkUtilities.java:630)
> at
> org.enhydra.shark.PackageAdmin.removeManagersForPackage(PackageAdmin.java:1052)
> at org.enhydra.shark.PackageAdmin.closePackage(PackageAdmin.java:509)
> at
> org.enhydra.shark.ws.PackageAdministrationWrapper.closePackage(PackageAdministrationWrapper.java:449)
> 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:585)
> at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
> at
> org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
> at
> org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
> at
> org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
> at
> org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
> at
> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
> at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
> at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
> at
> org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
> at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
> at
> org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
> at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
> at org.jboss.ejb.Container.invoke(Container.java:960)
> at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at
> org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
> at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
> at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
> at
> org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
> at
> org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
> at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
> at
> org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
> at
> org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
> at
> org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
> at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
> at
> org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
> at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
> at $Proxy169.closePackage(Unknown Source)
> at
> org.enhydra.shark.webclient.presentation.PackageHandlerPO.handleUnload(PackageHandlerPO.java:153)
> 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:585)
> at
> org.enhydra.shark.webclient.presentation.BasePO.getPageContentForEvent(BasePO.java:478)
> at
> org.enhydra.shark.webclient.presentation.BasePO.handleEvent(BasePO.java:328)
> at org.enhydra.shark.webclient.presentation.BasePO.run(BasePO.java:194)
> at
> com.lutris.appserver.server.httpPresentation.HttpPresentationManager.runPresentationObj(HttpPresentationManager.java:479)
> at
> com.lutris.appserver.server.httpPresentation.HttpPresentationManager.Run(HttpPresentationManager.java:252)
> at
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.serviceDirect(HttpPresentationServlet.java:680)
> at
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet.service(HttpPresentationServlet.java:805)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
> at java.lang.Thread.run(Thread.java:595)
>
> Caused by: com.lutris.dods.builder.generator.query.DataObjectException:
> Couldn't write transaction: java.sql.SQLException: The DELETE statement
> conflicted with the REFERENCE constraint "SHKXPDLData_XPDL". The conflict
> occurred in database "shark2", table "dbo.SHKXPDLData", column
> 'XPDL'.
> at
> org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery._runQuery(ProcessDefinitionQuery.java:691)
> at
> org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.runQuery(ProcessDefinitionQuery.java:642)
> at
> org.enhydra.shark.instancepersistence.data.ProcessDefinitionQuery.getNextDO(ProcessDefinitionQuery.java:1417)
> at
> org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessMgrObject(DODSPersistentManager.java:3573)
> ... 71 more
>
>
> I'd really appreciate it if someone could explain this behavior to me. I
> don't think I'm doing anything wrong. The same error occurs when I'm using a
> test-client (command-line) and simply call the 'closePackage' method on a
> 'PackageAdministration' object. What kind of configuration step might I be
> overlooking?
>
> Thanks in advance and bye, Peter
>  

--
You receive this message as a subscriber of the shark@... mailing list.
To unsubscribe: mailto:shark-unsubscribe@...
For general help: mailto:sympa@...?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

[20mithrandir]

Hi Sasa,

Sasa Bojanic wrote:

do you have process instances in your database based on the XPDL you try
to unload?
If so you need to terminate and delete them.

No, I don't have any process instances. Like I said, the problem occurs on a clean database when loading and directly unloading a package (without any instantiations).

Sasa Bojanic wrote:

However, in the case of MSQL/MSQL2005, you will also need to manually
change the configuration in Shark.conf in order to be able to delete
process instances using Shark Web Client application.

Yep, I thought of that too ; - )

Sasa Bojanic wrote:

You need to find the following entry in Shark.conf (in
%JBOSS_HOME%\server\default\sharkFiles\conf\Shark.conf):

DatabaseManager.ConfigurationDir

and set the value to the location of DODSs' configuration directory
inside your JBoss installation, e.g:
d:/jboss-4.0.2/server/default/sharkFiles/conf/dods

I already set the path to the place where I unzipped SharkDBUtil (from XPDL4JBoss.zip) and configured the database ... and that was my error. Setting the [...]/sharkFiles/conf/dods solved the problem.

Sasa Bojanic wrote:

Greetings,
Sasa.

Thank you very much for the fast reply and have a nice day ; - )

bye, Peter