How to extend the timeout for the executing the SQL query from SMP
I have a query would run very long time and I get always timeout error from SMP.
Thank for your help.
Discussion (7)1
Log in or sign up to continue
https://test.community.intersystems.com/post/how-extend-timeout-executing-sql-query-smp
Do you have access to the Cache terminal?
NAMESPACE> Do $System.SQL.Shell()
I know it's not exactly what you asked for, but it doesn't time out ...
Yeah!
it's not only no timeout but you can easy debug all your SQLCOMPUTED code.
In principle OK.
But also ODBC or JDBC connection have timeouts limits. Though they are typically longer than CSP.
So how is this an ACTUAL solution if you're going to get cursed at for using it in a Production environment?
Generally, for long-running queries it makes sense to use external tools.
E.g. DBVisualizer or SQuirrel
Timeout for CSP Gateway to wait response from Caché is in Management Portal -> System Administration -> Configuration -> CSP Gateway Management.
Then Default Parameters -> Server Response Timeout.
Because I know Chen-Chieh is a developer .
For an ACTUAL solution to your question - go to the SMP and to System Administration->Configuration->(CSP/Web) Gateway Management. From there go to 'Default Parameters'. The timeout you want to change is the Server Response Timeout. If you are using the private apache you can also edit the CSP.ini file in <Install>/csp/bin/. Of course, if this is a Production Systems DO NOT DO THIS OR I WILL FIND YOU AND SAY VERY MEAN THINGS!