Bug 777563 (SOA-67) - Integrity constraint violation - no parent FK_ACTION_ACTNDEL table: JBPM_DELEGATION - at (emmbedded) server startup
Summary: Integrity constraint violation - no parent FK_ACTION_ACTNDEL table: JBPM_DELE...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-67
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: JBPM - within SOA
Version: 4.2 IR3
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 4.2 CR3
Assignee: Mike Brock
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA-67
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2007-10-29 17:21 UTC by Len DiMaggio
Modified: 2013-06-17 05:10 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
RHEL5 Java 1.5 Sun IR3 - embedded ESB server - installed from: https://svn.corp.jboss.com/repos/soa/trunk/releases/soa-p-4.2.0-IR3.0/soa-platform-installer-4.2.IR3.jar
Last Closed: 2007-12-05 03:11:00 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-67 0 Major Closed Integrity constraint violation - no parent FK_ACTION_ACTNDEL table: JBPM_DELEGATION - at (emmbedded) server startup 2013-02-26 10:59:05 UTC

Description Len DiMaggio 2007-10-29 17:21:23 UTC 
Date of First Response: 2007-11-09 10:51:33
project_key: SOA

Seeing this at server startup:

13:10:37,284 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=JbpmDS' to JNDI name 'java:JbpmDS'
13:10:37,287 INFO  [STDOUT] ** CONFIGURING jBPM CONSOLE
13:10:37,353 INFO  [STDOUT] executing sql
13:10:37,500 ERROR [STDERR] java.sql.SQLException: Integrity constraint violation - no parent FK_ACTION_ACTNDEL table: JBPM_DELEGATION
13:10:37,501 ERROR [STDERR]     at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
13:10:37,501 ERROR [STDERR]     at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
13:10:37,501 ERROR [STDERR]     at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
13:10:37,501 ERROR [STDERR]     at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:84)
13:10:37,502 ERROR [STDERR]     at org.jboss.internal.soa.platform.deployment.support.jbpm.StartupJBPMConsoleData.runSQLFile(Unknown Source)
13:10:37,502 ERROR [STDERR]     at org.jboss.internal.soa.platform.deployment.support.jbpm.StartupJBPMConsoleData.runSetup(Unknown Source)
13:10:37,502 ERROR [STDERR]     at org.jboss.internal.soa.platform.deployment.support.jbpm.StartupJBPMConsoleData.startService(Unknown Source)
13:10:37,502 ERROR [STDERR]     at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
13:10:37,502 ERROR [STDERR]     at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
13:10:37,502 ERROR [STDERR]     at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
13:10:37,502 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13:10:37,502 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
13:10:37,502 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
13:10:37,502 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
13:10:37,503 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
13:10:37,503 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
13:10:37,503 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
13:10:37,503 ERROR [STDERR]     at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
13:10:37,503 ERROR [STDERR]     at $Proxy0.start(Unknown Source)
13:10:37,503 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:417)
13:10:37,503 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:435)
13:10:37,503 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:435)
13:10:37,503 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:435)
13:10:37,503 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:435)
13:10:37,504 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:435)
13:10:37,504 ERROR [STDERR]     at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
13:10:37,504 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13:10:37,504 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
13:10:37,504 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
13:10:37,504 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
13:10:37,504 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
13:10:37,504 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
13:10:37,504 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
13:10:37,504 ERROR [STDERR]     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
13:10:37,505 ERROR [STDERR]     at $Proxy4.start(Unknown Source)
13:10:37,505 ERROR [STDERR]     at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
13:10:37,505 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
13:10:37,505 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
13:10:37,505 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13:10:37,505 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
13:10:37,505 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
13:10:37,505 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
13:10:37,505 ERROR [STDERR]     at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
13:10:37,505 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
13:10:37,506 ERROR [STDERR]     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
13:10:37,506 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
13:10:37,506 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
13:10:37,508 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
13:10:37,508 ERROR [STDERR]     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
13:10:37,508 ERROR [STDERR]     at $Proxy30.start(Unknown Source)
13:10:37,508 ERROR [STDERR]     at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
13:10:37,508 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
13:10:37,508 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1015)
13:10:37,508 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
13:10:37,508 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
13:10:37,508 ERROR [STDERR]     at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
13:10:37,508 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13:10:37,509 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
13:10:37,509 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
13:10:37,509 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
13:10:37,509 ERROR [STDERR]     at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
13:10:37,509 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
13:10:37,509 ERROR [STDERR]     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
13:10:37,509 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
13:10:37,513 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
13:10:37,513 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
13:10:37,513 ERROR [STDERR]     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
13:10:37,513 ERROR [STDERR]     at $Proxy9.deploy(Unknown Source)
13:10:37,513 ERROR [STDERR]     at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
13:10:37,514 ERROR [STDERR]     at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
13:10:37,514 ERROR [STDERR]     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
13:10:37,514 ERROR [STDERR]     at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
13:10:37,514 ERROR [STDERR]     at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
13:10:37,514 ERROR [STDERR]     at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
13:10:37,514 ERROR [STDERR]     at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
13:10:37,514 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13:10:37,515 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
13:10:37,515 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
13:10:37,515 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
13:10:37,515 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
13:10:37,515 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
13:10:37,515 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
13:10:37,515 ERROR [STDERR]     at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
13:10:37,515 ERROR [STDERR]     at $Proxy0.start(Unknown Source)
13:10:37,516 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:417)
13:10:37,516 ERROR [STDERR]     at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
13:10:37,516 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13:10:37,516 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
13:10:37,516 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
13:10:37,516 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
13:10:37,516 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
13:10:37,516 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
13:10:37,516 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
13:10:37,516 ERROR [STDERR]     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
13:10:37,517 ERROR [STDERR]     at $Proxy4.start(Unknown Source)
13:10:37,517 ERROR [STDERR]     at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
13:10:37,517 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
13:10:37,517 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
13:10:37,517 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
13:10:37,517 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
13:10:37,517 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
13:10:37,517 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
13:10:37,517 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13:10:37,517 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
13:10:37,518 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
13:10:37,518 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
13:10:37,518 ERROR [STDERR]     at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
13:10:37,518 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
13:10:37,518 ERROR [STDERR]     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
13:10:37,518 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
13:10:37,518 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
13:10:37,518 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
13:10:37,518 ERROR [STDERR]     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
13:10:37,518 ERROR [STDERR]     at $Proxy5.deploy(Unknown Source)
13:10:37,519 ERROR [STDERR]     at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
13:10:37,519 ERROR [STDERR]     at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
13:10:37,519 ERROR [STDERR]     at org.jboss.Main.boot(Main.java:200)
13:10:37,519 ERROR [STDERR]     at org.jboss.Main$1.run(Main.java:508)
13:10:37,519 ERROR [STDERR]     at java.lang.Thread.run(Thread.java:595)
13:10:37,521 INFO  [SchemaDeployment]
Comment 1 Mark Little 2007-11-09 15:51:33 UTC 
TomB reckons this is a platform issue.
Comment 2 Mike Brock 2007-11-15 22:14:46 UTC 
This component has been removed (Deployer) -- It has been superseded upstream in ESB
Note You need to log in before you can comment on or make changes to this bug.