RDB-List or Obj-Browse methods provide incorrect date value
Pega sets incorrect date value to the date property while retrieving the date from Database; the date is of the previous day's (actual date minus 1). Whereas, in DB the correct value is stored.
While retrieving the date using RDB-List or Obj-Browse methods previous day's date is displayed. The time zone set in the operator profile and Server time zone are the same.
Steps to Reproduce
1. Retrieve date from DB using RDB-List and Obj-Browse.
2. Check for the date value in the clipboard page.
The root cause of this problem is a defect in Pegasystems’ code/rules. In DB, the date column type is Date and it should be of type Varchar for MSSQL. The Date column type is only supported currently for the DB2 database platforms and not for SQL Server. In Pega 7.1.8, logic had been added to throw a bad table mapping exception should a save into a Date column in platforms other than DB2 is attempted. However, in Pega 7.1.7 this exception logic is missing.
This issue is resolved by HFix-22311.
0% found this useful