DB Gene — Change Log

Version 4.6.1

Release date: 2025-07-02

New Features & Improvements

DBPF-8336 DOC-1229 Docker-compose template now exposes missing variable for the gateway service
DBPF-8135 Gene Image Widget now supports Scenario Data

Bug Fixes

DBPF-8542 DOC-1271 Data-service could compute incorrect column names when running multiple schema checkers in parallel
DBPF-8541 DOC-1270 ConcurrentMapException could happen when running schema checkers
DBPF-8523 [Gantt] Loading was failing for INSTANT/PERIOD series
DBPF-8503 DOC-1259 [Charts] Legend wasn't using the available space when comparing scenarios and using "split by scenario"
DBPF-8468 [Pivot table] DateTime fields were filtered with Date input without hours or minutes
DBPF-8366 DOC-1176 Pivot View: Field of Aggregation row was not Displayed within Aggregated Cell Details

Version 4.6.0

Release date: 2025-06-20

New Features & Improvements

DBPF-8388 DOC-1237 Calls to Gene HTTP API now support both relative URLs /api/xxx and api/xxx
DBPF-8301 [Scenario Comparison] The multiple scenario comparison option is now activated by default in the Application Preferences
DBPF-8207 ngx-quill has been upgraded to 27.0.2
DBPF-8206 NGINX has been upgraded to 1.28.0 in Gene and DBOS
DBPF-8204 AG Grid has been upgraded to 33.3.0 in Gene
DBPF-8203 FullCalendar has been upgraded to 6.1.17
DBPF-8202 DateTimePicker has been upgraded to 19.1.1
DBPF-8201 Angular has been upgraded to 19.2.11 in Gene
DBPF-8200 RabbitMQ has been upgraded to 4.1.0
DBPF-8199 PostgreSQL has been upgraded to 15.13
DBPF-8198 MongoDB has been upgraded to 8.0.9
DBPF-8197 Apache Commons text has been upgraded to 1.13.1 and Apache POI to 5.4.1
DBPF-8196 Keycloak has been upgraded to 26.2.4
DBPF-8195 SpringBoot has been upgraded to 3.4.5 and Spring Framework to 6.2.6
DBPF-8194 Python max version has been updated to 3.12.10
DBPF-8171 [Dashboards] Widget titles have been renamed and their descriptions have been rewritten
DBPF-8170 DOC-1138 DOC-1139 [Dashboards] Widgets are now selected through the Widget Gallery
DBPF-8136 [JupyterLab] The Helper now provides a method to produce binary/base64 images
DBPF-8124 DOC-1148 The data integration now stops on errors
DBPF-8096 DOC-1140 DOC-807 [Dashboards] It is now possible to duplicate a widget to another dashboard
DBPF-8086 [Dashboards] Custom Views are now removed
DBPF-8018 DOC-1112 JupyterLab sessions now report their activity on a Gene application
DBPF-8007 [Gene Online] The JDL AI Converter has been improved
DBPF-7972 DOC-670 [Gantt Chart] The widget now supports multiple series
DBPF-7950 DOC-1135 [Calendar] The widget now supports advanced configuration of labels
DBPF-7949 DOC-1134 [Calendar] The widget now supports advanced tooltip configuration
DBPF-7551 The Gene Framework now supports widgets implementing GeneConfigurationValidator
DBPF-7226 Zap - Gene - CSP: script-src unsafe-eval
DBPF-7208 DependencyCheck - Gene - Upgrade npm package to graphql 16.10.0 and json-to-graphql-query to 2.3.0

Bug Fixes

DBPF-8425 DOC-1247 DOC wasn't saving data from a routine with a scenario link as an input
DBPF-8422 DOC-1232 [Pivot Table] The widget was getting stuck on loading when filtering on dates through in-built filters
DBPF-8365 DOC-1177 [Pivot Table] The widget was not displaying the time of DateTime fields and was parsing Date values incorrectly when aggregated
DBPF-8361 DOC-1234 [Gantt Chart] The loadData method in the controller was no longer being called
DBPF-8334 DOC-1230 Jobs with input Scenarios created on a version before 4.2.0 were failing
DBPF-8333 [Composite widget] In the title of the configurator, another widget was being mentioned
DBPF-8318 [Gene Online] The data-service pod being killed during the rebuild of the application was causing the application to be stuck
DBPF-8285 DOC-1210 In Gene Online, Min and Max values with decimal figures were not working properly in the JDL data model
DBPF-8270 [Dashboards] Adding widgets without a configurator could lead to an error in the console
DBPF-8267 [DataGrid] Cells with Date-Time values were remaining in edition mode even after saving changes
DBPF-8266 [DataGrid] The date-time editor/picker icon was misaligned when using a small column width
DBPF-8264 [Dashboard] A new widget was replacing an existing one under certain conditions
DBPF-8247 The Python CPO JupyterLab Notebook was not working anymore
DBPF-8229 The Gene WebUI was not redirected correctly to the Keycloak login page when the JWT had expired
DBPF-8188 [JupyterLab] A binary field was failing to save null values
DBPF-8162 DOC-1145 DOC-1188 [Gene Online] Compilation was failing because of a Unicode character
DBPF-8122 DOC-1178 [Filters] The filter bar did not handle special characters
DBPF-8102 [Scenario comparison] The reference scenario list could have multiple entries of the same scenario
DBPF-8091 [Scenario Comparison] It was possible to select the same scenario multiple times
DBPF-7870 [Dashboards] A user who did not have editing rights for the UI was able to see and click on the "Add widget" link on an empty dashboard
DBPF-7866 [Dashboards][Gene Online] Setting a dashboard as the Home made it unusable and the Home link pointed to the default Home view
DBPF-7807 [JupyterLab] The notebook execution was failing with an "Interrupted waiting for lock" error
DBPF-7769 [Gantt Chart] The header was displaying the wrong year in some cases
DBPF-7765 DOC-993 [DBOS] Worker collections were not being cleaned properly
DBPF-6953 [Data Explorer] The preview in the configurator was not being updated correctly

Version 4.5.3

Release date: 2025-05-15

New Features & Improvements

DBPF-8115 DOC-676 [Gantt] Gantt now support single color series
DBPF-8101 DOC-1121 Scenario can now be filtered when loading or saving from python API
DBPF-8066 DBOS no longer depends on keycloak-angular library
DBPF-8065 Gene no longer depends on keycloak-angular library
DBPF-7948 DOC-1132 Calendar now supports events "color by" configuration
DBPF-7614 DataModel can now be downloaded
DBPF-7589 [Gantt] Deprecated loadEvents / loadResources have been removed
DBPF-7354 PenTest - DOC - REST and GraphQL API getUsers are secured and limited to permission_admin users
DBPF-7228 Zap - Gene - CSP: Vulnerable JS Library - Upgrade jquery-ui-dist to 1.13.3

Bug Fixes

DBPF-8144 Deadlock between data and scenario services at startup when migrating Mongo data to 4.5.2
DBPF-8077 Scroll vertical layout was broken after undo action
DBPF-8067 [Gantt] Data edition was not refreshing correctly with dynamic loading enabled
DBPF-7967 DOC-1109 DBOS worker stack traces were not captured
DBPF-7903 [Gene Online] editor wasn't detecting entities with the same name case insensitive
DBPF-7896 [Gantt] Edition mode allowed dropping an event onto a group
DBPF-7859 [Gene Online] Renaming an entity by changing only the capitalization of its first letter would prevent the data service from restarting

Version 4.5.2

Release date: 2025-04-18

New Features & Improvements

DBPF-7942 The JupyterLab Docker file is now simplified using our internal artifacts
DBPF-7930 AG Grid has been updated to 33.2.1 in Gene
DBPF-7878 Pandas deprecation warning has been fixed
DBPF-7827 The Scenario Picker now supports Multiple (>2) Scenarios Comparison
DBPF-7826 Dashboards are now able to display Multiple (>2) or Simple Scenario Comparison based on settings and configuration
DBPF-7825 JDL now handles compilation errors better
DBPF-7539 [UI] Text colour has been adjusted to use CSS variables when applied on application colours
DBPF-7506 DOC-773 Users can now compare Scenarios on Error having no Schema Issue

Bug Fixes

DBPF-8073 DOC-1170 Excel Export was broken when using a filter (regression)
DBPF-8061 DOC-1156 [Gantt] Dynamic loading didn't work for primitive properties
DBPF-7991 In Dashboard edition mode, undoing/redoing a step without changing the grid type was rendering the Dashboard Settings unusable
DBPF-7966 DOC-1145 GeneOnline —JDL @Description annotation was not supporting strings containing special characters
DBPF-7965 DOC-1090 Data loading was failing because of uninitialized cache
DBPF-7941 There were permission issues when creating a virtualenv in JupyterLab
DBPF-7939 There were Web client warnings in the console
DBPF-7936 DOC-1142 Relation wasn't correctly set when importing an Excel file
DBPF-7931 DOC-1127 Import Scenario was failing
DBPF-7910 JDL can now use java reserved keywords for field names
DBPF-7907 [UI] New UI Dashboard link was missing on newly generated app
DBPF-7898 [UI] Confirmation was no longer asked when leaving a dashboard with unsaved data modifications
DBPF-7831 JDL editor was highlighting line 1 on errors with no line information

Version 4.5.1

Release date: 2025-03-26

New Features & Improvements

DBPF-7926 Keycloak has been upgraded to 26.1.4
DBPF-7921 SpringBoot has been upgraded to 3.4.4, Spring Cloud to 2024.0.1 and Spring Framework to 6.2.5
DBPF-7606 JDL Editor now asks the user before leaving the view when there are unsaved changes

Bug Fixes

DBPF-7933 DOC-1130 [Gantt] Gantt wasn't reloading on DataUpdated events if related to entities unrelated to the configuration
DBPF-7932 DOC-1124 Gateway service error on macos : Unable to load io.netty.resolver.dns.macos.MacOSDnsServerAddressStreamProvider
DBPF-7929 [Issue Details] Details grid was not loading issues for a single entity as expected
DBPF-7925 DOC-1125 GeneCompositeConfiguratorComponent and GeneRulesScriptEditorConfiguratorComponent have the same selector
DBPF-7909 ag-grid was using the wrong font in grid cells
DBPF-7658 DOC-1044 Keycloak Realm export did not work anymore

Version 4.5.0

Release date: 2025-03-21

New Features & Improvements

DBPF-7842 JupyterLab — Dataframes no longer exposes internal IDs of relations
DBPF-7830 Dashboard margin settings are now more streamlined
DBPF-7829 Widget manifest attributes minItemCols and minItemRows are now deprecated and will no longer be taken into account
DBPF-7804 DOC-1086 The exit script of a task can now know which step failed during the main script execution
DBPF-7755 Internal IDs are now optional in DataFrames scenario data
DBPF-7710 Jupyter Notebook Gene Helper have been improved
DBPF-7709 Jupyter Notebook Samples have been improved
DBPF-7708 GeneOnline now has a JDL AI Converter
DBPF-7692 The helper API for JupyterLab notebooks has been reworked
DBPF-7682 eCharts has been upgraded to 5.6.0
DBPF-7681 AG Grid has been upgraded to 33.1.1 in Gene and to 32.3.3 in DBOS
DBPF-7680 FullCalendar has been upgdraded to 6.1.16
DBPF-7679 Datetime Picker has been upgraded to 19.1.0
DBPF-7678 Angular has been upgraded to 19.1.7
DBPF-7677 RabbitMQ has been upgraded to 4.0.7
DBPF-7676 MongoDB has been upgraded to 8.0.5
DBPF-7674 SpringBoot has been upgraded to 3.4.3, Spring Cloud to 2024.0.0 and Spring Framework to 6.2.3
DBPF-7649 DOC-635 DOC-948 Display Descriptive Values Alongside Keys in Filter Widgets
DBPF-7648 Jupyter Notebook can now use 3rd party libraries
DBPF-7574 [TIP][Gantt] Gantt edition now supports deleting events
DBPF-7563 SimpleExcelExportTask task has been removed
DBPF-7548 The Widget layout view has a new collapsible section to edit Gridster display settings
DBPF-7546 The Dashboard Configuration and Layout menus have now been combined into one configuration view
DBPF-7520 NGINX has been updated to 1.27.3 in DOC Web base image, in DBOS UI and in DBOS documentation
DBPF-7519 PostgreSQL has been upgraded to 15.10 (alpine version)
DBPF-7423 DOC-940 Pivot table has now been improved
DBPF-7328 [UI - Pivot Table] Table to edit data can now be displayed next to (vs over) the pivot table
DBPF-7271 [Tech Debt] Change the Python CSV Dialect to quoting csv.QUOTE_NOTNULL
DBPF-7263 Keycloak has been upgraded to 26.1.3
DBPF-7246 [Gantt] Gantt data edition now supports snap to Grid
DBPF-7240 [Gantt] Edition Mode
DBPF-7232 Trivy - Upgrade Doc Generator base image to nodejs-20-minimal:1-1736729465
DBPF-7219 "Applies to" can be edited on any filter when a "Filter field" is selected
DBPF-7206 DependencyCheck - DBOS - testng has been removed
DBPF-7205 DependencyCheck - DBOS - swagger-ui webjar has been removed
DBPF-7204 DependencyCheck - DBOS - Upgrade to luxon = 3.5.0
DBPF-7203 DependencyCheck - DBOS - Upgrade to jszip = 3.10.1
DBPF-7201 DependencyCheck - DBOS - Upgrade to aws-java-sdk-s3 = 1.12.780
DBPF-7200 DependencyCheck - DBOS - Upgrade to mongock = 5.5.0
DBPF-7198 DependencyCheck - DBOS - Upgrade to springdoc-openapi-starter-webmvc-ui = 2.6.0
DBPF-7195 DependencyCheck - DBOS - Upgrade to Java-WebSocket = 1.6.0
DBPF-7191 DBOS Master base image is now the latest Ubuntu Noble
DBPF-7190 Trivy - Upgrade DBOS Documentation to NGINX >= 1.26.2-alpine3.20
DBPF-7186 Trivy - Upgrade doc web base image to nginxinc/nginx-unprivileged:1.26.2-alpine
DBPF-7182 Trivy - Postgres was updated to version 15.10
DBPF-5531 DOC-993 DBOS CRON are now configurable through properties
DBPF-5454 Python — load CSV data are now differentiating the null and empty strings

Bug Fixes

DBPF-7892 Selecting the "Show Scenario Info" sample action on a toolbar button was breaking the configuration view
DBPF-7890 Scaffolded checker task was failing when saving a scenario in CDM
DBPF-7849 [Chart] Tooltip did not support split by business key
DBPF-7845 There were some bugs with the new Dashboard Edition view
DBPF-7836 Boolean values were not saved from a Python DataFrame or Collector
DBPF-7833 [Gantt] Data edition was not supported when using LocalDate fields as start/end
DBPF-7813 [Gantt] Gantt was not parsing LocalDate field correctly
DBPF-7808 DOC-1103 [Gantt] Gantt chart was losing scroll position after consecutive data edits
DBPF-7800 DOC-1088 [Chart][Sort] Chart was not resolving BK categories correctly
DBPF-7780 There were issues on CPLEX IloMemoryException with Native Jar
DBPF-7774 [UI - Look & Feel] styling was inconsistent between text color and background color when using custom styles
DBPF-7767 [Gantt] Gantt's tooltip wasn't up to date for locally updated events
DBPF-7756 DOC-1079 Python DOM generated code is using reserved keyword "yield"
DBPF-7752 DOC-1070 DOC-993 DBOS master - Out Of Memory error when worker write output
DBPF-7746 Widgets from old configurations were not draggable anymore in Layout mode
DBPF-7745 JDL validation returned only the first syntax errors instead of all at the same time
DBPF-7739 View toolbar is shown on Home view if coming from a dashboard that shows it
DBPF-7731 Java DOM code generator couldn't compile generated classes
DBPF-7730 DOC-1055 The task codeReplicasUpdate was overriding customization of the Chart.yaml file
DBPF-7725 Rule Scripts Editor couldn't be added to a composite widget
DBPF-7723 Map widget was ignoring configured colors
DBPF-7684 [Gantt Configurator] Field selector automatic label was wrong when using business keys
DBPF-7666 DOC-730 [UI - Jobs] [Job Detail Widget] Line breaks were not respected for TEXT result output
DBPF-7664 DOC-1043 DateTime formatting in split by charts
DBPF-7658 DOC-1044 Keycloak Realm export did not work anymore
DBPF-7653 DOC-975 [UI - Scenario List] customizeGridOption was not taken into account in ScenarioListController
DBPF-7652 DOC-827 DOC-994 It was impossible to empty the trash containing a locked scenario
DBPF-7650 DOC-945 DOC-984 Job List was "jumping" to the first page once any job status is updated
DBPF-7628 [Gantt] Gantt resource selection was confusing resources with the same name
DBPF-7473 Computed field columns were no longer grayed out in edit mode of Data Grid
DBPF-6510 DOC-805 [Chart] Tooltip was not ignoring formatting with time axis, tooltip wasn't showing series names in split line chart
DBPF-5544 DOC-1091 DOC-796 [Charts] With legend placement set to "bottom", the legend was displayed at the top

Version 4.4.5

Release date: 2025-02-17

New Features & Improvements

DBPF-7747 SpringBoot has been upgraded to 3.3.8, Spring Cloud to 2023.0.5 and Spring Framework to 6.1.16
DBPF-7199 DependencyCheck - DBOS- Upgrade kubernetes to client-java = 22.0.0
DBPF-7197 DependencyCheck - Gene and DBOS - Upgrade bcprov-jdk15on to org.bouncycastle:bcprov-jdk18:1.78.1
DBPF-7193 Trivy - Upgrade DBOS Tools to python:3.12.8-alpine3.21
DBPF-7188 Trivy - Upgrade Java service to latest JDK 17.0.14

Bug Fixes

DBPF-7738 [Gantt] Editing scenario data was causing the Gantt to reload even if in edition
DBPF-7505 DOC-809 [Chart] Y-axis labels are now left-aligned with the axis

Version 4.4.4

Release date: 2025-02-10

New Features & Improvements

DBPF-7703 DOC-1065 The Excel Template could omit the three Gene... tabs
DBPF-7700 DBOS 4.4.4 now uses updated version of base images
DBPF-7699 Gene 4.4.4 now uses Keycloak 26.0.8
DBPF-7643 Blank JDL now shows a commented example with no application block
DBPF-7638 Python DOM API now implements __str__() and display methods
DBPF-7636 Jupyterlab helper now uses XCSV instead of CSV API
DBPF-7631 [Gantt] Drag'n'drop scrolling is now supported in edition mode
DBPF-7612 [Gantt] Chart drawing API now supports rendering images
DBPF-7595 DOC-1111 The memory usage for List<FileValue> is now reduced
DBPF-7564 DOC-1047 Users with ACCESS only permission can now export scenarios
DBPF-7556 The Widget Configuration now contains the widget description
DBPF-7555 The type of widget is now displayed in the widget's configuration view
DBPF-7553 DOC-1027 Dashboards/Views now have a new option to set Filter Bar default visibility
DBPF-7550 UX research results to improve the widget display in layout mode are now applied
DBPF-7538 The colors of the sidebar reflect the application color for Gene Online
DBPF-7536 DOC-382 The “Views” separator has been removed from the sidebar
DBPF-7534 “Views” notion is now hidden for Gene Online
DBPF-7532 The “Workspace” notion is now hidden for Gene Online
DBPF-7531 “Home” is now hidden from the Sidebar for Gene Online
DBPF-7528 The default Filter Scope is now set to VIEW for Gene Online
DBPF-7489 Application block is now optional in the GeneOnline JDL editor
DBPF-7487 [Technical Dept] ExecuteJupyterNotebookTask use Api Key instead of JWT token for loading and saving scenarios.
DBPF-7245 [Gantt] Gantt Custom Controller API now supports controlling edition
DBPF-7127 markModified now applies to visible scenarios as well

Bug Fixes

DBPF-7724 Color configuration view was stuck on "loading" state when there is no configuration
DBPF-7705 Loading a python scenario collector failed with an access denied
DBPF-7645 JDLs with unclosed comment blocks were considered valid in Gene Online
DBPF-7632 DOC-1019 Pin columns in datagrid was not persistent
DBPF-7627 DOC-1007 DBOS job fails with "Worker has died" after "worker stopped" when worker terminated normally
DBPF-7590 CodeEditor configurator preview was broken
DBPF-7581 DOC-1046 [Gantt] Collapse of resource groups didn't work when customizing loadData
DBPF-7572 [Gantt] Zoom-out button was scrolling back to the left
DBPF-7570 [Gantt] Resource selection could fail with "overlapping events" when zoomed in
DBPF-7544 DOC-1011 DOC-1033 SQL Table name resolution could return a corrupted name when multiple scenarios were created in parallel
DBPF-7513 DOC-924 [Data Explorer] Filter on date-time fields from columns retrieved from another table did not display times
DBPF-7512 DOC-779 DOC-799 DOC-893 [Gantt / Chart] Custom color palette was not applied when using a scalar color-by field
DBPF-7507 DOC-1012 idOfNewScenario is failing with a correct error message for CDM
DBPF-7502 DOC-989 Expired JWT token
DBPF-7501 DOC-1003 [DBOS console] Series in the KPI chart could not be unselected anymore
DBPF-7493 DOC-1023 Automatically pick the selected scenario did not work on already existing button widget
DBPF-7492 DOC-1024 [Gantt] Grouping by a <NULL> value was not supported
DBPF-7458 [Gantt] Gantt chart was not rendering properly with a numeric color-by field
DBPF-7450 [Gantt] Gantt context menu didn't close in some cases
DBPF-7294 [UI - Data Grid] Fill handle was causing an NPE in some cases when filling Dates
DBPF-7067 [Gantt] Light grey preset color wasn't taken into account
DBPF-7026 [Gantt Configurator] Field selector automatic label was not always updated
DBPF-6955 [Color picker] In some color pickers the color icons were editable text fields

Version 4.4.3

Release date: 2025-01-17

New Features & Improvements

DBPF-7547 The toolbar configuration now has a new global settings section to show/hide the toolbar on the dashboard
DBPF-7535 Application Preferences is now placed in the Application Configuration section
DBPF-7495 DOC-1017 Add 'auto-scroll-to-bottom' setting in Code Editor
DBPF-7337 The new boolean filter display is now improved
DBPF-5626 Python DOM - A new remove_all_xxx() API is now available

Bug Fixes

DBPF-7592 NPE was triggered when executing a Ruleset
DBPF-7579 Repository URLs were not updated automatically in the gradle.properties
DBPF-7516 DOC-562 DOC-922 Routines were crashing when returning a list of files
DBPF-7498 DOC-1014 Starting the scenario creation task from "Run new job" was not loading the references

Version 4.4.2

Release date: 2025-01-10

Bug Fixes

DBPF-7559 GeneOnline — JupyterLab rebuild and restart were sometimes failing
DBPF-7542 DOC-1034 The custom text color for the header was not applied on the widget toolbar
DBPF-7533 Clear button in job button configuration view was no longer visible
DBPF-7515 DOC-895 [Calendar] The widget always displayed Instants in UTC even when changing time zone

Version 4.4.1

Release date: 2024-12-31

New Features & Improvements

DBPF-7475 A JupyterLab notebook can now be executed from a DB Gene Application
DBPF-7409 A simplified Jupyter Notebook sample is now available

Bug Fixes

DBPF-7488 DOC-1026 Gene Actuator could return NaN gene_idle_time_seconds under some conditions
DBPF-7474 DOC-938 [Data Explorer] Column filters on dates and date time fields were not being displayed