PI JDBC Receiver synchronous query "Inbound expired" ?

[Former Member]

Hi,

I have problem with JDBC receiver adapter for long query time. The error message is

"com.sap.aii.af.ra.ms.api.MessageExpiredException: Message ddde233a-7f81-c6f1-847f-001a6431e09e(INBOUND) expired"

how to increade inbound message expired ? because my query will be running around 11-15 minutes.

Thank You and Best Regards

Fernand

[Former Member]

Hi,

You can increse the Synchronous Timeout parameter in the visual admin to the limit you want.

But remeber this parameter will system dependent, which means it will be effective on all the synchronous interfaces running on your system.

Regards,

Anurag Mahendru.

[Former Member]

Hey Fernand

Try this...

Set the Batch Mode indicator if you want to collect SQL statements in a batch. This can improve performance considerably.

Prabhakar