Question

1
Replies
692
Views
Shital Mitkari (ShitalM9)
Bank of America
AVP
Bank of America
US
ShitalM9 Member since 2013 6 posts
Bank of America
Posted: March 26, 2018
Last activity: November 30, 2018
Posted: 26 Mar 2018 17:24 EDT
Last activity: 30 Nov 2018 14:39 EST
Closed
Solved

pxCommitDateTime in work history table issue after daylight saving

In work history table pxCommitDateTime lags behind the pxTimeCreated that’s where we observed after recent daylight saving began on 11th March 2018 and the issue last for 1 week. Our BIX process is based on the pxCommitDateTime and because of this time lag issue we missed few data to extract for that week as per our logic. Ideally what I understand pxCommitDateTime must be either equal or greater than pxTimeCreated for any history item getting added.

We are using DBaaS (Oracle 12.xx) where date time is all based on GMT.

  1. Just wonder to see why this time lag has happened for 1 week and then diminish on its own

  2. Why there is lot of time gap between pxCommitDateTime and pxTimeCreated. For example, we are seeing pxCommitDateTime is 6 to 10 hrs ahead of pxTimeCreated? Does it mean Pega OOTB commit take so long to commit the data?

So two contradictory things are observed here –

  1. pxCommitDateTime < pxTimeCreated. Where ideally it should be more than pxTimeCreated. This issue last only for 1 week after daylight saving

  2. pxCommitDateTime is way more than pxTimeCreated that we observed continuously.

Please see the attachment indicating these 2 issues.

***Moderator Edit: Vidyaranjan | Updated SR details***

Case Management Data Integration Support Case Parallel
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.