Instructions for installing the patch for the OLAP server component
Service level 4.00.030 - Upper English
May 2001
 

Downloading the Patch

This patch will fix all problems described in the previous document. The patch must be applied only to the ShowCase STRATEGY 4.0 release. Refer to the instructions below for downloading and applying the patch.

1. Download the patch (ESE030PS.EXE - 23.2 MB), saving the file in any convenient directory on your PC.

 
2. In Windows Explorer, double-click ESE030PS.EXE. When the dialog box appears, click Extract - you will be prompted to save the file in a new directory. Click Yes. ESE030PS.BIN will be saved.

• Verify that the version of ShowCase STRATEGY Essbase/400 installed is 4.0. Type the following to display the ESSSVR version:

<Essbase Installation Library>/DSPESSENV
• To find out if this patch has already been applied to 4.0, check if the ShowCase PTF user space exists.
DSPOBJD <Essbase installation library>/ESE030PU *USRSPC If the following message appears, the patch has not been applied. CPF9801 - Object ESE030PU in library <Essbase installation library> not found.
• Ensure that you can use FTP between your PC and your AS/400.
• You will be required to sign on to your AS/400 as QSECOFR or with equivalent authority (*ALLOBJ, *IOSYSCFG, *SAVSYS, *JOBCTL, and *SECADM special authorities are needed) to apply the patch.
• The Essbase server to which this patch will be applied must be shut down before applying the patch. Either use your typical method of shutting down, or use the ShowCase-supplied command, ENDESSSVR.
• Bring down your OLAP server. Either use your typical method of shutting down, or use the ShowCase-supplied command, ENDAOSSVR.
• Once both the OLAP server and the Essbase server are shutdown, signoff your AS/400 session and re-signon.

Note: Before installing the patch, be sure to read and follow the prerequisites listed above.

1. OS/400: Create a save file in QGPL
CRTSAVF QGPL/ESE030PS
2. PC: Use FTP to transfer ESE030PS.BIN to the AS/400:
C:\>FTP<AS/400 IP Address>
User (system:(none)): <userid>
331 Enter password.

Password: <password>
230 <userid> logged on.
ftp> binary
ftp> put c:...\ESE030PS.BIN QGPL/ESE030PS
ftp> quit
C:\>

3. OS/400: Restore the LODRUNS program and command from the save file using the following command. This may replace an existing version of the command and program which is OK.
RSTOBJ OBJ(LODRUNS) SAVLIB(QTEMP) DEV(*SAVF) OBJTYPE(*ALL) SAVF(QGPL/ESE030PS) RSTLIB(<Essbase installation library>) ALWOBJDIF(*ALL) MBROPT(*ALL)
4. OS/400: If the restore is correct, the following message will appear:
2 objects restored from QTEMP to <Essbase installation library>. Note: If the RSTOBJ command fails, be sure you successfully created the save file in step 1 and that the FTP in step 2 was also successful.
5. OS/400: Update the command as follows.
CHGCMD CMD(<Essbase installation library>/LODRUNS) PGM(<Essbase installation library>/LODRUNS)
6. OS/400: Apply the patch as follows. When prompted, enter the name of the Essbase installation library.
<Essbase installation library>/LODRUNS SAVF(QGPL/ESE030PS)
7. OS/400: A journal will be created during the apply process. The journal contains information about the apply process and the last entry in the journal contains the PTF level. There should not be any journal entries of type ER or CE. The last ID entry will indicate the latest PTF level that was applied. DSPJRN JRN(<Essbase installation library>/SCPTFLOG)
8. The patch process is now complete.

The Essbase/400 4.00.030 Server patch resolves the following updates:

• Floating Point error 1012564 when running a calculation; (F7390)
• Essbase build plan in Warehouse Builder will fail without a rule file associated with it; (F6361)
• Rollups using the @sibling function could possibly give a value of zero when it should not have; (F7264)
• Data file Cache Settings where being displayed incorrectly; (F7123)
• Essbase server could crash when displaying the server log; MCH3601 from GetLogTime; (F7085)
• Using the CALCOPTCALCHASHTBL set to True can cause a calculation to run long; (F6960)
• MCH3601 when validating a transparent partition with attributes; (F6958)
• 'IF' statements under German, French, and Italian version will fail; (F6947)

• Error message "Cannot access object: Ess00000.TMP" when using the Outline API; (B23034)
• Database fails to load with buffered I/O in effect and an Index Page size less than 8K; (B21733)
• Cannot tag a parent and a child Dynamic Calc and Store with dimension build; (B14688)
• EsbLROAddObject() may give Error 1030718; (B17507)
• The server may not be able to create database whose names contain certain foreign characters; (B18532)
• An attempt to create and delete a chart on Lotus 1-2-3, Release 9.0 may disable the double-click drilling function of the mouse; (B18719)
• Server crashes during extremely heavy concurrent update workload; (B19397)
• Excel does not prompt to save when Essbase Cascade is performed; (B19431)
• Database setting "Create block on equation" behaves differently after Release 5.0.2 P9; (B19496)
• Essbase EssRetrieve macro lock option for 2 and 3 no longer works for Lotus 9.1; (B19496)
• 5.0.2 P10 locale files and ESSBASE.MDB are not replaced in a new patch installation; (B19522)
• Long member formula gets truncated with member load using rules file; (B19902)
• ESBGetLogFile will not get the server log file unless application name is undefined; (B19936)
• Retrieve returns invalid values on certain databases with circular dependencies between blocks; (B20158)
• Calc never finishes across a transparent partition; (B20579)
• Renaming a member with shared attribute incorrectly causes complete restructure; (B20764)
• Attributes with lengthy text names may crash the application; (B20795)
• Unable to synchronize an outline after the outline is revised for transparent partition; (B20904)
• Right click of the mouse to collapse member values displays irregular layout with Hyperion Spreadsheet Add-in; (B20916)
• When Substitution Variables are set to validate a calc script an error "Unknown Member" is generated; (B20927)
• VB API crashes on EsbOtlGetMemberInfo; (B20941)
• Performance problem with Dimension Build for aliases on shared members; (B20997)
• If there is more than one substitution variable, changing one value may cause some of the previous substitution variables to disappear; (B20999)
• Record #65536 is missed when doing a file/Update outline; (B21000)
• Attribute query with shared members and two-pass calc members may cause the server to crash; (B21099)
• Clicking a member cell may clear the spreadsheet; (B21159)
• Adding members to outline with OUTLINECHANGELOG TRUE crashes the database; (B21190)
• The multiple UPDATEVARIABLE command updates the first variable; (B21207)
• Loading data with rules file set with "Add to existing value" with #MISSING after 0 value, gives #MISSING; (B21272)
• The option CALCOPTCALCHASHTBL TRUE causes inconsistent results; (B21300)
• Hyperion Essbase Application Manager crashes when viewing a member with a user-defined attribute (UDA) list display larger than 4k; (B21534)

• Possible MCH3601 messages from the Server or Application job when attempting to validate a transparent partition on outlines have Attribute Dimensions; (F6958)
• Unable to edit group profile when integrated security is turned on. Error 'User essgroup does not exist; (F6816)

• If a Base Dimension has one or more 'Implied Share' member(s)  because of a code defect Essbase can derive incorrect total members for that dimension. This can potentially cause a problem during incremental dimension build of that dimension. This fix corrects the problem.  (F6441)
• Resolved a problem whereby substitution variables were deleted in error when attempting to delete other substitution variables. (F5485)
• Analyzer for the Web would receive an MCH3601 when right clicking on a dimension in the navigator.  (F6509)
• Essbase load would fail when trying to load a .txt file with no rules file in Warehouse Builder.  (F6361)

Time Series data gets removed after dimension build was run.  (F6904)

Back to Patch Description