I am using Jbpm + Hibernate on MSSQL Server and see this error frequently. Sometimes, I am able to run without any problems. Any help in understanding and fixing this issue will be deeply appreciated.
10:29:29,947 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState:
HYT00
10:29:29,951 ERROR [JDBCExceptionReporter] The query has timed out.
10:29:29,956 ERROR [BatchSearchAction] Error in assigning all docs
message:could not initialize a collection: [org.jbpm.taskmgmt.exe.TaskInstance.variableInstances#767]
10:29:29,970 INFO [BatchSearchAction] Exception:
org.hibernate.exception.GenericJDBCException: could not initialize a collection:
[org.jbpm.taskmgmt.exe.TaskInstance.variableInstances#767]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.loader.Loader.loadCollection(Loader.java:2001)
at org.hibernate.loader.collection.CollectionLoader.initialize(Collectio
nLoader.java:36)
at org.hibernate.persister.collection.AbstractCollectionPersister.initia
lize(AbstractCollectionPersister.java:565)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onIn
itializeCollection(DefaultInitializeCollectionEventListener.java:60)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:
1716)
at org.hibernate.collection.AbstractPersistentCollection.initialize(Abst
ractPersistentCollection.java:344)
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPe
rsistentCollection.java:86)
at org.hibernate.collection.PersistentMap.values(PersistentMap.java:234)
at org.jbpm.taskmgmt.exe.TaskInstance.submitVariables(TaskInstance.java:
135)
at org.jbpm.taskmgmt.exe.TaskInstance.end(TaskInstance.java:458)
at org.jbpm.taskmgmt.exe.TaskInstance.end(TaskInstance.java:418)
