Installation instructions for hot fix J78003 on HP-UX IPF

Installation Instructions for Hot Fix J78003

HP-UX IPF

Hot fix J78003 addresses the issue(s) in SAS Decision Services 5.6 as documented in the Issue(s) Addressed section of the hot fix download page:

http://ftp.sas.com/techsup/download/hotfix/HF2/J78.html#J78003

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

J88003 updates SAS Decision Services Design Mid-Tier 5.6
J89003 updates SAS Decision Services Engine Server 5.6
J90003 updates SAS Decision Services Logical File Types 5.6
J85003 updates SAS Decision Services Monitor 5.6
J86003 updates SAS Decision Services Plug-ins for SAS Management Console 5.6
J87003 updates SAS Decision Services Server Configuration 5.6

See What is a container hot fix? in the Hot Fix FAQ for more information about container hot fixes.

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

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

IMPORTANT NOTES

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.

INSTALLATION

Hot Fix J78003 must be installed on each machine where the updated components of the product, listed above, are installed. During the installation process you may see references to all operating systems for which updates are provided in the hot fix. The installation process will determine the operating system and which component(s) of SAS Decision Services 5.6 require updating on the machine. See SAS Note 44810 for more details.

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

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

POST-INSTALLATION INSTRUCTIONS

For each product installed, click the link to be redirected to post-installation instructions.

J88003 updates SAS Decision Services Design Mid-Tier 5.6
J89003 updates SAS Decision Services Engine Server 5.6
J90003 updates SAS Decision Services Logical File Types 5.6
J85003 updates SAS Decision Services Monitor 5.6
J86003 updates SAS Decision Services Plug-ins for SAS Management Console 5.6
J87003 updates SAS Decision Services Server Configuration 5.6

Review SAS Notes
After the installation of this hot fix and product post-installation instructions, please review the following SAS Notes for details on changes that are required to take advantage of the fix.

PoolDiagnostics page - See SAS Notes 49630, 51997
Logging switches for quick performance measurement – See SAS Note 51264
Monitor enhancements to cleanup old data – See SAS Note 51268

J88003 updates SAS Decision Services Design Mid-Tier 5.6

Web application Update

This hot fix requires steps that will update the web application deployed to your application server.

Step 1: Re-build Web Applications

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

1.1 Invoke the SAS Deployment Manager 9.3

From the SASDeploymentManager directory launch sasdm.sh. The default installation path for the SAS Deployment Manager is

<SASHOME>/SASDeploymentManager/9.3

1.2 Select a language in the Choose Language box

1.3 Select Rebuild Web Applications

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

1.5 Specify Connection Information, including the sasadm User ID and Password

1.6 Select SAS Decision Services Design Mid-Tier as the Web Application to Rebuild

1.7 Verify the information on the Summary screen and select Start

1.8 Select Finish when the deployment is complete

This process will update the SAS Decision Services Design Mid-Tier ear in <CONFIGDIR>/Lev1/Web/Staging. A backup of the original ear file will be placed in the Backup directory.

Step 2: Re-deploy Web Applications

2.1 Re-deploy the updated ear listed above to the web application server you are using based on the instructions appropriate for your web application server. See SAS 9.3 Intelligence Platform, Middle-Tier Administration Guide, Chapter 7, Administering SAS Web Applications, for more details.

Metadata Update

In order to complete this hot fix, two new properties are required to be manually added to your Decision Services metadata. To add these properties, perform the steps detailed in SAS Note 55831: SAS® Real-Time Decision Manager incorrectly assumes that dates returned from queries to Oracle are in the GMT time zone.

J89003 updates SAS Decision Services Engine Server 5.6

Web application Update

This hot fix requires steps that will update the web application deployed to your application server.

Step 1: Re-build Web Applications

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

1.1 Invoke the SAS Deployment Manager 9.3

From the SASDeploymentManager directory launch sasdm.sh. The default installation path for the SAS Deployment Manager is

<SASHOME>/SASDeploymentManager/9.3

1.2 Select a language in the Choose Language box

1.3 Select Rebuild Web Applications

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

1.5 Specify Connection Information, including the sasadm User ID and Password

1.6 Select SAS Decision Services Engine Server as the Web Application to Rebuild

1.7 Verify the information on the Summary screen and select Start

1.8 Select Finish when the deployment is complete

This process will update the SAS Decision Services Engine Server ear in <CONFIGDIR>/Lev1/Web/Staging. A backup of the original ear file will be placed in the Backup directory.

Step 2: Re-deploy Web Applications

Metadata Update

J90003 updates SAS Decision Services Logical File Types 5.6

NONE

J85003 updates SAS Decision Services Monitor 5.6

Web application Update

This hot fix requires steps that will update the web application deployed to your application server.

Step 1: Re-build Web Applications

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

1.1 Invoke the SAS Deployment Manager 9.3

From the SASDeploymentManager directory launch sasdm.sh. The default installation path for the SAS Deployment Manager is

<SASHOME>/SASDeploymentManager/9.3

1.2 Select a language in the Choose Language box

1.3 Select Rebuild Web Applications

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

1.5 Specify Connection Information, including the sasadm User ID and Password

1.6 Select SAS Decision Services Monitor as the Web Application to Rebuild

1.7 Verify the information on the Summary screen and select Start

1.8 Select Finish when the deployment is complete

This process will update the SAS Decision Services Monitor ear in <CONFIGDIR>/Lev1/Web/Staging. A backup of the original ear file will be placed in the Backup directory.

Step 2: Re-deploy Web Applications

Metadata Update

J86003 updates SAS Decision Services Plug-ins for SAS Management Console 5.6

NONE

J87003 updates SAS Decision Services Server Configuration 5.6

Note that these instructions provide example filenames and directory names based on a Windows deployment. If your deployment is to a different operating system please make the appropriate adjustments.

There is one sas file that is included in this Hotfix. It will need to be modified and reloaded to the Federation Server database. Instructions for modifying this sas file are as follows.

Make a backup of all the files located in <CONFIGDIR>\Lev1\Applications\SASDecisionServicesServerConfig5.6\SASCode
Copy the tap_table.sas.orig file from <SASHOME>\SASDecisionServicesServerConfiguration\5.6\Configurable\SASCode to <CONFIGDIR>\Lev1\Applications\SASDecisionServicesServerConfig5.6\SASCode
Modify this file replacing all instances of the connection string token with values that match your configuration. Be sure the file to be loaded contains the Federation Server Admin password.
```
Ex:  proc ds2 nolibs noprompt="@sas.activity.connection.string@";
Becomes:  proc ds2 nolibs noprompt="driver=remts;server=<Federation Server hostname>;port=21032;protocol=bridge;uid=fedsrv;pwd=ENTER FEDERATION
SERVER ADMIN PASSWORD;conopts=(DSN=BASE_DSN)";
```
To simplify this step, copy the proc ds2 statement from the .sas file of the same name to the .sas.orig file.
Delete the *.sas file that will be replaced by the *.sas.orig file.
Rename the *sas.orig file to be <filename>.sas
From SAS Display Manager, execute <CONFIGDIR>\Lev1\Applications\SASDecisionServicesServerConfig5.6\SASCode\tap_table.sas.