How to increase MID Server response time while using Data Source?

[Artemis15]

Hi All,

We have used data source to pull data from external data bases(Oracle). When we hit to pull only 10 or 20 records, data source is working fine but when we hit all records to pull, it gives an error "MID Server did n't response". The default response timings for mid server is "300" seconds

How can we increase that?

--

Cheers,

AR

[Mike Allen]

Can you set the timeout in the data source record:

[Artemis15]

Hi Mike,

Already tried that but not working. Still it is showing 300

[poyntzj]

Connection timeout can be set to 0

Query timeout does not seem to have the same option, but I can change it to be a large number here, however, my queries run so I cannot confirm easily if it is able to wait for more than 300 seconds.

I would first look at running the same query via whatever Admin / Query tool you can and see how long it takes (for me, I installed the MSSQL tools locally and use those)

you may need to split the query down into more manageable chunks if it takes too long and increasing the timeout does not work

[Community Alums]

Hi,

Did you ever figured out how to increase the timeout for mid-server from 300 to more ?

Thanks
Ishan