JDBC-XI-JDBC(Synchronous)

[Former Member]

Hi All,

I have one query regarding this scenario.

XI fecthing the only one row Date column from Sender Database(JDBC) and

after that XI Selects the records in Receiver Database based upon the condition.

We have the VIEW in the receiver database.In this View we have more than 6 laks of records.

in View we have 20 columns out of that First 5 columns only need to check the condition, in the first five coloumns we have Date field data only.

Condition is:

coloumn1> Date or column2> Date ..........coloumn5>Date. if condition satisfied XI selects the remaining fields and take response from Receiver Database.

Here above condition is checking the database so much time to retrieve the the response from database, So XI fails the Synchoronous step and getting" Message expired exception"

How i can increase synchronous time?

How i can acheive it?can you provide your valuble suggestions.

Thank you very much.

Sateesh

[prateek · Accepted solution]

See SAP Note 791379

From visual admin check out xiadapter.inbound.timeout.default within the SAP XI Adapter: XI J2EE service

Regards,

Prateek

[former_member181985]

In XI, we can increase HTTP time out parameter using SXMB_ADM tcode. But I dont think this will help you.

Go ahead with stored procedure and BPM. In SP, use chunking concept.

BPM should iterate until you receive all records.

[Former Member]

Hi Praveen,

Thanks for your suggestion,

in this scenario i am using BPM. is possible BPM should iterate until you receive all records?

What step i need to use here.

In my BPM using,

Receive step-Transformation1-Send Synchronou-Transformation2-send asynchrou

If possible throught, Which step i need to add here?

Kindly help me.

Thank you

Sateesh

[former_member181985]

Please follow Prateek's response. If it doesnt work, then have a SP on receiver JDBC side with BPM.