asked on January 20, 2025
Hello, our server is running Windows Server 2008 R2 Simplified Chinese edition. I am trying to install "flexmonster-data-server.exe." Whether I run it directly or use the command prompt, the process exits immediately without any response.
I understand that Windows Server 2008 R2 might not support "Flexmonster-Admin-Panel.exe," which is fine. I would like to use "flexmonster-data-server.exe" instead, but it still doesn't work. Am I missing something? Please see the screenshot below for reference.
⋅ January 20, 2025
Hello, LeoChen!
Thank you for reaching out to us.
Kindly note that Flexmonster Data Server is using the 8 version of the .Net framework. We have checked that the Windows Server 2008 R2 is not in the list of supported OS by this version of .Net, which may be the cause of the behavior you are experiencing.
Hope you will find our answer helpful.
Kind regards,
Solomiia
⋅ January 21, 2025
Dear Solomiia Andrusiv
Thank you for your prompt response. However, I find it strange that another cloud server (on Azure) we have, which is also running Windows Server 2008 R2 (English version), can successfully install and run the "flexmonster-data-server.exe" without any issues. But on our current VM, which is Windows Server 2008 R2 Simplified Chinese version, I installed ".NET Framework 4.8" just now, and it still doesn't work.
Since it's not feasible to upgrade the client's server, is there any alternative way to support "Windows Server 2008 R2 Simplified Chinese"? Or could you provide a slightly older version of the "flexmonster-data-server.exe" that might work?
Thank you.
⋅ January 21, 2025
Hello, LeoChen!
Thank you for getting back to us.
Kindly note that flexmonster-data-server.exe is a self-contained application that already includes the correct version of .Net Core(later .Net) and it doesn't need to be installed separately. According to the official Microsoft documentation, .Net Core is not compatible with the Windows Server 2008 R2 starting from the .Net Core 3, and the current version the Data Server uses is .Net 8. We could provide you with an older bundle of the Data Server, which is based on .Net 6, but we don't think this will be of any help.
Our team strongly recommends updating your Windows Server at least to the minimal compatible version, which is 2012-R2 according to the .Net docs, to have access to all Flexmonster functionality and updates.
If upgrading is not an option, you can load the data as JSON/CSV files directly to Flexmonster client.
Please let us know if this approach would work for your case.
Kind regards,
Solomiia
⋅ January 22, 2025
Dear Solomiia Andrusiv,
I hope this message finds you well.
May I kindly confirm if it’s possible to use JSON or CSV datasets directly on Windows Server 2008R2 without installing "Flexmonster-Admin-Panel.exe" or "flexmonster-data-server.exe"?
(Currently, I am using Flexmonster to connect directly to MS-SQL Server 2008R2.)
If so, would it be correct to assume that I need to develop a scheduled program to regularly extract data from a specific transaction table in MS-SQL (approximately 200,000 rows and 100 columns),
convert it into JSON or CSV format, and provide it to Flexmonster on the server?
Furthermore, if the data is updated periodically (e.g., changes in the JSON or CSV content), will Flexmonster automatically detect and refresh the data?
Given the size of our transaction table (about 200,000 rows and 100 columns), would you recommend using CSV or JSON to ensure optimal performance?
Thank you very much for your guidance and advice.
⋅ January 22, 2025
Hello, LeoChen!
Thank you for the provided details about your use case.
For such a large amount of data, the approach of loading JSON/CSV directly on the client may not be the best in terms of performance. We'd recommend sticking to the Flexmonster Data Server if possible.
Taking into account all the newly provided details, we've thought about one more approach to use the Data Server in your case. The idea lies in separating the Flexmonster Data Server from the server where the database is stored and hosting the DataServer on the other machine with more up-to-date configurations. This way, you can connect to your database as to remote data source by slightly modifying the connection string.
Could you please let us know if such an approach would work for your case?
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ January 23, 2025
Dear Solomiia Andrusiv
Thank you for your reply. So, regardless of whether we use a direct connection to MS-SQL, JSON, or CSV, the "flexmonster-data-server.exe" must be installed on the server side, correct?
However, our server cannot be upgraded for the time being and can only run on Windows Server 2008R2 Simplified Chinese.
We also cannot provide another VM.
Is there any other way to run Flexmonster's pivot table functionality on Windows Server 2008R2 Simplified Chinese?
⋅ 7 days ago
Hello,
Thank you for the response.
In this case, we recommend loading JSON/CSV directly on the client side. Please note that this approach does not require using Flexmonster Data Server. This means that you don't need to install "flexmonster-data-server.exe" to load the data in a JSON or CSV format.
The idea is to write a server-side script that fetches the data from your database and returns it in JSON or CSV format. Then, the pivot component will use the URL to this server-side script and display the data. Our documentation provides more details: https://www.flexmonster.com/doc/connecting-to-other-data-sources/#server-side-script.
Please let us know if it works for you. Looking forward to hearing from you.
Kind regards,
Nadia
⋅ 7 days ago
Dear Solomiia Andrusiv,
Thank you very much for your reply. Alright, I will try the method you suggested in the next few days (retrieving data from the database and saving it in CSV format, approximately 100,000 records with 100 fields).
I will then link the CSV file directly to Flexmonster on Windows Server 2008 R2 Simplified Chinese edition (without installing "flexmonster-data-server.exe") to see if it works. If I encounter any issues, I will reach out to you for further assistance. Thank you!
⋅ 6 days ago
Hello,
Thank you for the feedback!
Do not hesitate to contact us if other questions arise.
Kind regards,
Nadia
