Hi Rupali, I cannot see an attachment. But anyway, can you confirm that the type of the detailsext field is "oid"?
Thanks, Waruna On 26 July 2011 18:30, 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**** > -- ----------------------------------------------------- Regards, Waruna Ranasinghe blog: http://warunapw.blogspot.com twitter: http://twitter.com/warunapww http://lk.linkedin.com/in/waruna www.facebook.com/waruna.ranasinghe
