Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How to correct the data base time zone of ACC

yueminspb
Level 3
Level 3

Hi team,

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

yueminspb_1-1610940562818.png

 

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

 

1 Accepted Solution
Darren_Bowers
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

1 Reply
Darren_Bowers
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post