Hot fix F6R015 addresses the issue(s) in SAS Fraud Management 6.1 as documented
in the Issue(s) Addressed section of the hot fix download page:
https://tshf.sas.com/techsup/download/hotfix/HF2/F6R.html#F6R015
Important: SAS 9.4 M7 is required for this hot fix. If your servers need to be upgraded, you must contact your SAS Account Representative
for a new software order. Do not proceed with this hot fix installation until a software order is obtained and the SAS software
depot is downloaded and available to your servers.
If your servers are already at SAS 9.4 M7 and you have not previously installed the SAS Security Update 2023-09 or later, you must install it
immediately after applying this hot fix.
Please read this entire document before beginning the hot fix installation.
I8K003 updates SAS Fraud Management Common Macros 6.1
G6C008 updates SAS Fraud Management Data Services 6.1***
F8Y011 updates SAS Fraud Management Decision Engine 6.1***
F6S014 updates SAS Fraud Management Mid-Tier 6.1***
I8L005 updates SAS Fraud Management Reporting History ETL Server Macros 6.1***
I8M003 updates SAS Fraud Management System of Record DB Maintenance Macros 6.1
F6T008 updates SAS Fraud Management Transaction Extensions 6.1
F8Z011 updates SAS Fraud Transactional Analysis Engine 6.1***
*** member hot fixes that have been updated since the previously released hot fix (F6R014)
Software Component | Server | F6R001 HF1 | F6R002 HF2 | F6R003 HF3 | F6R004 HF4 | F6R005 HF5 | F6R006 HF6 | F6R007 HF7 | F6R008 HF8 | F6R009 HF9 | F6R010 HF10 | F6R011 HF11 | F6R012 HF12 | F6R013 HF13 | F6R014 HF14 | F6R015 HF15 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SAS FM Common Macros 6.1 | Batch Server (Unix) | - | - | - | I8K001 | - | I8K002 | - | - | - | I8K003 | - | - | - | - | - |
SAS FM Data Services 6.1 | Data Server (Unix) | G6C001 | - | - | G6C002 | - | G6C003 | - | G6C004 | G6C005 | G6C006 | - | G6C007 | - | - | G6C008 |
SAS FM Decision Engine 6.1 | Decision Server | F8Y001 | - | - | F8Y002 | F8Y003 | F8Y004 | - | F8Y005 | F8Y006 | F8Y007 | F8Y008 | F8Y009 | - | F8Y010 | F8Y011 |
SAS FM Mid-Tier 6.1 | Midtier | F6S001 | F6S002 | F6S003 | F6S004 | F6S005 | F6S006 | F6S007 | F6S008 | F6S009 | F6S010 | F6S011 | F6S012 | - | F6S013 | F6S014 |
SAS FM Reporting History ETL Server Macros 6.1 | Batch Server (Unix) | - | - | - | I8L001 | I8L002 | I8L003 | - | - | - | - | - | I8L004 | - | - | I8L005 |
SAS FM System of Record DB Maintenance Macros 6.1 | Batch Server (Unix) | - | - | - | I8M001 | - | I8M002 | - | - | - | I8M003 | - | - | - | - | - |
SAS FM Transaction Extensions 6.1 | Decision Server (Unix), Rules Server (Unix) | F6T001 | - | - | F6T002 | F6T003 | F6T004 | - | F6T005 | F6T006 | - | - | F6T007 | - | F6T008 | - |
SAS Fraud Transactional Analysis Engine 6.1 | Transaction Analysis Server | F8Z001 | - | - | F8Z002 | F8Z003 | F8Z004 | - | F8Z005 | F8Z006 | F8Z007 | F8Z008 | F8Z009 | F8Z010 | - | F8Z011 |
Before applying this hot fix, follow the instructions in SAS KB0036131 to generate a SAS Deployment Registry report on each server in your environment.
Commands to create the report:Two files are created: DeploymentRegistry.txt and DeploymentRegistry.html. Either of these files can be used to verify that the appropriate product releases are installed on your system. You can determine the current hot fix level by comparing the member hot fix numbers in the HOT FIX COMPONENT HISTORY chart above with the hot fix entries in the Deployment Registry report.
Backup the following on each Server:
Note: When you run the SAS Deployment Manager in a later step to install the hot fix, you must use the -alwaysoverwrite option to force edited files to be replaced with new files in <SASHome>.
For a detailed list of updated files, see the hot fix manifest. NOTE: The manifest is cumulative for all hot fixes for this release.
$ ./sas.servers stop
Hot Fix F6R015 must be installed on each machine where the updated components of the product, listed above, are installed.
The hot fix will be applied using the SAS Deployment Manager (SDM). By default, the SDM 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. Do NOT extract the contents of F6R015pt.zip into the selected directory. The hot fix installation process will extract the contents as needed.
After copying F6R015pt.zip, follow the instructions for applying hot fixes in the SAS Deployment Wizard and SAS Deployment Manager 9.4: User's Guide.
For example:
$ export DISPLAY=<displayname>:0
From the SASDeploymentManager directory execute sasdm.sh
$ cd <SASHOME>/SASDeploymentManager/9.4
$ ./sasdm.sh
Important: The SAS Deployment Manager will present a screen with two options: "Apply SAS hot fix" and "Configure SAS hot fix" On this screen, you must ensure that the "Configure SAS hot fix" option is *not* selected before continuing.
Notes:
$ ./sasdm.sh -reinstallhotfix
$ ./sasdm.sh -alwaysoverwrite
The hot fix installation process generates a log whose name matches this pattern:
<SASHOME>/InstallMisc/InstallLogs/IT_date-and-time-stamp.logAn example file name is: IT_2021-05-28-11.00.31.log. Each attempt to apply a hot fix results in the creation of a new log file giving detailed information regarding the installation process.
For each member hot fix, additional logs are written to the <SASHOME>/InstallMisc/InstallLogs directory. The logs whose names end with "_Install_postexec.log" identify the files that were added, backed up, changed and removed by the installation of that member hot fix.
This section describes custom steps that depend on the starting version of your system before this hot fix was installed. Locate your starting version in the first column of the table below and perform only those steps listed in the second column for that version.
Starting Version | Steps |
---|---|
6.1M0 (No Hot Fix) or 6.1M0 HF1 or 6.1M0 HF2 or 6.1M0 HF3 |
Steps for upgrade from base 6.1M0, HF1, HF2, HF3 to HF15
|
6.1M0 HF4 or 6.1M0 HF5 |
Steps for upgrade from HF4, HF5 to HF15
|
6.1M0 HF6 or 6.1M0 HF7 or 6.1M0 HF8 or 6.1M0 HF9 or 6.1M0 HF10 or 6.1M0 HF11 |
Steps for upgrade from HF6, HF7, HF8, HF9, HF10, HF11 to HF15
|
6.1M0 HF12 | Steps for upgrade from HF12 to HF15
|
6.1M0 HF13 or 6.1M0 HF14 |
Steps for upgrade from HF13, HF14 to HF15There are no manual updates required when upgrading 6.1M0 HF13 or HF14 to 6.1M0 HF15. |
If this step has been performed during a prior hot fix installation, it can be skipped.
On the Transaction Analysis Server (TAS), some JAR files need to be copied from the Elasticsearch 2.3.4 installation package to a new 'lib' directory that you create in the TAS configuration directory.Note: If you already have Elasticsearch 2.3.4 installed on a server in your environment, you may copy the files from that installation instead.
mkdir <CONFIGDIR>/Lev1/Applications/SASFraudManagement/6.1/<Auth-Domain>/analysis/lib
chown sascfg.sasfraud <CONFIGDIR>/Lev1/Applications/SASFraudManagement/6.1/<Auth-Domain>/analysis/lib chmod 775 <CONFIGDIR>/Lev1/Applications/SASFraudManagement/6.1/<Auth-Domain>/analysis/lib
Vendor | Database | Hot fix | Updates |
---|---|---|---|
PostgreSQL | MEH | HF1 | Authorizations are added to the static partition tables. |
Oracle | TDR | HF1 | Peformance improvements are made to the DECODE_BASE64_SIGNATURE function. |
Oracle | SOR | HF4 | Delete fmx_me_phone entry, loaded by default that is a space. |
PostgreSQL | SOR | HF4 |
- Support for SAMS for PostgreSQL. - Delete fmx_me_phone entry, loaded by default that is a space. |
PostgreSQL | TDR | HF4 | Support for SAMS for PostgreSQL. |
PostgreSQL DB2 Oracle |
SOR | HF6 | Support for 6000 rule slots. |
PostgreSQL DB2 Oracle |
TDR | HF6 | Support for 6000 rule slots. |
PostgreSQL DB2 Oracle |
SOR | HF8 |
- Add new properties to the FCM_PROPERTY table
- Update the FCM_FIELD_DEFINITION table to set size related information for the srp_rule_overtime field name. - Update the FCM_GSU_VW view. |
DB2 | SOR | HF8 | - Update the FCM_FIELD_DEFINITION table to set DBMS_VARIABLE_TYPE value to DECIMAL(19,5) where it is BINARY_DOUBLE. |
PostgreSQL | SOR | HF9 | - Update the FCM_LOOKUP_LIST_DEFINITION table to change the KEY_COLUMNS data type from VARCHAR(4000) to Text. |
DB2 Oracle |
SOR | HF9 | - Update the FCM_LOOKUP_LIST_DEFINITION table to change the KEY_COLUMNS data type from VARCHAR(4000) to CLOB. |
PostgreSQL DB2 Oracle |
SOR | HF9 | - Update the FCM_PRIVILEGE table to add "Approve and Promote Rules" and "Approve and Delete Rules" privileges. |
PostgreSQL DB2 Oracle |
SOR | HF10 |
- Add new properties to the FCM_PROPERTY table
|
PostgreSQL DB2 Oracle |
SOR | HF12 | - Update the FCM_FIELD_DEFINITION table to correct the DBMS_VARIABLE_TYPE value for the FIELD_NAME = 'tbt_billing_ref_num'. |
DB2 | SOR | HF12 | - Update the GET_RULE_SLOTS function to convert the input HEX string to uppercase. |
PostgreSQL | SOR | HF15 |
- Update checkout_and_get_alert function to put in condition if the alert status is CLOSED, rollback and return error. - Update force_checkout function to put in condition if the alert status is CLOSED, rollback and return error. |
DB2 | SOR | HF15 |
- Update CHECKOUT_AND_GET_ALERT procedure to put in condition if the alert status is CLOSED, rollback and return error. - Update FORCE_CHECKOUT procedure to put in condition if the alert status is CLOSED, rollback and return error. |
Oracle | SOR | HF15 |
In the ALERT_SERVICING package: - Update checkout_and_get_alert procedure to put in condition if the alert status is CLOSED, rollback and return error. - Update force_checkout procedure to put in condition if the alert status is CLOSED, rollback and return error. |
PostgreSQL DB2 Oracle |
SOR | HF15 | Update the deployment_script_webapp property in the FCM_PROPERTY table. Set the PROPERTY_DESC and the PROPERTY_EDITABLE_IND columns to note that the property is no longer supported. |
$ ./mehddl.sh preview
$ ./sorddl.sh preview
$ ./tdrddl.sh preview
$ ./mehddl.sh updateNotes:
$ ./sorddl.sh update
$ ./tdrddl.sh update
$ ./mehddl.sh clearCheckSums
$ ./mehddl.sh update
$ ./sorddl.sh clearCheckSums
$ ./sorddl.sh update
$ ./tdrddl.sh clearCheckSums
$ ./tdrddl.sh update
If your servers are already at SAS 9.4 M7, skip this step.
If you upgraded SAS 9.4 M6 to SAS 9.4 M7 in the previous step, skip this step. The upgrade process installs the latest SAS Security Update available.
See SAS 9.4 Intelligence Platform Middle-Tier Administration Guide for details on rebuilding and redeploying Web Applications.
$ ./sas.servers stopIf 'sas.servers start' command takes a long time to complete, you may be experiencing the issue described in this SAS KB0036360.
$ ./sas.servers start
Log in to the web application as a user with the privilege to deploy rules on the Console tab. Deploy all the existing rules files.
Note: After a hot fix install, all users may need to clear their web browser cache before running the web application.
Confirm there are no errors in the log.
Confirm there are no errors in the log.
Run a new SAS Deployment Registry report following the same steps as in the PRE-INSTALLATION INSTRUCTIONS. The new report files will overwrite the existing ones. To retain the old files, save them to a new location or rename them before running the commands.
Please send a copy of the final DeploymentRegistry.txt file to SAS Fraud Management support.
The three JAR files are:
If these jars have been updated by this hot fix or any hot fix since your starting hot fix level, they must be copied into the 'lib' subdirectory of the BOSS installation directory. For additional details see SAS KB0036356.
Important: Save a backup copy of the jars from the BOSS directory before replacing them.