Installation Instructions for Hot Fix S72010

64-bit Enabled AIX

Hot fix S72010 addresses the issue(s) in SAS Forecast Analyst Workbench 5.2 as documented in the Issue(s) Addressed section of the hot fix download page:

http://ftp.sas.com/techsup/download/hotfix/HF2/S72.html#S72010

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

S73003  updates  SAS Forecast Analyst Workbench Mid-Tier 5.2
S74010  updates  SAS Forecast Analyst Workbench Server 5.2

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, S72010pt.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 S72010pt.zip on each machine or save it in a network location that is accessible to all machines.

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

IMPORTANT NOTES

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

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

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

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

INSTALLATION

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.

Note: During the hot fix installation process, be sure to deselect the 'Configure SAS hot fix' check box when prompted.

After downloading S72010pt.zip, follow the instructions for applying hot fixes in the SAS Deployment Wizard and SAS Deployment Manager 9.4: 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

Perform the following steps to import the product life cycle relationships from the Stage tables to Administration workspace of the SAS Forecast Analyst Workbench user interface:

1. Copy the ddcf_plc_load_phase_out_rltn.sas file from <SAS install path>/misc/ddcfsrv to the location where Nestle Purina has kept the rest of the files that import the PLC relationships.
   Note: You must overwrite the above file if the target location already contains a file with the same name.
   
   
2. Execute the following code through the Code Editor of SAS Data Integration Studio. (Ensure that the user, who runs this macro, is a member of "SAS Administrator" group):
   %include "<Path of the location where all files that import the PLC relationships at Nestle Purina site>/*.sas";
   
   /* Path of the PostgreSQL executable file. For example, the path of PostgreSQL executable on UNIX can be /SASInstall/SASHome/SASWebInfrastructurePlatformDataServer/9.4/bin/psql. */
   %let GL_FAW_BL_PSQL_PATH = <PSQL executable file of the PostgreSQL Database>;
   
   %ddcf_plc_load_stage_to_sdl(libraryin=stage,libraryout=sdl);
   %ddcf_plc_load_sdl_to_uiart;

   After the above code is executed, the following tables are populated in the UIART library:

   • phase_in_dtls
   • phase_in_rltn
   • phase_out_dtls
   • phase_out_rltn
   • successor_dtls
   • successor_rltn
   • dim_rltn_dtls

This completes the installation of hot fix S72010 on 64-bit Enabled AIX.

Copyright 2017 SAS Institute Inc. All Rights Reserved.