Support Article
RDB-List or Obj-Browse methods provide incorrect date value
SA-12463
Summary
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.
Error Messages
Not Applicable
Steps to Reproduce
1. Retrieve date from DB using RDB-List and Obj-Browse.
2. Check for the date value in the clipboard page.
Root Cause
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.
Resolution
This issue is resolved by HFix-22311.
Published July 29, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.