Installation Instructions for Hot Fix D82004
Windows for x64
Hot fix D82004 addresses the issue(s) in SAS Merchandise Intelligence Server 4.2_M1 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/D81.html#D82004
IMPORTANT NOTES
-
You must have SAS Merchandise Intelligence Server 4.2_M1 and
Hot Fix D81003 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.
-
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.
-
You must have Administrator Privileges on your CLIENT or SERVER machine.
-
All currently active SAS sessions, daemons, spawners and servers must be terminated
before applying this hot fix.
-
This hot fix should be installed using the same userid who performed the initial software
installation.
- You must deploy the hot fix in the following timeframe
- after your weekly activity has completed
- before the weekly ETL and back-end job
- It is highly recommended that you back up the entire "di" directory in your
SAS Deployment prior to installing this hot fix.
This directory is located in <!SASHOME>\SASFoundation\9.2\di.
<!SASHOME> is the directory where SAS 9.2 is installed.
INSTALLATION
1. The installer downloaded is D82004x6.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.
2. Execute D82004x6.exe
This will initiate the installation wizard, which will guide you through the hot fix
installation process.
Note: If your Windows operating system is Windows Vista, Windows 7 or
Windows Server 2008, it may be necessary to "right-click" D82004x6.exe and select
"Run as administrator".
See the Maintenance Installation Tool
(MIT) documentation for more details on the installation of hot fixes.
The content of this hot fix is listed in the hot fix manifest.
POST-INSTALLATION INSTRUCTIONS
ADD THE NEW DI_EXPORT_SALES_FORECAST JOB PARAMETER TO THE JOB_PARAM TABLE IN THE DI_MON LIBRARY:
Add the following DI_EXPORT_SALES_FORECAST job parameter to the JOB_PARAM table:
- etlp_daily_model: The parameter to request daily forecasts.
For more details on this new parameter and other new export information, see the Errata
documentation for the Administrator’s Guide on the documentation Web site.
Insert the etlp_daily_model parameter into the DI_MON library with SQL code like the following:
proc sql noprint;
DELETE FROM di_mon.job_param where jobname = ‘<JOB_NAME>’ and param_name='<PARAM_NAME>’;
Insert into di_mon.job_param
(jobname, param_name, param_value, default_func)
values("<JOB_NAME>", "<PARAM_NAME>","<PARAM_VALUE>",'"<PARAM_DEFAULT>"')
;
quit;
For example, for these values:
JOB_NAME=DI_EXPORT_SALES_FORECAST
PARAM_NAME=etlp_daily_model
PARAM_VALUE=1
PARAM_DEFAULT=1
The SQL statement would be:
proc sql noprint;
DELETE FROM di_mon.job_param where jobname = 'DI_EXPORT_SALES_FORECAST' and param_name='etlp_daily_model';
Insert into di_mon.job_param
(jobname, param_name, param_value, default_func)
values("DI_EXPORT_SALES_FORECAST", "etlp_daily_model","1",'"1"')
;
quit;
This completes the installation of hot fix D82004 on Windows for x64.