Known Issues in Jedox 2020.1

Below is a current list of known issues in Jedox 2020.1. 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.

Known issues in other versions of Jedox:

To obtain a patch 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.
  • 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

  • Pasting a subset with a long formula across several rows and columns results in an error message due to technical restrictions from Microsoft Excel.
    • Workaround: Jedox Excel Add-in inserts the formula in the first cell of the selected range so that it can be used to manually create an array in the desired range. (44019)
  • Subset can't be pasted in excel if any filter formula exceeds 254 characters. An error results and the subset formula will be pasted as text only. (44555)
  • In Excel for Office 365, pasting a subset into a single cell and then expanding it over a range of cells as an array doesn’t work due to a recent change in Excel functionality, which inserts an @ into formulas. Pasting the subset directly into a range of cells does work. (44557)
    • Workaround: after expanding the cell range, remove the @ operator manually from the formula and press CTRL-SHIFT-ENTER.
  • 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
  • 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)

Jedox Web

  • When a cube has the same name as its database, and the cube is selected in Modeler, the database properties open. (45074)
  • Views created before 2020.1 and pasted into a spreadsheet show red triangle flag (indicating change to view), even when no changes were made. (44540)
  • Undo not working in some instances with stored views selected from the Stored View combobox. (44575)
  • In Designer, expanding a view with 3 column and 3 row dimensions results in #VALUE! error. (44712)
  • Pictures of all types (png, jpg, gif) and dynamic charts in spreadsheets are not exported to HTML. (44637)
  • For Button form elements, “No color” option in color picker does not work as expected. (43539)
  • File icons do not appear in General tab of Properties dialog. (44668)
  • When navigation tree is collapsed and the main window is resized, and empty shaded space (container) is revealed. (43452)
  • Designer: if a spreadsheet contains a label AND either a ComboBox with a subset as its source OR a DatePicker, and the spreadsheet is exported as XLSX, the label data is lost upon import into Jedox Web. (43796)
  • In navigation tree in Designer: files cannot be dragged into the parent folder; copying and pasting a file into parent folder results in error message; copied files don’t appear immediately in hierarchy. (43525, 43603)
  • Designer: when dimensions of the file selector are larger than the file thumbnail icon, the keyboard delete function does not work. (43600)
  • When axis labels in charts are wrapped to multiple lines, they appear in PDFs as a single line and partially overlap. (44988)
  • Reports exported from Jedox Web with styles are only applied properly on the first sheet in reports that were exported from Jedox Web. (44647)
  • In Administration, multiple tabs for the same user, group, and role can be opened at once. (44528)
  • When some dialogs are minimized, the content appears truncated. (43652, 43987, 44020)
  • Form element inserts “Root” element instead of an empty string when a row is inserted between values in the spreadsheet. (44570)
  • In Jedox Views, the Hide Headers option in the Paste View>Option dialog doesn’t work in some scenarios. (44680, 44672)
  • 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)
  • 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)
  • Deleting duplicate stored subsets with case sensitive name deletes both stored subsets. (#40858)
  • In 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)
  • 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 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)
  • 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)
  • The order of cube dimensions listed in the Rule Editor is not correct in all scenarios. (#43169)

Jedox Integrator & Integrator Manager UI

  • After renaming an Integrator project, a file with the old name remains in the recent file list. Clicking on the file leads to a FlowGraph error. (44633)
  • When the browser is resized to a smaller size, some tabs overlap and the FlowGraph pane cuts into the Settings Panel. (#42866)
  • In Relational Extracts, the count(*) function does not give the correct count in the data preview for a multi-statement, table-valued function. (#44749)

Jedox Scheduler

  • Batch PDF creation in Scheduler does not currently support the config.php setting CFG_COOKIE_SECURE setting, which is default in Jedox Cloud environments. (44946)

Jedox Supervision Server

  • If all workers are occupied AND use-dimension-worker is enabled, workbooks cannot be created or opened in Designer and an error message is thrown “Unable to load workbook.”(44317)

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, e.g. add line: export JAVA_HOME=/usr/lib/jvm/java-11-openjdk-
  • All reports / widgets accessing Google Maps are not loaded correctly (#38669)

Jedox Mobile

  • Login not possible in offline mode. (42764)
  • Option to disable “filter by device” is missing. (43352)
  • When tapping the “Clear cache” button in Settings, there is no visual feedback to indicate action. (42066)
  • Ad hoc views based on stored views cannot be created. (43135)
  • Web reports do not scale down on Android devices. (41728)
  • On some Android devices (including OnePlus), the touch sensor is disabled after a few false attempts to authenticate with the touch sensor. (45167)
  • 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.

Fixed & patched after release

The following issues have been fixed and patched since the the initial release of Jedox 2020.1. To obtain a patch, follow the link to the Hotfix Download page at the Jedox Support Portal.
  • Fixed: error connecting to OneDrive using password credentials. (44966)
  • Fixed: check boxes only assess TRUE or FALSE as values, not 1 or 0. (44929)
  • Fixed: DATAV not filling the correct cell areas. (44901)
  • Fixed: error when copying aggregated elements whose children have 0 weight. (44869)
  • Fixed: “Snap to grid” positioning for ComboBoxes not working. (44841)
  • Fixed: Dynamic charts not exported to PDF on Linux. (444783)
  • Fixed: Scheduler task start and stop times are not set correctly. (44778)
  • Fixed: unhandled exception error when selecting “None” in Select Elements dialog. (44658)
  • Fixed: issue when writing data to multiple cells of a specific cube using palo_setdata_bulk(). (44688)
  • Fixed: Input with unit (i.e. 20k) requires splashing prefix (#) on base cells. (44656)
  • Fixed: calling activeworkbook() in parent() macro caused error. (44526)
  • Fixed: delete option available even when no element is selected in Reports tree. (44501)
  • Fixed: Widget error “Source function not specified” when using Source type range. (44479)
  • Fixed: Macro/Subset/ODBC cannot be set a widget source. (44377)
  • Fixed: Scheduler task can’t be opened in tree when thumbnail view is active. (44272)
  • Fixed: a template can be opened in multiple tabs when switching between tasks. (44219)
  • Fixed: font formatting not applied/saved in some form elements. (43479)
  • Fixed: UndoLockManager displayed overlapping of text and dropdown arrow when width of grid columns is decreased. (42759)
  • Fixed: folder group not selected in combo box after creation; root folder not created in group with “Create root folder” checked. (44596)
  • Fixed: details tab in Request Profiler can’t be opened. (44666)
  • Fixed: calculation errors in rules with LEN. (45042)
  • Fixed: exception errors during metadata retrieval when specific certificates are used in SAML configuration. (45039)
  • Fixed: wrong group names returned in views/subsets on #_GROUP_ dimension. (45015)
  • Fixed: behavior of $additive parameter in OnCellChange Event. (44914)
  • Fixed: form element inserts “Root” element instead of an empty string when a row is inserted between values in the spreadsheet. (44570)
  • Fixed: Sandbox does not automatically configure the secret from Silent Setup script. (44593)
  • Fixed: when publishing a view from Excel Add-in to Jedox Web, PALO.VIEW.TITLE does not work on the first try. (44428)
  • Fixed: in thumbnail view of scheduled tasks, start/stop time is not working correctly. (44270)
  • Fixed: issue in Jedox Web Rule Tracer with PALO.EL formula syntax. (44320)
  • Fixed: console error after selecting a stored view. (44538)
  • Fixed: in Format chart properties dialog, the Series menu item is not selected when the font tab is open. (43601)
  • Fixed: when Default or Group homepage is set, the X icon for closing a report is missing, and when other reports are opened, they all open in the same sheet. (43704)
  • Fixed: Connection Manager doesn’t display properly. (44640)
  • Fixed: layout issues in Roles Manager. (44641)
  • Fixed: height/width labels mixed up in New Frameset dialog. (44434)
  • Fixed: parameters are not saved in Scheduler tasks when switching to the model window and back again. (44214)
  • Obsolete: in Report Designer menu "File" - "Open" thumbnail view is not working (#39228)
  • Fixed: the order of cube dimensions listed in the Rule Editor is not correct in all scenarios. (#43169)
  • Fixed: in Administration, multiple tabs for the same user, group, and role can be opened at once. (44528)
  • Fixed: incorrect behavior of the Data Filter in the Subset Editor when Subcube Variables are activated. (#42291)
  • Fixed: the Data filter in the Subset Editor causes a Chrome log error when using variables as a cell reference. (#42283)
  • Fixed: in a ComboBox, preselecting an element from a very large dimension (1M or larger) causes an Internal Server error. (#41809)
  • Fixed: 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)
  • Fixed: View lists are not correctly shown after moving the View between Global and Private. (41015)
  • Fixed: if Java is not installed on the server, the Integrator command line client doesn't work. (#39862)
  • Fixed: working with deeply nested elements in Paste View > Select elements can cause display issues. (#41049, #41003)
  • Fixed: it is not possible to set line breaks in the Stored View description. (#41096)
  • Fixed: the layout in Report Designer is not properly displayed when toggling between components. (#41008)
  • Fixed: in Report Designer, the borders of unlocked cells are sometimes not shown in User Mode. (#41043)
  • Fixed: in Standalone links, the option "Show Toolbar" has no effect when Simple Ribbon is used. (#41382)

Updated May 5, 2021