Zoomdata Version

Address "Not Authorized to Access" error

This issue applies to Zoomdata versions 2.2.15 and earlier.

Symptom

You may encounter an issue where you cannot access certain charts in a dashboard (occurs more frequently after importing a dashboard) and the following behaviors occur:

  1. A "... you do not appear to be currently authorized to access the underlying data for this visualization" error is thrown in the chart canvas:

  2. When saving the dashboard, an "Uncaught TypeError: Cannot read property 'time' of undefined" error is seen in the browser's Console (accessed, in Chrome, via Developer Tools > Console).

Possible CAUSE

This error could occur for many reasons and is thrown whenever the Zoomdata client is unable to parse the data. One such example might be where the chart is incorrectly trying to use a field or calculation that doesn't (or no longer) exists in the underlying datasource.

RESOLUTION: For v2.2.16 and Later

In Zoomdata 2.2.16 and newer, the error message is updated, allowing you to close it and continue your work.

You may delete the chart and recreate it, if necessary. Alternatively, if you do not wish to recreate the chart or you are on an earlier version of Zoomdata and cannot upgrade, please refer to the workaround below.

WORKAROUND: For v2.2.15 and Earlier

This workaround is for users on versions earlier than 2.2.16 or if they'd rather modify the JSON than rebuild the chart.

  1. Export the dashboard configuration in JSON format.
  2. Next, we need to find out what fields are being used in the group-by for these particular visualization(s). Identify the chart definition(s) in the dashboard JSON by searching for the corresponding chart name using a text editor. Depending on the visualization type being used, the parameters in the chart definition will be different.
    • Here is an example of a Line Trend: Multiple Metrics chart called "Network ASR and NER Trend" and using a calculated field called "calc_asr2" in the Y-axis:
      "name": "Line Trend: Multiple Metrics", 
                  "owner": "BOOKMARK", 
                  "source": {
                      "filters": [], 
                      "live": true, 
                      "playbackMode": true, 
                      "sourceId": "57a0d4f4e4b0c25ca48726ab", 
                      "sourceName": "LIVE - ACS System Metrics", 
                      "sparkIt": false, 
                      "textSearchEnabled": false, 
                      "variables": {
                          "Chart Description": "", 
                          "Chart Name": "Network ASR and NER Trend", 
                          "Trend Attribute": "{\"name\":\"c4\",\"limit\":1000,\"sort\":{\"dir\":\"asc\",\"name\":\"c4\"},\"func\":\"MINUTE\",\"label\":\"Timestamp\",\"type\":\"TIME\",\"granularities\":[\"MINUTE\",\"HOUR\",\"DAY\",\"WEEK\",\"MONTH\",\"YEAR\"],\"groupColorSet\":\"ZoomSequential\",\"autoShowColorLegend\":false,\"colorNumb\":2,\"autoColor\":true,\"groupColors\":{}}", 
                          "Y Axis": "calc_asr2:calc:{\"colorNumb\":2,\"legendType\":\"palette\",\"colors\":[{\"name\":\"calc_asr2:calc\",\"label\":\"ASR\",\"color\":\"#ffc65f\"},{\"name\":\"calc_ner2:calc\",\"label\":\"NER\",\"color\":\"#0096b6\"}],\"colorSet\":\"ZoomSequential\",\"autoShowColorLegend\":true,\"autoColor\":true,\"colorPositions\":null,\"colorScaleType\":\"distinct\"} calc_ner2:calc", 
                          "_custom_variables": "[{\"name\":\"font\",\"value\":{\"title\":{\"size\":\"normal\",\"typeface\":\"sans\",\"align\":\"left\",\"style\":\"\"}}},{\"name\":\"rulers\",\"value\":{\"gridlines\":{\"X1grid\":false,\"Y1grid\":true,\"X2grid\":false,\"Y2grid\":false},\"axis\":[{\"axis\":\"Y Axis\",\"name\":\"Y Axis\",\"metricsName\":null,\"from\":0,\"to\":100,\"step\":20,\"fromAuto\":true,\"toAuto\":true,\"stepAuto\":true,\"logScaleEnabled\":false,\"type\":\"yAxis\"}],\"reflines\":[]}},{\"name\":\"ColorLegendMetadata\",\"value\":{\"position\":{\"top\":154.6666717529297,\"left\":613.489616394043}}}]"
    • Here is another example of a Bar chart called "1st AE Call Volume by BDR and Week" using a time attribute called "Opportunity Created Date" in the multi group-by:
      "name": "Bars", 
                  "owner": "BOOKMARK", 
                  "source": {
                      "filters": [], 
                      "live": false, 
                      "playbackMode": false, 
                      "sourceId": "5764537de4b0085bb8fb1cdf", 
                      "sourceName": "Diana Opps 6-15 to 6-16", 
                      "sparkIt": true, 
                      "textSearchEnabled": false, 
                      "variables": {
                          "Bar Color": "count::{\"colorNumb\":3,\"legendType\":\"palette\",\"colors\":[{\"name\":\"Color 1\",\"color\":\"#ffc65f\"},{\"name\":\"Color 2\",\"color\":\"#9eb778\"},{\"name\":\"Color 3\",\"color\":\"#0096b6\"}],\"colorSet\":\"ZoomSequential\",\"autoShowColorLegend\":true,\"autoColor\":true,\"colorPositions\":null,\"colorScaleType\":\"gradient\"} ", 
                          "Chart Description": "", 
                          "Chart Name": "1st AE Call Volume by BDR and Week", 
                          "Metric": "count", 
                          "Multi Group By": "[{\"sort\":{\"dir\":\"asc\",\"name\":\"opportunity_createddate\"},\"limit\":50,\"name\":\"opportunity_createddate\",\"label\":\"Opportunity Created Date\",\"type\":\"TIME\",\"granularities\":[\"DAY\",\"WEEK\",\"MONTH\",\"YEAR\"],\"func\":\"MONTH\",\"defaultGranularity\":\"MONTH\",\"groupColorSet\":\"ZoomPalette\",\"autoShowColorLegend\":false,\"colorNumb\":4,\"autoColor\":false,\"groupColors\":{\"Nick Damiano\":\"#f4c658\",\"Roberto Neyra\":\"#a0b774\",\"Percy Darkwah\":\"#0095b7\",\"Irvin Mateo\":\"#fe8b3e\"}},{\"name\":\"activity_createdby_name\",\"limit\":50,\"sort\":{\"dir\":\"desc\",\"name\":\"count\"},\"label\":\"Activity Created By Name\",\"type\":\"ATTRIBUTE\",\"groupColorSet\":\"ZoomPalette\",\"autoShowColorLegend\":false,\"colorNumb\":4,\"autoColor\":false,\"groupColors\":{\"Nick Damiano\":\"#f4c658\",\"Roberto Neyra\":\"#a0b774\",\"Percy Darkwah\":\"#0095b7\",\"Irvin Mateo\":\"#fe8b3e\"}}]", 
                          "_custom_variables": "[{\"name\":\"UberBarsSettings\",\"value\":{\"showXGrid\":true,\"showYGrid\":true,\"chartType\":\"stacked\",\"chartOrientation\":\"vertical\",\"thickness\":\"100\",\"showAbsoluteValues\":false,\"showRelativeValues\":false,\"showGroupLabels\":true,\"enableLogScale\":false}},{\"name\":\"font\",\"value\":{\"barLabels\":{\"size\":\"normal\",\"typeface\":\"sans\",\"align\":\"left\",\"style\":\"\"},\"title\":{\"size\":\"normal\",\"typeface\":\"sans\",\"align\":\"left\",\"style\":\"\"}}},{\"name\":\"rulers\",\"value\":{\"gridlines\":{\"X1grid\":false,\"Y1grid\":true,\"X2grid\":false,\"Y2grid\":false},\"axis\":[{\"axis\":\"Metric\",\"name\":\"Metric\",\"metricsName\":\"Volume\",\"from\":0,\"to\":12,\"step\":2,\"fromAuto\":true,\"toAuto\":true,\"stepAuto\":true,\"logScaleEnabled\":false,\"type\":\"yAxis\"}],\"reflines\":[]}}]"
  3. Once we have identified the fields that are used in this visualization, search the JSON using the field name to make sure these field definitions exist in the source definition of the dashboard JSON. If the field is invalid, the field(s) likely will only be found in these corrupted/broken charts. However, if the field exists and is valid, the field should be able to be found in the source definition as well. Using the existing example:
    • In this example, the "calc_asr2" calculation doesn't exist. However, the "calc_asr" field can be found in the formulas section of the dashboard JSON:
      "id": "57a0d4f5e4b0c25ca487318f", 
      "label": "ASR", 
      "name": "calc_asr", 
      "requiresTotal": false, 
      "script": "(SUM(c8)*100)/SUM(c6)", 
      "sourceId": "57a0d4f4e4b0c25ca48726ab", 
      "userName": "admin", 
      "valid": true
  4. Once we identify the invalid fields being used in these visualization, replace these fields in the chart with a different valid field (of the same or similar type) that exists in the source definition.
  5. Save the JSON and import it into Zoomdata. This new dashboard can be used as a workaround to replace the existing dashboard that has this issue.
  • The file name of your JSON file should be in this format or Zoomdata will not accept it: name_20160603050359.json
  • If the file is not able to import because of "incorrect format", you can use this site to check the validity of your JSON.
  • If the JSON is valid and it still says "check formatting", you can use this tool to convert your JSON into plain text.