Bug 777535 (SOA-35)

Summary:	java.sql.SQLException reported in server log the first time the jBPM console is started
Product:	[JBoss] JBoss Enterprise SOA Platform 4	Reporter:	Len DiMaggio <ldimaggi>
Component:	Build Process	Assignee:	Mike Brock <cbrock>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	medium	Docs Contact:
Priority:	medium
Version:	4.2 IR2	CC:	rruss
Target Milestone:	---
Target Release:	4.2 IR3
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-35
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:	soa-standalone.zip (oct 1 2007) RHEL5 java version "1.5.0_12" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04) Java HotSpot(TM) Server VM (build 1.5.0_12-b04, mixed mode)
Last Closed:	2007-11-02 13:40:51 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-02 14:41:00 UTC

Date of First Response: 2007-10-09 09:57:18
project_key: SOA

Seeing this error - ESB standalone server - when the jBPM console is started - for the first time only - with the Oct 1. SOA-P build. The console, however, does start up...

10:29:03,083 INFO  [STDOUT] ** CONFIGURING jBPM CONSOLE
10:29:03,143 INFO  [STDOUT] executing sql
10:29:03,286 ERROR [STDERR] java.sql.SQLException: Integrity constraint violation - no parent FK_ACTION_ACTNDEL table: JBPM_DELEGATION
10:29:03,287 ERROR [STDERR]     at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
10:29:03,287 ERROR [STDERR]     at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
10:29:03,287 ERROR [STDERR]     at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
10:29:03,287 ERROR [STDERR]     at org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatement.java:84)
10:29:03,287 ERROR [STDERR]     at org.jboss.internal.soa.platform.deployment.support.jbpm.StartupJBPMConsoleData.runSQLFile(Unknown Source)
10:29:03,287 ERROR [STDERR]     at org.jboss.internal.soa.platform.deployment.support.jbpm.StartupJBPMConsoleData.runSetup(Unknown Source)
10:29:03,287 ERROR [STDERR]     at org.jboss.internal.soa.platform.deployment.support.jbpm.StartupJBPMConsoleData.startService(Unknown Source)
10:29:03,288 ERROR [STDERR]     at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
10:29:03,288 ERROR [STDERR]     at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
10:29:03,288 ERROR [STDERR]     at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
10:29:03,288 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
10:29:03,288 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
10:29:03,288 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
10:29:03,288 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
10:29:03,288 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
10:29:03,288 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
10:29:03,288 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
10:29:03,289 ERROR [STDERR]     at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
10:29:03,289 ERROR [STDERR]     at $Proxy0.start(Unknown Source)
10:29:03,289 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:417)
10:29:03,289 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:435)
10:29:03,289 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:435)
10:29:03,289 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:435)
10:29:03,289 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:435)
10:29:03,289 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:435)
10:29:03,289 ERROR [STDERR]     at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
10:29:03,289 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
10:29:03,290 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
10:29:03,290 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
10:29:03,290 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
10:29:03,290 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
10:29:03,290 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
10:29:03,290 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
10:29:03,290 ERROR [STDERR]     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
10:29:03,290 ERROR [STDERR]     at $Proxy4.start(Unknown Source)
10:29:03,290 ERROR [STDERR]     at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
10:29:03,291 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
10:29:03,291 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
10:29:03,291 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
10:29:03,291 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
10:29:03,291 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
10:29:03,291 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
10:29:03,291 ERROR [STDERR]     at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
10:29:03,291 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
10:29:03,291 ERROR [STDERR]     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
10:29:03,291 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
10:29:03,292 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
10:29:03,292 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
10:29:03,292 ERROR [STDERR]     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
10:29:03,292 ERROR [STDERR]     at $Proxy30.start(Unknown Source)
10:29:03,292 ERROR [STDERR]     at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
10:29:03,292 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
10:29:03,292 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1015)
10:29:03,292 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
10:29:03,292 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
10:29:03,293 ERROR [STDERR]     at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
10:29:03,293 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
10:29:03,293 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
10:29:03,293 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
10:29:03,293 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
10:29:03,293 ERROR [STDERR]     at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
10:29:03,293 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
10:29:03,293 ERROR [STDERR]     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
10:29:03,293 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
10:29:03,293 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
10:29:03,294 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
10:29:03,294 ERROR [STDERR]     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
10:29:03,294 ERROR [STDERR]     at $Proxy9.deploy(Unknown Source)
10:29:03,294 ERROR [STDERR]     at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
10:29:03,294 ERROR [STDERR]     at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
10:29:03,294 ERROR [STDERR]     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
10:29:03,294 ERROR [STDERR]     at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
10:29:03,294 ERROR [STDERR]     at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
10:29:03,294 ERROR [STDERR]     at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
10:29:03,294 ERROR [STDERR]     at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
10:29:03,295 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
10:29:03,295 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
10:29:03,295 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
10:29:03,295 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
10:29:03,300 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
10:29:03,300 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
10:29:03,300 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
10:29:03,300 ERROR [STDERR]     at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
10:29:03,300 ERROR [STDERR]     at $Proxy0.start(Unknown Source)
10:29:03,300 ERROR [STDERR]     at org.jboss.system.ServiceController.start(ServiceController.java:417)
10:29:03,300 ERROR [STDERR]     at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
10:29:03,300 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
10:29:03,300 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
10:29:03,301 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
10:29:03,301 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
10:29:03,301 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
10:29:03,301 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
10:29:03,301 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
10:29:03,301 ERROR [STDERR]     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
10:29:03,301 ERROR [STDERR]     at $Proxy4.start(Unknown Source)
10:29:03,301 ERROR [STDERR]     at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
10:29:03,301 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
10:29:03,301 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
10:29:03,302 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
10:29:03,302 ERROR [STDERR]     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
10:29:03,302 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
10:29:03,302 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
10:29:03,302 ERROR [STDERR]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
10:29:03,302 ERROR [STDERR]     at java.lang.reflect.Method.invoke(Method.java:585)
10:29:03,302 ERROR [STDERR]     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
10:29:03,302 ERROR [STDERR]     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
10:29:03,302 ERROR [STDERR]     at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
10:29:03,303 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
10:29:03,303 ERROR [STDERR]     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
10:29:03,303 ERROR [STDERR]     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
10:29:03,303 ERROR [STDERR]     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
10:29:03,303 ERROR [STDERR]     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
10:29:03,303 ERROR [STDERR]     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
10:29:03,303 ERROR [STDERR]     at $Proxy5.deploy(Unknown Source)
10:29:03,303 ERROR [STDERR]     at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
10:29:03,304 ERROR [STDERR]     at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
10:29:03,304 ERROR [STDERR]     at org.jboss.Main.boot(Main.java:200)
10:29:03,304 ERROR [STDERR]     at org.jboss.Main$1.run(Main.java:508)
10:29:03,304 ERROR [STDERR]     at java.lang.Thread.run(Thread.java:595)

Comment 1 Mike Brock 2007-10-09 13:57:18 UTC

Re-assigning this to myself.

Comment 2 Mike Brock 2007-10-16 15:34:47 UTC

this is being ported up to ESB directly.  if this issue is persistant after that, re-open a case in ESB