Troubleshoot Visualization Issues

This topic describes common problems that you might encounter when working with visualizations and explains how to solve them.

When I import a workbook, I get an error saying something went wrong and I'm unable to import my .dva file

This message displays because one or more data sources use a connection with the same name as a connection you're trying to import. Delete these data sources.

When I import a workbook, I get an error stating that the workbook, data source, or connection already exists

When you’re trying to import a workbook, you might receive the following error message:

“There is already a workbook, data source or connection with the same name as something you’re trying to import. Do you want to continue the import and replace the existing content?”

This error message is displayed because one or more of the components exported with the workbook is already on your system. When a workbook is exported, the outputted .DVA file includes the workbook’s associated data sources and connection string. To resolve this error, you can either click OK to replace the components on your system, or you can click Cancel and go into your system and manually delete the components.

This error message is also displayed when the workbook you’re trying to import contains no data. When you export a workbook without data, the workbook’s and data sources’ metadata are included in the .DVA. To resolve this issue, you can click OK to replace the components on your system, or you can click Cancel and go into your system and manually delete the data source or connection that’s causing the error.

I have issues when I try to refresh data for file-based data sources

Keep in mind the following requirements when you refresh data for Microsoft Excel, CSV, or TXT data sources:

  • To refresh an Excel file, ensure that the newer spreadsheet file contains a sheet with the same name as the original file you uploaded. If a sheet is missing, then you must fix the file to match the sheets in the original uploaded file.
  • If the Excel, CSV, or TXT file that you reload is missing some columns, then you’ll get an error stating that your data reload has failed. If this happens, then you must fix the file to match the columns in the original uploaded file.
  • If the Excel, CSV, or TXT file you used to create the data source was moved or deleted, then the connection path is crossed out in the Data Source dialog. You can reconnect the data source to its original source file, or connect it to a replacement file, by right-clicking the data source in the Display pane and in the Options menu select Reload Data. You can then browse for and select the file to load.
  • If you reloaded an Excel, CSV, or TXT file with new columns, then the new columns are marked as hidden and don’t display in the Data Panel for existing workbooks using the dataset. To unhide these columns, click the Hidden option.

Your Excel spreadsheets must have a specific structure. See About Files for Datasets.

I can’t refresh data from a MongoDB data source

The first time you connect to MongoDB, the MongoDB driver creates a cache file. If the MongoDB schema was renamed and you try to reload a MongoDB data source or use the data source in a workbook, then you might get an error or Oracle Analytics doesn’t respond.

To correct this error, ask your administrator to clear the MongoDB cache.

The visualizations that I embedded into a custom application or web page don't render correctly

If the visualizations aren't rendering correctly, then view or open the application or web page's HTML page and confirm that the DOCTYPE declaration exists and is set to <!DOCTYPE html>. See Prepare the HTML Page.