How to extend the timeout for the executing the SQL query from SMP

Question

Question

Chen-Chieh Hsu · Jan 24, 2018

#Caché

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

Jeffrey Drumm · Jan 24, 2018

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 ...

0 0

Alexander Koblov · Jan 25, 2018

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.

0 0

Kyle Baxter · Jan 26, 2018

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!

0 0

score 0 · Answer 1 · 2018-01-25T06:33:36-05:00

Robert Cemper · Jan 25, 2018

Yeah!
it's not only no timeout but you can easy debug all your SQLCOMPUTED code.

0 0

score 0 · Answer 2 · 2018-01-25T06:35:43-05:00

In principle OK.
But also ODBC or JDBC connection have timeouts limits. Though they are typically longer than CSP.

score 0 · Answer 3 · 2018-01-26T11:34:59-05:00

Jeffrey Drumm · Jan 26, 2018

So how is this an ACTUAL solution if you're going to get cursed at for using it in a Production environment?

0 0

score 0 · Answer 4 · 2018-01-26T11:24:59-05:00

Kyle Baxter · Jan 26, 2018

Because I know Chen-Chieh is a developer .

0 0