Oracle® Fusion Middleware

Known Issues for Oracle Analytics Desktop


September 2019

Oracle Analytics Desktop Known Issues

This chapter lists and describes known issues.


Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.

Known Issues with Oracle Essbase Database Connections and Data Sources

The Oracle Essbase database connection type and Oracle Essbase data sources have a number of known issues.

  • Searching for a specific column within an Oracle Essbase data source displays a "No Matches Found" message.

  • When you click an Oracle Essbase data source column from the BI Ask search results, you'll see an "Error Loading Data" message.

  • The Advanced Analytics functions don't work for Oracle Essbase data sources.

  • If you create an Oracle Essbase connection and provide invalid login information, you'll see this incorrect error message:"Failed to save the connection. JDS - Invalid syntax." The error message should state "Failed to save the connection due to an invalid user name and password.”

  • When creating an Oracle Essbase connection, you can choose the Require users to enter their own username and password authentication option, but Oracle Analytics Desktop doesn’t activate this behavior and instead authenticates all users with the user name and password that you specified.

  • Time-based columns are sometimes not imported correctly. A column displaying a date in text can’t be converted to a column of date data type because of format mismatch.

  • Oracle Essbase data sources don’t work in data flows.

  • When working in a project, you can’t use match columns to join an Oracle Essbase data source to any other data source included in the project.

  • When you import an Oracle Essbase data source, you can’t prepare the data, and you can’t edit the data after import. For example, you can't change a column’s data type or aggregation.

Null Values in XLSX File Set to String

If you're adding an XLSX file as a data source and if the spreadsheet’s null values are expressed as hyphens, then Oracle Analytics treats the null values as strings irrespective of the other values in the column.

To work around this issue, remove the hyphens from the column and try to import the XLSX file again.

Connection Not Found Error Message After Importing Project and Opening Oracle Database Data Flow

If you import a project that is sourced from an Oracle Database then try to open the data flow, you might see an error message that connection can't be found.

To work around this issue, click the connection name, select it again, and save and reopen the data flow.

Query Results for Columns of String Values Might Differ

You might notice that queries for columns of type String return differing results. This situation can occur if String columns are matched with columns in the subject areas of the metadata repository that have CHAR data types. Trailing spaces are treated differently between VARCHAR and CHAR data types in many SQL functions. This issue has no workaround.

Can't Invoke HTTP API Data Actions from Oracle Analytics Desktop

You can create an HTTP API data action, but you can't invoke the action.

To invoke an HTTP data action, you must set a safe domain for the URL; however, the Safe Domains page isn't currently available in Oracle Analytics Desktop. This issue has no workaround.

Help Link Doesn't Access Current Documentation Library

The Home page's Help link accesses the version of the Oracle Analytics Desktop library.

To workaround this issue, use this link to access the current ( documentation library:

Installation and Configuration Issues and Workarounds

Sometimes there are issues with the installation and configuration. This section contains information about known installation and configuration issues and how you can resolve them.

Collect Diagnostics Dialog Displayed During Upgrade

When you upgrade Oracle Analytics Desktop and depending on the resources of your computer, you might find that the upgrade takes several minutes. If you see the Collect Diagnostics dialog, click Dismiss, to allows the upgrade process to continue to completion.

Reinstallation of Machine Learning After Upgrade

When you upgrade, you must reinstall Machine Learning to use Oracle Advanced Analytics functions in your projects.

You must install Machine Learning using the installer provided with Oracle Analytics Desktop. This installation enables Machine Learning for the corresponding Oracle Analytics Desktop installation, only. No other installation of Machine Learning will work. See Oracle Analytics Desktop Installation FAQs.

Connection to Oracle Business Intelligence Server Fails Without Trusted Certificate Authority

If you're trying to create a connection to an Oracle Business Intelligence Server which is SSL-enabled but doesn't have a certificate signed by a trusted certificate authority, then your connection fails.

To resolve this issue, your system administrator must add or renew a certificate that is signed by a trusted certificate authority on the server.

Before Upgrading Oracle Analytics Desktop on Mac

If you already have Oracle Analytics Desktop installed on Mac, then perform these steps before upgrading to a newer version:

  1. Open Finder and access the Applications folder.
  2. Send the following items to Trash: 
    • Oracle Analytics Desktop
    • Oracle Analytics Desktop Configure Python
  3. Empty the Trash folder.

Oracle Fusion Middleware Known Issues for Oracle Analytics Desktop


Copyright © 2016, 2019, Oracle and/or its affiliates. All rights reserved.

Describes information about known issues and their workarounds for this release of Oracle Data Visualization Desktop.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.