PQ84215: CAN NOT REMOVE NODE AFTER DB2 FIXPACK UPGRADE | |||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||
APAR status Closed as program error. Error description When removing node from websphere cluster, websphere work load manager invoke the executeQuery method with an SQL statement to perform an update. DB2 versions before Fixpak 6 and later fixpak does not allow the the use of executeQuery. ExecutePreparedUpdate need to be implemented.Local fix NO local fix.Problem summary **************************************************************** * USERS AFFECTED: WebSphere Application Server users of WLM * * or Workload Management. * **************************************************************** * PROBLEM DESCRIPTION: When attempting to remove a node from * * a domain an SQL exception is thrown. * **************************************************************** * RECOMMENDATION: * **************************************************************** When attempting to remove a node from a domain an SQL exception is thrown. The following is an example of the error that occurs when trying to remove a node from a domain. StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode -99,999 and SQL State S1000, to a StaleConnectionException: COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0637E QUERY cannot be found.at COM.ibm.db2.jdbc.app.SQLExceptionGenerator .throwInvalidQueryError(SQLExceptionGenerator.java (Compiled Code)) at COM.ibm.db2.jdbc.app.DB2PreparedStatement .executeQuery(DB2PreparedStatement.java(Compiled Code)) at com.ibm.ejs.cm.cache.CachedStatement .executeQuery(CachedStatement.java(CompiledCode)) at com.ibm.ejs.cm.proxy.StatementProxy .executeQueryCommon(StatementProxy.java(CompiledCode)) at com.ibm.ejs.cm.proxy.PreparedStatementProxy .executeQuery(PreparedStatementProxy.java(CompiledCode)) at com.ibm.ejs.sm.util.db.DBMgr .executePreparedQuery(DBMgr.java(Compiled Code)) at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl .updateTablesOnServerDelete(WLMBootstrapImpl.java:800) at com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl .serverDeleted(WLMBootstrapImpl.java:185) at com.ibm.ejs.sm.beans.NodeBean.ejbRemove(NodeBean.java:549) at com.ibm.ejs.container.EntityBeanO.remove(EntityBeanO.java:887) at com.ibm.ejs.container.EJSContainer .removeBean(EJSContainer.java(CompiledCode)) at com.ibm.ejs.container.EJSWrapper.remove(EJSWrapper.java:330) at com.ibm.ejs.sm.beans._Node_Stub.remove(_Node_Stub.java:225) at com.ibm.ejs.sm.beans.RepositoryObjectImpl ... ...Problem conclusion The wrong SQL statement was being used.Temporary fix There is no temporary fix for this problem.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 #: PQ84215
IBM Group: Software Group
Modified date: Jun 9, 2004
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.