Known Issues 2020.1

Release Date: 2/26/2020

Fixes and Patches

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 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

  • 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)