I have recently built an elasticube (EC) including a custom SQL table (similar ones have worked fine in the past). This time, although the query runs fine within the Sisense Server console, when I try to build dashboards with it using the EC Manager Analytics tab, the name does not appear as a selectable EC and I am unable to proceed further.
On the Data tab of the EC Manager, I get a message that the EC failed to open due to an "unexpected token E in JSON at position 0. Please contact your System Administrator" error.
I have checked the Sisense Support forums for this message but could not find anything that matched. I did, however, see one conversation trend about ECs not running due to a FROM SQL syntax error using two tables and/or a table with two fields with the exact name but none of these conditions apply to this case.
Has anybody experienced this and what is a solution? I am not a JSON or coding expert but I really would appreciate some help. Thank you!
Please sign in to leave a comment.