3 Troubleshooting Installation, Upgrades and Downgrades

Installing 32-bit TimesTen on 64-bit Windows

The default ODBC Data Source Administrator on 64-bit Windows does not show TimesTen 32-bit drivers and DSNs. If Windows is installed in the default location (C:\WINDOWS), use C:\WINDOWS\SysWOW64\odbcad32.exe for the ODBC Data Source Administrator when you are installing 32-bit TimesTen on a 64-bit Windows machine.

Downgrading a data store with Oracle data types to TimesTen 6.0

In rare situations, after upgrading a data store from TimesTen 6.0, you may find that you need to downgrade a TimesTen 7.0 or later data store back to TimesTen 6.0 after the data types are already converted to Oracle types. However, the ttMigrate utility for TimesTen 6.0 does not understand Oracle data types, and this can lead to problems when downgrading data stores from TimesTen 7.0 or later. To avoid any pitfalls in the downgrade process, you should convert the Oracle data types back to TimesTen types using TimesTen 7.0 or later first, and only then downgrade the data store to TimesTen 6.0, using the following steps:

1. Create a migration file using TimesTen 7.0 or later ttMigrate.

   ttMigrate -c datastore datastore.migrate
   

2. Destroy the data store using TimesTen 7.0 or later ttDestroy.

   ttDestroy datastore
   

3. Convert the data types to TimesTen types using TimesTen 7.0 or later ttMigrate.

   ttMigrate -r -noRepUpgrade -convertTypesToTT datastore    datastore.migrate
   

4. Create a new migration file using TimesTen 7.0 or later ttMigrate.

   ttMigrate -c datastore datastore.migrate
   

5. Destroy the data store using TimesTen 7.0 or later ttDestroy.

   ttDestroy datastore
   

6. In another terminal, with the environment set correctly for TimesTen 6.0, restore the data store as a TimesTen 6.0 data store using TimesTen 6.0 ttMigrate.

   ttMigrate -r datastore datastore.migrate