Hot fix F90006 addresses the issue(s) in SAS Risk Management for Insurance 2.1_M1 on Linux as documented
in the Issue(s) Addressed section of the hot fix download page:
http://ftp.sas.com/techsup/download/hotfix/HF2/F90.html#F90006
F90006 is a "container" hot fix that contains the following "member" hot fixes which will update the software components
as indicated. See the Container Hot Fixes section in the
Maintenance Install Tool (MIT) Usage Guide
for more information about container hot fixes.
G55004 for SAS Detail Data Store for Insurance 5.4_M1
F88006 for SAS Firmwide Risk Management for Insurance Server 2.1_M1
F89006 for SAS Market Risk Management for Insurance Server 2.1_M1
F03003 for SAS Risk Dimensions Server Component 5.3_M1
G61004 for SAS Risk Management for Insurance Mid-Tier 2.1_M1
F12007 for SAS Risk Management for Insurance Server 2.1_M1
G54004 for SAS Risk Reporting Repository 1.4_M1
F92006 for SAS Underwriting Risk Management for Life Insurance Server 2.1_M1
F91006 for SAS Underwriting Risk Management for P&C Insurance Server 2.1_M1
IMPORTANT
NOTES
ASSETS-D1 The following reports will not be available as they
have been dropped from the CP9 EIOPA templates. Metadata and configurations for
the reports have been removed: Cover-A1 Following reports were added/updated
in the metadata per CP9 EIOPA QRT list: Assets-D1Q Descriptions (report names) for the following
changed per CP9 EIOPA templates and have been updated in the metadata: ASSETS-D1 If you need to retain previous versions of these
files, they can be retrieved from backup locations as needed. Newly
added tables: Columns
for the newly added tables: TABLE
NAME COLUMN NAME XBRL_COMPLEXTYPE BASE_CD MAXINCLUSIVE MAXLENGTH MININCLUSIVE NAME_CD PATTERN_CD VALID_FROM_DTTM VALID_TO_DTTM XBRL_COMPLEXTYPE_ENUMERATION NAME_CD VALUE_VAR VALID_FROM_DTTM VALID_TO_DTTM XBRL_DIMENSION DIMENSION_CD REPORT_CD DIMENSIONTYPE FORMAT_CD MEMBERTAG VARIABLE_CD VARIABLESTAG VALID_FROM_DTTM VALID_TO_DTTM XBRL_FACTELEMENTS BASETYPE_CD ELEMENTCODE ELEMENTNAME PERIODTYPE TAXONOMY TYPE_CD
If the updated components of this product are installed on multiple operating systems, you must download the hot fix
for the appropriate operating system(s) and follow the installation instructions provided to complete the deployment
of this hot fix.
The installer downloaded is F90006lx.bin.
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.
To install the hot fix:
1. Verify that the installation binary has execute permission. If it does not, use the
chmod command to make it executable.
See the
Maintenance Install Tool (MIT) Usage Guide
for more details on the installation of hot fixes.
For each product installed, click the link to be redirected to post-installation instructions. Newly
added tables: ACCOUNTING_TRANS CREDIT_FACILITY_CR_MITIGANT GL_SEGMENT_BALANCE Updated
tables: CREDIT_FACILITY Newly
added columns: Table
Name Column
Name ASSET_SEGMENT_X_EXPOSURE FINANCIAL_POSITION_RK CLAIM_UNIT CLAIM_UNIT_CURRENCY_CD RECOVERY_ESTIMATED_AMT RECOVERY_RECEIVED_AMT COMML_PROP_DETAILS APPLICATION_RK COMML_VEHICLE_DETAILS APPLICATION_RK CONVERSION_SCHEDULE
VALID_FROM_DTTM VALID_TO_DTTM COVERED_PERILS PERIL_RK FINANCIAL_ACCOUNT PAYMENT_DAY_OF_MONTH_NO INT_PAYMENT_DAY_OF_MONTH_NO RESET_DAY_OF_MONTH_NO FINANCIAL_INSTRUMENT PAYMENT_DAY_OF_MONTH_NO INT_PAYMENT_DAY_OF_MONTH_NO RESET_DAY_OF_MONTH_NO FINANCIAL_INSTRUMENT_ASSOC PHYSICAL_ASSET_RK GENERAL_UNIT_OF_EXPOSURE UNDERWRITING_MODEL_AMT UNDERWRITING_MODEL_TYPE_CD GL_ACCOUNT CONTROL_ACCOUNT_FLG GL_ACCOUNT_BALANCE ACCOUNT_PERIOD_RK AS_OF_DATE GL_BALANCE_BASE_CURRENCY_CD GL_BALANCE_REPT_CURRENCY_CD REPORTING_METHOD_CD GL_JRNL REVERSAL_DESC EVERSAL_REASON_CD REVERSED_GL_JRNL_ID GL_JRNL_DETAILS ACCOUNT_PERIOD_RK GL_SEGMENT_PARAM_GROUP GL_SEGMENT_GROUP_DESC GL_SEGMENT_PARAMETER PARAMETER_DESC LEGAL_PROT_INSURED_SUBJECT APPLICATION_RK LIABILITY_INSURED_SUBJECT APPLICATION_RK PERIL PERIL_RK VALID_FROM_DTTM VALID_TO_DTTM PERS_PROP_DETAILS APPLICATION_RK PERS_VEHICLE_DETAILS APPLICATION_RK REINSURANCE_CARRIER PARTICIPATION_LIMIT_AMT RI_CARRIER_RK RI_CARRIER_TYPE_CD RI_NETWORK_ID REINSURANCE_COLLATERAL EFFECTIVE_DTTM EXPIRATION_DTTM REINSURANCE_CONTRACT_SECTION GROSS_RETENTION_PCT REINSURANCE_EXPOSURE CEDING_COMMISSION_AMT RI_AMT_SHARE RI_CONTRACT_SECTION_RK RI_EXP_EFFECTIVE_DT RI_EXP_EXPIRATION_DT REINSURANCE_TRANS RI_CONTRACT_RK RI_CONTRACT_SECTION_RK RI_REINSTATEMENT_RK XL_LAYER_RK REINSURANCE_TRANS_LINE_ITEM LINE_ITEM_TRANS_AMT RI_CONTRACT_RK RI_CONTRACT_SECTION_RK RF_CURVE_X_RF_GROUP VALID_FROM_DTTM VALID_TO_DTTM RI_TRANS_X_RI_EXPOSURE RI_CONTRACT_RK RI_EXP_TRANS_AMT RISK_FACTOR VALID_FROM_DTTM VALID_TO_DTTM RISK_FACTOR_CURVE VALID_FROM_DTTM VALID_TO_DTTM RISK_FACTOR_GROUP VALID_FROM_DTTM VALID_TO_DTTM RSK_FCTR_X_ANAL_MDL_TRANS_METH VALID_FROM_DTTM VALID_TO_DTTM RISK_FACTOR_X_RISK_FCTR_CURVE VALID_FROM_DTTM VALID_TO_DTTM SUB_LEDGER AS_OF_DT SWAP_INSTRUMENT_LEG PAYMENT_DAY_OF_MONTH_NO INT_PAYMENT_DAY_OF_MONTH_NO RESET_DAY_OF_MONTH_NO TECHNICAL_INSURED_SUBJECT APPLICATION_RK OTHER_INSURED_SUBJECT APPLICATION_RK Renamed
Columns: The column
ASSET_PORTFOLIO_X_EXPOSURE__RK from ASSET_PORTFOLIO_SGMNT_X_EXPOSURE table had
a typo. It has been renamed to ASSET_PORTFOLIO_X_EXPOSURE_RK. Deprecated
tables and columns: A few
tables and columns have been deprecated from previous versions. They will be
removed physically in the future. The comment for such objects has been updated
to "DEPRECATED" and can be used to know if the table or column is
deprecated. Table
Name Column Name ASSET_SEGMENT_X_EXPOSURE FINANCIAL_INSTRUMENT_RK BOND_VOLATILITY_QUOTE TERM_CD COMMODITY_VOLATILITY_QUOTE TERM_CD CREDIT_SPREAD_QUOTE TERM_CD FX_FORWARD_QUOTE TERM_CD FX_VOLATILITY_QUOTE TERM_CD INDEX_VOLATILITY_QUOTE TERM_CD INTEREST_RATE_QUOTE TERM_CD PHYSICAL_ASSET_QUOTE TERM_CD INT_RATE_VOLATILITY_QUOTE TERM_CD UNDERLYING_TERM_CD
REINSURANCE_COLLATERAL EFFECTIVE_DT REINSURANCE_COLLATERAL EXPIRATION_DT Columns
with changed attributes: Table
Name Column Name EXTERNAL_ORG NAICS_CD EXTERNAL_ORG SIC_CD INDEX_QUOTE INDEX_CD CEDED_LOSS CEDED_LAE_CASE_RESERVE_AMT CEDED_LOSS CEDED_PAID_LAE_AMT Notes: JavaArgs_13=-Dcom.sas.metadata.logical.table.TableOptionsPanel.MergeOptionVisible=TRUE
For detailed instructions of
creating physical table and importing metadata, please refer to SAS® Detail
Data Store for Insurance 5.4 Second Edition. 1.
HEALTH_SOLVENCY 2.
FIRMWIDE_MCR Create 1
Stored process objects: 1.
/System/Applications/SAS Risk
Management for Insurance/Firmwide Risk
Server2.1/Analysis/HEALTH_SOLVENCY
xii.
Click Ok and then Finish. 1.
SLTH_SOLVENCY Create 1
Stored process objects: 1.
/System/Applications/SAS Risk Management
for Insurance/Life Risk Server2.1/Analysis/SLTH_SOLVENCY
xii.
Click Ok and then Finish. 1.
NSLTH_SOLVENCY Create 1
Stored process objects: 1.
/System/Applications/SAS Risk
Management for Insurance/Property Casual Risk Server2.1/Analysis/NSLTH_SOLVENCY
xii.
Click Ok and then Finish. 1.
RE_J1 2.
RE_J2 3.
RE_J3 4.
TP_E4 5.
ACCOUNTING_MEASURES 6.
TP_E6 7.
TP_E7A 8.
TP_E7B The reason
that these STPs need to be removed is to be able to consolidate them under a
new data management folder (which will be installed from the utilities.spk
files)
ii.
To remove the STPs execute the
following steps: 1.
RE_J1 2.
RE_J2 3.
RE_J3 4.
TP_E4 5.
ACCOUNTING_MEASURES 6.
TP_E6 7.
TP_E7A 8.
TP_E7B Newly added jobs: Job Name RMI_INT_100_I_ACCOUNT_CREDIT_RISK_MITIGANT RMI_INT_100_I_CREDIT_FACILITY_CR_MITIGANT RMI_INT_100_I_EXPOSURE_CR_MITIGANT_RANK RMI_INT_100_I_FINANCIAL_POSITION_CR_MITIGANT RMI_INT_100_I_FRA_INSTRUMENT_LEG RMI_STG_210_EXPOSURE_CRM_LINK RMI_STG_210_GL_BAL_SEGMENT_ATTR_VAR RMI_STG_210_GL_BALANCE_SEGMENT RMI_STG_210_RATE_PARAM_GROUP_X_PARAMETER RMI_STG_210_RI_CONTRACT_COLLATERAL RMI_STG_210_SUB_LEDGER RMI_STG_230_CAPITAL_ALLOCATION RMI_STG_230_CAPITAL_COST
Modified Jobs: Job Name RMI_INT_100_I_ASSET_SGMNT_X_EXPOSURE
RMI_INT_100_I_EXTERNAL_ORG RMI_INT_100_I_FINANCIAL_INSTRUMENT RMI_INT_100_I_FX_FORWARD_QUOTE
RMI_INT_100_I_FX_VOLATILITY_QUOTE
RMI_INT_100_I_INT_RATE_VOLATILITY_QUOTE
RMI_INT_100_I_INTEREST_RATE_QUOTE
RMI_INT_100_I_RISK_FACTOR RMI_INT_100_I_SWAP_INSTRUMENT_LEG RMI_INT_105_I_FINANCIAL_ACCOUNT RMI_INT_110_I_QUOTE_VOLATILITY RMI_STG_210_CEDED_LOSS RMI_STG_210_CLAIM_HISTORY RMI_STG_210_GENERAL_INSURANCE_SUBJECT RMI_STG_210_GENERAL_INSURANCE_UOE RMI_STG_210_GL_ACCOUNT_ASSOC RMI_STG_210_INSURANCE_SEGMENT RMI_STG_210_INSURED_ITEM_LOCATION RMI_STG_210_SECURITIZATION_POOL_MART RMI_STG_230_ASSET_SGMNT_X_EXPOSURE RMI_STG_230_CASHFLOW_ACCOUNT RMI_STG_230_CASHFLOW_FRA RMI_STG_230_CASHFLOW_INSTRUMENT RMI_STG_230_CONVERSION_SCHEDULE RMI_STG_230_CONVERTIBLE_BOND_INSTRUMENT RMI_STG_230_EMBEDDED_OPTIONS
RMI_STG_230_OPTION_INSTRUMENT RMI_STG_230_QUOTE_FX RMI_STG_230_QUOTE_INDEX RMI_STG_230_QUOTE_IR RMI_STG_230_QUOTE_VOLATILITY
RMI_STG_230_RISK_FACTOR RMI_STG_230_RISK_FACTOR_CURVE RMI_STG_230_RISK_FACTOR_GROUP RMI_STG_230_SWAP_INSTRUMENT Note: If RMI21.M1 ETL is not existing then first
import rmi_etl_bridge.spk from the same
location. 3.
Login to SAS DI Studio as the
Administrator (sasadm) user 4.
Click on the Folders tab 5.
Navigate to the folder Products 6.
Right-click on the Products folder
and select Import SAS Package from the menu 7.
Browse to /SASRiskManagementForInsuranceMidTier/2.1/ETL
and select the rmi_etl_bridge_m1_hf5.spk file. 8.
Select the radio button for All
Objects and click Next 9.
Ensure that you have the correct
mappings for the SAS Application Servers. Click Next. 10.
Review the Summary information and
click Next. 11.
The next screen should show that the
import was completed. Click the View Log button and scan the log for any
errors. If the import was successful, you should see a message such as
"The import process completed successfully" in the log 12.
Click Ok and then Finish. Follow the steps below to regenerate
the Solution Data Mart (SDM):
%create_solution_data_mart( %create_solution_data_mart(soln_data_mart_dir=<complete
path to indata directory in your install>);
Example of
indata path: <CONFIGDIR>/AppData/SASRiskManagementForInsurance/2.1/indata
Select File
> Manage Shared Data Mart from the menu and click Delete, then
click Create in the same Manage Shared Data Mart window. The
following steps update a loading mapping configuration: To
load sample data in to the private SAS Risk Reporting Repositories: For
example: options metauser="<username>"
metapass="<Password>" G54003
for SAS Risk Reporting Repository 1.4_M1 There are different ways in which to
apply the new structure. Please select one of the following methods that is applicable to your installation(s). NB: In this release of the SAS Risk
Reporting Repository previously marked deprecated tables and/or columns have
been removed from the model. The files for these structures may still exist on
your installation due to the delivery mechanism; however, code has been added
to ignore the pre-existing files when necessary. NB: If the post-installation tasks
for F12006 has been applied, the structures of the
Private locations will be automatically updated with the latest reportmart structure for the F12007 post-installation
tasks and the subsequent methods are not necessary for applying the data model
changes to private RRR locations. The following methods can be applied to both
the private and shared locations depending on the state of your installation. 1. Updating via the provided
sample data: If a given reportmart
location has not been updated by another process, creating the shipped reportmart sample data in a given location will install the
data model changes. The shipped sample data scripts
already contain the updates in the RRR data model/formats. If you would like to
utilize the shipped RMI sample data for the RRR without maintaining existing
data, create the RRR sample data using the following steps. Note: The sample data creation
script does not depend on the version of the original RRR that is being
overwritten. This script will overwrite the existing data and data model. For
example, if you are have the RRR 14 m1 version of the RRR and are installing the
fourth RRR hotfix, by creating the shipped sample data you do not need to
install the "sample data for the previous hotfix". The shipped sample
data is a snapshot of the given version. Submit the following code with your
installation specific information. (Note: This has changed from previous
releases as you are now required to submit the rmiinit;
prior to submitting the batch program.) options metauser="<username>"
metapass="<password>" metaserver="<server_name>"
metaport=<port_number>
metarepository="Foundation"; %rmiinit; * If you need to install the reportmart sample data to the Global RRR with the sample
data script, you must submit the following code with the additional information
and changes: %let rrr_user=<username>; options metauser="<username>"
metapass="<password>" metaserver="<server_name>"
metaport=<port_number>
metarepository="Foundation"; NOTE: It is not recommended that you use this process
on the Global RRR unless you are absolutely certain of your specific
installation needs. The script, as shown above, deletes the Global RRR and
replaces the location with the new version of the RRR with the shipped sample
data ONLY. All data in the Global location will be lost using this process. 2. Updating an existing install
with alter/migration scripts:
If you have existing data in your reportmart and wish to only apply the data model changes,
execute the specific alter scripts for your given installations: A.
If the reportmart is the RRR14m1 version: execute %run_rrr14m1_to_rrr14m1hf4.
Follow the instructions to execute this alter script in the PDF document m1rrr14_to_m1rrr14hf4_instructions.pdf
that has been delivered with the alter scripts. These files will be typically
located in the following directory: Win: <SASHOME>\SASFoundation\9.2\rskrptmrtvrt\sasmisc\alterscripts\hotfix_4\m1_to_hotfix4
Unix: <SASHOME>/SASFoundation/9.2/misc/rskrptmrtvrt/alterscripts/hotfix_4/m1_to_hotfix4
B.
If the reportmart is the RRR14m1hf1 version: execute %run_rrr14m1hf1_to_rrr14m1hf4.
Follow the instructions to execute this alter script in the PDF document m1rrr14hf1_to_m1rrr14hf4_instructions.pdf
that has been delivered with the alter scripts. These files will be typically
located in the following directory: Win: <SASHOME>\SASFoundation\9.2\rskrptmrtvrt\sasmisc\alterscripts\hotfix_4\hotfix1_to_hotfix4
Unix: <SASHOME>/SASFoundation/9.2/misc/rskrptmrtvrt/alterscripts/hotfix_4/hotfix1_to_hotfix4
C.
If the reportmart is the RRR14m1hf2 version: execute %run_rrr14m1hf2_to_rrr14m1hf4.
Follow the instructions to execute this alter script in the PDF document m1rrr14hf2_to_m1rrr14hf4_instructions.pdf
that has been delivered with the alter scripts. These files will be typically
located in the following directory: Win: <SASHOME>\SASFoundation\9.2\rskrptmrtvrt\sasmisc\alterscripts\hotfix_4\hotfix2_to_hotfix4
Unix: <SASHOME>/SASFoundation/9.2/misc/rskrptmrtvrt/alterscripts/hotfix_4/hotfix2_to_hotfix4
B.
If the reportmart is the RRR14m1hf3 version: execute %run_rrr14m1hf3_to_rrr14m1hf4.
Follow the instructions to execute this alter script in the PDF document m1rrr14hf3_to_m1rrr14hf4_instructions.pdf
that has been delivered with the alter scripts. These files will be typically
located in the following directory: Win: <SASHOME>\SASFoundation\9.2\rskrptmrtvrt\sasmisc\alterscripts\hotfix_4
Unix: <SASHOME>/SASFoundation/9.2/misc/rskrptmrtvrt/alterscripts/hotfix_4
3. Installing a new reportmart using the ddls/createrrr.sas script: If you would like to create a new
RRR with the new data model, follow the instructions for installing a clear RRR
in the Installing and Configuring the SAS Risk Reporting Repository
section in the SAS Risk Reporting Repository 1.4 Reference Guide, Second
Edition. This hot fix requires that the WebApp be rebuilt and redeployed. Use the following steps
to perform this post-installation task: Step 1: Re-build Web Application In order for this step to execute
correctly, the Metadata Server must be running. 1.1 Invoke the SAS Deployment Manager 9.2 From the SASDeploymentManager
directory launch config.exe. <SASHOME>/SASDeploymentManager/9.2 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 Risk Management for Insurance 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 Risk
Management for Insurance ear in <SASCONFIGDIR>/Web/Staging. Re-deploy the web applications based
on the instructions for the web application server you are using. Copy files into your application
server’s deployed EAR for SAS Risk Management for Insurance as follows: From: <SASHOME>/SASRiskManagementForInsuraceMidTier/2.1/Static/wars/sas.solutions.risk.rmi/WEB-INF/web.xml
To: sas.solutions.risk.rmi.ear
/sas.solutions.risk.rmi.war/WEB-INF/web.xml From: <SASHOME>/SASRiskManagementForInsuraceMidTier/2.1/Static/wars/sas.solutions.risk.rmi/WEB-INF/spring-config/app-config.xml
To: sas.solutions.risk.rmi.ear
/sas.solutions.risk.rmi.war/WEB-INF/spring-config/app-config.xml Re-start the application (or the
application server) using your application server’s admin console.
ASSETS-D1Q
ASSETS-D1S
ASSETS-D2O
ASSETS-D2T
ASSETS-D3
ASSETS-D4
ASSETS-D5
ASSETS-D6
COUNTRY-K1
COVER-A1A
COVER-A1Q
G01
G03
G04
IGT1
IGT2
IGT3
IGT4
OF-B1Q
RC
RE-J1
RE-J2
RE-J3
RE-SPV
SCR-B2A
SCR-B2B
SCR-B2C
SCR-B3B
SCR-B3C
SCR-B3D
SCR-B3E
SCR-B3G
TP-E1
TP-E1Q
TP-E2
TP-E3
TP-E4
TP-E6
TP-E7A
TP-E7B
TP-F1
TP-F1Q
TP-F2
TP-F3A
TP-F3B
TP-F4
VA-C2A
VA-C2B
VA-C2C
C2_ANALYSIS_LF
C2_ANALYSIS_NL
C2_SUMMARY
G10
G15
G20
G30
IGT5
IGT6
TP-E5
TP-E7
VA-C2D
Assets-D1S
Assets-D2O
Assets-D2T
Cover-A1A
Cover-A1Q
VA-C2A
VA-C2B
VA-C2C
TP-E7A
TP-E7B
G14
IGT1
IGT2
IGT3
IGT4
Re-J1
SCR-B2A
SCR-B2C
TP-E1
TP-E1Q
TP-E3
TP-E6
TP-F4
XBRL_COMPLEXTYPE
XBRL_COMPLEXTYPE_ENUMERATION
XBRL_DIMENSION
XBRL_FACTELEMENTS
XBRL_FMT
XBRL_REPORT
XBRL_SCHEMA
INSTALLATION
This hot fix must be installed on each machine where the updated components of the product, listed above, are installed.
The installation process will determine which components of SAS Risk Management for Insurance 2.1_M1 are installed on each machine,
and apply the appropriate updates.
$> chmod 755 F90006lx.bin
2. Set your $DISPLAY environment variable
export DISPLAY=<your_node_name>:0
3. Execute F90006lx.bin using the -alwaysoverwrite option:
<path_to_downloaded_file>/F90006lx.bin -alwaysoverwrite
For example:
./F90006lx.bin -alwaysoverwrite
This will initiate the installation wizard, which will guide you through the hot fix
installation process. During the installation you will be prompted for the
SASHOME location to be updated. You should provide the path to the
top level SAS directory where the deploymntreg directory exists.
The content of this hot fix is listed in the hot fix manifest.
This completes the installation of F90006. You must perform any "Post-Installation Instructions" documented below
to successfully complete the deployment of this hot fix.
POST-INSTALLATION INSTRUCTIONS
G55004 for SAS Detail Data Store for Insurance 5.4_M1
F88006 for SAS Firmwide Risk Management for Insurance Server 2.1_M1
F89006 for SAS Market Risk Management for Insurance Server 2.1_M1
F03003 for SAS Risk Dimensions Server Component 5.3_M1
G61004 for SAS Risk Management for Insurance Mid-Tier 2.1_M1
F12007 for SAS Risk Management for Insurance Server 2.1_M1
G54004 for SAS Risk Reporting Repository 1.4_M1
F92006 for SAS Underwriting Risk Management for Life Insurance Server 2.1_M1
F91006 for SAS Underwriting Risk Management for P&C Insurance Server 2.1_M1
G55004 for SAS Detail Data Store for Insurance 5.4_M1
ACCOUNTING_TRANS_LINE_ITEM
ACCOUNT_PERIOD
ACCOUNT_PERIOD_ASSOC
ASSET_PORTFOLIO_SEGMENT
ASSET_PORTFOLIO_SGMNT_X_EXPOSURE
ASSET_SEGMENT_X_EXPOSURE
CEDED_LOSS
CONTRACT_SECTION_X_RI_CARRIER
CURRENCY_CONVERSION_RATE
EXPOSURE_PLEDGED
FRA_INSURMENT_LEG
GL_SEGMENT_PARAMETER
GL_SEGMENT_PARAM_GROUP
REINSURANCE_COLLATERAL
REINSURANCE_CONTRACT
REINSURANCE_CONTRACT_SECTION
REINSURANCE_COVERAGE
REINSURANCE_COVERAGE_REFERENCE
REINSURANCE_INTERMEDIARY
REINSURANCE_PROGRAM
REINSURANCE_RATE
REINSURANCE_REINSTATEMENT
RISK_DRIVER
RISK_DRIVER_X_EXPOSURE
RI_TRANS_X_CEDED_LOSS
SUB_LEDGER
SUB_LEDGER_BALANCE
XL_LAYER
XL_LAYER_X_RI_CARRIER
EMBEDDED_OPTIONS
FINANCIAL_ACCOUNT
FINANCIAL_INSTRUMENT
FINANCIAL_INSTRUMENT_CHNG
FUND_INSTRUMENT
PHYSICAL_ASSET
SECURITIZATION_POOL
F88005 for SAS Firmwide Risk Management
for Insurance Server 2.1_M1
NONE
F89005 for SAS Market Risk Management
for Insurance Server 2.1_M1
NONE
F03003 for SAS Risk Dimensions Server
Component 5.3_M1
NONE
F12006 for SAS Risk Management for
Insurance Server 2.1_M1
Import updated .spk files:
soln_data_mart_dir=&sysparm,
fca_c_lib_nm=FINCAD_Suite_32_2011,
fea_c_lib_nm=intrlib,
run_tps_fincad_flag=N,
run_tps_fea_flag=N );
In addition, complete the following to recreate any shared entity data
marts and user directories.
<SASCONFIG>/Lev1/AppData/SASRiskManagementForInsurance/2.1/data/userdata
metaserver="<server_name>"
metaport=<port_number>
metarepository="Foundation";
%rmiinit; %rmi_batch_create_rrr_sample_data(ENTITY=MAIN,USERNAME=<username>,SCOPE=P);
Data model changes have been made to the SAS Risk Reporting Repository. You
must update the structures of the private RRR location and Shared location.
%rmi_batch_create_rrr_sample_data(ENTITY=MAIN,USERNAME=<username>,SCOPE=P);
%let rrr_password=<Password>;
%rmiinit;
%rmi_batch_create_rrr_sample_data(ENTITY=MAIN,USERNAME=<username>,SCOPE=S);
F92005 for SAS Underwriting Risk
Management for Life Insurance Server 2.1_M1
NONE
F91004 for SAS Underwriting Risk
Management for P&C Insurance Server 2.1_M1
NONE
G61003 for SAS Risk Management for
Insurance Mid-Tier 2.1_M1
Re-build and Re-deploy Web Application
SAS Deployment Manager is installed in the following default location:
A backup of the original ear file will be placed in the directory below:
<SASCONFIGDIR>/Web/Staging/Backup
Step 2: Re-deploy Web Applications
Step 3: Copy files into the application's deployed ear file
This completes the installation of hot fix F90006 on Linux.