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

[former_member192892]

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

[former_member192892]

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