Siebel Analytics Installation and Configuration Guide > Integrating Siebel Analytics with Siebel Operational Applications > Process of Upgrading Siebel Analytics Seed Data >

Upgrading Older Repositories on UNIX

If you have an older version of the Siebel Analytics server running under UNIX, you must run the following upgrade steps, otherwise parts of the repository may be invalid when you upgrade to Siebel Analytics 7.7.

In the repository, the Date, Time and Timestamp data types are not portable across UNIX and Windows. You can see this in the SiebelAnaltyics.rpd on HP-UX. When you navigate to Manage > Variables > LAST_REFRESH_DT in the Administration Tool running on Windows, the LAST_REFRESH_DT will appear to be garbage—for example, it has a negative number for the year.

If you are running under UNIX, there are some additional configuration steps to run. Unless these steps are run, you may have compatibility problems for repositories with Date, Time, and Timestamp columns. The general process is to convert your 7.0.4 repository or repositories to text format, then convert them back to repository format before you use the repository.

To upgrade a 7.0.4 repository

  1. Using binary mode, FTP the repository to a Windows 2000 or Windows NT machine.
  2. Convert the repository to text.

    nqudmlgen -U administrator -P SADMIN -R SiebelAnalytics.rpd -O SiebelAnalytics.txt

  3. Convert the text back to repository format.

    nqudmlexec -U administrator -P SADMIN -I SiebelAnalytics.txt -O SiebelAnalytics.rpd

  4. FTP the repository back to the UNIX machine.

 Siebel Analytics Installation and Configuration Guide, Version 7.7, Rev. A 
 Published: 11 March 2004