Splunk Enterprise

How to fix this error: com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.

spl10
Explorer

Hello Splunkers

I am trying to execute a SQL Query, however is it throwing  "com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out." error.

I had also increased the timeout windows still no luck

spl10_0-1661432781311.png

 

Can anyone please assist how to resolve this issue

 

Labels (1)
Tags (1)
0 Karma

isoutamo
SplunkTrust
SplunkTrust
You should try to increase “query timeout “ parameter from 30 to e.g. 60s
0 Karma

spl10
Explorer

@isoutamo Thanks for the reply...

I have increased the timeout window to 150 seconds around and even as alternative I have reduced the number of results from the main query to get the output.

However still getting same error message "com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out."

0 Karma

isoutamo
SplunkTrust
SplunkTrust

Have you try to get this query working with MS SQL own tools? Check it with it and also ensure that you have correct indexes etc. defined to get response enough quickly.

0 Karma
Get Updates on the Splunk Community!

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...

Security Highlights | January 2023 Newsletter

January 2023 Splunk Security Essentials (SSE) 3.7.0 ReleaseThe free Splunk Security Essentials (SSE) 3.7.0 app ...

Platform Highlights | January 2023 Newsletter

 January 2023Peace on Earth and Peace of Mind With Business ResilienceAll organizations can start the new year ...