Hi,
We are using the custom data source. All the request from UI that handled in our customized service. The Service is working with small dataset and getting Index property is missing error while load the 300K rows from database.
We required assist to load the data.
Please check and advise.
Thanks,
Loganathan A.
The request is failing in the /fields API.
Hello, Loganathan!
Thank you for reaching out to us.
From the context of the previous tickets, we assume that you are using Flexmonster Data Server to connect Flexmonster to your database.
If our assumptions are correct, as a first step, please provide us with the Data Server logs. Check out how to find the logs: https://www.flexmonster.com/doc/troubleshooting-data-server/#data-server-logs.
It would also be helpful to know:
With this information, we'll be able to continue the investigation.
Looking forward to hearing from you.
Kind regards,
Solomiia
Hi,
This problem is now solved, the issue was with the refresh time, we had made it to 1 min. Now we have made it 0 so that it doesnt refresh. Now we have a challenge in calling the refresh API:PUT
request "http://localhost:9555/admin/indexes/reload/YOUR_INDEX_NAME". We checked for the required port, seems its not available.
Please refer the below screenshot
This is running inside docker.
Thanks
Hello, Vaibhav!
Thank you for providing additional details of the case.
Kindly note that the admin/indexes/reload/YOUR_INDEX_NAME
is the Admin Panel endpoint, which is unreachable when using Flexmosnter Data Server in the Docker container.
To reload data with Flexmonster Data Server, we recommend using the native approach: specify the dataRefreshTime and set keepDataOnRefresh: true with the latest version of Flexmonster Data Server. For our built-in approach to work correctly, we need to research the initial issue.
As a first step, please provide us with the Data Server logs for "Index property is missing" case: https://www.flexmonster.com/doc/troubleshooting-data-server/#data-server-logs.
It would also be helpful to know the following:
With this information, we'll be able to continue the investigation.
Looking forward to hearing from you.
Kind regards,
Solomiia
Hi Solomiia,
Is there any alternative for calling admin/indexes/reload/YOUR_INDEX_NAME to refresh the data source manually? We want to refresh the data on a trigger (when a process completes).
For the first issue with "Index property is missing", it was due to the refresh time, it was set to 1minute and it was taking more than a minute to return the data (which in case of refresh was removed to store new data before it could return) causing the above failure.
Thanks
Hello, Vaibhav!
Thank you for your swift response.
Kindly note that there is no built-in function to refresh data on a trigger. You can either set the refresh for every n minutes or schedule a refresh for a certain time using our default refreshing functionality.
For the described case, we suggest trying to run the Data Server with --serviсe
in Docker.
This way, the Data Server service would run the Admin Panel app under the hood. With the Admin Panel enabled, you should be able to use the admin/indexes/reload/YOUR_INDEX_NAME
on the 9555
(admin) port.
Please let us know if the suggested approach works well for you.
Kind regards,
Solomiia
Hi Solomiia,
We are running flexmonster in docker image. we required steps to rebuild the admin panel to refresh the index data.
Please suggest your thought.
Thanks,
Loganathan A.
Hello, Loganathan!
Thank you for getting back to us.
Kindly note that you need to add --service
to the command that runs Flexmonster Data Server is your Docker container. With this part, the Admin Panel would run along with the Data Server, and you'll be able to use the admin/indexes/reload/YOUR_INDEX_NAME
to manually reload data index on a trigger.
Since refreshing the index requires the Admin Panel endpoint, you will also need to expose the Admin Panel port, which is 9555
.
Hope you will find our answer helpful.
Kind regards,
Solomiia
Hello Solomiia,
We need assist to pass the customized parameter(Where conditions) in the Index Query to fetch the records.
Kindly check and advise.
Thanks,
Loganathan A.