Upcoming Webinar: Register now >>

15th

January

2025

Must-attend SAM event of the year

OpenLM Annapurna Summit 2025

OpenLM_Icons_Reporting Hub

OpenLM Reporting Hub

The following is a log of all enhancements and bug fixes introduced with OpenLM Reporting Hub releases. For general information about the OpenLM Reporting Hub, please take a look at our Documentation page.

Also, consult the system requirements document before installing.

 

24.11.26
December 4, 2024
Fixed

56636: Missing data in following incremental ETL run on hourly measure

v24.11
November 14, 2024

A critical security vulnerability has been identified and addressed in the OpenLM Reporting Hub. To protect your systems, we strongly recommend updating to the latest version as soon as possible.

In accordance with industry best practices, we will provide more detailed information about the specific vulnerability in 30 days.

Updated

PostgreSQL updated to v16.4

Updated

56000: Security patch

v24.7
July 22, 2024
Added

44715: clientlicenseversion column to Power BI reports for filtering data by client license version

Fixed

47452: Multiple Family IDs within a single session

Updated

52227: SpringFramework to 5.3.26 version

Added

52474: Added the ability to filter data by server.โ€จ

Added

46223: Added the ability to send emails using SSL

Fixed

51790: In the process of updating data regularly (incremental ETL), there are repeated entries (duplicates) in the column named concusage within the table called featureusagemeasurehourly_splitโ€จ

v23.2
February 13, 2023
Added

42267: Added default settings configurations for .kettle

Updated

38789: Java version upgrade to OpenJDK11U-jrex64windowshotspot11.0.17_8

Updated

38789 : JDBC Drivers update (mariadb-java-client-2.7.5 mssql-jdbc-9.4.1 postgresql-42.2.9)

Updated

38789: Pentaho 9.3 upgrade

Fixed

42186: Target MSSQL transfer - "Cannot drop the view 'sys.databasefirewallrules', because it does not exist or no permissions"

Fixed

42234: Uppercase alias errors on a case-sensitive MySQL databases

Fixed

38100: PowerBI reports Hourly License Quantity calculation issue

Fixed

42109: Target database creation issues on MySQL

Fixed

41646: MSSQL Destination drop constraint error

Fixed

38560: License with no usage now is not displayed

Fixed

41718: Anonymization failure

Added

37738: The Used Dimension now has a "country" field

v21.11
November 17, 2021
Fixed

29623: Reporting hub: Cloud - ETL fails on the denials step when generating the month

Fixed

31235: Reporting Hub: a single feature has several rows in the DB

Fixed

31503: Reporting Hub: ETL is not collecting features with a version

Fixed

32515: Reporting Hub: ETL failure in customer's DB

Fixed

33621: Reporting Hub: ETL fails on indexes

Fixed

33745: Reporting Hub: Kettle path fix

Fixed

33815: Reporting Hub: ETL throws Invalid column name - INCREMENTAL=false recreates Postgres DB schema BUT not MS SQL schema

Fixed

33979: Reporting Hub not starting

Fixed

34034: Reporting hub is not creating Postgres database

Fixed

34036: Reporting Hub ETL fails on data extraction

Fixed

33933: Reporting Hub - ETL Status table is not logging failed ETL status

Fixed

34349: Reporting Hub: Latest ETL fails on UTF issues

Fixed

34497: Reporting hub ETL - maxusagedate variable is not found

Fixed

35126: Reporting Hub SaaS cloud ETL - transfer from postgres to mysql fails

Added

30141: Reporting Hub: Conversion mechanism for kettle files

Improved

30344: Reporting Hub: Kettle file - edit variable names to be more descriptive

Added

30559: Reporting Hub: Add table for host availability

Improved

31241: Reporting Hub: Data anonymization

Added

31242:Reporting Hub: Add status table

Improved

33490: Reporting Hub: Rename DB Connection variables to match Data Migration Tool

Improved

33666: Reporting Hub: MySQL denials transfer performance optimization

Improved

33682: Reporting Hub: Add Destination DB: Create functionality for the external transfer

Compatibility

33768: Reporting Hub: Align to the Versioning template

Deprecated

33878: Reporting HUB : Firebird deprecation

Added

33991: Reporting HUB : Add license expiration date to the reporting License ETL

Improved

34283: Reporting Hub ETL - Sequential runs per vendor

Added

35040: Reporting Hub ETL - remove denials stream that uses "LICENSE_ID"

v5.4
January 12, 2021
Added

29434: Reporting Hub ETL - Starting date variables

Added

29433: Reporting Hub ETL - Normalize value names

Fixed

29172L: Reporting Hub ETL - transfer to MSSQL happens twice

Fixed

29097: Reporting hub ETL - ETL_VERSION update fails

Fixed

29067: Reporting Hub - Remove requirement for temp folder

Fixed

27886: Reporting Hub - Denials sid_hourly not created correctly

Fixed

27859: Reporting Hub - Quantity table get deleted server data

Fixed

27207: Reporting Hub - Duplicates in workstation primary key

Fixed

26976: Reporting Hub - Transfering to MySQL fails

Fixed

26975: Reporting Hub - License Quantities are not showing up

Fixed

26744: Reporting Hub build - Live calculation folder is missing

Fixed

26527: Reporting hub - missing a column "License Manager type"

Fixed

26416: Reporting Hub - Reserverd licenses flag is not being considered

Fixed

26353: Reporting Hub - Denials query performance.

v5.0
July 19, 2020
Added

26101: Reporting Hub - Packages not working correctly

Fixed

25263: Reporting Hub - No success or error state in job

Fixed

25253: Reporting Hub - License quatity presented

Fixed

25227: Reporting Hub - Deleting temp tables fails

Fixed

24555: Reporting Hub - Additinal key value in external destination should be 1000 chars long

Added

24511: Date value is duplicated when transfering from Postgres to MSSQL

Fixed

22263: Reporting Hub - Automatically edit postgresql.conf and pg_hba files

Added

22262: Reporting hub ETL - Create DB automatically

Added

22190: Support case sensitive databases in Reporting Hub

Added

22185: Test Postgres 12 with Reporting Hub

Added

22017: Reporting Hub ETL - Daily run does not remove tmp tables

v4.5
September 19, 2019
Fixed

21641: Reporting Hub ETL runs slowly on MySQL for Phillips

Fixed

21639: Reporting hub ETL grabed duplicated value

Improved

21574: Redesign Reporting Hub to fit very large datasets

Added

19612: Reporting Hub - Increase license server name character count ( Varchar(100) --> Varchar(400) )

Added

16635: Reporting Hub - Implement the "Live" functionality in the current reports.

Fixed

16011: Reporting Hub - Hourly Concurrent Usage table showing wrong value

Added

16010: Reporting Hub - "Live" concurrent usage is slow on large databases

Added

16009: Reporting Hub - Add Candidate Expiration Date to License_Dimension table

v4.2
December 16, 2018
Added

14760: Reporting Hub - License Expiry in license file name

Added

14749: Reporting Hub - ETL workstation query taking a long time

Fixed

13391: Reporting Hub - Foreign keys fail when hostname is blank

Added

13176: Reporting Hub: "Live" concurrent queries

v4.0
October 16, 2018
Added

13175: Reporting Hub add and fix columns

Fixed

13174: Features with "-" cause issues with ETL

Added

13171: Reporting Hub - Faster Power BI, Trend line and sum values

Fixed

13170: Aggregated and raw tables give different results

Added

9204: Hourly aggregation in Reporting hub

Added

9199: Add nested groupping to Reporting Hub data structure

v3.4
November 12, 2017
Added

6698: Add "Projects" field to the Reporting Hub

Added

6202: Test PostgreSQL 10 with Reporting Hub

Skip to content