Need a special offer?Find out if your project fits.
+

Index not available

Answered
Alessandra Fregnani 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,
 

3 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster 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

Public
Maksym Diachenko Maksym Diachenko Flexmonster 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

Public
Maksym Diachenko Maksym Diachenko Flexmonster 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

Please login or Register to Submit Answer