Hi I've been trying to install Apache ODE and then to deploy a minimal BPEL process, but I've always got the same error and it looks that the BPEL process was never deployed. I tried with Apache Tomcat and with Jetty, and i got the same errors. I have searched for the exception message everywhere and haven't found anything about it.
I'm doing it in a server with Red Hat Enterprise Linux AS release 3 (Taroon). I downloaded apache-ode-war-1.1.zip and then Apache Tomcat 5.5.25. JVM is jre1.5.0_13 I uncompressed Apache Tomcat, then copied ode.war to webapps, and ran Tomcat. Everything perfect But when I copy any bpel process to webapps/ode/WEB-INF/processes, the exception (at bottom) occurs. I supposed that it was a problem with Tomcat so I tried with Jetty 6.1.5 and I got the same exception. I supposed that the BPEL process was wrong... so I created a new one ... and I got the same exception. I found a webpage with instructions step by step (http://www.infoq.com/articles/paul-brown-ode), I followed them ...... the same exception occurs. I restarted Tomcat, because the exception says "counter may be reappear after restart" (counter is the name of the BPEL process). And everything looks ok... but when I execute something like: curl http://localhost:8080/ode/processes/counter/init?name=foo the response is: <soapenv:Reason xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope"><soapenv:Text xml:lang="en-US">The service cannot be found for the endpoint reference (EPR) /ode/processes/counter/init?name=foo</soapenv:Text></soapenv:Reason> and at that moment.. in the tomcat log: DEBUG - GeronimoLog.debug(66) | Checking for Service using target endpoint address : /ode/processes/counter/init?name=foo 15:32:03,463 DEBUG [ODEAxisDispatcher] Checking for Service using target endpoint address : /ode/processes/counter/init?name=foo DEBUG - GeronimoLog.debug(66) | Found service in registry from name counter/init: null 15:32:03,470 DEBUG [ODEAxisDispatcher] Found service in registry from name counter/init: null It is the only Tomcat running in that server. There's only one other little application in the same server: Oracle Application Server 10g, but there's no port conflict. Any help? Did I skip an important step? (another secondary problem is that I can't shutdown Tomcat unless I kill it) Thank you in advance Iván Rivera The exception that appears when I deploy the bpel process is: (counter is the name of the bpel process) --------------------------------------------------------------------------------------------------- ERROR - GeronimoLog.error(104) | Error synchronizing with data store; counter may be reappear after restart! 15:06:09,510 ERROR [ProcessStoreImpl] Error synchronizing with data store; counter may be reappear after restart! ERROR - GeronimoLog.error(108) | Deployment of counter failed, aborting for now. org.apache.ode.bpel.iapi.ContextException: DbError at org.apache.ode.store.ProcessStoreImpl.exec(ProcessStoreImpl.java:545) at org.apache.ode.store.ProcessStoreImpl.deploy(ProcessStoreImpl.java:237) at org.apache.ode.axis2.deploy.DeploymentPoller.check(DeploymentPoller.java:144) at org.apache.ode.axis2.deploy.DeploymentPoller.access$300(DeploymentPoller.java:55) at org.apache.ode.axis2.deploy.DeploymentPoller$PollingThread.run(DeploymentPoller.java:188) Caused by: java.util.concurrent.ExecutionException: <0.9.7-incubating nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Syntax error: Encountered ")" at line 1, column 161. {SELECT t0.DEPLOYDT, t0.DEPLOYER, t0.DIR, t1.DU, t1.PID, t1.STATE, t1.TYPE, t1.VERSION FROM STORE_DU t0, STORE_PROCESS t1 WHERE t0.NAME = ? AND t0.NAME = t1.DU(+) ORDER BY t1.DU ASC} [code=30000, state=42X01] at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at org.apache.ode.store.ProcessStoreImpl.exec(ProcessStoreImpl.java:543) ... 4 more Caused by: <0.9.7-incubating nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Syntax error: Encountered ")" at line 1, column 161. {SELECT t0.DEPLOYDT, t0.DEPLOYER, t0.DIR, t1.DU, t1.PID, t1.STATE, t1.TYPE, t1.VERSION FROM STORE_DU t0, STORE_PROCESS t1 WHERE t0.NAME = ? AND t0.NAME = t1.DU(+) ORDER BY t1.DU ASC} [code=30000, state=42X01] at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3784) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:260) at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:111) at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57) at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:876) at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:834) at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:751) at org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:172) at org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:349) at org.apache.ode.store.jpa.ConfStoreConnectionJpa.getDeploymentUnit(ConfStoreConnectionJpa.java:64) at org.apache.ode.store.ProcessStoreImpl$2.call(ProcessStoreImpl.java:240) at org.apache.ode.store.ProcessStoreImpl$2.call(ProcessStoreImpl.java:238) at org.apache.ode.store.ProcessStoreImpl$Callable.call(ProcessStoreImpl.java:702) 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: org.apache.openjpa.lib.jdbc.ReportingSQLException: Syntax error: Encountered ")" at line 1, column 161. {SELECT t0.DEPLOYDT, t0.DEPLOYER, t0.DIR, t1.DU, t1.PID, t1.STATE, t1.TYPE, t1.VERSION FROM STORE_DU t0, STORE_PROCESS t1 WHERE t0.NAME = ? AND t0.NAME = t1.DU(+) ORDER BY t1.DU ASC} [code=30000, state=42X01] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:200) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:56) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:227) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:163) at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:163) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1308) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:152) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:474) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:454) at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:344) at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:308) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getInitializeStateResult(JDBCStoreManager.java:376) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:299) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:255) ... 16 more 15:06:11,048 ERROR [DeploymentPoller] Deployment of counter failed, aborting for now. org.apache.ode.bpel.iapi.ContextException: DbError at org.apache.ode.store.ProcessStoreImpl.exec(ProcessStoreImpl.java:545) at org.apache.ode.store.ProcessStoreImpl.deploy(ProcessStoreImpl.java:237) at org.apache.ode.axis2.deploy.DeploymentPoller.check(DeploymentPoller.java:144) at org.apache.ode.axis2.deploy.DeploymentPoller.access$300(DeploymentPoller.java:55) at org.apache.ode.axis2.deploy.DeploymentPoller$PollingThread.run(DeploymentPoller.java:188) Caused by: java.util.concurrent.ExecutionException: <0.9.7-incubating nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Syntax error: Encountered ")" at line 1, column 161. {SELECT t0.DEPLOYDT, t0.DEPLOYER, t0.DIR, t1.DU, t1.PID, t1.STATE, t1.TYPE, t1.VERSION FROM STORE_DU t0, STORE_PROCESS t1 WHERE t0.NAME = ? AND t0.NAME = t1.DU(+) ORDER BY t1.DU ASC} [code=30000, state=42X01] at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at org.apache.ode.store.ProcessStoreImpl.exec(ProcessStoreImpl.java:543) ... 4 more Caused by: <0.9.7-incubating nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Syntax error: Encountered ")" at line 1, column 161. {SELECT t0.DEPLOYDT, t0.DEPLOYER, t0.DIR, t1.DU, t1.PID, t1.STATE, t1.TYPE, t1.VERSION FROM STORE_DU t0, STORE_PROCESS t1 WHERE t0.NAME = ? AND t0.NAME = t1.DU(+) ORDER BY t1.DU ASC} [code=30000, state=42X01] at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3784) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:260) at org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:111) at org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57) at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:876) at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:834) at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:751) at org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:172) at org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:349) at org.apache.ode.store.jpa.ConfStoreConnectionJpa.getDeploymentUnit(ConfStoreConnectionJpa.java:64) at org.apache.ode.store.ProcessStoreImpl$2.call(ProcessStoreImpl.java:240) at org.apache.ode.store.ProcessStoreImpl$2.call(ProcessStoreImpl.java:238) at org.apache.ode.store.ProcessStoreImpl$Callable.call(ProcessStoreImpl.java:702) 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: org.apache.openjpa.lib.jdbc.ReportingSQLException: Syntax error: Encountered ")" at line 1, column 161. {SELECT t0.DEPLOYDT, t0.DEPLOYER, t0.DIR, t1.DU, t1.PID, t1.STATE, t1.TYPE, t1.VERSION FROM STORE_DU t0, STORE_PROCESS t1 WHERE t0.NAME = ? AND t0.NAME = t1.DU(+) ORDER BY t1.DU ASC} [code=30000, state=42X01] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:200) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:56) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:227) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:163) at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:163) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1308) at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:152) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:474) at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:454) at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:344) at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:308) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getInitializeStateResult(JDBCStoreManager.java:376) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:299) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:255) ... 16 more --------------------------------------------------------------------------------------------------- -- View this message in context: http://www.nabble.com/Deployment-of-%3Cbpelprocess%3E-failed%2C-aborting-for-now..-DbError-tp14339737p14339737.html Sent from the Apache Ode User mailing list archive at Nabble.com.
