1. Administering Oracle Analytics Server
  2. Troubleshooting

C Troubleshooting

This appendix describes common problems that you might encounter in Oracle Analytics Server and explains how to solve them.

Topics:

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.

Troubleshoot Configuration Issues

This topic describes common problems that you might encounter when configuring or managing Oracle Analytics Server and explains how to solve them.

I can’t access options in the Console

If you see an "unauthorized” message or don't see an option in the Console, you probably don’t have the BI Service Administrator application role. You must have the BI Service Administrator application role to access most Console options, for example Users and Roles, Snapshots, Connections, Safe Domains, Session and Query Cache, Issue SQL, and Search Index.

Ask an administrator to verify your permissions. See Assign Application Roles to Users.

I can’t upload my snapshot

You can only upload snapshots taken from Oracle BI Enterprise Edition (12c), and Oracle Analytics Server. Check where the .bar file you’re trying to upload was originally downloaded from.

I can't use Model Administration Tool in SSL mode

If the default security certificates don't work, import the server security certificates. For example, on the machine where you've installed Model Administration Tool, you might use the Key and Certificate Management Tool (keytool) to execute these commands:

C:\Oracle\Middleware\oracle_common\jdk\jre\bin\keytool.exe -importcert -alias oacserver -file
C:\Oracle\Middleware\oracle_common\jdk\jre\lib\security\server.crt -keystore
C:\Oracle\Middleware\oracle_common\jdk\jre\lib\security\cacerts -storepass
thepassword

Troubleshoot Indexing

This topic describes common problems that you might encounter when indexing semantic models and catalog content and explains how to solve them.

A home page search returns no results

If you search on the home page and no results are returned, then check that the Index User Folders option is selected. If this option isn't selected then nothing in the catalog is indexed.

This option is located on the Search Index page's Catalog tab.

A home page search returns too many or duplicate items

If your search results aren't meaningful, then reduce the number of items to index. For example, if a dimension called Sales is included in 20 subject areas and all subject areas are indexed, then when you search for Sales your results will contain 20 items called Sales.

Go to the Search Index page's Data Model and Catalog tabs and reduce the number of items to index. Oracle suggests that you deselect everything and then select only the items that you need.

Expected items are missing from search results

If some items are missing from your search results, then check that the crawl job completed successfully. Sometimes a crawl was terminated or its progress totals are zero. In such cases, rerun the crawl.

  1. Click Console.
  2. Click Search Index.
  3. Click Monitor Crawls.
  4. Click the Configure Crawls link.
  5. In the Data Model tab, deselect and then reselect the Enable Data Model Crawl checkbox.
  6. Click Save.
  7. Click the Monitor Crawls link and locate the scheduled job. The revised crawl will run in a few minutes.