Running the approval utilities

You can run the following approval utilities by running the approval-utils.bat (Windows) or approval-utils.sh (UNIX) file:

• Approval Join Fix—joinfix (See Running-the-Approval-Join-Fix-utility)
• Approval Change Schema—chgschema (See Managing-the-sizes-of-approver-fields)
• Approval Upgrade—upgrade

To run the approval utilities

1. Open the approval-utils.bat or approval-utils.sh file in the approvalServerInstallDir\bin directory.

2. The interface prompts as follows:

   Approval Utility Commands
   ===========================
   Exit/Quit               <e | q>
   Help                    <h | help>
   
   Approval Join Fix       <joinfix>
   Approval Change Schema  <chgschema>
   Approval Upgrade        <upgrade>
   
   Command:
   
3. Type the name of the utility that you want to run.

   1. If you type joinfix, and press enter, the interface displays the parameters for the utility and prompts the user to enter the required arguments as follows:

      Info - Created command - joinfix
      Approval Join Fix
      Usage:
        [-x Server]
        [-u User]
        [-p Password] [-t TCP Port]
        [-a Authentication String] [-r RPC Port]
        [-f Form]
        [-m Mode]
               1. Update Join Criteria
               2. Add new fields in Three-way Join Form
       3. Update Password Objects on Three-way Join Form
      Arguments:
      

   2. If you type chgschema, and press enter, the interface displays the parameters for the utility and prompts the user to enter the required arguments as follows:

      Info - Created command - chgschema
      Approval Change Schema
      Usage:
        [-x Server]
        [-u User]
        [-p Password] [-t TCP Port]
        [-r RPC Port] [-a Authentication String]
      Arguments:
      

   3. If you type upgrade, and press enter, the interface displays the parameters for the utility and prompts the user to enter the required arguments as follows:

      Info - Created command - upgrade
      Approval Upgrade
      Usage:
        [-d Installation Directory]
        [-l Log File Path]
      Arguments:
      

The logs for the chgschema and joinfix utilities are stored in the approval-utils.log file located in the approvalServerInstallDir\bin directory.

The log for the upgrade utility is stored in the log file as per the -l parameter. However, if the value for this parameter is not specified, then the logs are stored in the approval-utils.log file.

After running the utilities, restart the approval server for the changes to take effect.