10.7
when i execute a sql query (Dynamic SQL) which takes a little time, I have an error after 60 seconds like com.wm.net.Net504Exception: [ISC.0064.9324] Server Error: Gateway Time-out .
it is possible to remove this time out and leave the service running until the end ?
Thank you
Hi,
please check your connection settings for JDBC Pool being used for the DynamicSQL adapter service and try to adjust the timeout values.
Check with the DBA if they can change some timeout settings on the database.
As a last option you can check for the ExtendedSettings in IS Admin for the watt.net.timeout property.
You will have to try different values until you find one that allows your query to complete but wont let it run indefinitely.
This can lead to IS becoming unresponsive when there are too many services running too long in parallel.
Regards,
Holger
Definitely take a look at the settings @Holger_von_Thomsen recommended but also be aware that this issue may be external to the Integration Server. A gateway typically sits between a client, i.e. your IS, and a server, i.e. your DB. It appears the timeout is occurring there and not on the IS.
504 erros are not uncommon when talking to Azure, for example, so try some online searches around 504 errors and the target application you’re trying to talk to and the results may shed some light. Based on your findings, if it indeed appears that the timeout is occurring in the target application, then you can reach out to that team with what you’ve found.
Last but not least, I’m assuming that the errors today are intermittent, right? If so, consider adding an automated retry mechanism in your code so that, in the event of a timeout, the SQL statement is automatically retried.
Hope this helps,
Percio
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.