Installation Instructions for Hot Fix F90004

Windows for x64


Hot fix F90004 addresses the issue(s) in SAS Risk Management for Insurance 2.1_M1 on Windows for x64 as documented in the Issue(s) Addressed section of the hot fix download page:

http://ftp.sas.com/techsup/download/hotfix/HF2/F90.html#F90004


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

G55002 for SAS Detail Data Store for Insurance 5.4_M1
F88004 for SAS Firmwide Risk Management for Insurance Server 2.1_M1
F89004 for SAS Market Risk Management for Insurance Server 2.1_M1
F03003 for SAS Risk Dimensions Server Component 5.3_M1
G61002 for SAS Risk Management for Insurance Mid-Tier 2.1_M1
F12005 for SAS Risk Management for Insurance Server 2.1_M1
G54002 for SAS Risk Reporting Repository 1.4_M1
F92004 for SAS Underwriting Risk Management for Life Insurance Server 2.1_M1
F91004 for SAS Underwriting Risk Management for P&C Insurance Server 2.1_M1

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 software components and release numbers should match the list of software components updated by the individual hot fix installers.


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. When applying this hot fix, the -alwaysoverwrite option should be used. This option causes the hot fix to overwrite files that are currently on your system with the updated hot fix version of those files. ANY customizations that may have been made to files included in the hot fix will be lost. The hot fix installer will automatically back up files for you. After the hot fix has been installed, use the backup copies to merge any of the customizations that you wish to retain. Links to manifests are provided in the section above to assist in determining which files will be overwritten.

  3. Configurations and related uncompiled macro files for the following reports will be updated as a part of this install:
    ASSETS-D1
    ASSETS-D1S
    ASSETS-D2O
    ASSETS-D3
    ASSETS-D4
    ASSETS-D5
    ASSETS-D6
    COUNTRY-K1
    COVER-A1A
    COVER-A1Q
    G20
    IGT1
    IGT2
    IGT3
    IGT4
    OF-B1Q
    RC
    RE-J1
    RE-J2
    RE-J3
    RE-SPV
    SCR-B2A
    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-F1
    TP-F1Q
    TP-F2
    TP-F3A
    TP-F3B
    The following reports will not be available as they have been dropped from the latest EIOPA templates. Metadata and configurations for the reports have been removed:
    Cover-A1
    C2_ANALYSIS_LF
    C2_ANALYSIS_NL
    C2_SUMMARY
    G10
    G15
    G30
    IGT5
    IGT6
    TP-E5
    TP-E7

    Following reports were added/updated in the metadata per latest EIOPA QRT list:

    Assets-D1Q
    Assets-D1S
    Assets-D2O
    Assets-D2T
    Cover-A1A
    Cover-A1Q
    VA-C2A
    VA-C2B
    VA-C2C
    VA-C2D
    TP-E7A
    TP-E7B

    Descriptions (report names) for the following changed per latest EIOPA templates and have been updated in the metadata:

    ASSETS-D1
    G14
    IGT1
    IGT2
    IGT3
    IGT4
    Re-J1
    SCR-B2A
    SCR-B2C
    TP-E1
    TP-E1Q
    TP-E3
    TP-E6
    TP-F4
    If you need to retain previous versions of these files, they can be retrieved from backup locations as needed.

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

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

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

  7. On UNIX systems, you may need to adjust file permissions on all new and updated files to meet with your sites security guidelines.


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.

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 F90004x6.exe.

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 this hot fix execute F90004x6.exe using the "-alwaysoverwrite" option:

path_to_downloaded_file>F90004x6.exe -alwaysoverwrite
For example:
F90004x6.exe -alwaysoverwrite
This will initiate the installation wizard, which will guide you through the hot fix installation process.

Note: If your Windows operating system is Windows Vista, Windows 7 or Windows Server 2008, it may be necessary to "right-click" F90004x6.exe and select "Run as administrator".

See the Maintenance Install Tool (MIT) Usage Guide for more details on the installation of hot fixes.


The content of this hot fix is listed in the hot fix manifest.


This completes the installation of F90004. You must perform any "Post-Installation Instructions" documented below to successfully complete the deployment of this hot fix.


POST-INSTALLATION INSTRUCTIONS

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

G55002 for SAS Detail Data Store for Insurance 5.4_M1
F88004 for SAS Firmwide Risk Management for Insurance Server 2.1_M1
F89004 for SAS Market Risk Management for Insurance Server 2.1_M1
F03003 for SAS Risk Dimensions Server Component 5.3_M1
G61002 for SAS Risk Management for Insurance Mid-Tier 2.1_M1
F12005 for SAS Risk Management for Insurance Server 2.1_M1
G54002 for SAS Risk Reporting Repository 1.4_M1
F92004 for SAS Underwriting Risk Management for Life Insurance Server 2.1_M1
F91004 for SAS Underwriting Risk Management for P&C Insurance Server 2.1_M1


G55002 for SAS Detail Data Store for Insurance 5.4_M1

  1. If you have existing DDS physical tables, take a backup of the data in a different location.

  2. Following is the summary of the changes in this hot fix:
    Newly added tables:

    ACCOUNTING_TRANS
    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
    GL_SEGMENT_BALANCE
    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

    Updated tables:

    CREDIT_FACILITY
    EMBEDDED_OPTIONS
    FINANCIAL_ACCOUNT
    FINANCIAL_INSTRUMENT
    FINANCIAL_INSTRUMENT_CHNG
    FUND_INSTRUMENT
    PHYSICAL_ASSET
    SECURITIZATION_POOL

    Newly added columns: 

    Table Name				Column Name

    

CLAIM_UNIT				CLAIM_UNIT_CURRENCY_CD
					RECOVERY_ESTIMATED_AMT
					RECOVERY_RECEIVED_AMT

COVERED_PERILS				PERIL_RK

GENERAL_UNIT_OF_EXPOSURE		UNDERWRITING_MODEL_AMT
					UNDERWRITING_MODEL_TYPE_CD

GL_ACCOUNT				CONTROL_ACCOUNT_FLG

GL_ACCOUNT_BALANCE			ACCOUNT_PERIOD_RK
					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

PERIL					PERIL_RK
					VALID_FROM_DTTM
					VALID_TO_DTTM

REINSURANCE_CARRIER			PARTICIPATION_LIMIT_AMT
					RI_CARRIER_RK
					RI_CARRIER_TYPE_CD
					RI_NETWORK_ID

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

RI_TRANS_X_RI_EXPOSURE			RI_CONTRACT_RK
					RI_EXP_TRANS_AMT

    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.

  3. If you already have existing DDS physical tables, then execute the ddls of the tables which have undergone changes as mentioned in point 2 above from <SASHOME>\SASFoundation\9.2\insurancedds\sasmisc\insurancedds_5.4M1\ddl folder.

  4. If you do not have existing DDS physical tables, then execute the ddlgen.sas file present in <SASHOME>\SASFoundation\9.2\insurancedds\sasmisc\insurancedds_5.4M1\ddl folder.

  5. If you already have existing DDS physical tables, migrate data for those tables which are updated in this hot fix.

  6. Copy the files present in <SASHOME>\SASFoundation\9.2\insurancedds\sasmisc\insurancedds_5.4M1\metadata\ folder to a location which can be accessed by DI studio client.

  7. Open DI studio and logon as unrestricted user.

  8. If you have existing metadata for DDS, backup the same.

  9. If you do not have existing metadata for DDS, then import insurancedds_54m1_sas.spk followed by insurancedds_54m1_hf2_sas.spk.

  10. If you have existing metadata for DDS hot fix 1 on top of 5.4_M1, then import insurancedds_54m1_hf2_sas.spk.

    Notes:

    1. Before importing the insurancedds_54m1_hf2_sas.spk, please delete the table SCHEDULE_X_TREATY from the destination metadata server using DI Studio from the folder /Products/SAS Detail Data Store For Insurance/DDS5.4_M1/01] INSURANCE PRODUCT.
    2. The table ASSET_PORTFOLIO_SGMNT_X_EXPOSURE has been renamed to ASSET_SEGMENT_X_EXPOSURE. The data if existing in the original table needs to be migrated to the newly created table. Please note that the column ASSET_PORTFOLIO_X_EXPOSURE__RK in the original table is represented as ASSET_SEGMENT_X_EXPOSURE_RK in the new table.

For detailed instructions of creating physical table and importing metadata, please refer to SAS® Detail Data Store for Insurance 5.4 Second Edition.


F88004 for SAS Firmwide Risk Management for Insurance Server 2.1_M1

NONE


F89004 for SAS Market Risk Management for Insurance Server 2.1_M1

NONE


F03003 for SAS Risk Dimensions Server Component 5.3_M1

NONE


F12005 for SAS Risk Management for Insurance Server 2.1_M1

Import updated .spk files:

  1. Backup existing metadata

  2. Import delivered SPK files using SAS MC Import/Export SAS Package wizard
    1. Import updated analysis.spk for the Firmwide component. You can skip this step if you had already performed the manual STP creation steps when installing HF3.
      1. Login to SAS Management Console (SMC) as the Administrator (sasadm) user
      2. Click on the Folders tab
      3. Navigate to the folder Analysis under System -> Applications -> SAS Risk Management for Insurance -> Firmwide Risk Server 2.1
      4. Right-click on the Analysis folder and select Import SAS Package from the menu
      5. Browse to <SASHOME>\rmifirmmva\sasmisc\Config\Deployment\Packages and select the analysis.spk file.
      6. Select the radio button for New Objects Only and click Next
      7. You should see the following STPs in the window. Click Next and then Next again.
        1. ASSET_VALUATION_HSLT_SCEN
        2. HEALTH_CAT_SOLVENCY
        3. HNSLT SOLVENCY
        4. HSLT_SOLVENCY
        5. HSLT_VALUATION_SCEN_LF
      8. Ensure that you have the correct mappings for the SAS Application Servers. Click Next.
      9. On this screen, map source code repositories between original and target application servers. Choose the path to the <SASHOME>\rmicomnsvr\sasstp folder. Click Next.
      10. Review the Summary information and click Next if correct. Otherwise, click on the Back buttons to make necessary corrections in earlier steps.
      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 messages such as the below in the log:

        Create 5 Stored process objects:

        1. \System\Applications\SAS Risk Management for Insurance\Firmwide Risk Server2.1\Analysis\ASSET_VALUATION_HSLT_SCEN
        2. \System\Applications\SAS Risk Management for Insurance\Firmwide Risk Server2.1\Analysis\HEALTH_CAT_SOLVENCY
        3. \System\Applications\SAS Risk Management for Insurance\Firmwide Risk Server2.1\Analysis\HNSLT_SOLVENCY
        4. \System\Applications\SAS Risk Management for Insurance\Firmwide Risk Server2.1\Analysis\HSLT_SOLVENCY
        5. \System\Applications\SAS Risk Management for Insurance\Firmwide Risk Server2.1\Analysis\HSLT_VALUATION_SCEN_LF

      12. Click Ok and then Finish.
      13. You should now see the five newly created STPs in the Analysis Folder.

    2. Import updated reports.spk for the RMI Common Server component
      1. Login to SAS Management Console (SMC) as the Administrator (sasadm) user
      2. Click on the Folders tab
      3. Navigate to the folder Reports under System -> Applications -> SAS Risk Management for Insurance -> Risk Management for Insurance Server 2.1
      4. Right-click on the Reports folder and select Import SAS Package from the menu
      5. Browse to <SASHOME>\rmicomnsvr\sasmisc\Config\Deployment\Packages and select the reports.spk file.
      6. Select the radio button for All Objects and click Next
      7. You should see a list of STPs in the window. Click Next and then Next again.
      8. Ensure that you have the correct mappings for the SAS Application Servers. Click Next.
      9. On this screen, map source code repositories between original and target application servers. Choose the path to the <SASHOME>\rmicomnsvr\sasstp folder. Click Next.
      10. Review the Summary information and click Next if correct. Otherwise, click on the Back buttons to make necessary corrections in earlier steps.
      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 messages such as "The import process completed successfully" in the log.
      12. Click Ok and then Finish.
      13. If required, selectively import metadata from the backup SPK (refer to Step 1) for only those QRTs that were customized earlier and are not delivered in the hot fix.

    3. Import updated system.spk for the RMI Common Server component
      1. Click on the Folders tab
      2. Navigate to the folder System under System -> Applications -> SAS Risk Management for Insurance -> Risk Management for Insurance Server 2.1
      3. Right-click on the System folder and select Import SAS Package from the menu
      4. Browse to <SASHOME>\rmicomnsvr\sasmisc\Config\Deployment\Packages and select the system.spk file.
      5. Select the radio button for All Objects and click Next
      6. You should see a list of STPs in the window. Click Next and then Next again.
      7. Ensure that you have the correct mappings for the SAS Application Servers. Click Next.
      8. On this screen, map source code repositories between original and target application servers. Choose the path to the <SASHOME>\rmicomnsvr\sasstp folder. Click Next.
      9. Review the Summary information and click Next if correct. Otherwise, click on the Back buttons to make necessary corrections in earlier steps.
      10. 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.
      11. Click Ok and then Finish.
      12. You should now see a new "Job name" parameter in the Parameters tab for the REPORT_OPTIONS STP.

    4. Import updated utilities.spk for the RMI Common Server component
      1. Click on the Folders tab
      2. Navigate to the folder Utilities under System -> Applications -> SAS Risk Management for Insurance -> Risk Management for Insurance Server 2.1
      3. Right-click on the Utilities folder and select Import SAS Package from the menu
      4. Browse to <SASHOME>\rmicomnsvr\sasmisc\Config\Deployment\Packages and select the utilities.spk file.
      5. Select the radio button for All Objects and click Next
      6. You should see a list of STPs in the window. Click Next and then Next again.
      7. Ensure that you have the correct mappings for the SAS Application Servers. Click Next.
      8. On this screen, map source code repositories between original and target application servers. Choose the path to the <SASHOME>\rmicomnsvr\sasstp folder. Click Next.
      9. Review the Summary information and click Next if correct. Otherwise, click on the Back buttons to make necessary corrections in earlier steps.
      10. 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:
      11. Click Ok and then Finish.
      12. You should now see the following STPs in the Utilities folder:
        RE_J1
        RE_J2
        RE_J3
        TP_E4
    5. Import updated rmi_etl_bridge_m1_hf5.spk for the RMI Solution Data Mart (SDM) ETL jobs
      1. Following is the summary of the newly added and modified jobs in this hot fix:
        Newly added jobs:

        Job Name

        RMI_INT_100_I_ASSET_SGMNT_X_EXPOSURE
        RMI_INT_100_I_EXPOSURE_PLEDGED
        RMI_STG_230_ASSET_PORTFOLIO_SEGMENT
        RMI_STG_230_ASSET_SGMNT_X_EXPOSURE
        RMI_STG_230_EXPOSURE_PLEDGED
        RMI_STG_230_RISK_DRIVER
        RMI_STG_230_RISK_DRIVER_X_FIN_CONTR
        RMI_STG_210_GENERAL_INSURANCE_SUBJECT

        Modified Jobs:

        Job Name

        RMI_INT_100_I_CREDIT_FACILITY
        RMI_INT_100_I_EMBEDDED_OPTIONS
        RMI_INT_100_I_FINANCIAL_INSTRUMENT
        RMI_INT_100_I_FINANCIAL_INSTRUMENT_CHNGM
        RMI_INT_100_I_FINANCIAL_INSTRUMENT_ISSUE
        RMI_INT_100_I_FINANCIAL_POSITION
        RMI_INT_100_I_PHYSICAL_ASSET
        RMI_INT_105_I_FINANCIAL_ACCOUNT
        RMI_INT_110_I_ACCT_POS_INST_FCLTY_APPEND
        RMI_STG_210_FUND_INSTRUMENT
        RMI_STG_210_SECURITIZATION_POOL_MART
        RMI_STG_230_EMBEDDED_OPTIONS
        RMI_STG_230_FINANCIAL_CONTRACT
        RMI_STG_230_FINANCIAL_CONTRACT_ISSUE
        RMI_STG_230_FINANCIAL_EXPOSURE
        RMI_STG_230_OPTION_SCHEDULE
        RMI_STG_230_SWAP_INSTRUMENT
        RMI_STG_210_CLAIM_HISTORY
        RMI_STG_230_PHYSICAL_ASSET
        RMI_STG_210_COVERED_PERILS

      2. If you already have existing RMI21.M1 ETL jobs, then import the rmi_etl_bridge_m1_hf5.spk file from <SASHOME>/SASRiskManagementForInsuranceMidTier/2.1/ETL folder as explained below.

        Note: If RMI21.M1 ETL is not existing then first import rmi_etl_bridge.spk from the same location.

      1. Login to SAS DI Studio as the Administrator (sasadm) user
      2. Click on the Folders tab
      3. Navigate to the folder Products
      4. Right-click on the Products folder and select Import SAS Package from the menu
      5. Browse to \SASRiskManagementForInsuranceMidTier\2.1\ETL and select the rmi_etl_bridge_m1_hf5.spk file.
      6. Select the radio button for All Objects and click Next
      7. Ensure that you have the correct mappings for the SAS Application Servers. Click Next.
      8. Review the Summary information and click Next.
      9. 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
      10. Click Ok and then Finish.

  3. If required, selectively import metadata from the backup SPK (refer to Step 1) for only those QRTs that were customized earlier and are not delivered in the hot fix.

Follow the steps below to regenerate the Solution Data Mart (SDM):

  1. Locate the create_solution_data_mart.sas file in your install: in a typical install, the macro resides under SASHOME\rmicomnsvr\sasmisc\solution_data_mart
  2. Open the create_solution_data_mart.sas file in a BASE SAS session on the installation server (where the SAS code resides)
  3. Scroll to the bottom of the macro file and comment out the following line:
    %create_solution_data_mart(
    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 );
  4. Compile the macro in the SAS session by clicking the Submit button on the menu
  5. After successful compilation, execute the following macro below:
    %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

  6. Check the SAS log for successful execution of the preceding macro.

    In addition, complete the following to recreate any shared entity data marts and user directories.

  7. Delete all user folders found in
    <SASCONFIG>/Lev1/AppData/SASRiskManagementForInsurance/2.1/data/userdata
  8. Login to Risk Management for Insurance 2.1
  9. Select File > Select Entity, choose an entity from the list, and click OK.
  10. Re-create the shared data mart for that entity.
    Select File > Manage Shared Data Mart from the menu and click Delete, then click Create in the same Manage Shared Data Mart window.
  11. Repeat steps 8 and 9 for each Entity

    The following steps update a loading mapping configuration:

    To load sample data in to the private SAS Risk Reporting Repositories:

  12. Execute the following code in SAS to create sample data with the appropriate information for your installation:

    For example:

    options metauser="sasdemo" metapass="Pass99"
    metaserver="rdcesx05105.race.sas.com" metaport=8561 metarepository="Foundation";
    %rmiinit;
    %rmi_batch_create_rrr_sample_data(ENTITY=MAIN,USERNAME=sasdemo,SCOPE=P);


G54002 for SAS Risk Reporting Repository 1.4_M1

Data model changes have been made to the SAS Risk Reporting Repository. You must update the structures of the private RRR locations and Shared location.

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: If the post-installation tasks for F12005 has been applied, the structures of the Private locations will be automatically updated with the latest reportmart structure the F12005 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 second 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="sasdemo" metapass="Pass99" metaserver="rdcesx05105.race.sas.com" metaport=8561 metarepository="Foundation";
%rmiinit;
%rmi_batch_create_rrr_sample_data(ENTITY=MAIN,USERNAME=sasdemo,SCOPE=P);

* 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=sasdemo;
%let rrr_password=Pass99;

options metauser="sasdemo" metapass="Pass99" metaserver="rdcesx05105.race.sas.com" metaport=8561 metarepository="Foundation";
%rmiinit;
%rmi_batch_create_rrr_sample_data(ENTITY=MAIN,USERNAME=sasdemo,SCOPE=S);

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_rrr14m1hf2. Follow the instructions to execute this alter script in the PDF document m1rrr14_to_m1rrr14hf2_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_2\m1_to_hotfix2

Unix:

<SASHOME>/SASFoundation/9.2/misc/rskrptmrtvrt/alterscripts/hotfix_2/m1_to_hotfix2

B. If the reportmart is the RRR14m1HF1 version, execute %run_rrr14m1hf1_to_rrr14m1hf2. Follow the instructions to execute this alter script in the PDF document m1rrr14_to_m1rrr14hf1_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_2

Unix:

<SASHOME>/SASFoundation/9.2/misc/rskrptmrtvrt/alterscripts/hotfix_2

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.


F92004 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


G61002 for SAS Risk Management for Insurance Mid-Tier 2.1_M1

Re-build and Re-deploy Web Application

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.sh.
SAS Deployment Manager is installed in the following default location:

<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.
A backup of the original ear file will be placed in the directory below:

<SASCONFIGDIR>/Web/Staging/Backup

Step 2: Re-deploy Web Applications

Re-deploy the web applications based on the instructions for the web application server you are using.

Step 3: Copy files into the application's deployed ear file

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.



This completes the installation of hot fix F90004 on Windows for x64.