Hi, what database schema did you use? Did you follow the instructions at http://ode.apache.org/ode-schema.html ?
Thanks, Tammo On Thu, May 5, 2011 at 09:44, Rafal <[email protected]> wrote: > I set up ode 1.3.5 under hibernate with SQL Server 2008. > > My ode-axis2.properties: > ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl > ode-axis2.db.mode=INTERNAL > ode-axis2.db.int.mcf=org.tranql.connector.sqlserver.XAMCF > ode-axis2.db.int.mcf.databaseName=ODE > ode-axis2.db.int.mcf.userName=test > ode-axis2.db.int.mcf.password=***** > ode-axis2.db.int.mcf.portNumber=1444 > ode-axis2.db.int.mcf.serverName=10.0.101.44 > > Everything works fine, but always when I undeploy (e.g. copy and > delete HelloWorld2) any process I get errors bellow. It works fine > with default derby database. Any ideas? > > 09:07:41,908 ERROR [BpelEngineImpl] Scheduled job failed; > jobDetail=JobDetails( instanceId: null mexId: null processId: null > type: null channel: null correlatorId: null correlationKeySet: null > retryCount: null inMem: null detailsExt: > {runnable=org.apache.ode.bpel.engine.ProcessCleanUpRunnable@b2bde5, > pid=1}) > java.lang.IllegalArgumentException: id to load is required for loading > at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:51) > at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:33) > at org.hibernate.impl.SessionImpl.get(SessionImpl.java:812) > at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) > at > org.apache.ode.daohib.bpel.BpelDAOConnectionImpl._getInstance(BpelDAOConnectionImpl.java:201) > at > org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getInstance(BpelDAOConnectionImpl.java:145) > at > org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:416) > at > org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:450) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:518) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:513) > at > org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:284) > at > org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:239) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:512) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:496) > at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) > at java.util.concurrent.FutureTask.run(Unknown Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown > Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) > at java.lang.Thread.run(Unknown Source) > 09:07:41,910 ERROR [SimpleScheduler] Error while processing a > persisted job: Job hqejbhcnphr6945qcvl95v time: 2011-05-05 09:07:38 > CEST transacted: true persisted: true details: JobDetails( instanceId: > null mexId: null processId: null type: null channel: null > correlatorId: null correlationKeySet: null retryCount: null inMem: > null detailsExt: > {runnable=org.apache.ode.bpel.engine.ProcessCleanUpRunnable@b2bde5, > pid=1}) > org.apache.ode.bpel.iapi.Scheduler$JobProcessorException: > java.lang.IllegalArgumentException: id to load is required for loading > at > org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:478) > at > org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:450) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:518) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob$1.call(SimpleScheduler.java:513) > at > org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:284) > at > org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:239) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:512) > at > org.apache.ode.scheduler.simple.SimpleScheduler$RunJob.call(SimpleScheduler.java:496) > at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) > at java.util.concurrent.FutureTask.run(Unknown Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown > Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) > at java.lang.Thread.run(Unknown Source) > Caused by: java.lang.IllegalArgumentException: id to load is required > for loading > at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:51) > at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:33) > at org.hibernate.impl.SessionImpl.get(SessionImpl.java:812) > at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) > at > org.apache.ode.daohib.bpel.BpelDAOConnectionImpl._getInstance(BpelDAOConnectionImpl.java:201) > at > org.apache.ode.daohib.bpel.BpelDAOConnectionImpl.getInstance(BpelDAOConnectionImpl.java:145) > at > org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:416) > ... 12 more > 09:07:41,944 ERROR [SimpleScheduler] Error while processing job, retrying in > 5s > 09:07:51,507 ERROR [SimpleScheduler] Error loading immediate jobs from > database. > java.lang.ClassCastException: java.lang.Long cannot be cast to > java.lang.String > at > org.apache.ode.scheduler.simple.JdbcDelegate.dequeueImmediate(JdbcDelegate.java:321) > at > org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:699) > at > org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:698) > at > org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:284) > at > org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:239) > at > org.apache.ode.scheduler.simple.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:697) > at > org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:842) > at > org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:658) > at > org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:656) > at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) > at java.util.concurrent.FutureTask.run(Unknown Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown > Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) > at java.lang.Thread.run(Unknown Source) > -- Tammo van Lessen - http://www.taval.de
