2.2 How to Apply This Maintenance Level Release?

This section describes how apply this maintenance release.

To install this Maintenance Level release:

Note:

If the OFS Behavior Detection 8.1.2.10.0 patch is to be installed on OFS Sanctions 8.1.2.0, then follow these steps:
  • Create table KDD_BUS_DMN_SANC as (select * from KDD_BUS_DMN); UPDATE KDD_BUS_DMN SET TF_BUS_DMN_NM=NULL;
  • Commit;
  • Restore the TF_BUS_DMN_NM column in the KDD_BUS_DMN table from NULL to the original value after the installation is complete.
  1. During OFS Behavior Detection 8.1.2.10.0 patch installation, only the FICServer (<FIC_HOME>/ficapp/common/FICServer/bin/startofsaai.sh) can be up and running. Stop all other OFSAAI application services (MANTAS, ICC, BD algorithms dispatcher, etc.).
  2. Load the .profile and ensure that $FIC_HOME corresponds to the proper environment where the patch application is required.
  3. Download and copy 37643766_LINUX.zip/37643766_SOLARIS_SPARC.zip (in Binary mode) to the server where OFSAA is installed.
  4. Navigate to <USER_PATCH_DIR> and extract the contents of the patch archive file using the command: unzip -a <name of the file to be unzipped>.

    For example: unzip -a 37643766_LINUX.zip/37643766_SOLARIS_SPARC.zip

    Note:

    <USER_PATCH_DIR> is the location of the <patch>.zip file. The -a option mentioned above is required to unzip the patch. If you encounter the error message unzip: not found [No such file or directory] when the package is not installed, contact your UNIX administrator to resolve the issue.

  5. Navigate to <USER_PATCH_DIR>/37643766/bin and grant execute (755) permission for all executables: $ chmod 755*.
  6. Navigate to <USER_PATCH_DIR>/37643766/conf/PatchConfig.xml and provide the following placeholder values:
    1. ##SCHEMA_OUT_XML_PATH## - this attribute refers to the path which needs to be pointed to OFS_BD_SCHEMA_OUTPUT.xml, which was generated at the time of installation.
    2. ##BIG_DATA_ENABLE## - set the value toFALSE.
    3. ##SCORING_PROTOCOL_SERVER_PORT## - provide the server host & port. For example: hostIP:PortNumber.
    4. ##FSDF_UPLOAD_MODEL##- provide the value mentioned in default.properties during BD 812 installation. Path : /<BD812_Installer>/OFS_BD_PACK/OFS_AML/conf/ default.properties.
    5. ##EXECUTE_PRE_AND_POST_SCRIPTS##- attribute value must be set to 1 to execute the prescripts and postscripts. Attribute value 0 skips the prescripts and postscripts.

      Note:

      As part of prescripts, back up tables with the naming convention <TABLE_NAME>_81210_BACKUP.
  7. Install the patch by executing the command: $./install.sh.
  8. Check if the patch is applied successfully by verifying the patch install logs under <USER_PATCH_DIR>/37643766/logs.

    Note:

    Contact My Oracle Support in case of any errors.