Bug 777535 (SOA-35) - java.sql.SQLException reported in server log the first time the jBPM console is started
Summary: java.sql.SQLException reported in server log the first time the jBPM console ...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-35
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Build Process
Version: 4.2 IR2
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
: 4.2 IR3
Assignee: Mike Brock
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA-35
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2007-10-02 14:41 UTC by Len DiMaggio
Modified: 2013-06-17 05:10 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
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

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-35 0 None None None Never

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
Note You need to log in before you can comment on or make changes to this bug.