Skip to Content
avatar image
Former Member

JDBC Recv: Generic Exception: -> java.lang.ArrayIndexOutOfBoundsException

Dear SDNers,

I'm facing a strange issue in my PI Quality server when inserting data using recv JDBC adapter. The error description which I get in the channel is given below:-

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: ERROR occured parsing request:com.sap.engine.lib.xml.parser.NestedSAXParserException: Generic Exception: -> java.lang.ArrayIndexOutOfBoundsException.

Now, I have tried out this message in a different PI server, to the same destination DB and it worked fine. Hence I'm very sure that this is not a mapping bug which is causing incomplete or wrong payload structures going in to the JDBC adapter.

I request the xperts to please suggest on this issue..

Thanks a lot

Varun

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 19, 2010 at 08:52 AM

    It seems the latest JDBC Driver for MS-SQL does not support batch mode for multiple tables. Removed the batch mode option and works as a charm..

    Regards

    Varun

    Add comment
    10|10000 characters needed characters exceeded