Hi,

I have the component installed in our environments. After installing the components we received the following errors in the Service Center:

After investigating the issue, we found that the JSON_VALUE function isn't on our version of the SQL Server (Microsoft SQL Server 2014 - 12.0.4213.0 (X64)), and the JSON_VALUE function was introduced in SQL Server 2016 (13.x). 

Based on the official documentation, this version of SQL Server 14 is compatible with O11.

It isn't ideal, but for SQL Server 2014, you can write custom code to parse JSON strings or use third-party libraries are necessary, or in the last scenario disable this query if you don't use the Toggle Hits feature.

We think this could be a common issue in other installations, which is the reason for the error.

Thank you.

Gonçalo Ferraria