Installation Instructions for Hot Fix D81009

64-bit Enabled AIX


Hot fix D81009 addresses the issue(s) in SAS Merchandise Intelligence 4.2_M2 on 64-bit Enabled AIX as documented in the Issue(s) Addressed section of the hot fix download page:

http://ftp.sas.com/techsup/download/hotfix/HF2/D81.html#D81009


D81009 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.

D86007 for SAS Merchandise Intelligence Client 4.2_M2
D83008 for SAS Merchandise Intelligence Mid-Tier 4.2_M2
D85007 for SAS Merchandise Intelligence Plug-in for SAS Management Console 4.2_M2
D82008 for SAS Merchandise Intelligence Server 4.2_M1
D84007 for SAS Merchandise Solutions Configuration Workbench 4.2_M2
E28003 for SAS Pack Optimization Server 2.2_M1
D87005 for SAS Promotion Optimization 4.2_M1
E62004 for SAS Regular Price Optimization 4.2_M1
D88003 for SAS Size Profiling 2.2_M1

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. You must have SAS Merchandise Intelligence 4.2_M2 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.2 maintenance release documentation about back up tasks:
    http://support.sas.com/documentation/cdl/en/whatsdiff/63928/HTML/default/viewer.htm#p083vd5jhklkfun1dxrana9mo7co.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.02232009
           where 02232009 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 servers except the SAS Metadata Server must be shut down as follows

  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

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 Merchandise Intelligence 4.2_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 D81009r6.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 D81009r6.bin
2. Set your $DISPLAY environment variable
export DISPLAY=<your_node_name>:0
3. Execute D81009r6.bin
<path_to_downloaded_file>/D81009r6.bin
    For example:
./D81009r6.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.

This completes the installation of D81009. 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.

D86007 for SAS Merchandise Intelligence Client 4.2_M2
D83008 for SAS Merchandise Intelligence Mid-Tier 4.2_M2
D85007 for SAS Merchandise Intelligence Plug-in for SAS Management Console 4.2_M2
D82008 for SAS Merchandise Intelligence Server 4.2_M1
D84007 for SAS Merchandise Solutions Configuration Workbench 4.2_M2
E28003 for SAS Pack Optimization Server 2.2_M1
D87005 for SAS Promotion Optimization 4.2_M1
E62004 for SAS Regular Price Optimization 4.2_M1
D88003 for SAS Size Profiling 2.2_M1


D86007 for SAS Merchandise Intelligence Client 4.2_M2

Updates to SAS Merchandise Intelligence Client machines are also required. Since this component can only be installed on Windows and Windows for x64, you must download D81007 for Windows and apply the hot fix per the installation instructions provided.


D83008 for SAS Merchandise Intelligence Mid-Tier 4.2_M2

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

If this component is installed on AIX, follow the steps below to rebuild and redeploy the web application:

Re-build Web Application

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

1. Set the DISPLAY environment variable, for example

$ export DISPLAY=:0

2. Invoke the SAS Deployment Manager 9.2

From the SASDeploymentManager directory execute config.sh, for example

$ cd <SASHOME>/SASDeploymentManager/9.2
$ ./config.sh

3. Select a language in the Choose Language box

4. Select Rebuild Web Applications

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

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

7. Select SAS Merchandise Intelligence Mid-Tier 4.2 as the Web Application to Rebuild

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

9. Select Finish when the deployment is complete

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

<SASCONFIGDIR>/Lev1/Web/Staging
A backup of the original ear file will be placed in the directory
<SASCONFIGDIR>/Lev1/Web/Staging/Backup

Re-deploy Web Application

1. Re-deploy the SAS Merchandise Intelligence Mid-Tier 4.2 web application (only). Details are provided at

http://support.sas.com/documentation/cdl/en/biwaag/63536/HTML/default/viewer.htm#/documentation/cdl/en/biwaag/63536/HTML/default/a003308992.htm

Note: Select sas.miserver4.2.ear when re-deploying the web application.
2. Stop and restart the Web application server.
Note for WebLogic: If the SAS Merchandise Intelligence Mid-Tier is not started automatically after following the instructions in the link above, you will need to manually start it from the WebLogic Admin Console.


Alternative Method: The SAS Merchandise Intelligence Mid-Tier can be re-deployed to WebLogic using the following steps. The equivalent steps for WebSphere are documented in the Replace the entire application method in the detailed document link above.

1. Ensure all the services are running, including WebLogic Admin Console and Managed Server, i.e. SASServer1.

2. Login to WebLogic Admin Console.

3. Click on Lock and Edit.

4. Select the sas.miserver4.2 ear and click on the Update button.

5. Accept the default path and click on OK.

6. Click on the Activate changes button.

The web application server does not need to be restarted after using the alternative method. The Activate changes step will restart the SAS Merchandise Intelligence Mid-Tier internally.


SAS REVENUE OPTIMIZATION ONLY: UPDATE DAV CONTENT

If you have a new install or have NOT already applied Hot Fix 4 or 5 (D81006), do the following:

Note:  To use DAVTree on UNIX, you must have a graphical interface. If you do not have a graphical interface, use a UNIX command line tool that supports upload to WebDAV. For example, use DAVExplorer instead of DAVTree to perform the following steps.

If you have performed XML configuration modifications to rpp-vendor-spreadsheet-forms.xml that are currently stored on a DAV server and you have your own template xls files, then perform the following steps:

  1. Edit the existing rpp-vendor-spreadsheet-forms.xml file in WebDAV, so that for all "form" elements the "template-url" attribute points only to filename (without any path), e.g. if it was "template-url=’c:\\mypath\\my_template.xls’" change it to "template-url=’my_template.xls’"

  2. Use DavTree to upload into WebDAV all template xls files that are referenced from rpp-vendor-spreadsheet-forms.xml.
    Note: There is no need to upload real vendor deal files - only templates.

If you did NOT modify rpp-vendor-spreadsheet-forms.xml and do NOT have your own template xls files, then perform the following steps:
  1. Edit the existing rpp-vendor-spreadsheet-forms.xml file in WebDAV, so that the "form" element has text "template-url=’Sample Vendor Deal.xls’"

  2. Use DavTree to upload new vendor deal template xls file into WebDAV:


D85007 for SAS Merchandise Intelligence Plug-in for SAS Management Console 4.2_M2

Since this component can only be installed on Windows and Windows for x64, you must download D81007 for Windows and apply the hot fix per the installation instructions provided.


D82008 for SAS Merchandise Intelligence Server 4.2_M1

RUN DATABASE COMMAND
Run the following against your DB2 or Oracle database:
delete from PROFILE_LOOKUP_STAT where NUM_PROFILE_LOOKUP is null;

RUN DATABASE ALTER SCRIPTS
Locate the .sql alter script in the following directory:
!SASROOT/misc/di/dbmsc


If you have already applied Hot Fix 6 (D81006) or Hot Fix 8 (D81008), there are no database scripts to run.

If you have NOT already applied Hot Fix 6 (D81006):
alter_m1mi42_db2_hf6.sql or alter_m1mi42_orcl_hf6.sql

If you have a new install or have NOT already applied Hot Fix 2 (D81002), Hot Fix 6 (D81006), and Hof Fix 8(D81008):
alter_m1mi42_db2_hf2.sql or alter_m1mi42_orcl_hf2.sql
alter_m1mi42_db2_hf6.sql or alter_m1mi42_orcl_hf6.sql


DB2
On the SAS Server machine, locate and run the appropriate scripts for updating DB2 tables.

Uncomment the following lines and substitute appropriate values for DB_NAME, USER_NAME (for example, DI_DM), PASSWORD, and SCHEMA.
       -- CONNET TO DB_NAME USER USER_NAME USING PASSWORD;
       -- SET CURRENT SCHEMA = schema_name;

Oracle
On the SAS Server machine, locate and run the appropriate scripts 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;


FOR SIZE OPTIMIZATION ONLY, DROP AND RECREATE SEQUENCE KEYS
Drop and recreate the SEQ_PKO_PSS_REQUESTID and SEQ_BUY_SK sequence keys.
When you recreate the sequence keys, ensure that their maximum and minimum values do not overlap.
For SEQ_PKO_PSS_REQUESTID, you must find the highest REQUEST_ID in the REQUEST table and recreate SEQ_PKO_PSS_REQUESTID with a higher starting sequence. For example:

DROP SEQUENCE SEQ_PKO_PSS_REQUESTID;
CREATE SEQUENCE SEQ_PKO_PSS_REQUESTID
START WITH 1000000000 CYCLE
MAXVALUE 1147483647
MINVALUE 1000000000

SEQUENCE SEQ_BUY_SK
For SEQ_BUY_SK, you can drop and recreate as follows:

DROP SEQUENCE SEQ_BUY_SK;
CREATE SEQUENCE SEQ_BUY_SK
START WITH 1148000000
CYCLE
MAXVALUE 2147483647
MINVALUE 1148000000

RUN SAS ALTER SCRIPTS
Locate the .sas alter scripts in the following directory:
!SASROOT/misc/di/dbmsc

Edit each of the following scripts that you are required to run:        a. Remove the comment in front of the macro call.
       b. Examine the macro call and the parameters supplied in each script. Unless the user has deviated from default behavior, the macro call need not be changed.
           For example:
               %alter_m1mi42_sas_hf*(LIBREF=DI_DATA,DTTMFMT=DATETIME21., DTFMT=DATE9.);

If you have already applied Hot Fix 8 (D81008), there are no scripts to run.

If you have already applied Hot Fix 4 (D81004):
       Run alter_m1mi42_sas_hf8.sas
       %let LIBREF = DI_DM;
       %include "/alter_m1mi42_sas_hf8.sas";


If you have NOT already applied Hot Fix 4 (D81004):
       1.   Run alter_m1mi42_sas_hf4.sas
           %let LIBREF = DI_DM;
           %include "/alter_m1mi42_sas_hf4.sas";

       2.  Run alter_m1mi42_sas_hf8.sas
           %let LIBREF = DI_DM;
           %include "/alter_m1mi42_sas_hf8.sas";


If you are a new deployment or have NOT applied Hot Fix 1 (D81001), Hot Fix 2 (D81002), Hot Fix 4 (D81004), and Hot Fix 8 (D81008):
  1.  Run alter_m1mi42_sas_hf1.sas
           %let LIBREF = DI_DM;
           %include "/alter_m1mi42_sas_hf1.sas";

    Note:
    Please ignore the following error:
           ERROR: Add/Update failed for data set DI_DATA.GLOBAL_SETTING because data value(s) do not comply with integrity constraint PRIM_KEY.

  1.  Run alter_m1mi42_sas_hf2.sas
           %let LIBREF = DI_DM;
           %include "/alter_m1mi42_sas_hf2.sas";

    Note:
    Ignore the following compilation time warning because the macro name and mend name don’t match:
    WARNING: Extraneous information on %MEND statement ignored for macro definition
           ALTER_M1MI42_SAS_HF2.

  1.  Run alter_m1mi42_sas_hf4.sas
           %let LIBREF = DI_DM;
           %include "/alter_m1mi42_sas_hf4.sas";

  1.  Run alter_m1mi42_sas_hf8.sas
           %let LIBREF = DI_DM;
           %include "/alter_m1mi42_sas_hf8.sas";


D84007 for SAS Merchandise Solutions Configuration Workbench 4.2_M2

Updates to Merchandise Solutions Configuration Workbench machines are also required. Since this component can only be installed on Windows and Windows for x64, you must download D81007 for Windows and apply the hot fix per the installation instructions provided.


E28003 for SAS Pack Optimization Server 2.2_M1

NONE


D87005 for SAS Promotion Optimization 4.2_M1

NONE


E62004 for SAS Regular Price Optimization 4.2_M1

NONE


D88003 for SAS Size Profiling 2.2_M1

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 D81009 on 64-bit Enabled AIX.