search

pegasystems / pega-helm-charts

Orchestrate a Pega Platform™ deployment by using Docker, Kubernetes, and Helm to take advantage of Pega Platform Cloud Choice flexibility.
https://community.pega.com/knowledgebase/articles/cloud-choice
Apache License 2.0
120 stars 193 forks source link

Timezone Difference issue #710

Open BUHPS2261R opened 4 months ago

BUHPS2261R commented 4 months ago

Describe the bug There is a time-zone difference between OpenShift PODS and PostgreSQL DB, OpenShift Cluster. We set the env to use TZ=Asia/Riyadh and it is still showing UTC time in the OpenShift PODs. But Both OpenShift Cluster and PostgreSQL server set to UTC+3 (Asia/Riyadh).

To Reproduce connect to OpenShift terminal of the pega container.

Expected behaviour Date and Time should display the UTC+3 time zone.

Chart version Version: 1.2.0, Overall Helm charts package 3.6.3

Server (if applicable, please complete the following information):

Additional context Findings & Approaches followed to fix the issue and none of them were successful

  1. Tried Passing the JVM Argument: -Duser.timezone="Asia/Riyadh"
  2. Created a configmap in the web deployment with below parameter kind: ConfigMap apiVersion: v1 metadata: name: timezone namespace: pegadev data: TZ: Asia/Riyadh
  3. Updated the _pega-deployment.tpl with below setting containers:
    • name: pega-web-tomcat image: {{ .root.Values.global.docker.pega.image }} env:
      • name: TZ value: "Asia/Riyadh"
  4. used the oc command: oc set env deployments/dc_name TZ=Asia/Riyadh
  5. used the oc command: oc set env deploymentconfig/dc_name TZ=Asia/Riyadh
  6. Tried all other instructions mentioned: https://access.redhat.com/solutions/2567961
kishorv10 commented 2 months ago

@BUHPS2261R Are you facing any functional issues in the platform due to this difference? Are the rules create/update timestamps correctly reflected in the database & retrieved in the application?

connect to OpenShift terminal of the pega container.

Do you mean the pod OS time stamp is not honouring the timezone?

I wanted to understand the problems you are facing due to the mismatch.

BUHPS2261R commented 2 months ago

Differneces facing: POD Shell Time zone and Pega Application Logs are different timezones. By default, UTC time zone being noted for application. But we want everything to be in KSA Time Zone.

Yes, The POD & logs stamps are not honouring the time zone.