Why is it not possible to view data in the newly installed / upgraded 2021.10 version of Insights?
Post a successful installation / upgrade of v2021.10 of Insights, sometimes the below error is thrown while trying to view data in Insights.
This error essentially occurs when SQL server 2016 is leveraged, as opposed to version 2019 which Insights 2021.10 is compatible with. This is mentioned in the "Database requirements" in the Insights official docs.
A similar error message is also thrown, with any lower versions of the SQL server.
To resolve this:
- Upgrade the SQL server as per the requirements
- Modify the connection strings to point to the updated server by following the instructions in the "Modifying the Insights Database Connection" section in our docs.