asked on July 27, 2023
Hello team,
We are using Flexmonster Data Server (2.9.43) with the admin panel. Our clients require realtime flexmonster reports. We are looking into creating views on the database and have FDS fetch the data from those views without caching the responses.
According to the documentation, we need to perform the following steps:
0.However, after this configuration change, we are served with an error "Unable to connect to custom data source API endpoint". This error only goes away on reloading the config json and ensuring cacheSizeLimit > 0 and Keep Data on Refresh is enabled.
I hope you can assist with this issue.
Thanks,
Akshay
Zenya Developer
⋅ July 31, 2023
Hello, Akshay!
Thank you for reaching out to us.
Based on the provided input, the issue occurs when FDS has no data to return while the index refresh is performed. Enabling the "Keep data on refresh" would ensure that the temporary index copy is stored during the refresh, guaranteeing that FDS always has the data to return. This option works independently from the cache, configured in the "Cache size limit" parameter. Please note that Flexmonster Data Server should also be updated to the latest version since this version contains a fix for the "Keep data on refresh" property.
You are welcome to check our updating guide: https://www.flexmonster.com/doc/updating-to-the-latest-version/#update-data-server
Also, we would like to provide some recommendations regarding using FDS with real-time data. First of all, you should set a short refresh time, meaning that FDS would perform queries to reload data from the dataset more often. In addition, we would like to mention that the cache is cleared after each index refresh. Hence, the old irrelevant data will not be returned from the cache. This implies that you can still use the cache for your use case, though it is more efficient with a smaller refresh time.
Please let us know if you found our recommendations helpful.
Best Regards,
Maksym
⋅ August 1, 2023
Hi Maksym,
Thanks for your answer. I updated Flexmonster data server and followed your instructions. It seems to work well now.
Regards,
Akshay
⋅ August 2, 2023
Hello, Akshay!
Thank you for your reply.
We are glad to hear that you were able to solve the issue with Flexmonster Data Server.
Feel free to contact us if more questions arise.
Best Regards,
Maksym