Installation instructions for hot fix Y98006 on Windows

Installation Instructions for Hot Fix Y98006

Windows

Hot fix Y98006 addresses the issue(s) in Field Quality Analytics 6.1 as documented in the Issue(s) Addressed section of the hot fix download page:

http://ftp.sas.com/techsup/download/hotfix/HF2/Y98.html#Y98006

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

Z02006 updates SAS Field Quality Analytics Logical Types 6.1
Z01006 updates SAS Field Quality Analytics Mid-Tier 6.1
Y99005 updates SAS Field Quality Analytics Server 6.1
Z03001 updates SAS Quality Analytics Suite Common Mid-tier 6.1_M2

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

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

Hot Fix Y98006 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 Field Quality Analytics 6.1 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 Y98006pt.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

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.

Z02006 updates SAS Field Quality Analytics Logical Types 6.1
Z01006 updates SAS Field Quality Analytics Mid-Tier 6.1
Y99005 updates SAS Field Quality Analytics Server 6.1
Z03001 updates SAS Quality Analytics Suite Common Mid-tier 6.1_M2

Z02006 updates SAS Field Quality Analytics Logical Types 6.1

NONE

Z01006 updates SAS Field Quality Analytics Mid-Tier 6.1

Z03001 updates SAS Quality Analytics Suite Common Mid-tier 6.1_M2

Re-build Web Application

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

1. Invoke the SAS Deployment Manager 9.4

From the SASDeploymentManager directory launch sasdm.exe.
SAS Deployment Manager is installed in the following default location:

<SASHOME>\SASDeploymentManager\9.4

2. Select a language in the Choose Language box

3. Select Rebuild Web Applications

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

5. Specify Connection Information, including the sasadm User ID and Password

6. Select SAS Field Quality Analytics Mid-Tier 6.1 and SAS Quality Analytics Suite Common Mid-tier 6.1 as the Web Application to Rebuild

7. Verify the information on the Summary screen and select Start

8. Select Finish when the deployment is complete

This process will update the SAS Field Quality Analytics Mid-Tier 6.1 and SAS Quality Analytics Suite Common Mid-tier 6.1 ear in

<SASCONFIGDIR>\Web\Staging

A backup of the original ear file will be placed in the directory

<SASCONFIGDIR>\Web\Staging\Backup

9. Exit the SAS Deployment Manager 9.4

Re-deploy Web Application

1. Restart all SAS sessions, daemons, spawners and servers.

2. Invoke the SAS Deployment Manager 9.4

From the SASDeploymentManager directory launch sasdm.exe.
SAS Deployment Manager is installed in the following default location:

<SASHOME>\SASDeploymentManager\9.4

3. Select a language in the Choose Language box

4. Select Deploy Web Applications

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

6. Specify Connection Information, including the sasadm User ID and Password

7. Check the Allow the application server to stop checkbox

8. Select SAS Field Quality Analytics Mid-Tier 6.1 and SAS Quality Analytics Suite Common Mid-tier 6.1 as the Web Application to Deploy

9. Verify the information on the Summary screen and select Start

10. Select Finish and exit the SAS Deployment Manager when the deployment is complete

Prerequisites:

1) Verify SAS Metadata Sever is started
2) Verify Field Quality Analytics Data Base Server is started

I) Changes to MFGAPP tables:

Summary:Execute following code (code snippet1) in SAS session where MFGAPP library is pre-allocated.

Steps:

1) Login to SAS Server Tier machine with Field Quality Analytics ETL Administrator user (Typically it is fqaetlad).
2) Launch SAS Editor (Go to location /Lev1/SASApp. For windows run sas.bat. For Unix run sas.sh.)
3) Verify MFGAPP library is available in libraries
4) Copy following code in program editor and execute

/*Code Snippet 1: Start*/
%macro wrna_hotfix_updates;

/* Find the maximum column id, so we can safely add new rows */
proc sql noprint;
select max(COLUMN_ID)+1 into :l_max from MFGAPP.TABLECOLUMN_META;
quit;

proc sql noprint;

/* Add metadata for ALERT_ISSUE_DATE */
select count(COLUMN_NM) into :l_cnt from MFGAPP.TABLECOLUMN_META where COLUMN_NM = "ALERT_ISSUE_DATE";
%if &l_cnt = 0 %then
insert into MFGAPP.TABLECOLUMN_META(SOLUTION_CD,COLUMN_ID,TABLE_ID,COLUMN_NM,COLUMN_LABEL,COLUMN_DESC,COLUMN_DATA_TYPE,COLUMN_FMT_NM)
values ("WRNA",&l_max,0,"ALERT_ISSUE_DATE","Alert Issue Date","Alert Issue Date",5,"NLDATE10.");;

/* Add DEFAULT_DATE_FORMAT property */
select count(PROPERTY_CD) into :l_cnt from MFGAPP.SAS_APPLICATION_CONFIG where PROPERTY_CD = "DEFAULT_DATE_FORMAT";
%if &l_cnt = 0 %then
insert into MFGAPP.SAS_APPLICATION_CONFIG (PROPERTY_CD, PROPERTY_VALUE, GROUP_CD)
values ('DEFAULT_DATE_FORMAT','NLDATE10.','GENERAL_CONFIGURATION');;

/* Add DEFAULT_DECIMAL_FORMAT property */
select count(PROPERTY_CD) into :l_cnt from MFGAPP.SAS_APPLICATION_CONFIG where PROPERTY_CD = "DEFAULT_DECIMAL_FORMAT";
%if &l_cnt = 0 %then
insert into MFGAPP.SAS_APPLICATION_CONFIG (PROPERTY_CD, PROPERTY_VALUE, GROUP_CD)
values ('DEFAULT_DECIMAL_FORMAT','F9.4','GENERAL_CONFIGURATION');;

/* Add DEFAULT_INTEGER_FORMAT property */
select count(PROPERTY_CD) into :l_cnt from MFGAPP.SAS_APPLICATION_CONFIG where PROPERTY_CD = "DEFAULT_INTEGER_FORMAT";
%if &l_cnt = 0 %then
insert into MFGAPP.SAS_APPLICATION_CONFIG (PROPERTY_CD, PROPERTY_VALUE, GROUP_CD)
values ('DEFAULT_INTEGER_FORMAT','F7.','GENERAL_CONFIGURATION');;

/* Add label for DATA_SELECTION_ATTRIBUTE_LOOKUP_TABLE_ROWS_PER_PAGE property */
select count(PROPERTY_CD) into :l_cnt from MFGAPP.SAS_APPLICATION_CONFIG where PROPERTY_CD = "DATA_SELECTION_ATTRIBUTE_LOOKUP_TABLE_ROWS_PER_PAGE";
%if &l_cnt = 0 %then
insert into MFGAPP.SAS_APPLICATION_CONFIG (PROPERTY_CD, PROPERTY_VALUE, GROUP_CD)
values ('DATA_SELECTION_ATTRIBUTE_LOOKUP_TABLE_ROWS_PER_PAGE','10','DS_CONFIGURATION');;

quit;

/* Update default Summary Tables ExposureType for Single Dimension Warranty configurations */
select DEFAULT_VALUE_TXT into :l_default_value_txt from MFGAPP.ANALYSIS_GLOBAL_DEFAULTS where PARAM_CD = 'WARRANTYDIMENSION';
%if &l_default_value_txt = 1 %then
update MFGAPP.ANALYSIS_TEMPLATE_PARAM
set DEFAULT_VALUE_TXT='TIS' where PARAM_CD = 'exposureType' and TEMPLATE_ID = 'CROSSTAB';;
quit;

%mend;
%wrna_hotfix_updates;
/*Code Snippet 1: end*/

5) Verify there are no errors in the log.
6) Logout

II) Changes to SASHELP tables:

Summary:Execute following code (code snippet2) in SAS session using same userid who performed initial SAS installation.

Steps:

1) Login with the install user
2) Launch SAS Editor(Go to location /Lev1/SASApp. For windows run sas.bat. For Unix run sas.sh.)
3) Verify SASHELP library is available in libraries
4) Copy following code in program editor and execute

/*Code Snippet 2: start*/ %macro wrna_hotfix_updates;
proc sql noprint;
/* Add label for ALERT_ISSUE_DATE */
select count(KEY) into :l_cnt from SASHELP.WRTYANL_TABLECOLUMN_META where KEY = "ALERT_ISSUE_DATE__LABEL";
%if &l_cnt = 0 %then
insert into SASHELP.WRTYANL_TABLECOLUMN_META(LOCALE,KEY,LINENO,TEXT)
values ("en","ALERT_ISSUE_DATE__LABEL",1,"Alert Issue Date");;

quit;
%mend;
%wrna_hotfix_updates;

/*Code Snippet 2: end*/

5) Logout

III)Restart the application server where sas.fieldqualityanalytics.war is deployed. (Typically it is SASServer8)

Y99005 updates SAS Field Quality Analytics Server 6.1

To correct an issue with running the business rules stored process multiple times in batch, modify the $SASHOME/wrtyanlmva/sasstp/WRNA_SWABRmain.sas file to include the following. This should be placed at the end of the macro, immediately following the call to %anl_br_driver;:

/* clear the macro variables */
proc sql;
     select name into :l_macrovar separated by ' '
     from sashelp.vmacro where scope="GLOBAL"
     and (substr(name,1,2)="L_" or substr(name,1,2)="G_") ;
quit;

%let i=1;
%do %until (%scan(&l_macrovar,&i,' ') = );
     %let l_mac=%scan(&l_macrovar,&i,' ');
     %symdel &l_mac;
     %let i=%eval(&i+1);
%end;

A new feature to compress dimensions tables in stored data selections is available, and requires the following to be added to /wrtyanlmva/ucamcros/wrna_init.sas/. This should be added immediately after the %macro wrna_init; statement.

%global g_compressdims;
%let g_compressdims=YES;