asked on January 25, 2024
Hi,
Sometimes an index does not respond and we receive the error "index not available"; the index is present in the configuration file, the problem can be solved by restarting the service or by restricting the data range by putting a where clause in the source query. The source of the data is a query in SqlServer.
"ConsGirasole": {
"Query": "select * from QConsuntivi where YEAR(DteRef)>= (YEAR(Getdate()) - 1)",
"Status": "enabled",
"RefreshTime": 0
},
},
"DataStorageOptions": {
"DataRefreshTime": 0,
"CacheSizeLimit": 1
},
what could be the problem?
Thank's in advance,
⋅ January 26, 2024
Hello, Alessandra!
Thank you for reaching out to us.
Please note that this issue may be caused by the command timeout of your SQL database. The command timeout defines the wait time before canceling the attempt to execute the connection query and generating an error. We recommend setting the CommandTimeout data storage option as 0 to make the wait time for query execution unlimited.
If this recommendation does not help, we kindly ask you to provide the Data Server logs so we can pinpoint the reason for the issue. You may find information about how to find the FDS logs in our troubleshooting guide.
Looking forward to hearing your feedback.
Best Regards,
Maksym
⋅ February 13, 2024
Hello, Alessandra!
Hope you are doing well.
We are wondering if you were able to find the solution for the SQL index connection issue.
Looking forward to hearing your feedback.
Best Regards,
Maksym
⋅ March 12, 2024
Hello, Alessandra!
Our team would like to know if setting `CommandTimeout` to zero helped to solve the connection issue.
We are looking forward to hearing from you.
Best Regards,
Maksym
