Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us