Troubleshoot Data Visualization Issues

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

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

This message displays for various reasons:
  • A file in the archive is larger than the maximum upload size (100 MB).

  • 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 project, I get an error stating that the project, data source, or connection already exists

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

“There is already a project, 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 project is already on your system. When a project is exported, the outputted .DVA file includes the project’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 project you’re trying to import contains no data. When you export a project without data, the project’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 projects using the data set. To unhide these columns, click the Hidden option.

Data Visualization requires that Excel spreadsheets have a specific structure. See About Adding Spreadsheets or Other Data Files.

I can’t refresh data from a MongoDB data source

The first time Data Visualization connects 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 project, then you might get an error or Data Visualization doesn’t respond.

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