Unexpected string JSON error message appears in text analytics widget (see attached):
"Unexpected string in JSON at position xxxxxxx" where xxxxxxx is a number
Steps to Reproduce
- Configure the text analytics widget by following the instructions in our documentation topic: Text analytics and text widgets
- Use an invalid indicator - breakdown in your instance
- Open the text analytics widget in a dashboard and the red error message appears
The root cause of the problem is an invalid indicator-breakdown link in the [pa_indicator_breakdowns] table. A record is considered invalid if an indicator or breakdown field is empty in this table, if you delete the invalid record then the widget should refresh with no error.
Related Problem: PRB1211079