Known Issues in Jedox 2019.4

Below is a current list of known issues in Jedox 2019.4. Hotfixes become available on an ongoing basis as issues are resolved. As of version 2019.2, Jedox software is now updated weekly and will include the latest hotfixes. Note that major releases will still take place on a quarterly basis.

To obtain a hotfix for a particular issue, contact Jedox Support.

Fixed & patched after release

Jedox OLAP Server & Client Libraries

  • The database access rights from cube #_GROUP_DATABASE_DATA are not yet fully utilized in Jedox Web (#18919)
    • Workaround: it is recommended not to define access to internal databases (fgrp* / rgrp*) via this cube currently.
  • When SAML authentication is configured, the Login for new users which do not exist in the System database yet sometimes does not work when using Jedox Web (#39151)
  • Scheduled Backups of large databases will reach a timeout after 20 minutes (#40440)
    • Workaround: exclude CSV files from the generation of the backup or increase the timeout setting.
  • Spacer elements are incorrectly displayed in views when an attribute or alias is used. (#40925)

Jedox Excel Add-In & Jedox Office Add-In

  • Subsets cannot be pasted if an AFilter formula exceeds 254 characters. An error results and the subset formula will be pasted as text only. (44555)
  • Success charts in xlsx files exported from Jedox Web are not properly shown when directly opened via double clicking the xlsx file
    • Workaround: Open excel and use menu “File” – “Open” to open the xlsx file
  • View lists are not correctly shown after moving the View between Global and Private. (#41015)
  • In some scenarios, a Lost UI error message is displayed in the log. This error message has no impact on the performance. (#42343)
  • Incorrect display of the Subset Editor for some display settings. (#39890)
    • Workaround: Enable the Optimize for compatibility option in Excel > Display Settings.
  • The Element Picker encounters display issues when using the arrows to remove elements from a selection. (#43332)
  • Paste View dialog encounters display issues for some Excel Display settings. (#43203)

Jedox Web

  • On some longer mathematical calculation formulas, the order of calculation is not correct (#16374)
    • Workaround: enforce calculation order by setting brackets in the formula
  • When creating two reverse DynaRanges that are aligned next to each other, expansion doesn’t work correctly (#19534)
  • When using a recursive named range (i.e. named range that refers to itself), Spreadsheet Server can become unstable (#16837)
  • In some scenarios, a popup regarding conversion of workbooks is shown when opening a workbook, even though it was already saved in the current version (#16423)
  • If the data source for a chart is dynamic (e.g. based on @variables), the chart may not initialize with correct settings and formatting in all cases (#21902)
    • Workaround: manually define the options for data structure in “Source Data” dialog
  • When using references for parts of PALO.ESELECT() formula, the element picker overwrites references with static values when changing the element selection (#26266)
  • Cell borders of merged cells are not exported to PDF when the print area touches merged cell area
    • Workaround: Increase print area to cover merged cells completely
  • In Views with hidden header dimension(s) creating a hold fails with error message (#35665)
  • Linux only: Setting a font format (e.g. alignment / font type) on a whole column (by selecting column header) in a Jedox Web report or loading a report with such formatting takes long time (#38372)
    • Workaround: Configure SSS to use "freetype" textmetric engine in font_config.xml
  • Labels not properly exported to XLSX when data source is a cell reference or named range (#40104)
  • When using Edge Browser, in some cases the Cursor does not change to pointing hand in User mode (#41179)
  • When enabling View Option: "Use Element Name in Path", elements selections done before get reset (#41143)
  • When a user belongs to multiple groups with different access rights to Folders in Report Hierarchies, the user rights are not correctly applied after setting them the first time (#33373)
    • Workaround: Set same user rights once more
  • In Report mode, Cell Tracer is not displayed in the context menu of the locked cells. (#41062)
  • In Standalone links, the option "Show Toolbar" has no effect when Simple Ribbon is used. (#41382)
  • Deleting duplicate stored subsets with case sensitive name deletes both stored subsets. (#40858)
  • It is not possible to set linebreaks in the Stored View description. (#41096)
  • Working with deeply nested elements in Paste View > Select elements can cause display issues. (#41049, #41003)
  • Preselecting multiple root level elements in Clear Cube, Advanced Rule Editor and Planning Assistant does not work. (#41089)
  • In Advanced Rule Editor, when only one element is used (both in 'Target' and 'Source' panels) it is not possible to preselect it. (#41106)
  • When searching for elements in dimensions with more than one million elements or with deep nesting, the search sometimes fails with an error message. (#41045)
  • Searching in a nested dimension in Modeler causes the following OLAP error: Error while loading elements. (#41135)
  • Deeply nested dimensions can trigger an error in Subset Editor. (#41055)
  • In Report Designer, the borders of unlocked cells are sometimes not shown in User Mode. (#41043)
  • Enabling Designer Preview on a workbook with DynaRanges or the preview option in Paste View logs a workbook load message in core.log. No other effect. (#41192)
  • The layout in Report Designer is not properly displayed when toggling between components. (#41008)
  • In a large database, it is not possible to find an element starting with 0 in a searchable ComBobox. (#41759)
  • When exporting and importing an XLSX containing bubble chart, the chart is not properly displayed due to the data source not being correctly interpreted. (#41651)
    • Workaround: After an XLSX import, set the data source again.
  • Warning messages are logged in the scheduler server log after installing a model from the marketplace and executing a task in the Scheduler. (#42293)
  • In the Subset Editor > Hierarchy tab, the Siblings option in a Cyclic list is not maintained selected after saving the subset. (#40834)
  • The Large Subset checkbox becomes deselected when switching from Formula to Subset and from Formula to ODBC query. (#41800)
  • The Data filter in the Subset Editor causes a Chrome log error when using variables as a cell reference. (#42283)
  • When creating a ComboBox, you cannot include an element in a target cell if its name starts with "+". (#41869)
  • The Undo functionality does not work properly after switching between the elements of a ComboBox. (#42321)
  • In a ComboBox, preselecting an element from a very large dimension (1M or larger) causes an Internal Server error. (#41809)
  • Incorrect behavior of the Data Filter in the Subset Editor when Cube/Subcube Variables are activated. (#42291, #42287)
  • In System cubes, when switching from Rules to Properties tab, an error in the browser console can occur. (#42285)
  • In some scenarios, Dynamic styles are incorrectly displayed in a report with unlocked cells. (#42336)
  • Importing a workbook that has the same name as an existing one via drag & drop takes a long time if you opt out of replacing the existing document. (#42296)
  • Using a comma in the name of a stored subset can cau43281se issues when trying to detach a view that uses that subset. (#42322)
  • HideRow inside a DynaRange does not work in User Mode. Instead it shows the actual "TRUE" instead of hiding the row. (#42178)
  • If there are neither row nor column dimensions in Paste View and Zero Suppression is enabled, editing the View by adding the dimensions to rows/columns will disable Zero Suppression. (#43101)

Jedox Integrator & Integrator Manager UI

  • FlowGraphs are not displayed in Linux SuSE environments. Workaround: Run the following command before starting the Jedox setup: “unset DISPLAY”. (#43124)

Jedox Scheduler

  • No known issues.

Jedox Supervision Server

  • No known issues.

Jedox Sandbox

  • No known issues.

Jedox Setup

  • On first installation, Visual C++ runtime 2017 Installer is executed, which might require a restart depending on OS / Version
  • If the Windows operating system isn't up to date, installation of the Visual C++ runtime during Jedox setup sometimes fails or hangs
    • Workaround: Make sure that all Windows updates are installed before executing setup.
  • Linux only: Log files of tomcat server show one hour difference to server system time (#40094)
  • Linux only: After installing R in jedox chroot login is not possible anymore, "Backend unavailable" error shown on login page (#40006)
    • Workaround: Set JAVA_HOME in setenv.sh, e.g. add line: export JAVA_HOME=/usr/lib/jvm/java-11-openjdk-11.0.1.13-3.el7_6.x86_64
  • All reports / widgets accessing Google Maps are not loaded correctly (#38669)

Jedox Mobile

  • Reports viewed in Android app return popup boxes "return_msgbox" randomly and freeze. This behavior only affects reports from the 2019.4 release. (#45319)
  • Element pickers on huge and highly nested dimensions are slow compared to web version (#38365)
  • Mobile tags set by administrators are not propagated to users. (#41664)
    • Workaround: As an administrator, you must log in as the user and set the tags.

Jedox Models

  • All Time Series reports: When POV menu is expanded, the chart isn't always correctly moved, overlapping the table
  • Documentation in Knowledge Base is not yet fully completed for all models

Fixed & patched after release

The following issues have been fixed and patched since the the initial release of Jedox 2019.4. To obtain a patch, follow the link to the Hotfix Download page at the Jedox Support Portal.

14 Jan 2020

  • Fixed: dimension elements that were reordered in flat view did not retain in that order after restart of Jedox services. (#43578)
  • Fixed an issue that caused extremely long or endless rule calculations in Jedox versions 2019.1 and later. (#43753)

8 Jan 2020

  • Fixed: using Zero suppression on columns in Excel Add-in was not possible in columns within the Edit Paste View dialog when the view had only zero values. (#43371)
  • Fixed: error in Paste View: “Identifier not found: Subset dependencies invalid. Subset not found on axis or bad order. (Error –56)” This error occurred when dragging and dropping dimensions from the page header to rows/columns area. (#43176)
  • Fixed an issue causing MAX function to return the wrong result. (#43809)
  • Fixed an issue in Excel Add-in that prevented enforced stored subset definitions from working with an alias. This resulted in error “Failed to fill element tree!” (#43538)
  • Fixed: when performing a repair installation on Linux in systems where the config.php file was deleted (e.g. to reset the internal_suite password), databases with journal files could not be loaded, and the palo process would become unresponsive and have to be killed. (#43660)
  • Fixed an issue in Jedox Web that caused top dimension elements with similar names to be assigned incorrectly in a data filter. (#43407)
  • Fixed an issue that caused a “failure to execute” error in certain cube loads when the option to “deactivate cube access while loading” has been selected. (#43318)

18 Dec 2019

  • Fixed Unhandled Exception error when selecting a branch or inverting the selection in the Select Elements dialog. (#43265)

Known issues in other versions of Jedox:

Updated November 26, 2020