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
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
We had the similar issue . Make sure the Database client you are using in App Server is same version as the Database server.
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
So above is the oracle client version in the ACC App server? What is Oracle Server version?
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
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 ?
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies