Pyramid 2020.28 (Service Pack 8 for 2020.20) has been released. It includes a large collection of fixes for bugs and issues.

2020.28 vs Pyramid 2023

Pyramid 2023, the new major version of the Pyramid platform was released last week. It includes many new capabilities and features. It also includes numerous bug fixes for issues found in previous releases.

2020.28 is a service pack for the previous major version, Pyramid 2020. It captures many of the same bug fixes for issues found in previous releases (where relevant). However, 2020.28 obviously does NOT include any of the new capabilities. 

Therefore, customers wishing to upgrade their existing Pyramid instances to resolve issues can use either 2020.28 or 2023.00. However, 2020.28 will be the better choice for those customers wishing to upgrade without introducing the new functional changes and application upgrades of Pyramid 2023, until they have had a chance to test it.

There will be further service packs for Pyramid 2020 till the end of calendar year 2023 covering issues found in the platform. However, their focus will be on critical items only.

Software

• The main installer files can be downloaded from the Customer Portal. 
• Docker containers have been upgraded for Kubernetes deployments.

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 2020.28 includes changes to existing capabilities. It builds on other changes made since the last major release (2020.20). Please consult the notes for all versions from 2020.20 onwards on this forum to understand the impact on your deployment.

As such, Pyramid recommends testing the new release 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.

Items fixed

Model

• Fixed a visual issue where relationships disappeared after processing a model
• Fixed an issue where the Model failed to retrieve the table list of an Oracle data source
• Added "Show More" and "Copy to Clipboard" buttons to error messages that appear in the SQL Editor
• Fixed an issue in the master flow where links between nodes in the For Each loop got removed after moving them
• Fixed an issue where a For Each loop stopped running after 1000 iterations
• Fixed an issue that was causing a hierarchy order to change
• Fixed a "Cannot read properties" error when connecting to Microsoft Access data source
• Fixed an issue where it was not possible to run a Custom Query on a Microsoft Access File
• Fixed an issue where a Python script node error did not present a clear error message: AttributeError: 'NoneType' object has no attribute 'shape' changed to "outputDF is not a data frame"
• Fixed an issue where an Azure Blob source, only some of the files appeared in the Select a File dropdown
• Fixed an issue where Pyramid tried creating unique indexes when processing a direct query with Azure Synapse
• Fixed a mapping error when using Unpivot when the UI language is set to Hebrew
• Fixed an issue where elements that were dragged into a large data flow appeared in the wrong location when using the Hebrew UI language
• Fixed an issue where Table Preview in the data flow on a BigQuery DB was using select *
• Fixed an IRDB paging issue that caused a specific query to return inconsistent results
• Fixed an issue where processing a model based on BigQuery, which was using OAuth had failed with an "OAuth2Credentials instance does not support refreshing the access token" error
• Fixed a "Table does not exist" error when running a data model that writes to BigQuery
• Fixed an issue where incorrect roles were assigned to a new/imported model

Discover

    Queries

• Fixed an issue where  a query failed when using two Parent Child hierarchies and an AVG formula in a report
• Fixed an issue where a Search in a global parameter filter did not work
• Fixed an issue where a report appeared blank after a change to a combined elements filter
• Quick sort by values is now disabled when the cross-axis is empty
• Fixed an issue where using Change Caption on a BW attribute caused the measure format to change
• Fixed multiple cache issues
• Fixed an MDX error when using an MTD calculation on SAP BW
• Fixed an issue where Grand Totals were calculated incorrectly in an OLAP cube
• Fixed an issue where a discover failed to run with a "failed run SQL query in model source" error when loaded

    Visuals

• Fixed an issue where a line chart was cut off when the chart had a zero value and Auto Scale Bounds
• Fixed an issue where the Custom Y-axis Scale bounds did not allow negative values
• Fixed an issue where a report did not show results when moving between visuals unless Autorun was on
• Fixed an issue where some X-Axis labels were cut off
• Fixed an issue where axis values appeared with a scientific notation
• Fixed an issue that was causing the browser to crash when switching between Discovery tabs
• Fixed an issue where the Dimension Panel and Data Source information did not load in a Discovery report
• Fixed an issue where a Viewer user in Analyze Further could not add a Longitude measure into the Map Location dropzone
• Fixed a slicer issue that was causing a blank screen when clicking analyze further
• Added a new "Always start from 0" option in the Scale Bounds, allowing to hide negative values

Present

• Fixed a cascading filter issue which was causing the interacted content to fail after selecting all items in the filter
• Fixed an issue where adding multi-select tree filters from the same hierarchy to a Present caused the filters to keep loading
• Fixed an issue where targets could not be added to a tiled presentation
• Fixed an issue where a report in Analyze Further could not be modified
• Fixed an issue where a parameter that was dragged from a discover to a present could be set as a tree slicer
• Fixed an issue where a direct link to a Present opened the wrong present when using OpenID while in Incognito mode
• Fixed an issue where a filter did not run when running the presentation
• Fixed an Interaction issue from a grid to a mini tab
• Fixed an issue where changing the initial selection of a calculation that used a global parameter caused an error
• Fixed an issue where the Dynamic Text did not update on a Cover Page
• Fixed an issue where Present Mini tabs failed to load after clicking on undo/reset
• Fixed an issue where a Present based on a SQL data source was timing out after an upgrade to 2020.27
• Fixed an issue where multiple grid rows were highlighted after clicking on a single item on rows
• Fixed an issue where grid colors in mini tabs disappeared after moving between tabs

Publish/Subscriptions

• Fixed an issue where a change to the subscription time of a Presentation caused its filter selection to reset to the default value
• Added paging to the Schedule Manager for Viewer Users
• Fixed an issue where schedules stopped running due to a time zone change
• Fixed an issue where a subscription was printed with an incorrect filter selection
• Fixed an issue where bold text in a Publication was not applied to a printed PowerPoint output
• Fixed an issue where deleted filter caused a scheduled job to fail

Formulate

• Fixed an issue where a format string behaved differently after an upgrade
• Fixed a blank screen issue when editing a parameter

Illustrate

• Fixed an issue where a dynamic illustration was updated incorrectly based on a filter selection

Content Management

• Fixed an issue where a message saying "There was an error opening the file" appeared when trying to run or edit a Present
• Fixed an issue where the Search results returned deleted content for a Viewer user
• Fixed an issue where a user couldn't create folders under Workgroup content
• Fixed an issue where a user couldn't delete/purge items
• Fixed an issue where data sources marked as Favorites did not appear in the Favorites panel

Printing/Export

• Fixed an issue where exporting a Publication to PowerPoint had cut-off columns of the grid when using Scale to fit
• Fixed an issue where a pdf export was blank after exporting a map in discovery and selecting the No Scale option
• Fixed an issue where exporting to CSV did not work for a Tabular gird with Sort enabled
• Fixed an issue where a print to CSV contained the filter selection of the report
• Fixed an issue where a shape used as a background of a grid appeared on top of it in a print
• Fixed an issue where a drill-through action export contained more records than expected
• Fixed an issue where printing a tiled presentation with an illustration to a PDF produced a blank print
• Fixed an issue where zero values in a grid did not appear in an Excel export
• Fixed a formatting issue in Excel with content that contained multiple charts
• Fixed an issue where a Unicode character that appeared in an Excel print prevented creating a calculation within the Excel
• Fixed an issue where a hyperlink from a publication\presentation did not work in Word
• Fixed an issue where the order of elements in a grid was different between runtime and printing

Admin

• Fixed an issue where the "Reset Password Every XX Months" when using Database Authentication did not work as expected
• Fixed an issue where a SQL Connection parameter caused a connection error
• Fixed an issue where a Mongo DB connection did not work through Pulse
• Fixed an issue where NULL server name values got added to the db after an upgrade and caused an error when trying to view the databases in the Admin Console
• Fixed a Multitenancy issue where a domain admin could not view a data source on a different tenant
• Fixed an issue where an admin couldn't set up the auth method to Windows auth alternative account for SQL server
• Fixed an issue where changing Database List Technique did not reflect in the UI
• Fixed an issue where making bulk changes to the role security in the Data Source Manager did not take the selection in the Tenant Name filter into account
• Fixed a SQL data source connection issue where Pyramid did not use the custom port in the Port field
• Fixed an issue where the Pyramid ad groups failed to sync when using an Oracle repository
• Fixed an Azure Synapse connectivity issue after the 2020.27 upgrade
• Fixed an issue where testing a Databricks connection failed with a missing JDBC connector error
• Fixed an issue where an error 500 occurred when setting up the Oauth data source with incorrect details
• Fixed an issue where errors appeared in the system logs each time a user who didn't have access to the internet logged in
• Added a new "Enable characteristic structures" checkbox in the SAP BW server setting to fix an issue where BW measures appeared as attributes
• Fixed an issue where if Provisioning was disabled, Pyramid still tried to sync the AD groups set up in Provisioning jobs based on the "AD sync time interval" setting or when Run Now was clicked in the System Schedule
• Fixed an issue where Pyramid always used Sync Method 1 when clicking on Run Now in the System Schedule
• Fixed an issue where the System Info did not show accurate RAM info
• Added the option to manually enter a project name into the Big Query data source connection settings
• Added support for the "af-south-1" region for Amazon Athena
• Fixed an issue where a "Snapshot isolation" error appeared after uploading a new license

API

• Fixed an issue where purging a folder using the API didn't purge all the subfolders
• Fixed an issue where Pyramid showed an empty Proxy Account 2 after using /createUserSaml and adding a proxy2 value
• Fixed an issue where /access/getUser showed the principle name as the proxy account
• Improved performance of findcontentItem

Mobile

• Fixed an issue where the iPhone PyramidMobileAuth header had no value when logging in through SAML
• Fixed an issue where a preset that was opened with a Direct Link on an iPhone didn't resize correctly after rotating the screen
• Fixed an issue where the mobile application used the English UI language, although Hebrew was selected
• Fixed an issue where interactions didn't work as expected in a dashboard that was opened with a direct link on a mobile device
• Fixed an issue where a filter was unresponsive in a Present on the mobile app
• A new Android app version has been published

Other

• Fixed an issue where a Present appeared with the desktop layout when running on a tablet
• Fixed an issue where the upper toolbar of the iPhone was overlying the Present
• Fixed an issue where the size of bubbles on a map was inconsistent between a report and a report snapshot in a conversation
• Fixed an issue where after upgrading to Pyramid 2020.27, users couldn't log in via OpenID when using a proxy
• Fixed an issue where Snowflake OAuth failed to insert a token into the database or read it
• Fixed an OpenID log-in issue where it was not possible to log in due to a missing / in the redirect URL
• Fixed an issue where OpenID failed to authenticate when an array was sent in the OAuth Token
• Fixed an OpenID log-in issue after upgrading to 2020.27
• Fixed an issue where Pyramid was unreachable after restarting the routers
• Fixed an installation failure issue when using Oracle 19c as a repository
• The Pyramid Maintenance Tool now works on Linux