Pyramid 2023.15 Released

Itamar_Birenzweig
updated 2 days ago

Pyramid 2023.15 a service pack for Pyramid 2023, has been released. It includes fixes with a few minor features. Importantly, it includes the release of API 3.0 which has breaking changes from the prior beta.

It should be noted that Pyramid 2024 LTS "Fibonacci" has also been released and is functionally equivalent to 2023.15.

Software

The main installer files and client SDKs can be downloaded from the Customer Portal.
Docker containers have been upgraded for Kubernetes deployments.
Upgraded Embed API libraries can be downloaded from NPM.

Installation & Upgrade Guidance

Main Installation guidance can be found here.
Help for upgrades can be found here.
Help on how to test an upgrade before deployment can be found here.
Help for Kubernetes deployments can be found here.

Cautions

Pyramid 2023.15 includes a number of changes to existing capabilities. As such, Pyramid recommends that the new release be tested on a duplicate version of an existing content database repository before any production upgrades are applied.

Further, a database repository backup should be made before upgrading any production systems and repositories.

New Capabilities and Changes

Features

DataDog Log Shipping - Added support for shipping Pyramid logs to DataDog
MS Fabric support - Pyramid now offers support to connect to Microsoft Fabric
New Conda options - added support for the Python Conda-forge repository as well as a new option to switch between Conda-forge and Anaconda.
Upgraded Java 17 - change to Java 17 to close vulnerabilities found in earlier release of Java 17.
API3 is now in GA - Previous beta and release candidate versions of API3 now upgraded to full General Availability. There were a last round of adjustments made to API3 as described below.

API3 breaking changes for GA release

Function	Description	Changes
getUserByPrincipalName	Find users using their “principal name” as specified in the SSO engine.	Function renamed to getUserByExternalId
createUsers	Creates users	Input object (CreateUserObject) was changed. PrincipalName was renamed to ExternalId within the parameter
getUserByExternalId getUser getTenantUsersByUserType getUsersByName getUsersByRole getMe	Functions that retrieve user information	Output object (PyramidUserObject) was changed. PrincipalName was renamed to ExternalId within the output
updateUsers	Updates users	Input object (UpdateUserObject) was changed. pPincipalName was removed from the input object.
suspendSchedule	Pauses or suspends the processing of an active schedule	Domain admins can use this function with with data permissions
resumeSchedule	Resumes the processing of a paused or stopped schedule	Domain admins can use this function with with data permissions

Deprecations

The database driver for MS SQL Server has been upgraded to be compliant with new Microsoft data technologies (like Fabric). The driver drops official Microsoft support for SQL Server 2012 and earlier. However, anecdotal testing shows SQL Server 2012 still works with this driver. Customers should migrate off older versions of SQL Server to avoid issues.

Items Fixed

Model

Fixed an issue where a user was getting a "Permission Denied" error when trying to execute a model
Fixed misaligned column headers in the Preview panel
Fixed a blank screen issue when clicking on Translations in Model
Fixed an issue where the drop-down to select an existing semantic model didn't appear for a user with a Model Only role
Fixed an issue where a user with a role granting Read permission on a Model couldn't process it due to an additional role with Model Only permission
Fixed an issue where a Table Filter was removed following an export/Import
Fixed an issue where a Table Filter didn't work for datetime columns in Oracle
Fixed an issue where a Calculated Column produced Null results
Fixed an issue where a Null error message appeared after clicking on "Data Model"
Improve the method of selecting bridging tables in diamond-shaped models
Fixed an issue that was causing multiple jobs of the same schedule to run simultaneously
Fixed an issue where a scheduled process failed when Sync All was enabled
Better handling of canceled or timed-out JDBC queries during ETL preview
Fixed an issue where a Join failed with a "Double cannot be cast to" error
Fixed an issue where an error message appeared upon opening a Master Flow in an existing model
Added Simplified Chinese to the list of Model Translations

Discover

Queries:

Fixed an issue where reports containing multiple Parent-Child Hierarchies in Filters, combined with a custom List, failed to load
Fixed an issue where Discovery Chat queries involving a time dimension didn't return results for OLAP and Tabular
Fixed incorrect Dice results when Auto Run was disabled
Fixed an issue where a Null member appeared in a grid although it was unselected in the filter
Fixed a Custom Order issue that caused a Discovery to open with a "Cannot read properties of undefined (reading '0')" error
Fixed a Hierarchy Security issue that caused reports to display a "not enough information" message upon opening
Fixed an issue where a Pre Query filter wasn't being applied

Visuals:

Fixed incorrect tooltips for Increase\Decrease border width
Fixes incorrect Calendar Slicer caption
Fixed an issue where the "Default Member" selection of a slicer was changed after an upgrade when using an OLAP source
Fixed an issue where some charts were not visible when using Safari on a Mac
Fixed an issue where Data Labels did not appear in a Marimekko chart
Fixed an issue where a Bubble displayed incorrectly on a Map chart when using a multi-select filter

Present

Fixed an issue that caused an "Error loading component" message to appear when clicking on a Waterfall chart interacting with another visual
Fixed an issue where the number of items in a filter did not respect the admin Result Limit setting in a Discovery report
Fixed an issue where the Search icon for a New Slicer was out of place for a BW source
Fixed an issue where Adding a filter in Presentation using the "Add New Slicer" button was not working on SAP BW source with predefined parameters
Fixed an issue where the Initial Selection was not applied after changing a slicer type
Fixed a permission issue that was causing a Presentation to show cached data in illustrations
Fixed an issue where a filter was cut in a Scrollable Panel
Fixed an issue where a Mini Tab didn't appear in Edit Model while it did appear during Runtime
Fixed an issue where the Advanced Slicer Initial Selection Mechanism was not working as expected
Fixed an issue where Dropdown Navigation didn't work as expected in embedded presentations
Fixed an issue where a tooltip didn't appear for selections in a Hierarchy Tree filter

Publish

Fixed an issue where a monthly schedule for the first Monday of the month had failed to run
Fixed an issue where the distribution of a Publication had failed when using File Mapping with a CSV file that contained commas
Resolved an issue where a Publication Schedule did not function as expected after a change in the case of a member caption used in a filter within the schedule
Fixed an issue where Dynamic Text printed intermittently with unexpected values
Fixed an issue where a dynamic text in a Publication with a Page Repeater showed wrong results once printed

Formulate

Fixed an issue where a Direct query column calculation could not be aggregated
Fixed an issue where a Custom Column didn't update in cases it was using a Parameter in conjunction with a custom measure
Fixed an issue where the StrToMember function failed with a "Can't run the given query" error
Fixed an issue where the title of a Model Parameter was changed to a dimension name after a metadata refresh
Fixed an issue where the Date() function did not work when using the Informix data source

Content Management

Fixed an issue where a Presentation export did not include a one-off parameter
Fixed an issue where a user could not access a Present in Workgroup content after saving an old version
Fixed an issue a pie file that was exported without related content had failed to import
Fixed an issue where a user was unable to access public content folders in Favorites
Fixed an issue where the import replace function did not delete Discovery actions when replacing a Discovery containing an action with one that does not
When editing a content Description field, clicking outside the field now saves the changes automatically
Fixed an issue where new imported content was mapped to a deleted materialized model

Printing/Export

Fixed an issue where hyperlinks in a grid were not correctly exported to Excel and PDF
Fixed an issue printing a discovery with a line chart and a measure list to Excel
Fixed an issue where a grid was printed to Excel with a background color although "Ignore Styling" was checked
Fixed an issue where a Publication print failed due to an issue with a Map visual
Fixed an issue where an image in a Present was missing in the printed output
Fixed an issue where the Document Format of a Publication Print Action could not be changed

Admin

Fixed an issue where a customized help URL persisted after changing to a license without White Label
Fixed an issue that was preventing new users from being added successfully
Fixed an issue where the Router service could not be restarted from the UI
Fixed an issue where Administrative Alerts displayed the Machine ID instead of the Machine Name
Fixed an issue where deleting a user failed due to a large number of items in its Private Folder
Fixed a "value too long for type character varying(256)" error when adding an Open AI key
Fixed an issue where a 'Failed Login - Missing authorizationHeader' error appeared in the Entries Logs following a successful Basic Auth login
Fixed an issue where the Server Instances page showed different times for the same machine

Other

Fixed an issue where the Maintenance Tool failed to run due to LogShipper Errors
Fixed an issue where a Kubernetes deployment timed out when selecting to use an existing repository
Fixed an issue where "Analyze Further" was not working on an iPad
Fixed an issue where Data Labels were cut off in a Chart on an iPad
Fixed an issue which was causing the upgrade to fail when using Helm on Kubernetes
Fixed an issue where subscriptions were running on a task server configured to run data flows only
Fixed an issue that was causing multiple "Can't run k8s pod monitor" error messages to appear in the logs after adding a Windows Connecter in Kubernetes
Fixed an issue where adding a new Python environment using the offline AI pod failed
Fixed an issue where Illustration Dynamic Color didn't work on Embed in the initial load
Improved error message for a Migration Destination test failure
Fixed an issue where no loading icon appeared when loading an embedded presentation with pre-query slicers
Fixed an issue where deploying Pyramid on OpenShift didn't work with the default YAML
The Conda version was upgraded to 24.5.0
Fixed an issue with the number of satellites generated when using the 'load balanced' option in the task engine
Various Help improvements