Installation Instructions for Hot Fix G22006

Linux for x64


Hot fix G22006 addresses the issue(s) in SAS High-Performance Markdown Optimization 4.3_M2 on Linux for x64 as documented in the Issue(s) Addressed section of the hot fix download page:

http://ftp.sas.com/techsup/download/hotfix/HF2/G22.html#G22006


G22006 is a "container" hot fix that contains the following "member" hot fixes which will update the software components as indicated. See the Container Hot Fixes section in the Maintenance Install Tool (MIT) Usage Guide for more information about container hot fixes.

G18001 for SAS High-Performance Markdown Optimization Server 4.3_M2
G19002 for SAS High-Performance Merchandise Intelligence Client 4.3_M2
G21005 for SAS High-Performance Merchandise Intelligence Grid Server 4.3_M2
G20002 for SAS High-Performance Merchandise Intelligence Mid-Tier 4.3_M2
G45002 for SAS High-Performance Merchandise Intelligence Plug-ins for SAS Management Console 4.3_M2
G17002 for SAS High-Performance Merchandise Intelligence Server 4.3_M2

Before applying this hot fix, follow the instructions in SAS Note 35968 to generate a SAS Deployment Registry report, then verify that the appropriate product releases are installed on your system. The software components and release numbers should match the list of software components updated by the individual hot fix installers.


IMPORTANT NOTES

  1. Files delivered in this hot fix will be backed up during the installation process. However, it is good general practice to back up your system before applying updates to software.

  2. You must have Administrator Privileges on your CLIENT or SERVER machine.

  3. All currently active SAS sessions, daemons, spawners and servers must be terminated before applying this hot fix.

  4. This hot fix should be installed using the same userid who performed the initial software installation.

  5. It is assumed that you have performed only Steps 1 through 4 (Refresh STG_BUDGET Table and Change Any Required ETL Orders) in the M2 installation steps in the SAS® High-Performance Markdown Optimization Maintenance Release 2 Installation Guide. You must not have already run the weekly batch job.
    You can use this link to access the installation guide:
    http://support.sas.com/software/revoptimization/pdfs/43_M2_pdfs/HPMDOMaintenanceRelease2ExistingInstallInstructions.pdf


INSTALLATION

This hot fix must be installed on each machine where the updated components of the product, listed above, are installed. The installation process will determine which components of SAS High-Performance Markdown Optimization 4.3_M2 are installed on each machine, and apply the appropriate updates.

If the updated components of this product are installed on multiple operating systems, you must download the hot fix for the appropriate operating system(s) and follow the installation instructions provided to complete the deployment of this hot fix.

The installer downloaded is G22006la.bin.

When downloading SAS 9.2 hot fix packages, you must choose to Save the hot fix to disk, then execute the install from the saved location. Attempting to install a hot fix directly from the download page results in the error documented in SAS Note 37104.

To install the hot fix:

1. Verify that the installation binary has execute permission. If it does not, use the chmod command to make it executable.

$> chmod 755 G22006la.bin
2. Set your $DISPLAY environment variable
export DISPLAY=<your_node_name>:0
3. Execute G22006la.bin
<path_to_downloaded_file>/G22006la.bin
    For example:
./G22006la.bin

This will initiate the installation wizard, which will guide you through the hot fix installation process. During the installation you will be prompted for the SASHOME location to be updated. You should provide the path to the top level SAS directory where the deploymntreg directory exists.

See the Maintenance Install Tool (MIT) Usage Guide for more details on the installation of hot fixes.


The content of this hot fix is listed in the hot fix manifest.


This completes the installation of G22006. You must perform any "Post-Installation Instructions" documented below to successfully complete the deployment of this hot fix.


POST-INSTALLATION INSTRUCTIONS

For each product installed, click the link to be redirected to post-installation instructions.

G18001 for SAS High-Performance Markdown Optimization Server 4.3_M2
G19002 for SAS High-Performance Merchandise Intelligence Client 4.3_M2
G21005 for SAS High-Performance Merchandise Intelligence Grid Server 4.3_M2
G20002 for SAS High-Performance Merchandise Intelligence Mid-Tier 4.3_M2
G45002 for SAS High-Performance Merchandise Intelligence Plug-ins for SAS Management Console 4.3_M2
G17002 for SAS High-Performance Merchandise Intelligence Server 4.3_M2


G18001 for SAS High-Performance Markdown Optimization Server 4.3_M2

NONE


G19002 for SAS High-Performance Merchandise Intelligence Client 4.3_M2

NONE


G21005 for SAS High-Performance Merchandise Intelligence Grid Server 4.3_M2

NONE


G20002 for SAS High-Performance Merchandise Intelligence Mid-Tier 4.3_M2

Updates to the SAS High-Performance Merchandise Intelligence Mid-Tier provided in this hot fix require that the Web application be rebuilt and redeployed.

The metadata server must be up and running before the web application is re-built.

Follow the steps below to rebuild and redeploy (sas.hpmimidtier4.3.ear):


Step 1: Re-build Web Applications In order for this step to execute correctly, the Metadata Server must be running.

1.1 Set the DISPLAY environment variable, for example

$ export DISPLAY=:0.0
1.2 Invoke the SAS Deployment Manager 9.2 From the SASDeploymentManager directory execute config.sh, for example
$ cd <SAS_HOME >/SASDeploymentManager/9.2
$ ./config.sh
1.3 Select a language in the Choose Language box.

1.4 Select Rebuild Web Applications.

1.5 Select Configuration Directory or Enter the Configuration Directory and Level that needs to be updated.

1.6 Specify Connection Information, including the sasadm User ID and Password.

1.7 Select High-Performance Merchandise Intelligence Mid-Tier as the Web Application to rebuild.

1.8 Verify the information on the Summary screen and select Start.

1.9 Select Finish when the deployment is complete. This process will update High-Performance Merchandise Intelligence Mid-Tier ear (sas.hpmimidtier4.3.ear) in /Lev1/Web/Staging A backup of the original ear file will be placed in the directory /Lev1/Web/Staging/Backup


Step 2: Re-deploy Web Applications

2.1 Re-deploy the High-Performance Merchandise Intelligence Mid-Tier web application (only).

Details are provided at: SAS(R) 9.2 Intelligence Platform: Web Application Administration Guide

Note: Select sas.hpmimidtier4.3.ear when re-deploying the web application.

2.2 Stop and restart the Web application server.


G45002 for SAS High-Performance Merchandise Intelligence Plug-ins for SAS Management Console 4.3_M2

NONE


G17002 for SAS High-Performance Merchandise Intelligence Server 4.3_M2

NOTE:
If you are installing this hot fix while installing 4.3 M2, it is assumed that you have performed only Steps 1 through 4 (Refresh STG_BUDGET Table and Change Any Required ETL Orders) in the M2 installation steps in the SAS® High-Performance Markdown Optimization Maintenance Release 2 Installation Guide. You must not have already run the weekly batch job.

  1. Log into the SAS server using the mietlusr user ID (or the MI ETL User that is defined in metadata).

  2. Run the migration script using the Merchandise Intelligence batch script sas_batch.sh.
    For example:
    <SAS config dir>/Lev1/MIMain/Batch/sas_batch.sh <SAS root dir>/misc/hpdi/migration/di_mig_attr_hier_43m2.sas -log <dir with write access>/di_mig_attr_hier_43m2.log

  3. Verify that the analytical hierarchy was successfully migrated by ensuring that the following two messages appear in the log that was generated in the previous step:
    NOTE: di_data.attr_prod_dm has been successfully migrated to 43m2.
    ...
    NOTE: di_data.attr_geo_dm has been successfully migrated to 43m2.

    If both messages do not appear in the log, then contact SAS Technical Support.


Perform the following steps:
  1. Run the required alter script located in the following directory:
    !SASROOT/misc/hpdi/dbmsc

    On the SAS Server machine, locate and run the alter_f2tkmi43_orcl_hf2.sql script for updating Oracle tables
    -- SET DEFINE OFF
    -- alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
    -- alter session set current_schema = schema_name;

  2. Manually copy the following two files from the following location to the Oracle database server’s upload location
    !SASHOME//SASHighPerformanceMerchandiseIntelligenceServer/4.3/Scripts/Upload/rebuild_missing_pk_mpln_geo_prod_result.template
    !SASHOME//SASHighPerformanceMerchandiseIntelligenceServer/4.3/Scripts/Upload/rebuild_pk_mpln_geo_prod_result.template

Run your weekly batch job according to your deployment’s process.


This completes the installation of hot fix G22006 on Linux for x64.