ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tammo van Lessen <tvanles...@gmail.com>
Subject Re: Getting exception while undeploying a process.. need help
Date Fri, 09 Sep 2011 14:43:44 GMT
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 <rupali.kabra@altair.com> 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

Mime
View raw message