Symptom
Database Setup fails with an error stating that Database Setup was unable to log into a different type of database than the system is using.
Resolution
This problem occurs when the database engine is changed during an upgrade, which results in the LNL_DB table having the wrong database type specified. For example, the error message states that "Database Setup cannot upgrade the SQL Database", but an Oracle database is being used or "Database Setup cannot upgrade the Oracle Database", but a SQL Server database is being used. To resolve the error:1) Check the LNL_DB table and determine what value is being used.
- A value of 1 is for a SQL Server database.
- A value of 3 is for an Oracle database.
2) Depending on the type of database the system has, you will have to make modifications.
- Run the following query to determine the LNL_DBID for the entry:
SELECT * FROM LNL_DB
- Run the following query to modify the database type:
UPDATE LNL_DB SET DB_ENGINE=<X> WHERE LNL_DBID=<Y>
For <X>, substitute the type of database the respective ODBC connection should be set to; set the value to 1 for a SQL Server database or 3 for an Oracle database. For <Y>, substitute the LNL_DBID for the entry.
