Variable Migration Utility

The Variable Migration utility is provided to migrate the variables defined in OFSAAI 8.0.5.0.0 and previous versions to the Variables Definition compatible with OFSAAI 8.0.6.0.0 and later. The utility variableresaveutil.sh is available in the $FIC_HOME/utility/variable/bin/ folder.

The following are the steps to run the migration utility:

1. Navigate to $FIC_HOME/utility/variable/bin directory.
2. Execute variableresaveutil.sh (UNIX).
   ./variableresaveutil.sh
   This command will migrate all available variables from all Infodoms, which are in the ftpshare/<infodom>/erwin/variable/ directory.
3. Provide the following parameter if you want to migrate variables that are present in a particular information domain:
   INFODOM- Specify the information domain name if you want to migrate variables present only in a particular information domain.
   ./variableresaveutil.sh <INFODOM>
4. Check the status, and errors if any, in the migration.log file available in the $FIC_HOME/utility/variable/logs/ folder.

   Note:

   After you have triggered this utility and migrated all variables successfully, any subsequent run of the utility will throw SQL constraint violation errors for Variables that have been migrated. You can ignore this error if you do not want to change any details in migrated variables. If you want to update or correct an existing variable, then delete the migrated variable from UI and retrigger the utility.