SR-A96203 · Issue 266909
CreateCase rollback corrected
Resolved in Pega Version 7.2.2
While creating a sub-case and getting an error on any end-step of flow, Pega starts the rollback of the process, but was saving pxCoveredInsKeys in the Clipboard page of Case. This was a missing use case in AddCoveredWork to call RemoveFromCover if an error was thrown while creating a child case along with copying page pages from cover to primary, and has been corrected.
SR-A91680 · Issue 259008
Resolved Null Pointer Error for resubmit of a corrected case with optimistic locking
Resolved in Pega Version 7.2.2
Work order case creation was throwing a null pointer exception in logs if optimistic locking was enabled on the case type and the case was resubmitted after correcting a validation error. This has been fixed with the addition of a null check for a clipboard page in use.
SR-A103064 · Issue 270247
Schema Change Tracking query performance improvements
Resolved in Pega Version 7.2.2
A query which was used in Schema Change Tracking (Designer Studio -> System -> Database -> Schema Change Tracking) was causing high CPU usage. This was due to the query having a full table scan which was using Information_schema, and the query has been rewritten for better efficiency.
SR-A88372 · Issue 259463
BIX log now includes BIX version info
Resolved in Pega Version 7.2.2
In order to enable better system tuning, the system has been updated to specify the BIX version in use in the logs. i.e. BIX Version : 7.1.9
SR-A89295 · Issue 258931
Result count option added to Campaigns for performance tuning
Resolved in Pega Version 7.2.2
Slowness was seen when launching and running Field Marketing Campaigns. This was an issue with loading results using pxRetrieveReportData with paging enabled, as it fetched the total result count for each page. To resolve this, an option has been added to pxRetrieveReportData to disable fetching of total result count. This is available as Embed-QueryInputs property of type TrueFalse called 'pyReturnResultCount' when running report using pxRetrieveSearchData's pyReportParamPageName Parameter.
SR-A100537 · Issue 268013
Optimized SQL query execution in multitenant systems
Resolved in Pega Version 7.2.2
SQL Query Execution was taking an excessive amount of time in a multitenant system when trying to retrieve a table which contained a given column and schema. To improve performance, the SQLGeneratorPostgres.getQueryForTablesWithColumn() query has been optimized.
SR-A99595 · Issue 267749
Error message displayed on UI for RAP import failure
Resolved in Pega Version 7.2.2
A build success message appeared after importing a RAP file even though the import process failed and an error was put in the log file. During the import process, the JSR94Client did not delegate any exceptions to the callers. This has been changed.
SR-A95888 · Issue 270679
MSSQL upgrade indexing updated
Resolved in Pega Version 7.2.2
After upgrade, an index was missing. Analysis showed the create index statement was using an include clause to add pzInskey in the index column list, which did not work on MSSQL because the DatabaseMetadata interface for the MSSQL JDBC driver did not return the columns in the INCLUDE list when a call to getIndexInfo was made. This resulted in a mismatch of the column list available in pr_changelog. This has been fixed, and automation has been added to detect this mismatch in the future.
SR-A87670 · Issue 256183
Better handling for external data source in the Upgrade utility
Resolved in Pega Version 7.2.2
An external data source included in the system configuration was being considered in the process of upgrade, resulting in an exception. To fix this, the UpgradeApplicationSchemaUtility has been modified to log errors with a message to rerun "Update Application Schema" from the landing page and then continue.
SR-A24411 · Issue 257220
Fastloader update error handling improved
Resolved in Pega Version 7.2.2
An issue was found where the FastLoader failed when an update to the vw table modified 0 instances. The update.bat script has been modified to better handle encountering data that did not get updated as expected.