PK15273: WQRY0041E ON QUERY EVALUATION

APAR status
Closed as program error.

Error description
Customer is getting com.ibm.websphere.ejbquery.QueryException:
WQRY0041E: An exception raised during query evaluation
This occurs on Cloudscape and Oracle databases. The evaluation
of UPPER in memory has a problem.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: Only those users whose EJB query contains    *
*                 an UPPER function and the backend databases  *
*                 are Cloudscape and Oracle.                   *
****************************************************************
* PROBLEM DESCRIPTION: The Customers will see the following    *
*                      exception:                              *
*                      "QueryException: WQRY0041E: An          *
*                      exception raised during query           *
*                      evaluation"                             *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
The evaluation of the UPPER function had a bug
and the query engine was not testing for the
null pointer while traversing the data structure.
Problem conclusion
The logic now checks for the null pointer while
traversing the data structure during the evaluation
of UPPER function. The fix for this was provided as an
IFix.
Temporary fix Comments
APAR information
APAR number PK15273
Reported component name WAS BASE 5.0
Reported component ID 5630A3600
Reported release 00W
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2005-11-15
Closed date 2006-01-25
Last modified date 2006-01-25

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros

Publications Referenced

Fix information
Fixed component name WAS ENTERPRISE
Fixed component ID 5630A3700

Applicable component levels
R003 PSY    UP
R00A PSY    UP
R00H PSY    UP
R00I PSY    UP
R00S PSY    UP
R00W PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Enterprise Edition (EE)
Operating system(s):
Software version: 00W
Software edition:
Reference #: PK15273
IBM Group: Software Group
Modified date: Jan 25, 2006