Hot fix J56001 addresses the issue(s) in Forecast Analyst Work Bench 5.1_M1 as documented
in the Issue(s) Addressed section of the hot fix download page:
http://ftp.sas.com/techsup/download/hotfix/HF2/J56.html#J56001
J56001 is a "container" hot fix that contains the following "member" hot fixes which will update the software components
as indicated.
J57001 updates SAS Forecast Analyst Workbench Mid-Tier 5.1_M1
J58001 updates SAS Forecast Analyst Workbench Server 5.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
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, J56001pt.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 J56001pt.zip on each machine or save it in a network location that is accessible to all machines.
Do NOT extract the contents of J56001pt.zip. The hot fix installation process will extract the contents as needed.
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.
After downloading J56001pt.zip, follow the instructions for applying hot fixes in the SAS Deployment Wizard and SAS Deployment Manager 9.3: User’s Guide.
The hot fix installation process generates the log file
<!SASHOME>/InstallMisc/InstallLogs/IT_date-and-time-stamp.logfor 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.
Click the link to be redirected to post-installation instructions:
J58001 updates SAS Forecast Analyst Workbench Server 5.1_M1
J57001 updates SAS Forecast Analyst Workbench Mid-Tier 5.1_M1
Clearing Cache
J58001 updates SAS Forecast Analyst Workbench Server 5.1_M1
For SAS® Forecast Analyst Workbench 5.1 hotfix release, the data administrator must execute the following macro through
the Code Editor of SAS Data Integration Studio:
%ddcf_f1ddf51_updates(library=uiart);
When you execute this macro, the following tasks are performed:
Parameter | Description | Example of the Parameter Value |
GL_INCLUDE_STAKEHOLDER_DIM_IND | Specifies whether the stakeholder dimension should be added while initiating the consensus planning process.
The values are 1 or 0. The value 1 indicates to include stakeholder dimension while the value 0 indicates not to
include stakeholder dimension.
Note: If the customer is already using the Stakeholder dimension and after applying this hotfix the customer does
not want to use the Stakeholder dimension, then perform the following steps:
For more information about SAS Financial Management, see SAS Financial Management: Data Administrator’s Guide. For more information about SAS Forecast Analyst Workbench, see SAS Forecast Analyst Workbench: Data Administration Guide and SAS Forecast Analyst Workbench: System Administration Guide. | 1
|
GL_DDF_ARCHIVE_DIR_PATH | Specifies the path where the archive tables should be created and data should be archived. | <SAS configuration directory>\Lev1\AppData\SASForecastAnalystWorkbench\Archive |
SAS Consultants or system administrators must specify the values of these parameters according to the implementation.
Table name | config.forecast_interval, uiart.forecast_interval |
Column name | LOW_HISTORY_THRESHOLD |
Value after update | 1 |
Table name | config.hpf_preferences | |
Column names | Option | Value |
hpfengine_input_required | YES | |
hpfengine_input_trimmiss | RIGHT | |
hpf_exceptions | CATCH | |
diag_arimax_outlier_filter | SUBSET |
Table Name | Config.hpf_preferences<Plan_ID> | |||||||||||||||||||||||
Column names | Plan_ID | Option | Value | Edit_From
| <Plan_ID>
| hpfengine_input_required
| YES
| BACK
|
| <Plan_ID>
| hpfengine_input_trimmiss
| RIGHT
| BACK
|
| <Plan_ID>
| hpf_exceptions
| CATCH
| BACK
|
| <Plan_ID>
| diag_arimax_outlier_filter
| SUBSET
| BACK
| |
If independent variables are selected for a plan, then these options are also added for independent variables. For example, hpfengine_input_required1, hpfengine_input_required2, hpfengine_input_requiredn
Similar options are added for the hpfengine_input_trimmiss. For example, hpfengine_input_trimmiss1, hpfengine_input_trimmiss2, hpfengine_input_trimmissn
Step 1: Re-build Web Applications
In order for this step to execute correctly, the Metadata Server must be running.
1.1 Set the DISPLAY environment variable, for example
$ export DISPLAY=<displayname>:0
1.2 Delete the cache file com.sas.app.launcher.cache, for example
$ cd <SASHOME>/SASVersionedJarRepository/eclipse1.3Invoke the SAS Deployment Manager 9.3
$ rm com.sas.app.launcher.cache
From the SASDeploymentManager directory execute sasdm.sh, for example
$ cd <SASHOME>/SASDeploymentManager/9.3
$ ./sasdm.sh
1.4 Select a language in the Choose Language box
1.5 Select Rebuild Web Applications
1.6 Select Configuration Directory or Enter the Configuration Directory and Level that needs to be updated
1.7 Specify Connection Information, including the sasadm User ID and Password
1.8 Select Forecast Analyst 5.1 as the Web Application to Rebuild
1.9 Verify the information on the Summary screen and select Start
1.10 Select Finish when the deployment is complete
This process will update the Forecast Analyst Work Bench ear in <CONFIGDIR>/Lev1/Web/Staging and
place the updated exploded ear in <CONFIGDIR>/Lev1/Web/Staging/exploded. The Forecast Analyst
Work Bench ear includes:
Step 2: Re-deploy Web Applications
2.1 Re-deploy the updated ear listed above to the web application server you are using based on the instructions appropriate for your web application server. See SAS 9.3 Intelligence Platform Web Application Administration Guide for more details.
Clearing Cache
What is Cache?
Basically, all the web-tier related files (.jsp .class, JSPCompiled files etc.,) get stored in the
<app_your_application> directory. This is treated as cache whenever there is a restart of a Web Application Server
instance. When this happens, the WebApp server will look for the last serviced object status stored in the cache for service
for any pending requests.
Why do we need to remove Cache?
Whenever your application is accessed for the first time for a fresh deployment of a new version, WebApp server
does a lookup in this directory to see if any older objects persist that will be a conflict with new code objects.
This is where the need for removal of cache arises.
Clearing Cache for Web Logic instance
For WebLogic 9.x onwards, removal of cache means deleting each server instance's tmp folder that contains cache and
stage folders. You can simply remove tmp folder provided there are no configuration changes to the server.
For Web-Logic, delete the tmp folder located at
SASConfig\Lev1\Web\SASDomain\servers\SASServer1\tmp
Clearing Cache for Web Sphere instance
Clear WebSphere cache every time you rebuild and redeploy the ear files.
From the file structure, delete the following folders/files:
ibm\websphere\appserver\profiles\<app server profile>\temp\<node>\<app server> folder
ibm\websphere\appserver\profiles\<app server profile>\wstemp, delete files in this folder
IBM Support may ask you to clear the class cache. There are several reasons for this. After an upgrade, it is possible that the class caches are still holding onto previous versions of classes. It is also possible that the caches became corrupted.
Please remember there are two caches that will need to be cleared, the JVM's cache and the OSGi cache. The server has to be stopped before clearing the cache.
To clear the OSGi class cache:
For Windows platforms, run the following script in each profile:
To clear the JVM's class cache (Windows, Linux and AIX only):
For Windows platforms, run the following script:
And clear the following directory contents:
Clearing Cache for JBoss instance
These folders are created dynamically when we start the Server.
For UNIX platforms, run the following script in each profile:
For UNIX platforms, run the following script:
<WebSphere_HOME>/bin/clearClassCache.sh
<WebSphere_HOME>\bin\clearClassCache.bat
C:\Documents and Settings\DefaultUser\Local Settings\ApplicationData\javasharedresources\
Delete the contents under
<JBossHome>/server/default/tmp
and
<JBossHome>/server/default/work
This completes the installation of hot fix J56001 on 64-bit Enabled Solaris.