SR-A5258 · Issue 213386
Documentation updated to reflect change to read-only getProperty pages
Resolved in Pega Version 7.2
In recent versions of the system, getProperty() was modified to support the creation of a property on a read-only page. However, even though the property has been created, it is not possible to set its value. This was not clearly indicated in the documentation, and read-only exceptions were being generated when putString() or setValue() attempted to give a value for the property on a read-only page. The documentation has been updated to clarify this use case.
SR-A6768 · Issue 215093
JDBC connection URL documentation updated for JBOSS installation
Resolved in Pega Version 7.2
An error was found in the JBOSS installation document: the JDBC connection URL defined inside the standalone-full.xml should not have forward slash (/) before the database name, i.e. the format below is incorrect: jdbc:oracle:thin:@//localhost:1521/dbName Instead, the forward slash before data name should be changed to a colon (:), for example: jdbc:oracle:thin:@//localhost:1521:dbName This documentation issue has been resolved by adding a section clarifying the necessary connection information and the method for creating a connection string, along with updating all connection-url steps to either include this information or a pointer to the new section.
SR-A5730 · Issue 213019
Namecase check added to DB2/ZOS split schema installation
Resolved in Pega Version 7.2
An omission in the documentation for the installation wizard guiding the creation of a split schema on DB2/ZOS failed to specify that the database username on the UI screen or in the setupDatabase.properties file as well as the properties in the DB2SiteDependentProperties file are required to be in all upper case. As a result, some installations experienced a runtime exception and an unexpected process termination due to name mismatch. The documentation has been updated. and a check has been added which will take a supplied mixed/lower-case user name and uppercase the value used to set the currentSQLID parameter.
SR-A8556 · Issue 218132
Removed unexpected 'History-' DB instances
Resolved in Pega Version 7.2
Due to an error, 61 additional Data-Admin-DB-Table instances that should not have been part of the media were packaged in the software distribution. The impact was low as all started with 'History-' and contained the name 'Engineering', but their presence and lack of matching associated Class Definitions caused them to be reported on the Database Landing page as "Invalid Class Mappings". We apologize for this confusion.
SR-A5183 · Issue 213803
Added check to ensure all invalidated shortcuts are processed correctly
Resolved in Pega Version 7.2
When running SQL server version 2012 with a particular JDBC driver, executing a DML statement without setting the pyMaxResultCount caused the number of records returned to be limited by the default record size, and the system was not picking up the latest versions of all of the rules after shortcuts were invalidated. To resolve this, the method invalidateShortcuts(RACacheAppCentricImpl) has been modified to set pyMaxRecords to zero when calling executeRDB so that all the impacted rows are processed.
SR-A5233 · Issue 212884
Added external DB support for DB2 v.8
Resolved in Pega Version 7.2
After upgrade, trying to connect to DB2 ver 8 as an external database generated the error "SQLCODE: -4700 SQLSTATE: 56038 Cannot connect to DB2". This was due to Method getSchemaName(SQLGeneratorDB2) firing a query which is valid only on a higher/supported version of DB2. To accommodate other versions of the database, the system will fallback to the V8 syntax if the higher-level query fails.
SR-133085 · Issue 210184
DATE support added for SQL
Resolved in Pega Version 7.2
Support has been added for using the Date column type with SQL servers in cases where the DB supports the DATE type.
SR-A7048 · Issue 215222
DATE support added for SQL
Resolved in Pega Version 7.2
Support has been added for using the Date column type with SQL servers in cases where the DB supports the DATE type.
SR-A3331 · Issue 208297
Enhanced added for non-logging config settings
Resolved in Pega Version 7.2
Both the upgrade process and Pega7 run-time make use of non-logged operations for major performance improvements. However, High Availability Disaster Recovery (HADR) database environments use database logs to replicate data from the primary database to the standby database. This caused a conflict that resulted in the unexpected termination of upgrade scripts. An enhancement has been added to make the logging function configurable (the default is No Logging = true), and tuning was done to make logged SQL generation faster to improve system performance when logging is enabled.
SR-A4488 · Issue 214464
Improved system performance for SQL using ReserveQueueItem
Resolved in Pega Version 7.2
The SQL generated using the stored procedure sppr_sys_reservequeueitem_b has been tuned to improve system performance for all database implementations; DB2, MS SQL Server, and Oracle.