Installation Instructions for Hot Fix P20027

Windows for x64


Hot fix P20027 addresses the issue(s) in SAS Revenue Optimization 5.2_M4 as documented in the Issue(s) Addressed section of the hot fix download page:

http://ftp.sas.com/techsup/download/hotfix/HF2/P20.html#P20027


P20027 is a "container" hot fix that contains the following "member" hot fixes which will update the software components as needed.

P23030  updates  SAS Merchandise Intelligence Client 5.21_M4
P28030  updates  SAS Merchandise Intelligence Grid Server 5.21_M4
P24030  updates  SAS Merchandise Intelligence Mid-Tier 5.21_M4
P25030  updates  SAS Merchandise Intelligence Plug-in for SAS Management Console 5.21_M4
P68017  updates  SAS Merchandise Intelligence Server 5.21_M4
P26030  updates  SAS Merchandise Intelligence Workbench Server 5.21_M4
P27030  updates  SAS Merchandise Solutions Configuration Workbench 5.21_M4
P52002  updates  SAS Regular Price Optimization 5.2_M4
P22020  updates  SAS Revenue Optimization Server 5.2_M4

See What is a container hot fix? in the Hot Fix FAQ for more information about container hot fixes.


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 release number information in the Registry report should match the 'member' release number information provided above for the software components installed on each machine in your deployment.

The hot fix downloaded, P20027pt.zip, includes the updates required for all components listed above on all applicable operating systems. To apply this hot fix on multiple machines, you can either save P20027pt.zip on each machine or save it in a network location that is accessible to all machines.

Do NOT extract the contents of P20027pt.zip. The hot fix installation process will extract the contents as needed.


IMPORTANT NOTES

  1. You must have SAS Merchandise Intelligence 5.2_M4 installed on your system before applying this hot fix. Refer to SN-35968 for instructions on how to determine which product releases you have installed.

  2. At a minimum, back up your system:
    a.    For SAS, refer to the SAS 9.3 Guide to Software Updates for documentation about back up tasks:
    http://support.sas.com/documentation/cdl/en/whatsdiff/63859/HTML/default/viewer.htm#titlepage.htm

    b.    For SAS Merchandise Intelligence, backup the MI data mart and database.
    Technical Support strongly suggests that you back up all of your files. You should always try to include the current date in the name of the backup file created to distinguish between versions of backup files. By doing this, you will maintain a history of the file, which will be helpful when multiple iterations of a maintenance release have been applied to the same file. For example:
           cp com.sas.solutions.di.server.jar com.sas.solutions.di.server.jar.08202012
           where 08202012 is the date when the maintenance release is applied.
    The extension must be appended after the .jar extension, as it appears above.

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

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

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

  6. You must deploy the hot fix in the following timeframe


INSTALLATION

Hot Fix P20027 must be installed on each machine where the updated components of the product, listed above, are installed. During the installation process you may see references to all operating systems for which updates are provided in the hot fix. The installation process will determine the operating system and which component(s) of SAS Revenue Optimization 5.2_M4 require updating on the machine. See SAS Note 44810 for more details.

The hot fix will be applied using the SAS Deployment Manager. By default, the SAS Deployment Manager will search in the <SASHOME>\InstallMisc\HotFixes\New directory for hot fixes to be applied, but will also prompt for a location if you have downloaded hot fixes to a different directory.

After downloading P20027pt.zip, follow the instructions for applying hot fixes in the SAS Deployment Wizard and SAS Deployment Manager 9.3: User’s Guide.


The hot fix installation process generates the log file

<!SASHOME>\InstallMisc\InstallLogs\IT_date-and-time-stamp.log
for example, IT_2011-10-31-13.18.21.log. Each attempt to apply a hot fix results in the creation of a new log file giving detailed information regarding the installation process.

Postexec log files are created after the installation is completed and identifies the files that were added, backed up, changed and removed. These log files include the ‘member’ hot fix id in the name of the file and are also written to the <!SASHOME>\InstallMisc\InstallLogs directory. There is one postexec log for each ‘member’ hot fix applied (member hot fixes are listed at the top of these instructions).


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


POST-INSTALLATION INSTRUCTIONS

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

P23030  updates  SAS Merchandise Intelligence Client 5.21_M4
P28030  updates  SAS Merchandise Intelligence Grid Server 5.21_M4
P24030  updates  SAS Merchandise Intelligence Mid-Tier 5.21_M4
P25030  updates  SAS Merchandise Intelligence Plug-in for SAS Management Console 5.21_M4
P68017  updates  SAS Merchandise Intelligence Server 5.21_M4
P26030  updates  SAS Merchandise Intelligence Workbench Server 5.21_M4
P27030  updates  SAS Merchandise Solutions Configuration Workbench 5.21_M4
P52002  updates  SAS Regular Price Optimization 5.2_M4
P22020  updates  SAS Revenue Optimization Server 5.2_M4


P23030  updates  SAS Merchandise Intelligence Client 5.21_M4
P27030  updates  SAS Merchandise Solutions Configuration Workbench 5.21_M4

Security Update for SAS Merchandise Intelligence Client 5.21_M4 and SAS Merchandise Solutions Configuration Workbench 5.21_M4

If the updates for the Java Deserialization Vulnerability documented at http://support.sas.com/security/Java-deserialization.html were applied to your system, you must rerun the SAS Security Update after applying this hot fix. The current SAS Security Update can be downloaded from http://ftp.sas.com/techsup/download/hotfix/HF2/Java-deserialization_update.html. To apply the update, perform Step 1 — Apply SAS Security Update and Step 3 — Rebuild and Redeploy Web Applications in the instructions in the PDF document provided at the same link.


P28030  updates  SAS Merchandise Intelligence Grid Server 5.21_M4

NONE


P24030  updates  SAS Merchandise Intelligence Mid-Tier 5.21_M4

Web application Update

Updates to the SAS Merchandise Intelligence Mid-Tier 5.21 provided in this hot fix require that Web Applications be rebuilt and redeployed. If this component is installed on Unix, follow the steps below to rebuild and redeploy the web application:

Step 1.    Remove com.sas.app.launcher.cacheFile

Delete

<SASHOME>\SASVersionedJarRepository\eclipse\com.sas.app.launcher.cacheFile

Step 2:   Re-build Web Applications

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

Re-build the Merchandise Intelligence Mid-Tier 5.2 Web application as instructed here:

SAS(R) 9.3 Intelligence Platform: Middle-Tier Administration Guide


Note: Select Merchandise Intell Mid-Tier 5.2 Web Applications to Rebuild


This process will update the SAS Merchandise Intelligence Mid-Tier 5.2 ear in

<CONFIGDIR>\Lev1\Web\Staging
A backup of the original ear file will be placed in the Backup directory.


Step 3:   Re-deploy Web Applications

Re-deploy the Merchandise Intell Mid-Tier 5.2 Web application (only). Re-deploy the SAS Web Applications as instructed here:

SAS(R) 9.3 Intelligence Platform: Middle-Tier Administration Guide

Note: Select sas.miserver5.2.ear when re-deploying the Web application.


Step 4:    Stop and restart the Web application server.


P25030  updates  SAS Merchandise Intelligence Plug-in for SAS Management Console 5.21_M4

NONE


P68017  updates  SAS Merchandise Intelligence Server 5.21_M4

Please query the Oracle table DI_TRANS.RDBMS_DM_CHANGE_MANAGEMENT to see if CHANGE_ID = ‘S1136150’ has already been applied. If it has not been applied a query for that CHANGE_ID will return zero rows. If CHANGE_ID 1336150 has not been applied and if the Oracle table RPP_VENDOR_DEAL already has an index named RPP_VENDOR_DEAL_IX5 in your environment please remove it. This will allow the update_datamart.sh script to run successfully. To remove the index, you can do so with the following code run in a SAS session where the SAS Merchandise Intelligence libraries are allocated:

proc sql noprint;
drop index RPP_VENDOR_DEAL_IX5 on DI_TRANS.RPP_VENDOR_DEAL;
quit;

Run the Update Data Mart Script

Run the Update Data Mart Script to update the existing data mart:
  1. Log on as MI ETL User (sasmietl).

  2. From the sasmietl home directory, run the update_datamart script.
    /Lev1/Applications/SASMerchIntellServer5.2/sas/update_datamart.sh

  3. Check the log file (update_datamart.log) for output and errors.
Note: When you run the update_datamart script, the system adds a date and time stamp to the name of the log file. This enables the system to maintain multiple versions of the log files. It also makes it easier to identify which log files correspond to specific runs of the scripts.

Here is an example of a log file that results from a script run on May 8, 2012, at 9:44 a.m.:
         update_datamart_20120508_0944.log



This hot fix makes the following schema changes.

RDBMS changes:

Add new indexes:
  • ‘RPP_VENDOR_DEAL_IX5’ on table RPP_VENDOR_DEAL (abs(PLAN_SK))
  • ‘PKO_PROD_HIER_IX8’ on table PKO_PRODUCT_HIER_ASSOC_DM (PROD_HIER_ASSOC_CD, PARENT_PROD_LVL, PROD_HIER_SK)
  • ‘PKO_PROD_HIER_IX10’ on table PKO_PRODUCT_HIER_ASSOC_DM (PROD_HIER_ASSOC_CD, PARENT_PROD_HIER_SK, PROD_LVL, PROD_HIER_SK)

Add a new spec ‘im_instore_maxlimit’ in PRF_CONFIG.
MAX_ALERT_BATCH_SIZE , should be also checked in DI_DM2.Global_setting_group_member and DI_DM2. Global_setting_details

Add new indexes :
  • ‘MPLN_GPA_IX2’ on table MPLN_GEO_PROD_AGG (MDO_PLAN_SK, PROD_HIER_SK, GEO_HIER_SK)
  • ‘MPLN_GPA_IX3’ on table MPLN_GEO_PROD_AGG (PROD_HIER_SK, MDO_PLAN_SK, GEO_HIER_SK)

Note:
Before executing the update_datamart.sh script, please check if these indexes (MPLN_GPA_IX2 & MPLN_GPA_IX3) already exist :
  • If the same indexes are already present in the schema with same name delete them before running the update_datamart.sh
  • If different indexes (created by the customer) are present in the schema with same name rename them before running the update_datamart.sh

Add new column CREATED_BY (VARCHAR(40)) to the following tables :
  • ATTR_SPEC
  • DATA_CONFIG
  • DATA_CONFIG_TEMPLATE
  • GLOBAL_GEO_PROD_STATUS_RULE
  • GLOBAL_GEO_PROD_STATUS_SPEC
  • MODEL_GEO_PROD_STATUS_RULE
  • MODEL_GEO_PROD_STATUS_SPEC
  • MODEL_SPEC
  • MODEL_SPEC_TEMPLATE
  • PRF_GEO_PROD_STATUS_SPEC


SAS changes:
Add new global settings :
  • INDEPENDENT_BATCH_PREP
  • MUST_MEET_SKU_MIN
  • DEDUPE_MULTIPLE_BULK_PACKS
  • PROMO_MIX_BLEND_CALC_TYPE

A new record for SPEC_NM = MAX_ALERT_BATCH_SIZE is added to global settings

Note: For details on the INDEPENDENT_BATCH_PREP global setting, see the Administrator’s Guide Errata document.
Add the parameter ETLP_POS_ENABLE in JOB_PARAM
Add new indexes :
  • PROD_HIER_IX8 on table PRODUCT_HIER_ASSOC_DM (PROD_HIER_ASSOC_CD,PARENT_PROD_LVL, PROD_HIER_SK)
  • PROD_HIER_IX10 on table PRODUCT_HIER_ASSOC_DM (PROD_HIER_ASSOC_CD, PARENT_PROD_HIER_SK, PROD_LVL, PROD_HIER_SK)
After applying this hotfix '|' is the separator for entries in the following three tables.   • pricing_relation.attr_value_list1
  • pricing_relation.attr_value_list2
  • pricing_reln_match_attr.match_attr_value_list
After installation of HF the following macro needs to be executed to convert existing data (the macro will replace the ',' in attribute values with '|'). New Customers that have no data do not need to run the script.
  • %di_util_update_pricing_reln_attr(src_delim=%str(,),tgt_delim=%str(|));

Add new column CREATED_BY (VARCHAR(40)) to the following tables :
  • PRODUCT_CROSS_EFFECT_SPEC
  • VEHICLE_SUPPORT_MAP
  • VEHICLE_SUPPORT_MAP_PREV
  • MODEL_SPEC_PREV
  • ATTR_SPEC_PREV


P26030  updates  SAS Merchandise Intelligence Workbench Server 5.21_M4

NONE


P52002  updates  SAS Regular Price Optimization 5.2_M4

NONE


P22020  updates  SAS Revenue Optimization Server 5.2_M4

NONE


After completing all of the post-install sections above, run your weekly ETL and back-end jobs.


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

Copyright 2018 SAS Institute Inc. All Rights Reserved.