People Task and message size error

[Anton]

Hello,

I have a problem with People Task and message size. I wrote a process
which takes information from database (approximately 6 string fields
300 records), than make an XSL transformation and display this
information to user (i made a simply xform with table control).
Process runs ok, I see the task with status "Ready" in tasks list. But
when I click on the task in ui-fw I receive an error.

I also tried to take the task data from Task Management Web Service,
but also I receive an error "An IOException was thrown when reading a
'java.sql.String' from an InputStream".

Here is the fragment from server log:

18:07:52,268 ERROR
[org.intalio.tempo.workflow.tms.server.TMSRequestProcessor]
[DefaultThreadPool 496] An IOException was thrown when reading a
'java.sql.String' from an InputStream.
<openjpa-1.1.0-SNAPSHOT-r422266:644852M nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: An IOException
was thrown when reading a 'java.sql.String' from an InputStream.
at org.apache.openjpa.jdbc.sql.SQLExceptions.narrow
(SQLExceptions.java:146)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException
(DBDictionary.java:4107)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore
(SQLExceptions.java:102)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore
(SQLExceptions.java:88)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore
(SQLExceptions.java:64)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize
(JDBCStoreManager.java:268)
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize
(DelegatingStoreManager.java:111)
at org.apache.openjpa.kernel.ROPStoreManager.initialize
(ROPStoreManager.java:57)
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:
879)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:837)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:759)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load
(JDBCStoreManager.java:811)
at org.apache.openjpa.jdbc.sql.AbstractResult.load
(AbstractResult.java:257)
at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load
(SelectImpl.java:2228)
at org.apache.openjpa.jdbc.sql.AbstractResult.load
(AbstractResult.java:251)
at
org.apache.openjpa.jdbc.kernel.InstanceResultObjectProvider.getResultObject
(InstanceResultObjectProvider.java:59)
at org.apache.openjpa.lib.rop.EagerResultList.<init>
(EagerResultList.java:36)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1222)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:989)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:804)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:774)
at org.apache.openjpa.kernel.DelegatingQuery.execute
(DelegatingQuery.java:533)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:
235)
at org.apache.openjpa.persistence.QueryImpl.getResultList
(QueryImpl.java:277)
at org.intalio.tempo.workflow.util.jpa.TaskFetcher.fetchTaskIfExists
(TaskFetcher.java:50)
at
org.intalio.tempo.workflow.tms.server.dao.JPATaskDaoConnection.fetchTaskIfExists
(JPATaskDaoConnection.java:51)
at org.intalio.tempo.workflow.tms.server.TMSServer.getTask
(TMSServer.java:101)
at org.intalio.tempo.workflow.tms.server.TMSRequestProcessor.getTask
(TMSRequestProcessor.java:105)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.axis2.receivers.RawXMLINOutMessageReceiver.invokeBusinessLogic
(RawXMLINOutMessageReceiver.java:97)
at
org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic
(AbstractInOutSyncMessageReceiver.java:42)
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:713)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
487)
at org.apache.geronimo.jetty6.InternalJettyServletHolder.handle
(InternalJettyServletHolder.java:65)
at org.mortbay.jetty.servlet.ServletHandler.handle
(ServletHandler.java:362)
at org.mortbay.jetty.security.SecurityHandler.handle
(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle
(SessionHandler.java:181)
at org.apache.geronimo.jetty6.handler.ThreadClassloaderHandler.handle
(ThreadClassloaderHandler.java:46)
at org.apache.geronimo.jetty6.handler.InstanceContextHandler.handle
(InstanceContextHandler.java:58)
at org.apache.geronimo.jetty6.handler.UserTransactionHandler.handle
(UserTransactionHandler.java:48)
at org.mortbay.jetty.handler.ContextHandler.handle
(ContextHandler.java:712)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
405)
at org.apache.geronimo.jetty6.handler.ComponentContextHandler.handle
(ComponentContextHandler.java:47)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle
(ContextHandlerCollection.java:211)
at org.mortbay.jetty.handler.HandlerCollection.handle
(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle
(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
506)
at org.mortbay.jetty.HttpConnection$RequestHandler.content
(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run
(SelectChannelEndPoint.java:396)
at org.apache.geronimo.pool.ThreadPool$1.run(ThreadPool.java:201)
at org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run
(ThreadPool.java:331)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask
(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run
(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: An IOException was thrown when
reading a 'java.sql.String' from an InputStream.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException
(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException
(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException
(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.getString(Unknown
Source)
at org.tranql.connector.jdbc.ResultSetHandle.getString
(ResultSetHandle.java:575)
at org.apache.openjpa.lib.jdbc.DelegatingResultSet.getString
(DelegatingResultSet.java:118)
at org.apache.openjpa.jdbc.sql.DBDictionary.getString
(DBDictionary.java:747)
at org.apache.openjpa.jdbc.sql.ResultSetResult.getStringInternal
(ResultSetResult.java:463)
at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal
(ResultSetResult.java:390)
at org.apache.openjpa.jdbc.sql.AbstractResult.getObject
(AbstractResult.java:662)
at org.apache.openjpa.jdbc.meta.strats.HandlerStrategies.loadDataStore
(HandlerStrategies.java:205)
at org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy.load
(HandlerFieldStrategy.java:172)
at org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:
796)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load
(JDBCStoreManager.java:868)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load
(JDBCStoreManager.java:820)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState
(JDBCStoreManager.java:342)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize
(JDBCStoreManager.java:263)
... 60 more
NestedThrowables:
java.io.IOException: ERROR 40XD0: Container has been closed.
at
org.apache.derby.impl.store.raw.data.OverflowInputStream.fillByteHolder
(Unknown Source)
at
org.apache.derby.impl.store.raw.data.BufferedByteHolderInputStream.read
(Unknown Source)
at java.io.DataInputStream.readUnsignedByte(DataInputStream.java:262)
at org.apache.derby.iapi.types.SQLChar.readExternal(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.getString(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.getString(Unknown
Source)
at org.tranql.connector.jdbc.ResultSetHandle.getString
(ResultSetHandle.java:575)
at org.apache.openjpa.lib.jdbc.DelegatingResultSet.getString
(DelegatingResultSet.java:118)
at org.apache.openjpa.jdbc.sql.DBDictionary.getString
(DBDictionary.java:747)
at org.apache.openjpa.jdbc.sql.ResultSetResult.getStringInternal
(ResultSetResult.java:463)
at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal
(ResultSetResult.java:390)
at org.apache.openjpa.jdbc.sql.AbstractResult.getObject
(AbstractResult.java:662)
at org.apache.openjpa.jdbc.meta.strats.HandlerStrategies.loadDataStore
(HandlerStrategies.java:205)
at org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy.load
(HandlerFieldStrategy.java:172)
at org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:
796)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load
(JDBCStoreManager.java:868)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load
(JDBCStoreManager.java:820)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState
(JDBCStoreManager.java:342)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize
(JDBCStoreManager.java:263)
at org.apache.openjpa.kernel.DelegatingStoreManager.initialize
(DelegatingStoreManager.java:111)
at org.apache.openjpa.kernel.ROPStoreManager.initialize
(ROPStoreManager.java:57)
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:
879)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:837)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:759)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load
(JDBCStoreManager.java:811)
at org.apache.openjpa.jdbc.sql.AbstractResult.load
(AbstractResult.java:257)
at org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load
(SelectImpl.java:2228)
at org.apache.openjpa.jdbc.sql.AbstractResult.load
(AbstractResult.java:251)
at
org.apache.openjpa.jdbc.kernel.InstanceResultObjectProvider.getResultObject
(InstanceResultObjectProvider.java:59)
at org.apache.openjpa.lib.rop.EagerResultList.<init>
(EagerResultList.java:36)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1222)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:989)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:804)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:774)
at org.apache.openjpa.kernel.DelegatingQuery.execute
(DelegatingQuery.java:533)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:
235)
at org.apache.openjpa.persistence.QueryImpl.getResultList
(QueryImpl.java:277)
at org.intalio.tempo.workflow.util.jpa.TaskFetcher.fetchTaskIfExists
(TaskFetcher.java:50)
at
org.intalio.tempo.workflow.tms.server.dao.JPATaskDaoConnection.fetchTaskIfExists
(JPATaskDaoConnection.java:51)
at org.intalio.tempo.workflow.tms.server.TMSServer.getTask
(TMSServer.java:101)
at org.intalio.tempo.workflow.tms.server.TMSRequestProcessor.getTask
(TMSRequestProcessor.java:105)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.axis2.receivers.RawXMLINOutMessageReceiver.invokeBusinessLogic
(RawXMLINOutMessageReceiver.java:97)
at
org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic
(AbstractInOutSyncMessageReceiver.java:42)
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:713)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:
487)
at org.apache.geronimo.jetty6.InternalJettyServletHolder.handle
(InternalJettyServletHolder.java:65)
at org.mortbay.jetty.servlet.ServletHandler.handle
(ServletHandler.java:362)
at org.mortbay.jetty.security.SecurityHandler.handle
(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle
(SessionHandler.java:181)
at org.apache.geronimo.jetty6.handler.ThreadClassloaderHandler.handle
(ThreadClassloaderHandler.java:46)
at org.apache.geronimo.jetty6.handler.InstanceContextHandler.handle
(InstanceContextHandler.java:58)
at org.apache.geronimo.jetty6.handler.UserTransactionHandler.handle
(UserTransactionHandler.java:48)
at org.mortbay.jetty.handler.ContextHandler.handle
(ContextHandler.java:712)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
405)
at org.apache.geronimo.jetty6.handler.ComponentContextHandler.handle
(ComponentContextHandler.java:47)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle
(ContextHandlerCollection.java:211)
at org.mortbay.jetty.handler.HandlerCollection.handle
(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle
(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
506)
at org.mortbay.jetty.HttpConnection$RequestHandler.content
(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run
(SelectChannelEndPoint.java:396)
at org.apache.geronimo.pool.ThreadPool$1.run(ThreadPool.java:201)
at org.apache.geronimo.pool.ThreadPool$ContextClassLoaderRunnable.run
(ThreadPool.java:331)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask
(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run
(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)


How can I solve this problem?

Thanks,
Anton.

[Nicolas Modrzyk]

Hi Anton,

Do you have a reproducible test ?
Also if you can send the content of the database for this particular task, or how to recreate exactly what you put in the database.

I will have a look.

Best Regards,

Nicolas,

[Anton]

Hi Nicolas,

Thank you for fast reply. Test project and database dump are uploaded
to Files (file name "PATask_Message_size.zip"). Receipt ID for
starting process is "34SS-09".

Thanks,
Anton.