Hot fix W19005 addresses the issue(s) in SAS Size Optimization 3.4 as documented
in the Issue(s) Addressed section of the hot fix download page:
http://ftp.sas.com/techsup/download/hotfix/HF2/W19.html#W19005
W19005 is a "container" hot fix that contains the following "member" hot fixes which will update the software components
as needed.
W23005 updates SAS Merchandise Intelligence Client 5.4
W24005 updates SAS Merchandise Intelligence Mid-Tier 5.4
W22005 updates SAS Merchandise Intelligence Plug-in for SAS Management Console 5.4
Z33002 updates SAS Merchandise Intelligence Server 5.4
W20005 updates SAS Merchandise Intelligence Workbench Server 5.4
W21005 updates SAS Merchandise Solutions Configuration Workbench 5.4
Y07003 updates SAS Size Profiling Server 3.4
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, W19005pt.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 W19005pt.zip on each machine or save it in a network location that is accessible to all machines.
Do NOT extract the contents of W19005pt.zip. The hot fix installation process will extract the contents as needed.
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 W19005pt.zip, follow the instructions for applying hot fixes in the SAS Deployment Wizard and SAS Deployment Manager 9.4: User's Guide.
Please review the CONFIGURATION Important Note above concerning proper selection of the "Configure SAS Hot Fix" option in the SAS Deployment Manager.
The hot fix installation process generates the log file
<!SASHOME>\InstallMisc\InstallLogs\IT_date-and-time-stamp.logfor 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.
For each product installed, click the link to be redirected to post-installation instructions.
W23005 updates SAS Merchandise Intelligence Client 5.4
W24005 updates SAS Merchandise Intelligence Mid-Tier 5.4
W22005 updates SAS Merchandise Intelligence Plug-in for SAS Management Console 5.4
Z33002 updates SAS Merchandise Intelligence Server 5.4
W20005 updates SAS Merchandise Intelligence Workbench Server 5.4
W21005 updates SAS Merchandise Solutions Configuration Workbench 5.4
Y07003 updates SAS Size Profiling Server 3.4
W23005 updates SAS Merchandise Intelligence Client 5.4
W21005 updates SAS Merchandise Solutions Configuration Workbench 5.4
W24005 updates SAS Merchandise Intelligence Mid-Tier 5.4
Re-build Web Application
In order for this step to execute correctly, the Metadata Server must be running.
1. Invoke the SAS Deployment Manager 9.4
From the SASDeploymentManager directory launch sasdm.exe.
SAS Deployment Manager is installed in the following default location:
<SASHOME>\SASDeploymentManager\9.4
2. Select a language in the Choose Language box
3. Select Rebuild Web Applications
4. Select Configuration Directory or Enter the Configuration Directory and Level that needs to be updated
5. Specify Connection Information, including the sasadm User ID and Password
6. Select SAS Merchandise Intelligence Mid-Tier 5.4 as the Web Application to Rebuild
7. Verify the information on the Summary screen and select Start
8. Select Finish when the deployment is complete
This process will update the SAS Merchandise Intelligence Mid-Tier 5.4 ear in
<SASCONFIGDIR>\Web\StagingA backup of the original ear file will be placed in the directory
<SASCONFIGDIR>\Web\Staging\Backup
9. Exit the SAS Deployment Manager 9.4
Re-deploy Web Application
1. Restart all SAS sessions, daemons, spawners and servers.
2. Invoke the SAS Deployment Manager 9.4
From the SASDeploymentManager directory launch sasdm.exe.
SAS Deployment Manager is installed in the following default location:
<SASHOME>\SASDeploymentManager\9.4
3. Select a language in the Choose Language box
4. Select Deploy 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. Check the Allow the application server to stop checkbox
8. Select SAS Merchandise Intelligence Mid-Tier 5.4 as the Web Application to Deploy
9. Verify the information on the Summary screen and select Start
10. Select Finish and exit the SAS Deployment Manager when the deployment is complete
Z33002 updates SAS Merchandise Intelligence Server 5.4
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 (sasmi).
2. From the sasmi home directory, run the update_datamart script.
/Lev1/Applications/SASMerchIntellServer5.4/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
Note: This hot fix makes following schema changes. For details, see the Administrator’s Guide Errata document.
RDBMS changes:
1. Add two new columns to the table DI_TRANS.PRF_PROFILE
ALTER TABLE PRF_PROFILE ADD PROFILE_STATUS_CD INTEGER;
ALTER TABLE PRF_PROFILE ADD PROFILE_UPDATED_DTTM DATE;
SAS changes:
1. The stage table ‘STG_PROFILE’ is modified to apply datetime informat to STG_PROFILE.PUBLISHED_DT column.
Columns dropped from the table - SO_VAAR_REPORTS:
1) PARTITION_FLG
2) PROD_PARTITION_LEVEL
3) SUB_START_DT
4) NO_OF_WEEKS_FRM_SUB_START_DT
Column added in the table - SO_VAAR_REPORTS:
1) PROJECT_SKS
W22005 updates SAS Merchandise Intelligence Plug-in for SAS Management Console 5.4
NONE
W20005 updates SAS Merchandise Intelligence Workbench Server 5.4
NONE
Y07003 updates SAS Size Profiling Server 3.4
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 W19005 on Windows for x64.
Copyright 2016 SAS Institute Inc. All Rights Reserved.