☝️Small business or a startup? See if you qualify for our special offer.
+

Urgent : Required assist to load the data from database

Re-Open
Loganathan A asked on August 29, 2025

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.

9 answers

Public
Loganathan A August 29, 2025

The request is failing in the /fields API.

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster September 1, 2025

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:

  • If you are using the Data Server as a DLL, or as a Windows/UNIX service;
  • the database you are trying to connect to;
  • report object on the client part, to check if the index is specified correctly.

With this information, we'll be able to continue the investigation.

Looking forward to hearing from you.

Kind regards,
Solomiia

Public
Vaibhav September 4, 2025

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

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster September 4, 2025

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

Public
Vaibhav September 4, 2025

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

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster September 8, 2025

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

Public
Loganathan A September 8, 2025

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.  

 

 

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster September 9, 2025

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

Public
Loganathan A September 12, 2025

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.

 

Solomiia Andrusiv created a new ticket #75349 from this answer

Please login or Register to Submit Answer