Excpetion while Persisting BPEL Instances.

[Ashwin S]

Hi All,
 I am doing a load test on composite application and while doing so facing few issues. I am using Glassfish v2.1 with Derby database bundled in it version 10.4.2.1.
I have enable the persistence for this application as defined in userguide. when I send a batch of 10 requests to our application. I observed following exception in the server.log.  And this excpetion is creating few issues at the endpoint server. I observed that whenever this excpetion thrown BEPL engine try to rollback the current transaction and sends the invoke requests number of times to the endpoint server.

Is anybody came across such exception or such behaviour.

Thanks in advance.
Ashwin

Exception at Server.log
----------------------------------------------------
[#|2009-10-21T21:51:22.086+0530|WARNING|sun-appserver2.1|com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection|_ThreadID=31;_ThreadName=sun-bpel-engine-thread-5;Process Instance Id=10.99.62.73:7c622b48:12477dca379:-7edf;Service Assembly Name=ALMIntegrationCASA;BPEL Process Name=SFDCInbound;_RequestID=da55ed98-aa94-471d-bc23-3678d5e9e93c;|BPCOR-6149: failed while executing SQL statement INSERT INTO VARIABLE  VALUES (?, ?, 'N', ?, ?)
java.sql.SQLNonTransientConnectionException: Network protocol exception: DSS chained with same id at end of same id chain parse.  The connection has been terminated.
            at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
            at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
            at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
            at org.apache.derby.client.am.LogicalConnection.prepareStatement(Unknown Source)
            at com.sun.gjc.spi.base.ConnectionHolder.prepareStatement(ConnectionHolder.java:475)
            at com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection.constructInsertStmt(AbstractDBConnection.java:410)
            at com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection.batchInsert(AbstractDBConnection.java:434)
            at com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection.insert(AbstractDBConnection.java:149)
            at com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.performDBOperationForDBOs(StateManagerImpl.java:780)
            at com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.performDBTransactionForDBOs(StateManagerImpl.java:598)
            at com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.updateState(StateManagerImpl.java:445)
            at com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.persistState(StateManagerImpl.java:393)
            at com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.PersistenceManager.doXA(PersistenceManager.java:340)
            at com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.PersistenceManager.endXA(PersistenceManager.java:325)
            at com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.InvokeUnitImpl.process(InvokeUnitImpl.java:707)
            at com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.InvokeUnitImpl.doAction(InvokeUnitImpl.java:182)
            at com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.execute(BPELInterpreter.java:162)
            at com.sun.jbi.engine.bpel.core.bpel.engine.BusinessProcessInstanceThread.execute(BusinessProcessInstanceThread.java:98)
            at com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELProcessManagerImpl.process(BPELProcessManagerImpl.java:1031)
            at com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineImpl.java:289)
            at com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineImpl.java:1291)
            at com.sun.jbi.engine.bpel.BPELSEInOutThread.processResponse(BPELSEInOutThread.java:488)
            at com.sun.jbi.engine.bpel.BPELSEInOutThread.processMsgEx(BPELSEInOutThread.java:264)
            at com.sun.jbi.engine.bpel.BPELSEInOutThread.run(BPELSEInOutThread.java:183)
Caused by: org.apache.derby.client.am.DisconnectException: Network protocol exception: DSS chained with same id at end of same id chain parse.  The connection has been terminated.
            at org.apache.derby.client.net.Reply.endOfSameIdChainData(Unknown Source)
            at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
            at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
            at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
            at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
            at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
            at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
            at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
            at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
            ... 22 more

[Murali Pottlapelli]

Will you please file a bug with test case to reproduce it and detailed
steps for reproducing the issue? I will investigate the issue.

Regards
Murali

Ashwin S wrote:

> Hi All,
>  I am doing a load test on composite application and while doing so facing
> few issues. I am using Glassfish v2.1 with Derby database bundled in it
> version 10.4.2.1.
> I have enable the persistence for this application as defined in userguide.
> when I send a batch of 10 requests to our application. I observed following
> exception in the server.log.  And this excpetion is creating few issues at
> the endpoint server. I observed that whenever this excpetion thrown BEPL
> engine try to rollback the current transaction and sends the invoke requests
> number of times to the endpoint server.
>
> Is anybody came across such exception or such behaviour.
>
> Thanks in advance.
> Ashwin
>
> Exception at Server.log
> ----------------------------------------------------
> [#|2009-10-21T21:51:22.086+0530|WARNING|sun-appserver2.1|com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection|_ThreadID=31;_ThreadName=sun-bpel-engine-thread-5;Process
> Instance Id=10.99.62.73:7c622b48:12477dca379:-7edf;Service Assembly
> Name=ALMIntegrationCASA;BPEL Process
> Name=SFDCInbound;_RequestID=da55ed98-aa94-471d-bc23-3678d5e9e93c;|BPCOR-6149:
> failed while executing SQL statement INSERT INTO VARIABLE  VALUES (?, ?,
> 'N', ?, ?)
> java.sql.SQLNonTransientConnectionException: Network protocol exception: DSS
> chained with same id at end of same id chain parse.  The connection has been
> terminated.
>             at
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
> Source)
>             at
> org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
>             at
> org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
>             at
> org.apache.derby.client.am.LogicalConnection.prepareStatement(Unknown
> Source)
>             at
> com.sun.gjc.spi.base.ConnectionHolder.prepareStatement(ConnectionHolder.java:475)
>             at
> com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection.constructInsertStmt(AbstractDBConnection.java:410)
>             at
> com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection.batchInsert(AbstractDBConnection.java:434)
>             at
> com.sun.jbi.engine.bpel.core.bpel.connection.AbstractDBConnection.insert(AbstractDBConnection.java:149)
>             at
> com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.performDBOperationForDBOs(StateManagerImpl.java:780)
>             at
> com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.performDBTransactionForDBOs(StateManagerImpl.java:598)
>             at
> com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.updateState(StateManagerImpl.java:445)
>             at
> com.sun.jbi.engine.bpel.core.bpel.persist.impl.StateManagerImpl.persistState(StateManagerImpl.java:393)
>             at
> com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.PersistenceManager.doXA(PersistenceManager.java:340)
>             at
> com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.PersistenceManager.endXA(PersistenceManager.java:325)
>             at
> com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.InvokeUnitImpl.process(InvokeUnitImpl.java:707)
>             at
> com.sun.jbi.engine.bpel.core.bpel.model.runtime.impl.InvokeUnitImpl.doAction(InvokeUnitImpl.java:182)
>             at
> com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.execute(BPELInterpreter.java:162)
>             at
> com.sun.jbi.engine.bpel.core.bpel.engine.BusinessProcessInstanceThread.execute(BusinessProcessInstanceThread.java:98)
>             at
> com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELProcessManagerImpl.process(BPELProcessManagerImpl.java:1031)
>             at
> com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineImpl.java:289)
>             at
> com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineImpl.java:1291)
>             at
> com.sun.jbi.engine.bpel.BPELSEInOutThread.processResponse(BPELSEInOutThread.java:488)
>             at
> com.sun.jbi.engine.bpel.BPELSEInOutThread.processMsgEx(BPELSEInOutThread.java:264)
>             at
> com.sun.jbi.engine.bpel.BPELSEInOutThread.run(BPELSEInOutThread.java:183)
> Caused by: org.apache.derby.client.am.DisconnectException: Network protocol
> exception: DSS chained with same id at end of same id chain parse.  The
> connection has been terminated.
>             at
> org.apache.derby.client.net.Reply.endOfSameIdChainData(Unknown Source)
>             at
> org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
> Source)
>             at
> org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown
> Source)
>             at
> org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown
> Source)
>             at
> org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown
> Source)
>             at
> org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown
> Source)
>             at
> org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
> Source)
>             at org.apache.derby.client.am.PreparedStatement.prepare(Unknown
> Source)
>             at
> org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
>             ... 22 more
>
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]