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
  • 4133 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.

    SheetalAgrawalSoni
    SheetalAgrawalSoniAuthor
    Level 2
    August 6, 2020

    ACC app server , Web server and Database is hosted in our own env only mid soucring is on adobe env. So yes its hybrid, as mid sourcing server is with Adobe. Oracle database version is 12.1.0.2 and oracle client installed on app server is 12.2.0.1.0. Seems Oracle client installed on app server is little latest version but that should not be problem. isnt it ?

    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...