ODE
  1. ODE
  2. ODE-787

column "detailsext" is of type bytea but expression is of type oid

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Won't Fix
    • Affects Version/s: 1.3.5, 2.0-beta3
    • Fix Version/s: 1.3.6, 1.4
    • Component/s: BPEL Runtime
    • Labels:
    • Environment:
      Linux localhost.localdomain 2.6.32.9-70.fc12.x86_64 #1 SMP Wed Mar 3 04:40:41 UTC 2010 x86_64 x86_64 x86_64 GNU/Linux

      psql (PostgreSQL) 8.4.2


      Description

      13:48:03,400 ODEServerImpl-1 ERROR [SimpleScheduler] Database error.
      org.apache.ode.scheduler.simple.DatabaseException: org.postgresql.util.PSQLException: ERROR: column "detailsext" is of type bytea but expression is of type oid
      at org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:218)
      at org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:230)
      at org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:187)
      at org.apache.ode.bpel.engine.ODEProcess.scheduleJob(ODEProcess.java:811)
      at org.apache.ode.bpel.engine.ODEWSProcess.scheduleInvokeCheck(ODEWSProcess.java:706)
      at org.apache.ode.bpel.engine.ODEWSProcess.invokePartner(ODEWSProcess.java:641)
      at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.invoke(BpelRuntimeContextImpl.java:739)
      at org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.invoke(RuntimeInstanceImpl.java:654)
      at org.apache.ode.bpel.rtrep.v2.INVOKE.wsdlInvoke(INVOKE.java:108)
      at org.apache.ode.bpel.rtrep.v2.INVOKE.run(INVOKE.java:71)
      at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:450)
      at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
      at org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.execute(RuntimeInstanceImpl.java:716)
      at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:844)
      at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.executeCreateInstance(BpelRuntimeContextImpl.java:832)
      at org.apache.ode.bpel.engine.ODEProcess.executeCreateInstance(ODEProcess.java:235)
      at org.apache.ode.bpel.engine.ODEWSProcess$1.call(ODEWSProcess.java:410)
      at org.apache.ode.bpel.engine.ODEWSProcess$1.call(ODEWSProcess.java:408)
      at org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:800)
      at org.apache.ode.bpel.engine.BpelInstanceWorker.doInstanceWork(BpelInstanceWorker.java:171)
      at org.apache.ode.bpel.engine.BpelInstanceWorker.execInCurrentThread(BpelInstanceWorker.java:106)
      at org.apache.ode.bpel.engine.ODEProcess.doInstanceWork(ODEProcess.java:355)
      at org.apache.ode.bpel.engine.ODEWSProcess.invokeProcess(ODEWSProcess.java:408)
      at org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.doInvoke(MyRoleMessageExchangeImpl.java:129)
      at org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:46)
      at org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:44)
      at org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:800)
      at org.apache.ode.bpel.engine.Contexts.execTransaction(Contexts.java:110)
      at org.apache.ode.bpel.engine.BpelServerImpl$TransactedCallable.call(BpelServerImpl.java:1031)
      at org.apache.ode.bpel.engine.BpelServerImpl$ServerCallable.call(BpelServerImpl.java:1011)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: org.postgresql.util.PSQLException: ERROR: column "detailsext" is of type bytea but expression is of type oid
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
      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:102)
      at org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:216)
      ... 37 more

      1. ODE-787.patch
        0.7 kB
        Terry Mueller

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Tammo van Lessen
            Reporter:
            Terry Mueller
          • Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development