Pre-requisites
Upgrade Utility does not require IVS for upgrading OIPA Database. Non-IVS environment can be created and used to upgrade between versions. If this approach is used, IVS upgrade scripts has to be run after OIPA upgrade is performed. Non-IVS Environment approach is recommended.
- NON-IVS Environment Approach:
- (For Upgrades from 9.7.x to 11.X) Palette Web Application Utility version 11.x , deployed and configured (as described in the Rules Palette Set-Up Instructions).
- Hostname and port for the Palette Web Application Utility
- Upgrade Utility login credentials (this is same as Rules Palette Credentials).
- IVS Environment Approach:
- (For Upgrades from 9.7.x to 11.X) IVS scripts (given at the end of this document) should be run before using the upgrade Utility tool to upgrade the OIPA database.
- (For Upgrades from 9.7.x to 11.X) Palette Web Application Utility version 11.X , deployed and configured (as described in the Rules Palette Set-Up Instructions)
- Microsoft Windows 2000 or later.
- Hostname and port for the Palette Web Application Utility Upgrade Utility login credentials (this is same as Rules Palette Credentials).
- OIPA application database and IVS database user name and password
- The following scripts must be run in the OIPA database before running the upgrade utility if their is no entry in DATABASECHANGELOGLOCK table:
INSERT INTO DATABASECHANGELOGLOCK (ID,LOCKED,LOCKGRANTED,LOCKEDBY) VALUES (1,0,null,null);
If the DATABASECHANGELOGLOCK table doesn't exists in the database then following script should get run first to create the table :
Script for Oracle Database:
CREATE TABLE DATABASECHANGELOGLOCK ( ID NUMBER(38) NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP(6), LOCKEDBY VARCHAR2(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID) );
Script for Db2 Database:
CREATE TABLE DATABASECHANGELOGLOCK ( ID INT NOT NULL, LOCKED SMALLINT NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));Script for SqlServer Database:
CREATE TABLE DATABASECHANGELOGLOCK ( ID INT NOT NULL, LOCKED BIT NOT NULL, LOCKGRANTED DATETIME, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
The script above may not be necessary in some cases. If a violation of the PK_DATABASECHANGELOGLOCK constraint is returned upon execution of the script, the violation can be disregarded.