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(Sim
pleScheduler.java:378)
at
org.apache.ode.scheduler.simple.SimpleScheduler.scheduleMapSerializableR
unnable(SimpleScheduler.java:369)
at
org.apache.ode.bpel.engine.BpelServerImpl.deleteProcessDAO(BpelServerImp
l.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(SimpleSc
heduler.java:284)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleSc
heduler.java:239)
at
org.apache.ode.bpel.engine.BpelDatabase.exec(BpelDatabase.java:74)
at
org.apache.ode.bpel.engine.BpelServerImpl.deleteProcessDAO(BpelServerImp
l.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.onProcessStoreEv
ent(ODEServer.java:635)
at
org.apache.ode.store.ProcessStoreImpl.fireEvent(ProcessStoreImpl.java:57
4)
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$DeploymentMessageRecei
ver.invokeBusinessLogic(DeploymentWebService.java:222)
at
org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessa
geReceiver.java:96)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145)
at
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostReques
t(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(Applica
tionFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.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:2
98)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.j
ava:861)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.proce
ss(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(QueryExecu
torImpl.java:1592)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1327)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
192)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:451)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:350)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2S
tatement.java:304)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(De
legatingPreparedStatement.java:105)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(De
legatingPreparedStatement.java:105)
at
org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java
:229)
... 37 more
Thanks and Regards
Rupali Kabra
