Known Issues – Version 2019.3

Release Date: 08/28/2019
* = Hotfix available

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)
  • On Linux, SVS Scripts that use symbolic links are not shown in the in SVS Script Editor and can’t be edited. (#42559)

Jedox Excel Add-In & Jedox Office Add-In

  • Creating Views in existing workbooks sometimes changes colors in previously formatted cells due to limitations of the Excel color table (#16502)
  • When using Excel Add-In on Windows 10 build 1709 on a high resolution display, element selectors in paste view are grey and show no content (#37212)
    • Workaround: Open any saved xlsx file containing a saved view and use “Edit View”
    • Fix: Update to latest Windows 10 release (verified with Windows 10 build 1803)
  • 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
  • On client environments using multiple screens with different scaling options, some dialogs are not displayed correctly (#38319)
    • Workaround: Set scaling of main display to 100%
  • View lists are not correctly shown after moving the View between Global and Private. (41015)
  • Error displayed when using Show now with a stored view. (#41200)
    • Workaround: Make sure no stored view is selected when you use the Show now feature.
  • Switching between two stored views in different databases causes the Saved Stored View dialog to be displayed without any change in the views. (#41042)
  • When SAML authentication is configured and the Olap session expires, automatic session renewal sometimes doesn’t work if only formulas in a workbook are reloaded with F9. (#41205)
    • Workaround: Use manual disconnect / connect. Increase Olap session timeout in palo.ini to avoid session timeout generally.
  • 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.

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 using a stored subset in a view and the subset is renamed, the view brakes and can’t be pasted again on the same spreadsheet (#41073)
  • 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)
  • In Internet Explorer 11, importing reports or report bundles sometimes fails with the following error: Unable to import “undefined” file. (#39744)
  • 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)
  • The User Mode button is disabled in the expanding menu of the Simple Ribbon when accessed from a small-sized browser window. (#42020)
  • In a large database, it is not possible to find an element starting with 0 in a searchable ComBobox. (#41759)
  • The User Mode button is disabled in the expanding menu of the Simple Ribbon when accessed from a small-sized browser window. (#42020)
  • 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)
    • 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)
  • Reports become unresponsive when copying and pasting a list from another report.
    • Workaround: Disconnect the localhost connection from the modeler, re-authenticate, save and close the destination report and reconnect. (#42415)
  • Using the Go Over Groups option when generating a batch PDF only generates one report. (#42253)
  • 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 cause 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)
  • Changing the title in a chart via Format Property removes all the advanced chart properties. (#43027)
    Setting a blank Named Range as a source for a variable in a Subset or a DynaRange list editor can lead to losing the variable when reopening the dialog. (#42709)
    Setting a Jedox Subset List mapping on a folder in reports does not work. (#42747)


Jedox Integrator & Integrator Manager UI

  • In Integrator standard jobs, the option Fail on status doesn’t work correctly when set to none, so jobs / loads after an execution with errors are not executed. (#41902)

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
    • 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, e.g. add line: export JAVA_HOME=/usr/lib/jvm/java-11-openjdk-
  • All reports / widgets accessing Google Maps are not loaded correctly (#38669)
  • When there are no binary database files for the internal databases shipped by setup, those databases can get corrupted during update. Binary database files should always exist, except they were manually deleted from file system.  (#42351)
  • When performing a Windows update installation, the value incorrectly set in, resulting in display issues for Dynamic Charts in PDF. (#42350)
  • When installing with a non-default Apache port (other than 80), Modeler shows an error message when accessed. (#42540)*
    • Workaround: Set the sss.url parameter to point to Apache port manually in <Jedox>\tomcat\webapps\rpc\WEB-INF\classes.

Jedox Mobile

  • Element pickers on huge and highly nested dimensions are slow compared to web version (#38365)

Jedox Models

  • When exporting model reports to PDF / XLSX, display of export is not always correct as page settings are set to defaults (#28987)
    • Workaround: Define page settings manually
  • 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 existed in the initial release of 2019.3. They have already been patched in the setup currently available on the homepage:

Update 3 (14 October 2019)
  • Fixed an issue that caused incorrect display of data or circular references when using a rule calculation. (#42602) 
  • Fixed an issue where PALO formulas were not updated after user group reassignment if the OLAP server was not restarted. (#42699) 
  • Fixed an issue that caused the result of a rule not to be displayed when using a Workflow Building Block. (#42719) 
  • Fixed an issue where rules were created as inactive after executing the script when exporting the database. Workaround: Manually set the rules to Active state. (#41857) 
Update 2 (30 September 2019)
  • Fixed an issue where an ODBC connection to a MySQL or MSSQL server did not work on Linux. (#41437)
  • Fixed an issue that prevented OLAP from performing correctly during an automatic save (#42570)
  • Fixed an issue that caused a delay when loading the content of a larger list of stored views in Excel Add-in. (#41277)
  • Fixed an issue that caused the following error to be displayed when opening the SUCCESS-charts.xlsx sample: “String does not contain a definition for oString” (#42295)


Update 1 (23 September 2019)
  • Fixed an issue that caused some images on buttons to be incorrectly displayed in Chrome. (#42436)
  • Fixed an issue that caused multiple clicks on the Login button to create multiple active sessions for the same user. In this case, a message was displayed, informing you that the session token was invalid or that the license concurrency limit had been reached. (#42484)
  • Fixed an issue where the set/applied style was not preselected in the Format Element dialog. (#42168)
  • Fixed an issue that caused errors to be logged when performing an online backup or download of a database when csv files were excluded. (#42262)