Installation Instructions for Hot Fix B3L004

Windows for x64

Hot fix B3L004 addresses the issue(s) in SAS Forecast Analyst Workbench 5.3_M1 as documented in the Issue(s) Addressed section of the hot fix download page:

http://ftp.sas.com/techsup/download/hotfix/HF2/B3L.html#B3L004

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

B3N001  updates  SAS Forecast Analyst Workbench Mid-Tier 5.3_M1
B3M004  updates  SAS Forecast Analyst Workbench Server 5.3_M1
B4R001  updates  SAS Forecast Analyst Workbench Server Configuration 5.3_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 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, B3L004pt.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 B3L004pt.zip on each machine or save it in a network location that is accessible to all machines.

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

POST-INSTALLATION INSTRUCTIONS

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

B3N001  updates  SAS Forecast Analyst Workbench Mid-Tier 5.3_M1
B3M004  updates  SAS Forecast Analyst Workbench Server 5.3_M1
B4R001  updates  SAS Forecast Analyst Workbench Server Configuration 5.3_M1

B3N001  updates  SAS Forecast Analyst Workbench Mid-Tier 5.3_M1

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

Follow the steps documented in the rebuild_redeploy_webapp doc to update and deploy the SAS Forecast Analyst Workbench Mid-Tier 5.3 webapp.

B3M004  updates  SAS Forecast Analyst Workbench Server 5.3_M1

After you install the hotfix, you must add the following two configuration parameters to specify the settings for time series disaggregation and the maximum time required to check the lock of a database table: GL_RUN_DISAGGREGATION_IND and GL_CHECK_LOCK_MAX_TIME.

The GL_RUN_DISAGGREGATION_IND parameter specifies whether you want to disaggregate the predicted values for the time series while diagnosing a forecast. You might want to disaggregate the time series when you are using collaboration planning and product chaining. The value 1 indicates that SAS Forecast Analyst Workbench disaggregates the predicted values for time series. The value 0 indicates that SAS Forecast Analyst Workbench does not disaggregate the predicted values for the time series.

The GL_CHECK_LOCK_MAX_TIME parameter indicates the maximum time a process can check whether a database table is exclusively locked by another process. When a database table is being modified by multiple processes, the first process exclusively locks the database table to update it. The rest of the processes wait for the first process to get completed and to release the lock. The GL_CHECK_LOCK_MAX_TIME parameter specifies the time in milliseconds that the other processes wait to get the lock released. You might want to increase the time that is specified in GL_CHECK_LOCK_MAX_TIME parameter when the stored processes are failed due to locking error.

Perform the following steps to specify the settings for time series disaggregation and database lock:

1. Log on to SAS Management Console as an administrative user (sasadm) or as a user with administrative rights.

2. In the Plug-ins tab, go to SAS Management Console > Application Management > Configuration Manager > Forecast Analyst Config.

3. Right-click Forecast Analyst Config and select Properties.

4. In the Forecast Analyst Config Properties dialog box, click Advanced tab.

5. In the Advanced tab, click Add.

6. In the Define New Property dialog box, enter Property Name as GL_RUN_DISAGGREGATION_IND and Property Value as 1.

7. Click OK to close the Define New Property dialog box.

8. On the Advanced tab, click Add to add another parameter.

9. In the Define New Property dialog box, enter Property Name as GL_CHECK_LOCK_MAX_TIME and Property Value as 10000.

10. Click OK to close the Define New Property dialog box.

11. Click OK to close the Forecast Analyst Config Properties dialog box.

B4R001  updates  SAS Forecast Analyst Workbench Server Configuration 5.3_M1

Import faw_jobs.spk file in order to see the jobs in SAS Data Integration Studio

Perform the following instructions to import the faw_jobs.spk file so that the ETL jobs become available in the SAS Data Integration Studio.

1. Log on to SAS Data Integration Studio as a user account that is in the SAS Administrators Group.

2. On the Folder tabs, go to Products > SAS Forecast Analyst Workbench > 5.3 Jobs.

3. Right-click 5.3 Jobs, point to Import and then select Import SAS Package.

4. In the Import from SAS Package wizard, browse the faw_jobs.spk file, and click Next.
   After you install the hotfix, the faw_jobs.spk file is present at <SASHome>/SASForecastAnalystWorkbenchServerConfiguration/5.3/Config/Deployment/SASPackages/.

5. In the Select Objects to Import step of the Import from SAS Package wizard, clear the check box for Products.
   After you clear the check box for Product, the check boxes for all objects are cleared.

6. Select the Wave 12 check box and then click Next.
   By selecting the check box for Wave 12, the two check boxes that are child of Wave 12 are automatically selected.

7. Review the summary and then click Finish.
   

The faw_1201_create_config_tables_for_forecast and faw_1202_create_and_diagnose_forecast jobs are imported.

Execute the following code through the Code Editor of SAS Data Integration Studio. (Ensure that the user, who runs this macro, is a member of "SAS Administrator" group):

%ddcf_faw53m1_hotfix_migration;