Question
Wipro
IN
Last activity: 7 Aug 2023 10:34 EDT
inflight cases showing different dates
Hi All,
recently our application got upgraded from 7.2 to 8.5v. before migration data back up was taken and also sql also upgraded to 19c version and loaded with data.
So when we are opening the Same inflight cases in PEGA7 and PEGA 8, there is a Difference in dates for the existing data in the inflight cases. but new actions are capturing with same dates data in both the environment. So no issue with new cases. when Dates on UI Compared with DB data, there is a difference of 10+ hours.
I've also checked DB columns and data , both are having the same data. also checked locale and time zone of operator, that is also same in both environment.
Still we are seeing a discrepancy in dates for inflight cases in PEGA 8 UI.
please help on this.
Thanks in Advance
Accepted Solution
Updated: 29 Jul 2021 2:05 EDT
Wipro
IN
Thank you for your valuable suggestions.
we observed the timezone difference in our JVMs and we changed to required. so now we are able to see the same dates in both PEGA 7 and PEGA 8 cases.
Thank you
Pegasystems Inc.
IN
What is the timezone set in both pega 7 and pega 8 database servers? Can you please run belwo query and confirm whether there is no difference in timezone set for both database servers?
SELECT DBTIMEZONE FROM DUAL;
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions039.htm
Wipro
IN
Thank you for your reply.
when i ran the query i'm getting the time zone as below.
PEGA 7 DB: Australia/Victoria
PEGA 8 DB: +11:00
please let me know if you need any other info.
Thanks in Advance
Pegasystems Inc.
IN
It seems to me that pega 7 databse server has timezone set as AEST which is utc +10. However, in your pega 8 instance the timezone is probably set as AEDT (for daylight saving) i.e utc+11 which might be why you see a difference of one hour. Please work with your database server administrator to verify whether daylight saving is causing this difference for inflight work objects. Thanks.
Wipro
IN
thank you for your reply.
Small doubht.
how the time zone of DB affect the values showing on PEGA UI ?
also i have checked the values of pxcreatedatetime column in both PEGA 7 and 8 DB, both are having the same date time values. only on PEGA UI values are different for pxcreatedatetime.
also i have checked controls and Properties details in section, all settings are same in both PEGA 7 and 8. even then value showing differently in PEGA 8.
Thanks
Pegasystems Inc.
IN
@Adarsha_Mohan I may have slightly misunderstood the problem earlier.
I think pxCreateDateTime is captured in GMT and showed as per user's locale at run time.
However, some date functions use app server jvm time zone. Please go through the community link to see if your issue is related to this.
Inconsistency in DateTime property values | Pega\
If this doesn't solve your problem, I would advise you to report the incident to Pega support for further troubleshooting. Thanks.
Updated: 29 Jul 2021 2:02 EDT
Wipro
IN
Thank you for your reply.
user ID locale is same and data saved in DB is also same in both 7 and 8 environments. only in UI we are observing this difference in dates.
we will check once app server JVM time zone whether we have same or different.
Thank you so much for your valuable time and inputs.
Accepted Solution
Updated: 29 Jul 2021 2:05 EDT
Wipro
IN
Thank you for your valuable suggestions.
we observed the timezone difference in our JVMs and we changed to required. so now we are able to see the same dates in both PEGA 7 and PEGA 8 cases.
Thank you