I have deployed the Flexmonster Data server to our development environment that simulates our production environment. It is unable to connect to the database, and the only error message I can see from the logs says:
Index brand_safety_detailed_daily_performance_tableview cannot be loaded. Details: Cannot load data from database executing query “SELECT * FROM `brand_safety_detailed_daily_performance_tableview`;”. Please check query or connection string.
Are there any settings, or options to enable more verbose logging? The server should have access to the database, so I am not sure why it is failing to load the data.
Thank you for writing to us.
The logging verbosity is configurable through the Admin Panel settings (or through the
LoggerMinLevel property, if you’re using the Data Server as a console application). However, the default level is
INFO, which is the most verbose it gets.
That being said, if you could give us a little more details on your data source connection, we’d be able to help you to find what’s wrong. More specifically, what database are you trying to connect to, and what connection string are you currently using?
Looking forward to your response!
How are you?
Just checking in to ask if your inquiry is still relevant. Have you managed to set up a database connection, or does the issue persist?
Please let us know your thoughts.
FDS is still unable to connect to our database – even when trying a number of different settings from the documentation. What would your recommended next steps be?
Thanks for following up.
Thank you for your response.
As I requested in my original response, it would help us a lot to know the following:
Any additional details on your Data Server and/or Flexmonster Pivot report configurations would be helpful as well.
Thank you in advance!