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.
General Issues and Workarounds
Some features and functions don’t work as expected.
SDK Build Command Fails
If you're using an existing SDK development directory, the SDK build command can fail and displays this error message: "Failed to create Jar file /.../jackson-core-2.15.2.jar".
- In a new service directory, run the
bicreateenvscript to create a new development environment. Then copy all existing plugins from your previous service directory into the new directory.
gradle/wrapper/gradle-wrapper.propertiesand change the Gradle version to 7.6.2.
Explain Not Returning Segments and Anomalies Insights
When you use Explain on MacOS to get insights on a column, Oracle Analytics fails to get segments and anomalies insights and presents this error message: "Error occurred when requesting data, More Details".
Hidden Workbook Header Causes Navigation Issue in Preview
If you're working in Present, set the Header property to Off in the Workbook tab, and then preview the workbook, there is no way to navigate back to the workbook in Present.
Close and reopen Oracle Analytics Desktop.
Any unsaved changes are lost when you close and reopen Oracle Analytics Desktop.
Go to the Oracle Analytics Desktop header, click Page Menu and then select Customize Home Page. In Customize, click Open Editors in New Tabs in and then click Save.
Setting this option ensures that the workbook opens in a new window that you can close if there is no header bar in preview mode.
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 workbook, you can’t use match columns to join an Oracle Essbase data source to any other data source included in the workbook.
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.
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, 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.
Error Adding Table With Mixed-Case Name or Column Names to a Dataset
Oracle Analytics displays the "Create Dataset Table Failed" error message when you add a database table with a name that uses mixed-case or a table that contains column names with mixed-case to a dataset.
Examples of mixed-case names include Sales, Products, Cust_ID, or Quantity_Sold.
- Double quote all table and column name identifiers that use mixed case.
- Alias the mixed case table column name identifiers with uppercase.
select "EfG_Field" as EFG_FIELD, "HiJ_Field" as HIJ_FIELD
Connectivity to Oracle Autonomous Database Using Wallet-Less (TLS) Connections Not Supported
If you connect to an Oracle Autonomous Database instance using TLS wallet-less connectivity, you can't connect to the data source using Oracle Analytics Desktop.
The "invalid connection credentials" error message is displayed if the connection string is invalid.
To work around this issue, use Oracle Analytics Cloud to connect to your database.
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 workbooks.
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, 2023, Oracle and/or its affiliates.