Timezone for Delivery is 4 hr behind current time in EST | Community
Skip to main content
SheetalAgrawalSoni
SheetalAgrawalSoni
Level 2
August 6, 2020
Solved

Timezone for Delivery is 4 hr behind current time in EST

  • August 6, 2020
  • 2 replies
  • 4128 views

Operator timezone is EST

mid source user time zone is in EST 

App server time zone in EDT

WdbcTimeZone in options is America/New_York

 

Still my delivery , log , time and audit log all shows 4 hrs late time.. 

 

Please help 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SheetalAgrawalSoni

Solution :-

Revert back the oracle client to match the oracle database server version and restart. After that timezone will work as expected. however while investigating we did couple things -->

 

1. Changed the user timezone setting on MTA server

2. Changed the MTA server timezone

3. on Marketing Adobe Campaign side changed user timezone

4. on Marketing Adobe Campaign side downgrade the oracle client on app and web server to match the database version i.e. 12.1.0.2.0

5. Restarted all

 

2 replies

A
amritakedia_epsilon
Level 3
August 6, 2020

We had the similar issue . Make sure the Database client you are using in App Server is same version  as the Database server.

    A
    amritakedia_epsilon
    Level 3
    August 6, 2020

    oracle client installed on app server should be 12.1.0.2 . That should resolve the issue . After reinstalling the oracle client to 12.1.0.2

     

    1. Copy the tns entry for the  database to the new tnsnames.ora file.
    2. Modify the PATH variable to point to the new Oracle client install .
    3. Restart the Adobe services
    SheetalAgrawalSoni
    SheetalAgrawalSoniAuthorAccepted solution
    Level 2
    August 8, 2020

    Solution :-

    Revert back the oracle client to match the oracle database server version and restart. After that timezone will work as expected. however while investigating we did couple things -->

     

    1. Changed the user timezone setting on MTA server

    2. Changed the MTA server timezone

    3. on Marketing Adobe Campaign side changed user timezone

    4. on Marketing Adobe Campaign side downgrade the oracle client on app and web server to match the database version i.e. 12.1.0.2.0

    5. Restarted all

     

    Terms & ConditionsAccessibility statement

    Loading footer...