asked on December 1, 2022
im facing error message index_database cannot be loaded when using flexmonster data server
could you help me (attached file)
⋅ December 1, 2022
Hello, Nam!
Thank you for reporting the issue.
We would like to have some additional context about this issue. Could you please tell us which SQL database you are using and copy the full log line containing the error (index_database cannot be loaded)?
Looking forward to hearing from you.
Best Regards,
Maksym
⋅ December 8, 2022
Hi, Nam!
Hope you are doing well.
Just checking in to ask if you had time to check our message. We would like you to send us the full log line containing the error, as it will greatly help to find out what is causing the issue.
Looking forward to hearing from you.
Best Regards,
Maksym
⋅ December 9, 2022
hi Maksym, sorry Im was busy, this is full log
please check query or connection string. exception of type 'system.outofmemoryexception' was thrown.
2022-12-09T09:19:51.419+07:00 at flexmonster.dataserver.core.dataloaders.dataloader.load(string index)
2022-12-09T09:19:51.419+07:00 at flexmonster.dataserver.core.datastorages.datastorage.getoraddasync(string cachekey)
2022-12-09T09:19:51.419+07:00 at flexmonster.dataserver.flexmonsterprepopulatingcacheservice.tryloadindex(iservicescope scope, string indexname)
⋅ December 9, 2022
Hello, Nam!
Thank you for providing this information.
The System.OutOfMemoryException with Flexmonster Data Server indicates that it hasn't enough RAM to load the entire dataset. We recommend prefiltering some unnecessary columns inside the connection query (SELECT a,b,c FROM table) or running the Data Server on a machine with larger RAM capacities.
Also, it is possible to decrease the amount of used RAM by disabling the cache with CacheSizeLimit: 0 and preventing the dataset from being stored on refresh with KeepDataOnRefresh: false. You are welcome to check our configurations reference for more details: https://www.flexmonster.com/doc/configurations-reference/#DataStorageOptionsObject
Please let us know if these solutions would work for you.
Best Regards,
Maksym
⋅ December 20, 2022
Hello, Nam!
Hope you are doing well.
We are wondering if you were able to check the provided solutions for avoiding the System.OutOfMemoryException with FDS.
Our team is looking forward to hearing your feedback.
Kind Regards,
Maksym
⋅ December 27, 2022
Hi, Nam!
Our team would like to know if you were able to optimize the data server's memory usage with one of the suggested approaches.
You are welcome to write us in case further assistance is needed.
Kind Regards,
Maksym
