Troubleshoot General Issues

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

I can’t access certain options from the Home page

Check with your administrator to ensure that you have the correct permissions to access the options that you need.

I see a performance decrease when using Mozilla Firefox

If you use Mozilla Firefox and notice a decrease in performance, then ensure that the Remember History option is enabled. When Firefox is set to not remember the history of visited pages, then web content caching is also disabled, which greatly affects performance. See Firefox documentation for details on setting this option.

I'm having trouble uploading data from a spreadsheet (XLSX) exported from Microsoft Access

Open your spreadsheet in Microsoft Excel and resave it as an Excel Workbook (*.xlsx).

When you export spreadsheets from other tools the file format can vary slightly. Saving your data again from Microsoft Excel can fix this.

Users can't see the Auto Insights option in the Visualize canvas in the workbook editor.

In Console, navigate to System Settings, then Performance and Compatibility, and enable the Enable Auto Insights on Datasets option. Then ask dataset developers to select the Enable Insights option on the Dataset Inspect dialog for datasets where they require insights. Workbook users can then use the Auto Insights option in the Visualize canvas in the workbook editor.

My analysis or workbook times out

You attempt to run an analysis or workbook and find that it times out. You see a message similar to this:

[nQSError: 60009] The user request exceeded the maximum query governing execution time.

This message is displayed when an Oracle Analytics query spends more than the allotted time communicating with the data source. For performance reasons, the limit for a single query to run is 11 minutes.

Try running the query again. To prevent this error, avoid long running queries or split the query into multiple queries.

Note:

For direct connections to Oracle Database, the query limit automatically extends to 60 minutes to accommodate occasional, longer running queries. To avoid excessive loads on the database, Oracle Analytics restricts the number of queries that are allowed to automatically extend at any one time. If your analysis or workbook connects to any other data source or connects to an Oracle Database indirectly through Data Gateway, the query limit is always 11 minutes; the limit doesn't extend beyond 11 minutes.

Search results on the Home page don't include the data I'm looking for

Datasets that users create from files must be indexed (and in some cases certified) to appear in search results on the Home page.

• A file-based dataset must be indexed before you can use it to build visualizations from the Home page.

• A file-based dataset must be indexed and certified before other users with permission to access the dataset can use it to build visualizations from the Home page.

See About Indexing a Dataset and Visualize Data from the Home Page.