PQ59508: IN WEBSPHERE 4.0.2 AES, CHANGING THE STATEMENT CACHE SIZE OF A DATA SOURCE PRODUCES CONFIGURATION ERROR CHKW3019E. | |||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||
APAR status Closed as program error. Error description In Websphere Application Server V4.0.2 AEs, when the statement cache size parameter on a data source is changed to 0 (to disable the prepared statement cache), the admin console will give an alert stating "Configuration problems have been detected." Clicking on the link, the error "CHKW3019E: Conflicting statement cache size of the data source must be specified. [DataSource_1]" is displayed." KEYWORDS: Websphere WAS 4.0 4.0.2 AEs Single Server Edition databaseLocal fix change the statementCacheSize="0" attribute in the DataSource tag in the server-cfg.xmlProblem summary **************************************************************** * USERS AFFECTED: All WebSphere Application Server 4.0 AEs * * users. * **************************************************************** * PROBLEM DESCRIPTION: The Statement Cache Size for a data * * source would not accept the value of * * 0 (zero) as a valid entry. * **************************************************************** * RECOMMENDATION: * **************************************************************** While attempting to modify the Statement Cache Size field for a data source in AEs, the validation would fail when the user entered a 0 (zero) as the value. A zero should be a valid entry. The error message displayed is: CHKW3019E: Conflicting statement cache size of the data source must be specified. DataSource_1Problem conclusion This issue has been resolved and the Statement Cache Size now accepts 0 (zero) as a valid entry. The fix will be available in ptf 4 when and if it is shipped.Temporary fix Comments
APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros
|
Document Information |
Product categories: Software > Application Servers >
Distributed Application & Web Servers > WebSphere Application
Server > General
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ59508
IBM Group: Software Group
Modified date: May 23, 2002
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.