Upgrading timestamps in the Archive Manager database
From your Content Deployer Web application, run a Java tool included with the installation media to update the timestamps in your Archive Manager database. Perform this task only after you have upgraded your Archive Manager database.
Before you begin
Your
JAVA_HOMEvariable must be set.The tool must be able to connect to a database through a JDBC connection (that is, a JDBC driver must be installed and a JDBC connection must be configured). If you use only a JNDI connection to your database, the tool does not work. To configure your Storage Layer for a JDBC connection, back up your existing JNDI storage settings and add the following JDBC settings:
<Storage Type="persistence" Id="defaultdb" dialect="MSSQL" Class="com.tridion.storage.persistence.JPADAOFactory"> <Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" /> <DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource"> <Property Name="serverName" Value="SERVER_NAME" /> <Property Name="portNumber" Value="1433" /> <Property Name="databaseName" Value="DATABASE_NAME" /> <Property Name="user" Value="USER_NAME" /> <Property Name="password" Value="PASSWORD" /> </DataSource> </Storage>where SERVER_NAME, DATABASE_NAME, USER_NAME and PASSWORD identify your database and the credentials to access it. After running the database update tool, you can remove these settings and reinstate your JNDI settings.
About this task
Timestamps in your Archive Manager database were stored in local time (that is, local to the server on which the Content Deployer runs). As of Archive Manager 1.0 SP3, timestamps are stored as UTC timestamps. To ensure that your existing database records have the right timestamps, run a Java tool.