Oracle Analytics Desktop Known Issues
This chapter lists and describes known issues.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
General Issues and Workarounds
Some features and functions don’t work as expected.
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.
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.
Connection Not Found Error Message After Importing Project and Opening Oracle Database Data Flow
If you import a project that's sourced from an Oracle Database then try to open the data flow, you might see an error message that the 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.
Microsoft Internet Explorer Is No Longer Supported
If you use Internet Explorer 11 with Oracle Analytics, then you'll experience significant performance issues.
Oracle no longer supports Internet Explorer and strongly recommends that you use a modern browser. Refer to the Microsoft Support website for information about the latest Microsoft browsers.
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 allow the upgrade process to complete.
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.
Oracle Analytics Known Issues for Oracle Analytics Desktop
Copyright © 2016, 2021, Oracle and/or its affiliates.
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 embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloud services are defined by the applicable contract for such services. 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 Inside 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, Epyc, and the AMD 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.