Running the UTC Conversion Utility

This topic is part of Converting Historical Data to UTC.

Complete the following task to run the UTC conversion utility and convert your date-time data to UTC.

See also About the UTC Conversion Utility and Preparing Your Data for Conversion to UTC.

Note: Running the UTC conversion utility might take a long time, depending on how many records and how many columns are being converted.

For detailed information about starting the Database Configuration Wizard, see Siebel Installation Guide.

Note: The values that you enter into the Database Configuration Wizard are case-sensitive. You cannot type spaces in parameter values; use underscores (_) instead. Click Next to go to the next screen.

To run the UTC conversion utility from the Database Configuration Wizard

1. Start the Database Configuration Wizard, as described in Siebel Installation Guide.

   The Database Configuration Wizard appears.

2. Enter required parameters that apply for every Database Configuration Wizard task.

3. Choose the option Run Database Utilities.

4. Choose the option Universal Time Code Conversion.

   See the table that follows for a list of dialog boxes, options, and required values.

   The UTC conversion utility updates your existing data. For columns configured for UTC, the UTC conversion utility adjusts the historical date and time values to their UTC equivalent.

   After successfully converting the UTC-enabled date-time fields, the UTC conversion utility sets the value for the Universal Time Coordinated system preference to True.

   The utility checks for errors, and writes any errors to a log file.

5. Review the log file generated by the UTC conversion process, and resolve errors as necessary. See Reviewing the UTC Conversion Log Files.

   Note: If the UTC conversion fails for any reason, then you must review the log files and resolve any errors encountered. Then you need to manually rerun the UTC conversion utility, as described in Manually Starting the UTC Conversion Utility.

The following table shows parameters to use with the Database Configuration Wizard and the UTC conversion utility.

At this prompt...	Enter or select the following...
Siebel Gateway Address Enterprise Server Name	Specify the following: The computer or operating system instance name where you installed Siebel Gateway. The name of the Siebel Enterprise Server.
Siebel Server Directory	Specify the Siebel Server installation location: the SIEBSRVR_ROOT directory. For example, for the current version, the location might be C:\siebel\ses\siebsrvr on Microsoft Windows or /siebel/ses/siebsrvr on UNIX or Linux.
Siebel Database Server Directory	Specify the Siebel Database Configuration Utilities installation location: the DBSRVR_ROOT directory. For example, the location might be C:\siebel\ses\dbsrvr on Microsoft Windows or /siebel/ses/dbsrvr on UNIX or Linux.
Database Platform	Specify the RDBMS platform that you are using.
Siebel Database Operation	Choose Run Database Utilities.
Database Utilities Options	Choose Universal Time Code Conversion.
Base (Primary) Language	Specify the primary language for your deployment.
ODBC Data Source Name	Specify the ODBC data source. The data source was created automatically during Siebel Enterprise configuration, using the format EnterpriseName_DSN. Note: Do not enter the value Siebel_DSN unless Siebel is the name of the Enterprise. To find the name of the ODBC data source on Microsoft Windows, go to Start, then Settings, then Control Panel, then Administrative Tools, and then Data Sources (ODBC). Click the System DSN tab to find the name of the ODBC data source.
Database User Name and Password	Enter the database user name and password. (Specify the user name of the Siebel administrator, for example, SADMIN.)
Database Table Owner and Password	Enter the database table owner name and password. Note: For Microsoft SQL Server: this is the login for the owner of the database, not necessarily the default owner of the database in DBO.
UTC Repository Name	Enter the name of the Siebel repository for which you are performing UTC conversion.
Security Group ID	Enter the name of the security group ID, such as SSE_ROLE.
Log Output Directory	Enter the name of the directory in which log output is to be generated. By default the log output is generated in the utc subdirectory.
Apply Configuration Changes	Specify whether to apply configuration changes when the wizard completes, or if you will apply changes later.
Configuration Parameter Review	Review the parameters that you have defined and then click Finish.