You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ode.apache.org by Rupali Kabra <ru...@altair.com> on 2011/07/26 08:30:43 UTC
Getting exception while undeploying a process.. need help
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
Re: Getting exception while undeploying a process.. need help
Posted by Waruna Ranasinghe <wa...@gmail.com>.
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 <ru...@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****
>
--
-----------------------------------------------------
Regards,
Waruna Ranasinghe
blog: http://warunapw.blogspot.com
twitter: http://twitter.com/warunapww
http://lk.linkedin.com/in/waruna
www.facebook.com/waruna.ranasinghe