Notes/Domino Fix List
 |  |
| SPR # BKOH6FBKDU | Fixed in 6.5.6; 7.0.1 release | Regression in 6.5.3 |
Product Area: Designer Technical Area: @functions Platform: Cross Platform
Lotus Customer Support APAR: LO09829
SPR# BKOH6FBKDU - Reverted to R5 behavior, where if @DBLookup obtains a value that's too long (greater than 64K), an @Error will be returned instead of displaying an error dialog.
Technote Number: 1233623
Problem:
This issue was reported to Quality Engineering and has been fixed in
Notes/Domino 6.5.6 and 7.0.1. The fix did not address the case where a lookup
was used in a Dialog List field.
Excerpt from the Lotus Notes and Domino Release 7.0.1 MR fix list (available at
http://www.ibm.com/developerworks/lotus):
@functions
SPR# BKOH6FBKDU - Reverted to R5 behavior, where if @DBLookup obtains a value
that is too long (greater than 64K), an @Error will be returned instead of
displaying an error dialog.
Refer to the Upgrade Central site for details on upgrading Notes/Domino.
Supporting Information:
The fix introduced a regression where lookups that returned greater than 64K
always returned an error, which should not be the case. In Notes 6.0 and
later, lookups are able to return greater than 64K as long as the resulting
data set is then limited using formulas or functions so that less than 64K of
data is returned to a field or the Notes user interface. For further details
on this regression issue, refer to the document titled: "@Db lookups that
return greater than 64K always return an error even when result set is limited
to less than 64K" (#1231611). Note: The fix for this regression issue causes
@IsError check to be nonfunctional when the data returned is greater than 64K.
In such cases, @ERROR will be returned in the field regardless of an @IsError
check.
The fix also introduced a change in the error observed when a lookup is present
within a computed field and @IsError is not being used. With the fix, a
computed field that returns greater than 64K will be populated with "@ERROR".
Prior to the fix, composing the document would have returned the error: "The
result of the computation cannot exceed 65535 bytes."
Examples of behavior
The examples below are relative to a lookup formula, which itself returns more
than 64K of data.
Computed field
5.x: When a document is composed, this error is returned: "The specified
database lookup generated more than 65,000 bytes of results, which is too large
to return in this context."
6.0 through 6.5.5, and 7.0: When a document is composed, this error is
returned: "The result of the computation cannot exceed 65535 bytes."
6.5.6, 7.0.1 and 7.0.1 CCH1: The field is populated with @ERROR. This is
expected given that returning more than 64K does not generate an error in 6.x
and later versions.
Computed field containing lookup with @IsError check
5.x: - The @IsError detects that greater than 64K of data was returned, which
is expected as this is not allowed in 5.x.
6.0 through 6.5.5, and 7.0 - When a document is composed, this error is
returned: "The result of the computation cannot exceed 65535 bytes." Note:
This is the issue described in this document.
7.0.1 - @IsError detects that greater than 64K of data was returned.
6.5.6, 7.0.1 CCH1 - The field reflects @ERROR and the @IsError check is
ignored. This is expected given that returning more than 64K is not an error.
Computed field which limits the amount of data returned to less than 64K of
data (for example, @Subset.)
5.x - When a document is composed, this error is returned: "Field:
'<fieldname>': The specified database lookup generated more than 65,000 bytes
of results, which is too large for Notes to return in this context."
6.0 through 6.5.5, and 7.0 - The expected data is returned.
7.0.1 - Field reflects @ERROR. Note: This is the regression issue described
previously in this document.
6.5.6, 7.0.1 CCH1 - The expected data is returned.
Dialog List field containing lookup with @IsError check
5.x: The @IsError function will work because 5.x does not allow more than 64K
of data to be returned.
6.x and 7.x: Triggering the dialog list returns the error: "The specified
database lookup generated more than 65,000 bytes of results, which is too large
for Notes to return in this context.." This is expected given that returning
more than 64K is not an error.
Dialog List field which limits the amount of data returned to less than 64K of
data (for example, @Subset.)
5.x: As 5.x did not allow more than 64K of data to be returned, the following
expected error is returned: "The specified database lookup generated more than
65,000 bytes of results, which is too large for Notes to return in this
context."
6.x and 7.x: The expected data is returned. More >
Last Modified on 12/04/2013
Go back
|