How to correct the data base time zone of ACC | Community
Skip to main content
Y
yueminspb
Level 3
January 18, 2021
Solved

How to correct the data base time zone of ACC

  • January 18, 2021
  • 1 reply
  • 1534 views

Hi team,

We might have a incorrect config during the initiation of the ACC database. That is the database time zone like below:

 

We can not re-install this ACC, please show me the way to adjust the time zone of data base, thank you very much

 

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 Darren_Bowers

Hi @yueminspb - we have been over this with Adobe techops with one of our instances and we have been told that there is no way to change the timezone of the server or database once the system has been configured. All dates/times in the database are stored as UTC, so this means you need to ensure that your workflows are executing in the correct timezone by setting the properties of the workflow, otherwise they will run in the Default (server) timezone. It's worth creating a workflow template to ensure this is always set.

You also need to ensure that your Operators have the correct timezone set so they see the dates for logs etc being correctly adjusted to the right timezone. If you do both of these, you wont really notice the incorrect server/db timezone.

Thanks

Darren

1 reply

Darren_Bowers
Darren_BowersAccepted solution
Level 9
January 18, 2021

Hi @yueminspb - we have been over this with Adobe techops with one of our instances and we have been told that there is no way to change the timezone of the server or database once the system has been configured. All dates/times in the database are stored as UTC, so this means you need to ensure that your workflows are executing in the correct timezone by setting the properties of the workflow, otherwise they will run in the Default (server) timezone. It's worth creating a workflow template to ensure this is always set.

You also need to ensure that your Operators have the correct timezone set so they see the dates for logs etc being correctly adjusted to the right timezone. If you do both of these, you wont really notice the incorrect server/db timezone.

Thanks

Darren

    Terms & ConditionsAccessibility statement

    Loading footer...