It happened again... exactly the same exception. I'm guessing that Oracle Application Server may be conflicting with Derby... maybe there's is an embedded hidden database there ... and since ODE detected it, may be it's using it. I'm going to shutdown every application in the server (later in the night) and try the whole installation again. I'll post the result if it works ... and if it doesn't work too. Thank you. Iván Rivera
Matthieu Riou-5 wrote: > > On Dec 17, 2007 4:20 AM, irrivera <[EMAIL PROTECTED]> wrote: > >> >> I'm using the default configuration... so it's the embedded Derby >> database. >> ODE is version 1.1, md5sum 8a7867eb6cc7bc093d753fe1e9b93750 >> Iván Rivera >> > > Could you please try with the coming 1.1.1 version? I've posted a RC1 > here: > > http://people.apache.org/~mriou/ode-1.1.1RC1/org/apache/ode/apache-ode-war/1.1.1RC1/ > > I have no real explanation for your problem but in this version we've > upgraded OpenJPA so I'm hoping it will fix your problem. It's the first > time > I see it so there must be something atypical about your environment, I > just > have no clue what can cause it. > > Matthieu > > >> >> >> Matthieu Riou-5 wrote: >> > >> > Hi Iván, >> > >> > The generated query looks fairly weird: >> > >> > 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<http://t0.name/>= ? AND >> > t0.NAME <http://t0.name/> = t1.DU(+) ORDER BY t1.DU ASC >> > >> > My guess is that the DU(+) is what bothers the database. Which database >> > are >> > you using, is it the plain embedded Derby one? Also which version of >> ODE >> > do >> > you use? >> > >> > Thanks, >> > Matthieu >> > >> > On Dec 14, 2007 10:47 AM, irrivera <[EMAIL PROTECTED]> wrote: >> > >> >> >> >> 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.5and >> >> 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. >> >> >> >> >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/Deployment-of-%3Cbpelprocess%3E-failed%2C-aborting-for-now..-DbError-tp14339737p14370261.html >> Sent from the Apache Ode User mailing list archive at Nabble.com. >> >> > > -- View this message in context: http://www.nabble.com/Deployment-of-%3Cbpelprocess%3E-failed%2C-aborting-for-now..-DbError-tp14339737p14405575.html Sent from the Apache Ode User mailing list archive at Nabble.com.
