H Upgrade Attestation Utility

In Oracle Identity Manager release 9.1.0, attestation design has been modified to merge few columns and put the data in a newly added column in XML format as a CLOB data. After upgrading to release 9.1.0, old attestation does not work because of this change. Therefore, the Upgrade Attestation utility must be run to perform data conversion.

To upgrade attestations:

1. Create a backup of the APD table because the Upgrade Attestation utility deletes some columns from this table.

2. Copy the PATCH/xellerate/lib/xlAttestationUpgrade.jar file to the OIM_HOME/lib/ directory.

3. Run the Upgrade Attestation script. Run the following file located at OIM_HOME/setup/ directory as appropriate for the operating system:

   For Microsoft Windows:

   UpgradeAttestation.bat  JDBC_DRIVER DB_URL OIM_DB_USERNAME OIM_DB_PASSWORD
   

   For UNIX:

   UpgradeAttestation.sh  JDBC_DRIVER DB_URL OIM_DB_USERNAME OIM_DB_PASSWORD
   

   The UpgradeAttestation script parameters are:

   • JDBC_DRIVER: JDBC driver

   • DB_URL: URL for the database

   • OIM_DB_USERNAME: User name for the database

   • OIM_DB_PASSWORD: Password for the database

   Note:

   If the host on which the UpgradeAttestation script is run cannot allocate 1 GB RAM for the process, then the following error is thrown:

   java.lang.NullPointerException at com.thortech.xl.attestation.AttestationUpgrade.main<Unknown Source
   

   If this occurs, then you must reduce the Java option for maximum memory allocation in the UpgradeAttestation script file. For example, if the memory allocation is similar to the following:

   "%JAVA_HOME%/bin/java" -Xmx1024m -cp %CLASS_PATH%com.thortech.xl.attestation.AttestationUpgrade %1 %2 %3 %4
   

   You can change it to the following:

   "%JAVA_HOME%/bin/java" -Xmx512m -cp %CLASS_PATH%com.thortech.xl.attestation.AttestationUpgrade %1 %2 %3 %4
   

4. Delete the xlAttestationUpgrade.jar from the OIM_HOME\lib\ directory.