Installation Instructions for Hot Fix D4Z007

Windows for x64

Hot fix D4Z007 addresses the issue(s) in SAS Risk Governance Framework 7.4 as documented in the Issue(s) Addressed section of the hot fix download page:

https://tshf.sas.com/techsup/download/hotfix/HF2/D4Z.html#D4Z007

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

D6X006  updates  SAS Risk Governance Framework Administrative Tools 7.4
D5B006  updates  SAS Risk Governance Framework Mid-Tier 7.4
D5A005  updates  SAS Risk Governance Framework Server 7.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, D4Z007pt.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 D4Z007pt.zip on each machine or save it in a network location that is accessible to all machines.

Do NOT extract the contents of D4Z007pt.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.

5. CONFIGURATION: No automatic configuration scripting is included for this hot fix. If you have previously configured software installed, the SAS Deployment Manager may present a screen where you will see "Apply SAS Hot Fixes" and "Configure SAS Hot Fixes" options. On this screen, you must ensure that the "Configure SAS Hot Fix" option is *not* selected. If this option is automatically selected, please de-select it prior to proceeding with the SAS Deployment Manager Screens. Failure to do so could have unintended consequences when applying this hot fix.

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.

After downloading D4Z007pt.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.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.

Security Update

POST-INSTALLATION INSTRUCTIONS

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

D6X006  updates  SAS Risk Governance Framework Administrative Tools 7.4
D5B006  updates  SAS Risk Governance Framework Mid-Tier 7.4
D5A005  updates  SAS Risk Governance Framework Server 7.4

D6X006  updates  SAS Risk Governance Framework Administrative Tools 7.4

1. Copy the following files from <SASHOME>\SASRiskGovernanceFrameworkAdministrativeTools\7.4\dbscripts to <SASCONFIGDIR>\Lev1\Applications\SASRiskGovernanceFrameworkAdministrativeTools\dbscripts

   a. extractContent.cmd
   b. extractContent.config
   c. removeWorkflowInstances.cmd
   d. removeWorkflowInstances.config

2. Copy the following files from <SASHOME>\SASRiskGovernanceFrameworkAdministrativeTools\7.4\dbscripts\data to <SASCONFIGDIR>\Lev1\Applications\SASRiskGovernanceFrameworkAdministrativeTools\dbscripts\data

   a. Workflows.csv
   b. Workflows.mappings.config

D5B006  updates  SAS Risk Governance Framework Mid-Tier 7.4

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

For more information about how to rebuild and redeploy Web Applications, see the SAS® 9.4 Intelligence Platform, Middle-Tier Administration Guide, Chapter 8 Administering SAS Web Applications.

1. Rebuild Web Applications

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

   Select the appropriate product as the Web Application to Rebuild

2. Re-start all SAS sessions, daemons, spawners and servers. For more information on the proper order for starting servers, go to SAS® 9.4 Intelligence Platform: System Administration Guide, Fourth Edition and review the section entitled "Starting, Stopping and Checking the Status of Servers".

3. Redeploy Web Applications

   Redeploy the updated wars to the web application server.

After the web application servers are restarted, complete the following steps

1. Copy the following files from <SASHOME>\SASRiskGovernanceFrameworkMidTier\7.4\Config\Deployment\Content\Preload\rgf-system\Scripts to the SAS Content Server, under the folder \SASContentServer\repository\default\sasdav\Products\SASRiskGovernanceFramework\RiskGovFrwkMid-Tier\rgf-system\Scripts, and replace any existing scripts.

   a. listCustomFields.groovy
   b. list_enums.groovy
   c. groovyEditor.groovy

2. After deploying the hotfix, you must examine any RGF and content package groovy scripts or functions for references to the Apache Struts library. If the groovy scripts use the following Struts classes, you must replace them with the RGF classes indicated below:

   org.apache.struts.util.LabelValueBean -> com.sas.oprisk.framework.server.util.LabelValueBean
   org.apache.struts.action.ActionMessage -> com.sas.oprisk.framework.server.util.ActionMessage
   org.apache.struts.action.ActionMessages -> com.sas.oprisk.framework.server.util.ActionMessages

3. Login to SAS Risk Governance Framework as an administrator. Flush caches.

4. Stop SOLR and apply the updates to the managed-schema file.

   a. Change directories to <SOLRHOME>\bin and run the following command to stop SOLR.
       solr stop -p 8983
   b. Change directories to <SOLRHOME>\server\solr\rgf\conf and run the following to command to backup managed-schema
       copy managed-schema managed-schema.bak
   c. Copy the new managed-schema from <SASHOME> directory to the SOLR configuration directory.
       copy <SASHOME>\SASRiskGovernanceFrameworkMidTier\7.4\Config\Samples\Solr\managed-schema <SOLRHOME>\server\solr\rgf\conf
   d. Change directories to <SOLRHOME>\bin and run the following command to start SOLR.
       solr start -p 8983 -m <mem_size>
   e. Change directories to <SASCONFIGDIR>\Lev1\Applications\SASRiskGovernanceFrameworkAdministrativeTools\dbscripts and update the SOLR search index for each installed content package, where content_id is “mrm”, “gcm”, “rmc”, etc.
       updateindex.cmd -c <content_id>

D5A005  updates  SAS Risk Governance Framework Server 7.4

1. Update the SAS Localization Labels:
   
   Open a SAS session, paste the following code into the SAS Editor and run the code.
   

   %SMD2DS(DIR=<SASHOME>\SASFoundation\9.4\rskmgtsvr\smd, BASENAME=rskmgtsvr, LOCALE=en, lib=SASHELP);

   *NOTE: Be sure to run the above SAS code in the same SAS session encoding that was used when the product was installed and configured.

2. Copy the following files from <SASHOME> to <SASCONFIGDIR>
   

   <SASHOME>\SASFoundation\9.4\rskmgtsvr\ucmacros\rgf_post_init.sas.orig
   <SASHOME>\SASFoundation\9.4\rskmgtsvr\sasmisc\control\grid_host.map
   <SASHOME>\SASFoundation\9.4\rskmgtsvr\ucmacros\rgf_job_load_audit_data.sas
   to
   <SASCONFIGDIR>\Lev1\AppData\SASRiskGovernanceFramework\Source\ucmacros\rgf_post_init.sas.orig
   <SASCONFIGDIR>\Lev1\AppData\SASRiskGovernanceFramework\Source\sasmisc\control\grid_host.map
   <SASCONFIGDIR>\Lev1\AppData\SASRiskGovernanceFramework\Source\ucmacros\rgf_job_load_audit_data.sas

3. Rename the "rgf_post_init.sas" in "<SASCONFIGDIR>\Lev1\AppData\SASRiskGovernanceFramework\Source\ucmacros"
   

   From:  rgf_post_init.sas
   To:      rgf_post_init.sas.old

4. Replace tokens w\ directory paths:

   A) Using a text editor, replace the tokens in the files with the paths listed below:
   
   <SASCONFIGDIR>\Lev1\AppData\SASRiskGovernanceFramework\Source\ucmacros\rgf_post_init.sas.orig
   
   Token: @CNTLFILEDIR@
   Path: <SASCONFIGDIR>\Lev1\AppData\SASRiskGovernanceFramework\Source\sasmisc\control
   
   
   B) Copy the lines below in "<SASCONFIGDIR>\Lev1\AppData\SASRiskGovernanceFramework\Source\ucmacros\rgf_post_init.sas.old"
   
   Example:
   
   %let rskmgt_dbserver=%upcase(PostgreSQL);
   %let rskmgt_dbengine=%upcase(POSTGRES);
   %let rskmgt_dbName=rgfdbname;
   %let rskmgt_dbAuth=RGF_db_auth;
   %let rskmgt_dbServerNm=xxx.abc.com;
   %let rskmgt_dbport=1001;
   
   and overwrite the following lines in "<SASCONFIGDIR>\Lev1\AppData\SASRiskGovernanceFramework\Source\ucmacros\rgf_post_init.sas.orig"
   
   %let rskmgt_dbserver=%upcase(@DBMS_TYPE@);
   %let rskmgt_dbengine=%upcase(@DBENGINE@);
   %let rskmgt_dbName=@DBIDENTIFIER@;
   %let rskmgt_dbAuth=@DBMS_AUTH@;
   %let rskmgt_dbServerNm=@DBMS_SERVER@;
   %let rskmgt_dbport=@DBMS_PORT@;
   
   
   C) Save the changes to the file.
   
   
   D) Rename
   <SASCONFIGDIR>\Lev1\AppData\SASRiskGovernanceFramework\Source\ucmacros\rgf_post_init.sas.orig
   to
   <SASCONFIGDIR>\Lev1\AppData\SASRiskGovernanceFramework\Source\ucmacros\rgf_post_init.sas
   to remove the ".orig" file suffix.

   
   This completes the installation of hot fix D4Z007 on Windows for x64.
   
   
   Copyright 2019 SAS Institute Inc. All Rights Reserved.