Installation Instructions for Hot Fix G22006

Windows for x64

Hot fix G22006 addresses the issue(s) in SAS High-Performance Markdown Optimization 4.3_M2 on Windows 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

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

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 G22006x6.exe.

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 this hot fix execute G22006x6.exe.

Note: If your Windows operating system is Windows Vista, Windows 7 or Windows Server 2008, it may be necessary to "right-click" G22006x6.exe and select "Run as administrator".

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

Note:
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.

Web application Update

Step 1: Re-build Web Applications

In order for this step to execute correctly, the Metadata Server must be running.

1.1 Invoke the SAS Deployment Manager 9.2

From the SASDeploymentManager directory launch config.exe. The default installation path for the SAS Deployment Manager is

C:\Program Files\SAS\SASDeploymentManager\9.2

1.2 Select a language in the Choose Language box

1.3 Select Rebuild Web Applications

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

1.5 Specify Connection Information, including the sasadm User ID and Password

1.6 Select SAS High-Performance Merchandise Intelligence Mid-Tier 4.3 as the Web Application to Rebuild

1.7 Verify the information on the Summary screen and select Start

1.8 Select Finish when the deployment is complete

This process will update the Customer Intelligence Core ear in <CONFIGDIR>\Lev1\Web\Staging. A backup of the original ear file will be placed in the Backup directory.

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.

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>\hpdi\sasmisc\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.

1. Run the required alter script located in the following directory:
   !SASROOT\hpdi\sasmisc\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

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