FixPak Date: May 2003
Service Levels:
This FixPak includes fixes for DB2 OLAP Server V8.1 and its features at the following service levels:
This FixPak is for Windows only.
DB2 OLAP Server Miner V8.1 is not updated by this FixPak.
This document describes FixPak 1 for Japanese, which is called FixPak 1.3 in the installation program. FixPak 1.3 is the same as FixPak 1 for Japanese.
If you are installing client products from a DB2 OLAP Server FixPak,
you must install server products to the same FixPak level. For example,
if you install a FixPak 1 client, you must also install the FixPak 1 server.
Using older server versions with newer client versions is not recommended
and is not supported.
FixPak 1 is the equivalent of Release 6.5.1 of the Hyperion products.
Hyperion maintenance levels are cumulative; each level contains new fixes
and all the fixes for the previous maintenance levels.
The installation program On Windows NT and Windows 2000 automatically stops the Windows services for DB2 OLAP Server and its features before copying files. In rare circumstances the install program might appear to freeze after displaying the message that it is stopping the services. If this occurs, exit the installation and manually stop any DB2 OLAP Server services that are running.
To stop Windows NT and Windows 2000 services:
ftp://service.software.ibm.com/ps/products/db2olap/fixes/v81/fp01/japanese/wincd.zip
If you are installing from a CD, copy the file to the temporary directory. If you have installed clients on other computers, you need to download the file to those computers, too.
To start the installation:
You need to download a number of files that contain the product code and documentation. The number varies according to how many operating systems you use and which documentation you want. You can download the files from here:
ftp://service.software.ibm.com/ps/products/db2olap/fixes/v81/fp01/eas/
You need to download a number of files that contain the product code and documentation. The number varies according to how many operating systems you use and which documentation you want. You can download the files from here:
ftp://service.software.ibm.com/ps/products/db2olap/fixes/v81/fp01/ees/
The following links work only after you finish installing the FixPak, or if you are reading this from the DB2 OLAP Server Web site. These links do not work while you are running the installation program. The documents displayed by these links refer to the OLAP products by their Hyperion names, not by their IBM names. The information in these documents supplements and updates the information in the DB2 OLAP Server 8.1 documentation originally installed.
FixPak 1 adds Japanese translations of the the following books:
To read the Administration Services documentation and begin the installation, see Installing the FixPak for DB2 OLAP Server Administration Services.
To read the Enterprise Services documentation and begin the installation, see Installing the FixPak for DB2 OLAP Server Enterprise Services.
Additionally, the following updates to the DB2 OLAP Server documentation are new in FixPak 1:
The instructions for silent installation are mislabeled in the Installation Guide as applying only to DB2 OLAP Server Miner. You can use the instructions in "Installing DB2 OLAP Server Miner on Windows" to do a silent install for DB2 OLAP Server on Windows as well as OLAP Miner.
If you use silent install for both DB2 OLAP Server and for OLAP Miner, ensure you copy the setup.iss file for OLAP Miner into a different temporary directory, or the file will overwrite the one for DB2 OLAP Server.
Configuring your spreadsheet program manually
If you have Lotus 1-2-3 or Excel installed before you install DB2 OLAP
Server, the installation program for DB2 OLAP Server detects the spreadsheet
program and configures it to work with OLAP applications. But if
you install Lotus 1-2-3 or Excel after installing DB2 OLAP Server for the
first time, you must configure the spreadsheet program manually.
Follow these steps:
On Windows, stop servers before running Modify Component or License
Information
In the Windows installation program, on the Setup - Maintenance panel, when you select the Modify or Repair actions, the installation program attempts to stop the server components so they won't interfere with the action. Under some circumstances, the servers might not stop successfully. IBM recommends you manually stop the servers for all DB2 OLAP Server products before running the Modify or Repair actions.
Tip for using 'Aggregate Missing Values'
If your database allows or requires 'Aggregate Missing Values' setting set to YES, then you may want to consider using ZLIB as the compression scheme. ZLIB particularly works well on such databases compared to other compression schemes. However, changing the aggregate missing values setting may have an impact on calculation results - see the Database Administrator's Guide. Consider using ZLIB only if you have already determined that the setting should be YES for other reasons.
Tip for validating outlines that use formulas with customer-defined functions
Outlines containing formulas that use custom-defined functions (CDFs) cannot be validated on the client. Outlines containing CDFs must be validated on the server.
New configuration setting to support ragged hierarchies
A new configuration file setting, HARAGGEDHIERARCHY, enables support of null values in columns of dimension tables that are used to create dimensions for Hybrid Analysis-enabled outlines. The dimension build that these dimension tables result in the outlines are known as ragged hierarchies.
NOTE: The HARAGGEDHIERARCHY setting is not valid for the Accounts dimension.
If you have null values in columns of dimension tables used to create
dimensions in an Hybrid Analysis-enabled outline, use the HARAGGEDHIERARCHY
setting in essbase.cfg to enable Hybrid Analysis to account for
these null values during SQL generation.
Syntax
HARAGGEDHIERARCHY [appname [dbname]] TRUE | FALSE
appname | Optional parameter. If you supply an application name, the setting applies to all databases within the named application. If you do not supply an application name, the setting applies to all applications and databases on the server. |
dbname | Optional parameter. If you supply a database name and an application name, the setting applies only to the named database. If you do not also provide an application name, the database is ignored and the setting applies to all applications and databases on the server. |
TRUE | Setting the value to TRUE enables Hybrid Analysis to account for null values during SQL generation. Note that this setting may have impact on performance because SQL generation is not optimized well on most relational databases. |
FALSE | Setting the value to FALSE prevents Hybrid Analysis from recognizing the null values or gaps in the ragged hierarchy. This option does not affect performance. The default is FALSE. |
(56003)
Correction to Hybrid Analysis Configuration File Settings
The following Hybrid Analysis configuration file settings are missing the application and database parameter in the documentation. Specifying the application and database is optional and lets you apply the configuration setting at the application, database, or global level. The correct syntax is given below:
HAENABLE [appname [dbname]] TRUE | FALSE
HAMAXNUMCONNECTION [appname [dbname]] n
HAMAXNUMSQLQUERY [appname [dbname]] n
HAMAXQUERYROWS [appname [dbname]] n
HAMAXQUERYTIME [appname [dbname]] n
HARETRIEVENUMROW [appname [dbname]] n
Quicklogin No Longer Required to Start Parallel Login Processing
To enable parallel login processing when you start DB2 OLAP Server, you no longer need to specify essbase password -quicklogin or set the QUICKLOGIN command in the Essbase configuration file. DB2 OLAP Server automatically starts up with parallel login. (55520)
Incremental Restructuring Turned Off When Adding Shared Members
Adding shared members to an outline automatically turns off incremental restructuring. (55467)(55470)
Correction for EsbGetDatabaseInfo Example
The example for the EsbGetDatabaseInfo Visual Basic API documentation contains errors.
The following sample code is incorrect:
If sts = 0 Then For n = 1 To Items sts = EsbGetNextItem(hCtx, ESB_REQINFO_TYPE, Items) Next End IfThe correct code is:
If sts = 0 Then For n = 1 To Items sts = EsbGetNextItem(hCtx, ESB_DBREQINFO_TYPE, DbReqInfo) Next End If(43501)
Correction to Hybrid Analysis Guidelines
The following information updates the documentation in Appendix D of the Database Administrator's Guide:
Hybrid Analysis has some guidelines with which you should be familiar:
Correction to ESTIMATEFULLDBSIZE Documentation
The following text corrects the ESTIMATEFULLDBSIZE ESSCMD documentation in the online Technical Reference.
Outlines that contain sparse formulas of any type or topdown formulas are not supported. Results of the estimation on such databases may be invalid.
Syntax
ESTIMATEFULLDBSIZE
Description
You can select an application and database, then issue this command. DB2 OLAP Server returns the number of blocks the database creates. The database can have all data loaded, or it can have a random sampling of data loaded.
Example
Assume that you have fully loaded Sample Basic. Use this command before
calculation to predict the number of blocks that the calculation would
create if it were executed. This example shows the command and the output
that results:
estimatefulldbsize;
Estimated count of blocks after full calculation = 335
Time elapsed to calculate this estimation = 0.02 seconds
(55822)
Range List Requirement Removed
Functions that take a range list as a parameter no longer require that the list contain only members from the same dimension. (39993)
This section describes the problems fixed in DB2 OLAP Server.
The problems fixed in Enterprise Services are listed in its documentation, which you can access from Installing the FixPak for DB2 OLAP Server Enterprise Services.
DB2 OLAP Server Administration Services and the Japanese edition of DB2 OLAP Integration Server are new to Version 8, and therefore they do not include lists of fixed problems. FixPak 1 does not update DB2 OLAP Server Miner.
Menu in the member selection dialog box in the Spreadsheet Add-in may
be displayed in the wrong location. 17249 (19585)
In the Spreadsheet Add-in, right-clicking in the member selection dialog
box under Rules sometimes displays the pop-up menu outside of the dialog
box.
The online help for the Edit URL dialog box does not work. 17408
(19807)
When you select Edit URL from the Linked Object Browser dialog box
and click Edit and then Help, the Spreadsheet Add-in displays an error
message and the help topic fails to appear.
In the Spreadsheet Add-in, the style selected for drill-through reports
is applied to all members in a dimension at the same level or below that
of the member with the drill-through report. 20724
If any member of a dimension has a drill-through report available,
and Integration Server Drill-Through is selected in the Essbase > Options
> Style tab of the Spreadsheet Add-in, all members of that dimension at
that level or below are displayed as having drill-through reports.
The Getdbstate Esscmd may fail to return the correct value for Concurrency
Wait. 21276 (24720)
The Getdbstate Esscmd incorrectly returns a zero value for Concurrency
Wait.
In some cases, Hybrid Analysis may round relational data using incorrect
precision. 22946
DB2 OLAP Server V8.1 may round all of the data from relational
sources to the same precision regardless of data type. In FixPak 1, Essbase
uses the column definitions from the fact table columns to generate expressions
in the select list with the correct casting. The fix for this problem is
to have Essbase HA use the precision described in the relational data.
Repeated calculations that fix on sparse members might run slowly
due to excessive fragmentation. 24882
If you run repeated calculations or data loads affecting the same set
of data blocks, subsequent calculation or data load times may deteriorate
because of excessive fragmentation. In FixPak 1, the effects of fragmentation
due to repeated loads or calculations is minimal and there should be no
drastic degradation in performance.
Calc script validation may fail to detect certain errors. 25734 (30211)
A calc script that fixes on one of the members to be calculated does
not generate errors during validation, and running the calc script crashes
the application. The validation now detects the error.
Copying a database during a data export may fail. 27608
Copying a database during a data export may fail if the original database
and the database created by copying the original have the same name.
In the Spreadsheet Add-in, the Essbase > Cascade option creates a
file in which the timestamp is not NLS enabled. 27656 (32684)
The cascade option creates worksheets and a file containing an index
of the worksheets. The timestamp in the index file is not NLS enabled,
that is, the format of the date is mm-dd-yy, instead of the format required
by regional settings.
Data load via transparent partition may fail. 27759
You can load data remotely to the source database of a transparent
partition by loading the data to the partitioned area of the target database.
This bug may cause the remote data load to fail with the following error
message "(1014004) Unable to Update Members Which Have Not Been Locked."
Calculating a database using a calc script with at least one formula
may cause the application to crash. 27911
Running a calc script with at least one formula may cause the application
to crash and cause DB2 OLAP Server to create an exception log.
The @ROUND function may produce different results in DB2 OLAP Server
V1.1 than it does in V7.1. 27971
Calculations that use the @ROUND function may have different results.
In the Spreadsheet Add-in, retrievals that return exactly 256 columns
may fail. 28121
Any retrieval or spreadsheet operation, such as a pivot or drill down,
that returns exactly 256 columns may fail.
The OLAP server may crash during a database copy if the security
file is very large. 28271 (33419)
Copying a database with a very large security file (73MB), may cause
the OLAP server to crash.
Spreadsheet retrievals with all members in the same column may crash
the application. 28342 (33499, 33113)
Certain spreadsheet retrievals that have unusual formatting, such as
displaying all members in a single column, may cause the application to
crash.
LDAP Authentication does not work using Active Directory. 28417
An externally authenticated DB2 OLAP Server user cannot log in using
LDAP parameters when the external LDAP repository is Microsoft Active Directory
on Windows 2000.
Parallel calculations that use the Calc TwoPass calculation command
may crash the application. 28718
Running a parallel calculation that uses the Calc TwoPass command may
crash the application.
Certain spreadsheet retrievals may misalign column headings and data.
28728
In spreadsheets that have Use Both Member Names and Aliases for Row
Dimensions selected (in Essbase > Options > Display tab), and have row
members placed between two columns, retrievals may misalign the column
headings and data.
The UPDATEVARIABLE command may fail to update substitution variables.
28849
The UPDATEVARIABLE command fails to update substitution variables when
the case does not match that of the original database and application.
After updating substitution variables using the UPDATEVARIABLE command,
the new variables are displayed in the Application Manager under Server
> Substitution Variables, but a spreadsheet retrieval returns the old
variables and their associated values.
Certain queries may crash the application. 29187
Retrievals of dynamic calc members with member formulas containing
the @PRIOR function may cause the application to crash.
Linked Partitions may not work. 29190
Drilling down on partitioned target members may not launch the linked
objects browser.
Calculations that use the CALC DIM calculation command may crash
the OLAP server. 29211
Using the CALC DIM calculation command with the dimension names listed
out of outline order may crash the OLAP server and generate an exception
log.
Essbase error while clearing database. 29225
When INCRESTRUC TRUE is specified in the essbase.cfg file,
clearing data may fail and may result in the error "Unable to free
aligned memory for [datctxp->ppDatMemPage[]]in[adDatTermDatCtx]."
The results of calculations that use SET AGGMISSG ON may be incorrect.
30739
Some calculations that include the command SET AGGMISSG ON may fail
to aggregate the missing values, thereby resulting in incorrect values.
A calculation fails to use the correct values for substitution variables
that have been changed using EsbCreateVariable. 33115
Values for substitution variables that have been created or changed
through the Visual Basic API function EsbCreateVariable() might not be
evaluated correctly by subsequent calculations.
Calculating currency conversions may take longer than expected. 33869
Running the CCONV calculation command on Currency Conversion applications
may take longer than expected.
The MaxL Perl Module may limit the length of query results to 128
characters. 35170
Query results from the MaxL Perl Module may be truncated if they are
greater than 128 characters in length.
Cannot view connection information in the Application Manager during
a dimension build. 36451
While running a dimension build, you cannot access Security > Connections
from Application Manager for any application on that OLAP server.
The memory used when starting the OLAP Server increases as the setting
for CALCLOCKBLOCKDEFAULT is increased. 36822
The OLAP Server uses relatively more memory at startup when the CALCLOCKBLOCKDEFAULT
is higher than it does when this setting is lower.
Attribute queries containing upper-level attribute members that have
implied share base members may return incorrect results. 36982
Queries from databases with upper level attribute members that have
level-one base members with only one child may return incorrect results.
Memory leak when running calculations that use the @XREF function.
37090
Calculations that use the @XREF function may fail and may result in
the error message "Unable to Allocate Memory"
Some calculations may be incorrect in DB2 OLAP Server V8.1 that were correct in previous versions. 37742, 40027, 40039
Spreadsheet retrievals that have the same member in two consecutive
rows may fail. 43242
Spreadsheet retrievals that have the same member in two consecutive
rows worked in earlier releases, but in V8.1 the same spreadsheet retrievals
fail with the error message, "A column item [] conflicts with a row item
[]."
Spreadsheet retrievals that use certain styles may crash Excel. 43248
Using styles for linked objects, read only cells, or read/write cells
may cause Excel to crash during spreadsheet retrievals.
Spreadsheet retrievals from transparently partitioned databases with
attribute dimensions may crash the application. 43306
Retrieving from a database that has attribute dimensions and is the
target in a transparent partition may crash the application.
The VB API EsbGetDatabaseState incorrectly reports that "Two Pass
Calculation" is not selected even though it has been selected through the
Database Administrator. 43321
The Database Administrator interface does not set the CalcTwoPass field
in the ESS_DBSTATE_T structure used by the Visual Basic API function EsbGetDatabaseState().
The function incorrectly returns that "Two Pass Calculation" is not selected
when "Two Pass Calculation" was set through the Database Administrator
(through Database > Settings > General tab).
Data loads from files with a large number of columns may fail because
of excessive memory usage. 43433
Certain free form data loads from data files that have a large number
of columns may fail because of excessive memory usage. Data files created
by exporting data from a database with a large number of sparse members
may have a large number of columns.
The SQL Drill Through Add-in (DB2 OLAP Server V.1. FixPak 14) may
fail to work with the V8.1 DB2 OLAP Server and Spreadsheet Add-in. 43499
After installing the V8.1 level of the OLAP server and Spreadsheet
Add-in, and the V1.1 FixPak 14 SQL Drill Through Add-in, SQL Drill Through
fails to appear in Essbase pull down menu of the Spreadsheet Add-in.
Retrieving dynamic time series data using the Esscell function may
fail. 43553
The Esscell function may incorrectly return zeros for dynamic time
series data.
Deleting databases may not delete data that resides on spanned disk
volumes. 54953
Using ESSCMD or Application Manager to delete databases may fail to
delete .pag files from the spanned disk volumes.
Parallel calculations may crash the application under certain circumstances.
55126
Parallel calculations may crash the application if the calculation
includes a sparse dynamic calc member that (1) consolidates into its stored
parent and (2) has a formula that causes a top down calculation.
Spreadsheet retrievals may be slower in DB2 OLAP Server V7.1 FixPak
8 and later, and in V8.1, than in V7.1 FixPak 7 or earlier. 55512
Certain spreadsheet retrievals may take longer.
Dimension builds that change consolidation properties may also alter
attribute associations. 55244
Changing consolidation properties using a dimension build rules file
may alter existing attribute associations, causing the outline to become
invalid.
Hybrid Analysis Known Issues
Hybrid Analysis supports only DB2 using native drivers or Meant drivers, Oracle ODBC using Meant drivers or native drivers, and SQL Server. See the Installation Guide for details about platform release levels and drivers supported.
If your system has Oracle ODBC drivers and you plan to use Hybrid Analysis, you must upgrade to Oracle 8.1.6 or later (30531). Enabling Hybrid Analysis while using Oracle ODBC drivers earlier than 8.1.6 causes the following conditions:
MaxL Known Issues
V8.1 of the MaxL Perl Module (essbase.pm) works with V8.1 of the DB2 OLAP Server. It is not compatible with previous releases of DB2 OLAP Server.
Although the limit for stored Essbase calculations is 64 KB, calculation scripts created in MaxL that have multi-byte characters cannot exceed 40 KB.
Database notes created using MaxL appear stripped of newline-character formatting when viewed in the Spreadsheet Add-in.
Memory and System Information on Microsoft
Because of a Microsoft system limitation, if you are running DB2 OLAP Server on a Microsoft platform with more than 4 GB memory, the information about memory and disk swapping in the System Information tab of the Server Information dialog box may be incorrect.
Problem
Number |
Description | |
171822 | When DBCS characters are used in Custom Definition Macro Editor with incorrect syntax, an error message is displayed showing the incorrect string but it does not identify what is wrong with the syntax. | |
173736 | When a table has GRAPHIC data type column, the DB2 OLAP Integration Server desktop does not show the graphic data type column. The table shows other data type columns, but not GRAPHIC. | |
171798 | The default display size of the Link Object Browser dialog is not large enough to display DBCS characters. The workaround is to resize the dialog. | |
171399 | Two DBCS characters are truncated in the Print dialog. The truncated DBCS text is for "Indent Space Number". | |
173340, | Two DBCS characters are truncated in the Custom Definition Macro Manager dialog. The truncated DBCS text is for "Application". | |
173342 | One DBCS character is truncated in the Custom Definition Macro Editor dialog. The truncated DBCS text is for "MaxL Statement". | |
173345 | One DBCS character is truncated in the Partition Manager dialog. The truncated DBCS text is for "Data Target". | |
171847 | If you try to login using the MaxL shell by entering the information one word at a time (such as enterying "login", then entering the user name, etc.), an error results. The workaround, if using MaxL, is to enter all the information at once, such as: "login DBCS+SBCS_user_name identified by password on server_name". | |
173811 | If you use the Spreadsheet Add-in on a computer on which the Adobe Acrobat Reader is not installed, no error message is displayed when you click "Tutorial" to launch the tutorial for Query Designer. Adobe Acrobat Reader is a prerequisite. | |
410713 | DBCS-unique data type columns such as GRAPHIC/VARGRAPHIC cannot be retrieved when you open SQL files with the Rule Editor. | |
409030 | Though the server is installed on same machine as the client, server is not on the same time zone as the client system. For example, even though a Japanese client might use JST (GMT+9), but the server might be looking at GMT instead. | |
409043 | In DB2 OLAP Integration Server, table names and object names that are displayed in Member Load and Data Load messages are displayed in the wrong codepage. The OIS log file (is\log\olapisvr.log) is also displayed incorrectly. | |
409044 | A Java runtime error occurs when you run the sample application
setup. The workaround is to run the SQL script called: oc_upgrade651_db2.sql.
For example, you could run: DB2 -tf oc_upgrade651_db2.sql The same error occurs when you import the sample metadata XML file with the XML Import/Export function. At this time, there is no workaround for this problem. |
|
409020 | Some installation panels are not showing SBCS characters correctly. | |
409028 | When you create a user with a DBCS name, OIS fails the first 2 times, then succeeds on the 3rd attempt. A different error message appears with each failure. | |
409029 | Some characters are appearing corrupted in the MaxL shell. | |
409032 | DBCS characters are truncated in the XML Import/Export panel, on the Import tab. The truncated string should appear as, "Will open XML file to import to OLAP Metadata Catalog". | |
409033 | Tables that have DBCS names that use more more than 1 code point (such as x'878A' and x'FA58') cannot be displayed by the OIS desktop. | |
409038 | DB2 OLAP Integration Server V8.1 FixPak 2 cannot import models that were exported from FixPak 1. You can only import models that were exported prior to FixPak 1. | |
409042 | The date format shown in server log file is not correct format for Japanese. | |
410720 | If you run a report and specify a file for your output, the dialog apparently appends a file extension of ".rpt" to the file, but fails. The output file does not have the extension. | |
411240 | When you import a Shift-JIS encoded XML file (with Shift-JIS encoding declaration), the XML Import/Export tab shows the model name as question mark insteads of DBCS characters. | |
411349 | When you save a model with a name that contains IBM Selected Characters, the model cannot be opened. | |
411244 | The day of week on the calendar is not translated. | |
411245 | If you do not have a default printer defined, then when the Print dialog initially displays, the printer information as displayed is corrupted. | |
411246 | The translated word "object" is truncated in a Data Load Rule Object informative message box. | |
411251 | On the DB2 OLAP Integration Server desktop, the font displayed in the Print Preview is not suitable for DBCS characters. | |
412367 | In DB2 OLAP Integration Server, Byte Order Mark (BOM) for UTF-8 is not supported with the Import function. | |
412370 | In the Query Designer, when dimension names have more than 5 DBCS characters, the name is truncated and the fifth DBCS character appears as a dot. | |
412761 | In Japanese, all the messages in MaxL have an extra period at the end of the sentence. | |
IBM6154 | On Windows, if you are logged on with a user ID that does not have administrator privileges, and you try to run the Modify License utility, an error occurs. Ask your server administrator to run the utility for you. Additionally, if you run the Spreadsheet Add-in with a user ID that does not have administrator privileges, you might see a message such as, "Error loading USE or USELSX module lsx123.dll". To prevent this message from occurring, manually remove the Spreadsheet Add-in from the spreadsheet program for this user ID, using the spreadsheet interface. | |
IBM6193 | On Windows 98, if you run silent install, you might encounter this error: "Sharing Violation Reading drive C... Abort, Retry, Fail." If you type Fail, the installation completes successfully. | |
16412 | In Excel, in Query Designer, the server location radio button may not be active in the "Hyperion Essbase Query Designer Save As Query" window when you try to save a query. This occurs because a selected cell is in Edit mode. If you are typing in a cell, Essbase menu items do not function, although they appear enabled, until you get out of Edit mode. | |
17023 | If a member name contains the ampersand (&), even if it is surrounded with quotation marks, and if the member name is in a calculation script, the script may fail validation if the user has Application Designer permission. DB2 OLAP Server incorrectly interprets the ampersand as the signal for a substitution variable. If you run the script without validation, it performs the calculation correctly. Users with supervisor privilege do not receive this validation error. | |
17253 | DB2 OLAP Server does not support discontinuous selection in Lotus, although it does in Excel. | |
17267 | At the end of a calculation started in Lotus, a dialog box appears with a message that the calculation is complete. Clicking on the dialog box does not close it. Press Esc/Cancel from the keyboard to close the dialog box. | |
17927 | DB2 OLAP Server does not warn you if you request that export results be written to a file that already exists. Essbase overwrites the existing file. | |
17957 | If you create a dimension build rule that uses "Create Using Text" on the last column, and if the last true field in the input file is an "Alias" column that has some blank records, the text generated by the "Create Using Text" feature will not be placed into the last column, but will be placed in any record where the "Alias" column is blank. The rule, which passes validation, will fail during the build. To correct, delimit the blank fields. | |
18015 | Leaving the Spreadsheet Add-in idle for long periods of time may cause extra "Please Log In" messages, because the user may have been logged out due to inactivity. Click OK until the message stops appearing. | |
18041 | DB2 OLAP Server may not be able to open a file if the directory location contains a space. This is true for all files such as load files, rules files, calculation scripts, etc. Consider moving the file so that there are no spaces in the directory path. | |
18046 | When logged in with database designer privilege, the entire list of users is displayed in Security > Database, even though only the list of users that the database designer has privileges to modify should appear. Attempts to modify users for whom database designer should not have privileges will not be successful. | |
18342 | If you use Set Member Filter in EQD, any MBCS values may display as broken characters. Type the values into Notepad, and then copy and paste them over the broken characters. | |
19288 | Using Dynamic Time Series (DTS) members on a partitioned database may
cause a server crash if these conditions are true:
|
|
19522 | When compiling client API programs on NT, with MS VC ++ version 6.0
and higher, you may experience API program crashes if you have used a constant
string assignment to a CHAR pointer, such as:
char * name = "myname";Workaround: Do not use a constant string assignment to a CHAR pointer, or use only ESSBASE data types. |
|
19632 | Valid calculation scripts with a FIX command and nested parentheses within the FIX command may not validate in the Calc Script Editor of the Application Manager and may report spurious errors. The same script will run without problems on the server. | |
20203, 30329 | If you start DB2 OLAP Server as a service on NT, you can
ignore this message, it is informational only:
The description for Event ID ( 0 ) in Source ( EssbaseService ) cannot be found. It contains the following insertion string(s): EssbaseService error: 0, Starting Essbase Service.... |
|
20775 | If you use the Query Designer to change members in a spreadsheet,
then select a dimension and choose Essbase > Cascade, and then in
the Destination Options tab, select the option "One Workbook, Separate
Sheets," you may receive the Microsoft Visual C++ Runtime Library error:
Runtime Error! C:\Program Files\Microsoft Office\Office\Excel.exe....abnormal program termination! error. |
|
22233, 23800, 23344 | Running too many concurrent reports may overwhelm product or operating system resources, especially against partitioned databases. If this occurs, reduce the number of such reports running concurrently. | |
22999 | If, during outline revision, you delete a member with a
particular alias name, and then create a new member with the same alias
name, the alias will fail to register and DB2 OLAP Server creates the new
member without an alias.
Workaround: Either delete the alias from the Outline Editor and save, or use a different alias name when revising. |
|
23086 | Due to a Microsoft bug, you may not be able to display the Spreadsheet Add-in in IE 5.0 if you are running on operating system NT4.0. If you try to open an .xls file from IE 5.0 on NT4.0, the spreadsheet may open in a separate window. | |
23374 | The application log, when displayed via Application Manager, may incorrectly fail to show some log entries for the current day because it evaluates the time using GMT. To view missing log entries, select "All Dates." | |
23974 | Trying to associate an attribute with an implied shared member causes the association to be ignored, and Essbase writes a message to the application log. An implied shared member is a member with only one child. | |
24350 | When the installation program for SQL Interface asks you to specify a driver, if you specify Merant, you won't be able to use DB2 Native drivers, and if you specify DB2 Native drivers, you won't be able to use Merant drivers. | |
24351 | Some characters, such as those using umlaut or accent marks, cannot be typed in ESSCMD interactive mode. | |
25659 | If you use a partition definition where one or more member functions in the definition resolve to an empty set, then DB2 OLAP Server may write more than one message in the application log when you validate the partition. Each message has the same information about a member function resolving to an empty set. All but the first message in the sequence can be ignored. | |
26028 | If you enable parallel calculation (CALCPARALLEL or SET
CALCPARALLEL greater than the default 0) on a database that is part of
a transparent partition, increase the value of SERVERTHREADS for each source
database that is part of the transparent partition, using these rules:
|
|
27139 | If you use Hybrid Analysis with source data in Oracle,
in either of these situations, you must use Oracle version 8.1.7 or higher:
<ROW (Market) [HA-enabled dimension] <DESCENDANTS (Market) |
|
27171 | If you use direct I/O, and have set DLTHREADSWRITE to a value of 16 or greater, Essbase may crash during a parallel data load. If you encounter this error, reduce the number of block write threads by lowering the value of DLTHREADSWRITE to 15 or less, then restarting Essbase. | |
29248 | When running DB2 OLAP Server V7.1 FixPak 5 or V8.1 on Windows 2000 or Windows NT systems, using the EsbSetActive Visual Basic API in code samples in Microsoft Access 2000 may crash Microsoft Access. | |
31691 | You must save a rules file and the data file it uses to the same ARBORPATH/App/database_name directory as the database whose outline you are working with. | |
43247 | Visual Basic API does not support VB.net at this time. | |
43406 | In DB2 OLAP Server V8.1, Application Manager is unable to modify an outline or load data if the text file is located in a different application database directory on the same server. | |
55620 | Adding both shared and non-shared members to a parent in
the outline of a partitioned database may cause the application to crash
and may cause an access violation error.
Workaround: Change the order in which the shared and non-shared children are listed in the outline under the parent. The non-shared children should be listed first and the shared children should be listed at the end of the outline. |
|
55837 | After importing a large number of LROs (for example, over
100 LROs) using MaxL or Administration Services, restructuring the outline
may cause the database to crash.
Workaround: Increase the index cache size from the default value of 10240 KB using the alter database MaxL statement, the Index Cache setting in the Database Properties window (Caches tab) in Administration Services, or the Index Cache setting in the Database Settings dialog box (Storage tab) in Application Manager. |
|
55926 | Before using the MaxL alter database statement to
get invalid block header information for a given database, be sure that
the server is not performing other operations, such as calculations or
dataloads; otherwise, an exception error may occur. Before running the
MaxL statement to get invalid block header information, the database administrator
must forcibly log off all users and disable all logins to ensure that no
other users or processes are using the server.
The complete MaxL statement to get invalid block header information is alter database DBS-NAME validate data to local logfile 'FILE-NAME';. |
Licensed
Material - Program Property of IBM
(c)
Copyright IBM Corp. 1998, 2003. All Right Reserved.
US
Government Users Restricted Rights - Use, duplication or disclosure restricted
by GSA ADP Schedule Contract with IBM Corp.
IBM,
DB2, and DB2 OLAP Server are trademarks of International Business Machines
Corporation in the United States, other countries, or both.
Portions
(c) 1991-2003 Hyperion Solutions Corporation. All rights reserved.
Hyperion is a registered trademark and Hyperion Solutions is a trademark
of Hyperion Solutions Corporation.
Portions
(c) Blue Sky Corporation. All rights reserved.