SR-126901 · Issue 190603
Handling added for temp install directory names with spaces
Resolved in Pega Version 7.1.8
If the install directory name contained spaces, the install failed at the point where the directory was used as a script parameter due to the parsing handling the name up to the space as one parameter and after the space as another parameter. In order to resolve this, handling has been added to allow temp directory names with spaces.
SR-127210 · Issue 190272
Added table-based cataloging
Resolved in Pega Version 7.1.8
The Update Manager catalog has been updated to reside in the Pega database instead of in the file system. This will facilitate cataloging in a multi-node environment, allow for reporting and other visibility into the catalog itself, and improve performance of dependency checking.
SR-127319 · Issue 197788
Updated cache searching for Obj-Browse on a class mapped to external table
Resolved in Pega Version 7.1.8
Unnecessary queries were being fired while using Obj-Browse on a class mapped to external table. This was caused by a class mapped to an external table and using Obj-Browse on that class fired queries to the metadata to get the columns instead of searching in the caches. The system has been updated so that the caches are read instead of firing querying the metadata every time to get the list of columns.
SR-127380 · Issue 192186
Resolved problem importing work objects into tenant layer
Resolved in Pega Version 7.1.8
Trying to import a RAP containing several work objects into the tenant layer of a multitenant system generated errors including "Import cannot proceed due to conflicting rule instances." This was caused by certain import restrictions regarding work objects belonging to a shared content class that were set during the initial development of multitenancy which are no longer required; these have now been removed.
SR-127803 · Issue 192265
Error information enhanced for Connector wizard working with external Teradata DB
Resolved in Pega Version 7.1.8
When using Teradata as an external DB, an exception was generated while using the SQL connector wizard and no rules were generated. This was caused by passing a date column that was not supported. The error has been addressed to make it more informative, but at this time the classes and properties for the fields and the mapping of the classes to the associated tables must be done manually. If the decision is made to use Date/Time properties that are mapped to Date fields, there may be time zone conversion issues. Further, mapping a Date property to the DATE column will allow the field to come across from a report definition but will not work as part of the filter (e.g. EFFT_DATE > "2014-12-01").
SR-128178 · Issue 192632
DataOnly upgrade modified to handle pr_data_products tables
Resolved in Pega Version 7.1.8
Running the upgrade.bat dataOnly true to upgrade the data schema failed while trying to insert values into the pr_data_products table. Promoting upgraded rules schema to higher environments and then upgrading the data schema is a supported upgrade procedure, but the dataOnly upgrade did not take this into account. The system has been updated such that when migrating post upgrade, it will not migrate pr_data_restore and pr_data_products tables and will fail if there are uncommitted hotfixes.
SR-128285 · Issue 193082
Added handling for column size mismatch on Oracle import
Resolved in Pega Version 7.1.8
When upgrading versions of CMF, errors were generated when importing the Pega jar file. The exported schema has pyAccessibility and pyBrowserSupportLevel datatypes as "integer" with size 10, but on the target Oracle database the same column was defined as Number with default precision and scale (0, -127). While importing, the logic checks for column compatibility and was generating an alter statement based on this scale mismatch. This has been resolved by modifying the system to detect that the metadata is returning the new style of NUMBER column metadata handling it correctly.
SR-128475 · Issue 194266
DB Trigger logic refactored for better vw table syncing
Resolved in Pega Version 7.1.8
There are many times in customer environments where for whatever reason the database triggers are disabled for a period of time and thus the vw table gets out of sync. Typically in that case the triggers are reenabled and a statement like "update pr4_rule_file set pzinskey=pzinskey" is run to get the vw table populated correctly. However, if the system was being upgraded the statement would update an existing row in the vw table but it would not add any missing rows to the vw table during migration. To ensure that all rows are handled correctly, trigger logic has been completely refactored for 7.1.8.
SR-128932 · Issue 194789
Added support for -x and -y parameters to ApplicationBundle import
Resolved in Pega Version 7.1.8
Previously, the use of the -x and -y parameters in the command line utility prpcUtils only worked with PegaArchives and not ApplicationBundle archives. In order to facilitate automation, the app bundle command line import command now honors the -x (override) and -y (skip) import parameters, and these options will be passed along to any nested par files.
SR-131199 · Issue 201548
Smoothed editing of data tables mapped to external DB
Resolved in Pega Version 7.1.8
It was not possible to edit a data table mapped to an external database table with column name different from that of the property. To resolve this, the system will ensure that the external mappings take precedence while trying to update the data table.