Installation Instructions for Hot Fix K37005

Windows

Hot fix K37005 addresses the issue(s) in SAS Size Optimization 3.2_M2 as documented in the Issue(s) Addressed section of the hot fix download page:

http://ftp.sas.com/techsup/download/hotfix/HF2/K37.html#K37005

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

K42007  updates  SAS Merchandise Intelligence Client 5.21_M2
L04005  updates  SAS Merchandise Intelligence Grid Server 5.21_M2
K43007  updates  SAS Merchandise Intelligence Mid-Tier 5.21_M2
K44007  updates  SAS Merchandise Intelligence Plug-in for SAS Management Console 5.21_M2
K40003  updates  SAS Merchandise Intelligence Server 5.21_M2
K45007  updates  SAS Merchandise Intelligence Workbench Server 5.21_M2
K46007  updates  SAS Merchandise Solutions Configuration Workbench 5.21_M2
K41004  updates  SAS Pack Optimization Server 3.2_M2
K61002  updates  SAS Size Profiling Server 3.2_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 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, K37005pt.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 K37005pt.zip on each machine or save it in a network location that is accessible to all machines.

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

IMPORTANT NOTES

1. You must have SAS Merchandise Intelligence 5.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.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
   • after your weekly activity has completed
   • before the weekly ETL and back-end job

INSTALLATION

The hot fix will be applied using the SAS Deployment Manager (SDM). By default, the SDM 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 K37005pt.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

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.

K42007  updates  SAS Merchandise Intelligence Client 5.21_M2
L04005  updates  SAS Merchandise Intelligence Grid Server 5.21_M2
K43007  updates  SAS Merchandise Intelligence Mid-Tier 5.21_M2
K44007  updates  SAS Merchandise Intelligence Plug-in for SAS Management Console 5.21_M2
K40003  updates  SAS Merchandise Intelligence Server 5.21_M2
K45007  updates  SAS Merchandise Intelligence Workbench Server 5.21_M2
K46007  updates  SAS Merchandise Solutions Configuration Workbench 5.21_M2
K41004  updates  SAS Pack Optimization Server 3.2_M2
K61002  updates  SAS Size Profiling Server 3.2_M2

K42007  updates  SAS Merchandise Intelligence Client 5.21_M2

NONE

L04005  updates  SAS Merchandise Intelligence Grid Server 5.21_M2

NONE

K43007  updates  SAS Merchandise Intelligence Mid-Tier 5.21_M2

Web application Update

Delete

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

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

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

Step 4:    Stop and restart the Web application server.

K44007  updates  SAS Merchandise Intelligence Plug-in for SAS Management Console 5.21_M2

NONE

K40003  updates  SAS Merchandise Intelligence Server 5.21_M2

Run the Update Data Mart Script to update the existing data mart: 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.bat

3. Check the log file (update_datamart.log) for output and errors.
   

%macro add_gs_unreqskus(m_di_data=);
proc sql;
            select count (*) into :_exists from &m_di_data..global_setting
               where spec_nm = 'ALLOW_UNREQUESTED_SKUS';
      quit;

      %if &_exists = 0 %then %do;
            proc sql;
                  insert into &m_di_data..global_setting (SPEC_NM,APP,SPEC_VALUE,SPEC_DESC) values
                     ('ALLOW_UNREQUESTED_SKUS','SZPK','1','Specifies whether packs with SKUs that were unrequested at a store may still be used at that store');
            quit;
      %end;
      %else %do;
            proc sql;
               update &m_di_data..global_setting set spec_desc =
                 'Specifies whether packs with SKUs that were unrequested at a store may still be used at that store' where
                  spec_nm = 'ALLOW_UNREQUESTED_SKUS';
            quit;
      %end;
%mend;

%add_gs_unreqskus(m_di_data=di_data);

      

K45007  updates  SAS Merchandise Intelligence Workbench Server 5.21_M2

NONE

K46007  updates  SAS Merchandise Solutions Configuration Workbench 5.21_M2

NONE

K41004  updates  SAS Pack Optimization Server 3.2_M2

NONE

K61002  updates  SAS Size Profiling Server 3.2_M2

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 K37005 on Windows.