3 Replies Latest reply on Feb 13, 2008 6:33 PM by Meghana Joglekar

    BPEL error: varbinary is incompatible with text

    Meghana Joglekar Novice

      Hello,

      When I run my BPEL process, I get this error -

      13:26:03,481 ERROR [StartListener] request delivery failed due to non-recoverable exception, giving up
      org.jbpm.JbpmException: problem closing services {persistence=org.hibernate.exception.DataException: could not insert co
      llection: [org.jbpm.bpel.variable.exe.MessageValue.parts#76]}
       at org.jbpm.svc.Services.close(Services.java:245)
       at org.jbpm.JbpmContext.close(JbpmContext.java:139)
       at org.jbpm.bpel.integration.jms.StartListener.deliverRequest(StartListener.java:237)
       at org.jbpm.bpel.integration.jms.StartListener.onMessage(StartListener.java:168)
       at org.jboss.mq.SpyMessageConsumer.run(SpyMessageConsumer.java:696)
       at java.lang.Thread.run(Thread.java:595)
      


      root cause -
      Caused by: java.sql.SQLException: Operand type clash: varbinary is incompatible with text
       at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
       at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
       at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
       at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
       at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
       at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
       at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
       at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
       at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
       at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1146
      )
      


      Searching on the web about this error didn't provide me much useful information. Can someone please help me understand what this means and where could it be coming from?

      Thank you,
      Meghana.