Get Free Trial

Timeout for large(?) requests from FM Data Server

Moshe Malin asked on December 1, 2020

I’m running FM Data Server, and using a query that supposed to fetch ~100K records from mySql.
It worked nicely last night.
Now, when I’m loading the server, it gets an error:
on one run I got:
2020-12-01 14:33:44.3677|FATAL|Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception
2020-12-01 14:33:44.3895|FATAL|Flexmonster.DataServer.Program|Timeout in IO operation
and when tried again I got:
2020-12-01 14:39:08.1986|FATAL|Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception
2020-12-01 14:39:08.2191|FATAL|Flexmonster.DataServer.Program|Timeout can be only be set to ‘System.Threading.Timeout.Infinite’ or a value > 0. (Parameter ‘value’)
Using workbench I get the 100K lines from the DB (it takes about 50 sec)
Is there a way to control the timeout? anything else to apply?

1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 2, 2020

Thank you for reaching out to us.
We assume the issue can be caused by the default command timeout limitation of the driver. By default, it is set to 30 seconds.
You can increase the timeout by specifying it as a parameter of the connection string.
Please refer to the following page for more information about this parameter. You will also find an example of the connection string with the default command timeout parameter specified.
Please let us know if it helps.
We are looking forward to hearing from you.

Please login or Register to Submit Answer