2 Replies Latest reply on Mar 5, 2010 11:52 AM by Jeff DeLong

    Exception when undeploying quickstarts

    Jeff DeLong Master

      My environment is Riftsaw 2.0 CR2 with HSQL on SOA-P 5 on JDK 1.6 on Mac. When I undeploy a quickstart process definition (e.g., simple_correlation) after having successfully executed a process, I see an exception in the console. The process does appear to be undeployed (it is no longer visible in the BPEL console). If I redeploy the process definition, then undeploy it, there is no exception.



      11:10:29,123 INFO  [BPELDeployer] Undeploy: Quickstart_bpel_simple_correlation-1.jar relativePath=bpel-deploy.xml
      11:10:29,125 INFO  [JAXWSBindingContext] Deactivate my role endpoint: {http://www.jboss.org/bpel/examples/wsdl}HelloGoodbyeService:HelloGoodbyePort
      11:10:29,127 INFO  [TomcatDeployment] undeploy, ctxPath=/Quickstart_bpel_simple_correlationWS
      11:10:29,135 INFO  [DefaultEndpointRegistry] remove: jboss.ws:context=Quickstart_bpel_simple_correlationWS,endpoint=Endpoint-8293927c-3b36-4f68-ad54-b01a4e5455d3
      11:10:29,141 INFO  [UDDIClerk] UnRegistering binding for service HelloGoodbyeService
      11:10:29,146 INFO  [BpelServerImpl] Unregistered process {http://www.jboss.org/bpel/examples}HelloGoodbye-1.
      11:10:29,150 INFO  [BpelServerImpl] Deleted only the process {http://www.jboss.org/bpel/examples}HelloGoodbye-1.
      11:10:29,151 INFO  [CronScheduler] Cancelling PROCESS CRON jobs for: {http://www.jboss.org/bpel/examples}HelloGoodbye-1
      11:10:29,151 INFO  [ProcessStoreImpl] Process {http://www.jboss.org/bpel/examples}HelloGoodbye-1 has been undeployed.
      11:10:29,222 WARN  [JDBCExceptionReporter] SQL Error: 50000, SQLState: HY000
      11:10:29,222 ERROR [JDBCExceptionReporter] General error: java.lang.NullPointerException [50000-68]
      11:10:29,225 ERROR [BpelServerImpl]
      org.hibernate.exception.GenericJDBCException: could not execute update query
          at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
          at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:110)
          at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:421)
          at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283)
          at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1169)
          at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117)
          at org.apache.ode.daohib.bpel.HibernateDao.deleteByIds(HibernateDao.java:106)
          at org.apache.ode.daohib.bpel.ProcessDaoImpl.deleteMessages(ProcessDaoImpl.java:243)
          at org.apache.ode.daohib.bpel.ProcessDaoImpl.deleteInstances(ProcessDaoImpl.java:178)
          at org.apache.ode.bpel.engine.ProcessCleanUpRunnable$1.call(ProcessCleanUpRunnable.java:56)
          at org.apache.ode.bpel.engine.ProcessCleanUpRunnable$1.call(ProcessCleanUpRunnable.java:51)
          at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:218)
          at org.apache.ode.bpel.engine.ProcessCleanUpRunnable.run(ProcessCleanUpRunnable.java:50)
          at org.apache.ode.bpel.engine.BpelServerImpl$PolledRunnableProcessor$1.run(BpelServerImpl.java:632)
          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
          at java.util.concurrent.FutureTask.run(FutureTask.java:138)
          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
          at java.lang.Thread.run(Thread.java:637)
      Caused by: org.h2.jdbc.JdbcSQLException: General error: java.lang.NullPointerException [50000-68]
          at org.h2.message.Message.getSQLException(Message.java:91)
          at org.h2.message.Message.convert(Message.java:176)
          at org.h2.message.TraceObject.logAndConvert(TraceObject.java:201)
          at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:123)
          at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96)
          at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
          at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:101)
          ... 18 more
      Caused by: java.lang.NullPointerException
          at org.h2.table.TableFilter.next(TableFilter.java:200)
          at org.h2.command.dml.Delete.update(Delete.java:54)
          at org.h2.command.CommandContainer.update(CommandContainer.java:69)
          at org.h2.command.Command.executeUpdate(Command.java:197)
          at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:132)
          at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:121)
          ... 21 more
      11:10:59,337 INFO  [BPELDeployer] Deploy: Quickstart_bpel_simple_correlation-1.jar relativePath=bpel-deploy.xml
      11:10:59,340 INFO  [ProcessStoreImpl] Starting deployment of processes from directory "/Users/jdelong/SOAWorkshop/software/jboss-soa-p.5.0.0/jboss-as/server/default/tmp/5c4o02-al1vmv-g6dutmkv-1-g6dvhe2x-fz/Quickstart_bpel_simple_correlation-1.jar".
      11:10:59,344 INFO  [BpelC] info: [CompilingProcess] Compiling BPEL process.
      11:10:59,367 INFO  [ProcessStoreImpl] Process {http://www.jboss.org/bpel/examples}HelloGoodbye-1 deployed from "{http://www.jboss.org/bpel/examples}HelloGoodbye-1".
      11:10:59,373 INFO  [CronScheduler] Cancelling PROCESS CRON jobs for: {http://www.jboss.org/bpel/examples}HelloGoodbye-1
      11:10:59,373 INFO  [CronScheduler] Scheduling PROCESS CRON jobs for: {http://www.jboss.org/bpel/examples}HelloGoodbye-1
      11:10:59,377 INFO  [JAXWSBindingContext] Activate my role endpoint: {http://www.jboss.org/bpel/examples/wsdl}HelloGoodbyeService:HelloGoodbyePort
      11:10:59,378 INFO  [STDOUT] Retrieving document at 'file:/Users/jdelong/SOAWorkshop/software/jboss-soa-p.5.0.0/jboss-as/server/default/tmp/5c4o02-al1vmv-g6dutmkv-1-g6dvhe2x-fz/Quickstart_bpel_simple_correlation-1.jar/HelloGoodbye.wsdl'.
      11:10:59,414 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=Quickstart_bpel_simple_correlationWS,endpoint=Endpoint-d8017050-67b1-4546-acc2-5c6ea5091d41
      11:10:59,431 INFO  [TomcatDeployment] deploy, ctxPath=/Quickstart_bpel_simple_correlationWS
      11:10:59,466 WARNING [config] Unable to process deployment descriptor for context '/Quickstart_bpel_simple_correlationWS'
      11:10:59,466 INFO  [config] Initializing Mojarra (1.2_13-b01-FCS) for context '/Quickstart_bpel_simple_correlationWS'
      11:10:59,562 WARN  [WSDL11Reader] UsingAddressing extensibility element not supported yet.
      11:10:59,562 WARN  [WSDL11Reader] UsingAddressing extensibility element not supported yet.
      11:10:59,562 WARN  [WSDL11Reader] UsingAddressing extensibility element not supported yet.
      11:10:59,562 WARN  [WSDL11Reader] UsingAddressing extensibility element not supported yet.
      11:10:59,566 INFO  [WSDLFilePublisher] WSDL published to: file:/Users/jdelong/SOAWorkshop/software/jboss-soa-p.5.0.0/jboss-as/server/default/data/wsdl/riftsaw-d8017050-67b1-4546-acc2-5c6ea5091d41.war/HelloGoodbye.wsdl
      11:10:59,570 INFO  [UDDIClerk] Registering service HelloGoodbyeService with key uddi:esb.jboss.org:bpel-services-HelloGoodbyeService
      11:10:59,576 INFO  [UDDIClerk] Registering service HelloGoodbyeService completed.
      11:10:59,605 INFO  [BpelProcess] Created new process DAO for {http://www.jboss.org/bpel/examples}HelloGoodbye-1 (guid=hqejbhcnphr53bn691gq7u)
      11:10:59,606 INFO  [BpelProcess] Created new process DAO for {http://www.jboss.org/bpel/examples}HelloGoodbye-1 (guid=hqejbhcnphr53bn691gq7u).
      11:10:59,606 INFO  [BpelServerImpl] Registered process {http://www.jboss.org/bpel/examples}HelloGoodbye-1.
      11:10:59,606 INFO  [CronScheduler] Cancelling PROCESS CRON jobs for: {http://www.jboss.org/bpel/examples}HelloGoodbye-1
      11:10:59,607 INFO  [CronScheduler] Scheduling PROCESS CRON jobs for: {http://www.jboss.org/bpel/examples}HelloGoodbye-1
      11:11:14,429 INFO  [BPELDeployer] Undeploy: Quickstart_bpel_simple_correlation-1.jar relativePath=bpel-deploy.xml
      11:11:14,432 INFO  [JAXWSBindingContext] Deactivate my role endpoint: {http://www.jboss.org/bpel/examples/wsdl}HelloGoodbyeService:HelloGoodbyePort
      11:11:14,434 INFO  [TomcatDeployment] undeploy, ctxPath=/Quickstart_bpel_simple_correlationWS
      11:11:14,441 INFO  [DefaultEndpointRegistry] remove: jboss.ws:context=Quickstart_bpel_simple_correlationWS,endpoint=Endpoint-d8017050-67b1-4546-acc2-5c6ea5091d41
      11:11:14,448 INFO  [UDDIClerk] UnRegistering binding for service HelloGoodbyeService
      11:11:14,450 INFO  [BpelServerImpl] Unregistered process {http://www.jboss.org/bpel/examples}HelloGoodbye-1.
      11:11:14,454 INFO  [BpelServerImpl] Deleted only the process {http://www.jboss.org/bpel/examples}HelloGoodbye-1.
      11:11:14,455 INFO  [CronScheduler] Cancelling PROCESS CRON jobs for: {http://www.jboss.org/bpel/examples}HelloGoodbye-1
      11:11:14,455 INFO  [ProcessStoreImpl] Process {http://www.jboss.org/bpel/examples}HelloGoodbye-1 has been undeployed.
      11:11:14,460 INFO  [ProcessCleanUpRunnable] Deleted runtime data for old process: 7.