Question
· Jan 24, 2018

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

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!