November 2021 Dashboard Release Notes
Original Release Name - pi.2021-11-25
Patched Release Name - pi.2021-11-25.1
Patched Release Name - pi.2021-11-25.2
Patched Release Name - pi.2021-11-25.4
Original Release Date - Dec 9, 2021
Patched Release Date - Dec 13, 2021
Patched Release Date - Dec 16, 2021
Patched Release Date - Dec 20, 2021
We are pleased to present our latest offering of pi - our November 2021 release! This page helps summarise and familiarise you with the changes we have made, and is supported (where applicable) with useful videos to help explain the changes we have delivered.
Dec 13, 2021 - in response to a Java security vulnerability around Log4J2, we have opted to patch our November dashboard release to mitigate against any risks. More information can be found HERE.
Dec 16, 2021 - because of the need for customers to upgrade to the latest version of the dashboard, to benefit from Log4J2 patches, it is imperative that the release notes and upgrade documentation is read and understood before attempting to upgrade, so you are aware of the changes made to the dashboard and any additional configuration that you may need to change to complete a successful upgrade. We always suggest attempting upgrades in non Production environments beforehand.
Multiple customers have recently attempted to upgrade through multiple versions, and have come across issues around environment variables, proxy and embedding settings - for more information on these areas, we recommend reviewing the Embedding Dashboard & Charts page first
Before upgrading, we recommend taking a backup. You can find more information here.
Here’s what we’ll cover;
- 1 Added
- 2 Changed
- 2.1 Response to Log4J2 vulnerability - updated Log4Shell versions
- 2.2 Adjusted file maintainance process during upgrade processing for Log4J
- 2.3 Increase VALUE field in MIS_VARIABLES (Zendesk#17239)
- 2.4 Remove maxSize restrictions from user interactable domain object fields
- 2.5 Removal of Apache Drill & FireBolt JDBS drivers (precaution)
- 3 Fixed
- 3.1 Improved dark theme so that text colours can be applied properly (Zendesk#10782)
- 3.2 Data with special characters on crosstab headers (Zendesk#17098)
- 3.3 Content Unavailable Message (Zendesk#16321,17164,17280,17592)
- 3.4 Dashboard updates the password for Data Connection ID 21 (Zendesk#17658)
- 3.5 ‘Can Be An Email Recipient’ privilege inherited from role (Zendesk#17661)
- 3.6 Display value as percentage by column on crosstabs
- 3.7 API - Importing users and variables (Zendesk#18078,18790)
- 3.8 Improved UI performance for importing larger data connections (Zendesk#17975)
- 3.9 Enable free hand sql charts in reports to be visible to users without permissions (Zendesk#18113)
- 3.10 Prevent blank schedule jobs being displayed in piReports Monitoring
- 3.11 Unable to use generic/ custom OpenID connector (Zendesk#18170)
- 3.12 Configuration tool not updating database username (Zendesk#18563,18626)
- 3.13 Internal port doesn’t always work as the dashboard URL (Zendesk#17270,17298,17632)
- 4 Keeping An Eye On pi
Added
Role level variables and restrictions
User Settings
Role level variables and role level restrictions have been added to the system. This means that the system now has a more flexible way to provide variables and restrictions to a user.
previously, if 10 users shared the same variable you would need to add that variable to each individual user
now, you can create a role with a variable and if this role is then assigned to 10 users, they would all have this variable
the same concept also applies to role restrictions
Please look at Role Level Variables for more information.
Video
We’ve created a short video to explain this in a bit more detail.
New Magic Variables (Zendesk#16540)
Variables
2 new magic variables have been added:
LANGUAGE_LOCALE- locale from language selection on the login screen (these selectable options are configured from dashboard installation on the server machine)LOCALE- locale of a user's browser, which generally is used for date formatting (this reflects whatever locale a user set on their browser)
Changed
Response to Log4J2 vulnerability - updated Log4Shell versions
Security
Patched Release 2021-11-25.1 - updated Log4J2 library to version 2.15.0 in response to security vulnerability (CVE-2021-44228).
Patched Release 2021-11-25.2 - updated Log4J2 library to version 2.16.0 in response to security vulnerability (CVE-2021-45046)
Patched Release 2021-11-25.4 - updated Log4J2 library to version 2.17.0 in response to security vulnerability (CVE-2021-45105)
Adjusted file maintainance process during upgrade processing for Log4J
Security
There will only be 1 version of log4j in the dashboard installation files, showing the latest version
Files are located here:
C:\Program Files\Installation_location\Dashboard\tomcat\webapps\panLicenceManager\WEB-INF\lib
C:\Program Files\Installation_location\Dashboard\tomcat\webapps\panMISDashboardResources\WEB-INF\lib
Increase VALUE field in MIS_VARIABLES (Zendesk#17239)
Configuration
A ‘value’ field in the MIS_VARIABLES table has been changed from varchar(4000) to long text in order to accommodate longer text inputs.
Remove maxSize restrictions from user interactable domain object fields
Configuration
maxSize restrictions have been removed from the following interactable domain objects:
MisChartColumn.operandTwo
MisColumn.columnName
MisDataSourceItem.driverClassPath
MisDefinedChart.helpText
MisDefinedChart.chartLevelStyles
MisFilterColumn.operandOne
MisFilterColumn.operandTwo
MisHierarchy.accessibilityMessage
MisHierarchy.htmlCardStyleSheet
MisHierarchy.customSql
MisHierarchy.svgUrl
MisHierarchyColumn.urlLink
MisLayoutText.text
MisParameter.hierarchyId
MisParameter.orderingIndex
MisPreferredLayout.layoutXml
MisReportFilter.defaultValue
MisReportLayout.layout
MisReportMedia.positioningStyle
MisReportMedia.formattingStyle
MisReportMedia.text
MisReportMedia.imagePath
MisSchedule.emailMessage
MisScheduleAttachment.webServiceUrl
MisScheduleJob.error
MisSecurityUser.clientPassword
MisSecurityUser.encryptedPassword
MisTable.tableName
MisTable.whereClause
MisTable.tablePriority
MisTableJoin.joinSql
MisUserRestriction.orderingIndex
MisVariable.value