BPEL error: varbinary is incompatible with text

[meghanai_99]

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.

[meghanai_99]

I am using SQL server 2005 and JBPM BPEL 1.1 GA.

I see that the ElementType uses Types.VARBINARY. The message value is stored as one. Does that mean SQL server does not understand this type? In previous beta version this was simple text type.

Any idea how I can fix this?

Thanks,
Meghana

[meghanai_99]

Btw when I open my SQL server database, I see part in MessageValue is created as 'text' column and not varbinary.

[meghanai_99]

Sorry for my flurry of messages. But I know what is happening in this case. I was using upgraded database from beta3 to GA so my ElementType was left on 'text' and wasn't updated to varbinary. Don't know how to change its type during upgrade script so if any one knows, I would appreciate the help.

Thanks,
Meghana