CA AuthMinder Windows Installation Guide › Upgrading to Release 7.1.01 › Upgrading to Release 7.1.01 › Migrating the Database to Release 6.0 for Arcot Common Components

Migrating the Database to Release 6.0 for Arcot Common Components

Note: Perform the procedure that is described in this section only if you are upgrading from 5.3.x or 5.4.x. If you are upgrading from 6.x or 7.0, do not migrate the database to 6.0 for Arcot common components.

Important! If you have installed CA RiskMinder along with CA AuthMinder and have completed the RiskMinder upgrade, then do not migrate the database for Arcot common components because this step has already been performed during the RiskMinder upgrade.

Migrate the database for the Arcot common components that are used in release 6.0.

Follow these steps:

1. Copy the upgrade directory to a temporary location on the system where you plan to upgrade.

   This folder contains the following zip files that are applicable for this migration path:

   • arcot-common-upgrade-0.x-1.0.zip
   • arcot-webfort-upgrade-5.x-6.0.zip
2. Copy the arcot-common-upgrade-0.x-1.0.zip file to the %ARCOT_HOME% directory:
3. Extract the contents of the arcot-common-upgrade-0.x-1.0.zip file in this directory.
4. Navigate to the following directory:

   %ARCOT_HOME%\dbscripts\<db_type>\
   

5. Run the arcot-db-config-for-common-1.0.sql script.

   Note: For Microsoft SQL server, if you run the database script from the command line using SQLCMD, then specify the -I option to set the QUOTED_IDENTIFER connection option to ON.

6. Navigate to the following directory:

   %ARCOT_HOME%\dbscripts\<db_type>\upgrade-scripts\
   

7. Run the arcot-upgrade-for-common-1.0.sql script.

   Note: For Microsoft SQL server, if you run the database script from the command line using SQLCMD, then specify the -I option to set the QUOTED_IDENTIFER connection option to ON and specify the -x option to disable variable substitution.

8. Copy the JDBC JAR that is compatible with the database that you are using to the following directory:

   %ARCOT_HOME%\java\lib
   

9. Copy the ArcotAccessKeyProvider.dll file to <JAVA_HOME used by App Server>\jre\bin. For example, in AuthMinder release 6.x, the libArcotAccessKeyProvider.so file is available in java\ext\<platform name>\<32bit or 64 bit>.
10. Copy the %ARCOT_HOME%\java\lib\arcot-crypto-util.jar file

    to

    <JAVA_HOME used by App Server>\jre\lib\ext
    

11. In the PATH variable, include the directory where ArcotAccessKeyProvider.dll is copied.
12. Open the command prompt window.
13. Change your working directory to:

    %ARCOT_HOME%\tools\upgrade
    

14. Run the upgrade tool by entering the following command at the prompt:

    upgrade-common.bat
    

15. Check the log file %ARCOT_HOME%\logs\upgrade-common.log to ensure that the common database migration was successful.

    Important! While migrating the database, if you encounter errors due to a step that you have performed incorrectly, restore the database backup that you created earlier. After you verify that the database is correctly restored, retry the database migration procedure.