Hi, please try the following schema for this table:
CREATE TABLE ode_job ( jobid CHAR(64) NOT NULL DEFAULT '', ts int8 NOT NULL DEFAULT 0, nodeid char(64), scheduled int4 NOT NULL DEFAULT 0, transacted int4 NOT NULL DEFAULT 0, details bytea, PRIMARY KEY(jobid)); HTH, Tammo On Thu, Aug 18, 2011 at 13:06, Rupali Kabra <[email protected]> wrote: > > > Hello Friends, > > > > I am successfully able to deploy a process but when I am trying to > undeploy a process I am getting the following exception > > > > NOTE:- I am using ODE 1.3.5 and attached is the sql file, if anybody has a > solution then please let me know… Thanks in Advance > > > > org.apache.ode.scheduler.simple.DatabaseException: > org.postgresql.util.PSQLException: ERROR: column "detailsext" is of type oid > but expression is of type bytea > > at > org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:231) > > at > org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:378) > > at > org.apache.ode.scheduler.simple.SimpleScheduler.scheduleMapSerializableRunnable(SimpleScheduler.java:369) > > at > org.apache.ode.bpel.engine.BpelServerImpl.deleteProcessDAO(BpelServerImpl.java:438) > > at > org.apache.ode.bpel.engine.BpelServerImpl.access$200(BpelServerImpl.java:84) > > at > org.apache.ode.bpel.engine.BpelServerImpl$2.run(BpelServerImpl.java:416) > > at > org.apache.ode.bpel.engine.BpelServerImpl$2.run(BpelServerImpl.java:414) > > at > org.apache.ode.bpel.engine.BpelDatabase$1.call(BpelDatabase.java:76) > > 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.bpel.engine.BpelDatabase.exec(BpelDatabase.java:74) > > at > org.apache.ode.bpel.engine.BpelServerImpl.deleteProcessDAO(BpelServerImpl.java:414) > > at > org.apache.ode.bpel.engine.BpelServerImpl.cleanupProcess(BpelServerImpl.java:679) > > at org.apache.ode.axis2.ODEServer.handleEvent(ODEServer.java:690) > > at org.apache.ode.axis2.ODEServer.access$100(ODEServer.java:88) > > at > org.apache.ode.axis2.ODEServer$ProcessStoreListenerImpl.onProcessStoreEvent(ODEServer.java:635) > > at > org.apache.ode.store.ProcessStoreImpl.fireEvent(ProcessStoreImpl.java:574) > > at > org.apache.ode.store.ProcessStoreImpl.undeploy(ProcessStoreImpl.java:382) > > at > org.apache.ode.store.ProcessStoreImpl.undeploy(ProcessStoreImpl.java:355) > > at > org.apache.ode.axis2.service.DeploymentWebService$DeploymentMessageReceiver.invokeBusinessLogic(DeploymentWebService.java:222) > > at > org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:96) > > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145) > > at > org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275) > > at > org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:120) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > > at > org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861) > > at > org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) > > at > org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584) > > at java.lang.Thread.run(Thread.java:619) > > Caused by: org.postgresql.util.PSQLException: ERROR: column "detailsext" is > of type oid but expression is of type bytea > > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) > > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) > > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304) > > at > org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) > > at > org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) > > at > org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:229) > > ... 37 more > > > > Thanks and Regards > > Rupali Kabra -- Tammo van Lessen - http://www.taval.de
