Bug 777563 (SOA-67)

Summary:	Integrity constraint violation - no parent FK_ACTION_ACTNDEL table: JBPM_DELEGATION - at (emmbedded) server startup
Product:	[JBoss] JBoss Enterprise SOA Platform 4	Reporter:	Len DiMaggio <ldimaggi>
Component:	JBPM - within SOA	Assignee:	Mike Brock <cbrock>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	4.2 IR3	CC:	mail, rruss
Target Milestone:	---
Target Release:	4.2 CR3
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-67
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
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
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

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