Business Analytics Administration : Business Analytics and MashZone Repositories : Synchronize the Business Analytics Repository and Business Analytics Server Time Zones
Synchronize the Business Analytics Repository and Business Analytics Server Time Zones
Creation and modification timestamps for artifacts and other Business Analytics Repository metadata can be different than times when events occurred in the Business Analytics Server in two cases:
*If the server hosting the Business Analytics Repository is located in a different time zone from the server hosting the Business Analytics Server
*If the time zone setting for the database hosting the Business Analytics Repository is set to a different time zone from the server hosting the Business Analytics Server
You can correct this problem by specifying a time zone in configuration for the Business Analytics Repository.
Important:  
The instructions in this topic are specific to MySQL databases. For other types of databases, please consult documentation for that database to determine the appropriate updates.
To synchronize time zones
1. In a text editor of your choice, open the rdsJDBC.properties file in your MashZoneNG-config folder. This is either in a shared external configuration folder or in app-server:port/presto/WEB-INF/classes.
2. Update the following properties:
*jdbc.url=jbdc:mysql://hostname/database-name?useLegacyDatetimeCode=false
*dbServer.timeZone=time-zone-id-for-mysql-server
Valid time zone identifiers include GMT time zones, common abbreviations such as EST or UTC, or time zone locations such as America/Los_Angeles.
3. Save these changes.
4. Restart the Business Analytics Server. See Start and Stop the Business Analytics Server for instructions.
Copyright © 2013-2016 Software AG, Darmstadt, Germany.
Product LogoContact Support   |   Community   |   Feedback