Fixes are available
APAR status
Closed as program error.
Error description
NestedThrowables: <openjpa-2.2.1-SNAPSHOT-r422266:1325904 fatal store error> org.apache.openjpa.util.ReferentialIntegrityException: A truncation error was encountered trying to shrink VARCHAR 'WebSphere:specName=WS_UDDIRuntime;WebSphere:specName=WS_Acti&' to length 256. {prepstmnt -760249216 UPDATE ENDPOINT_PROPS SET VALUE = ? WHERE id = ? [params=?, ?]} [code=20000, state=22001] FailedObject: com.ibm.ws.management.system.smgr.db.model.EndpointProp-32 at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.jav a:4918) at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDic tionary.java:4884) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions .java:136) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions .java:78) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flus hAndUpdate(PreparedStatementManagerImpl.java:143) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerI mpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flus hInternal(PreparedStatementManagerImpl.java:99) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flus h(PreparedStatementManagerImpl.java:87) at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush PrimaryRow(OperationOrderUpdateManager.java:203) at org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush (OperationOrderUpdateManager.java:89) at org.apache.openjpa.jdbc.kernel.BatchingOperationOrderUpdateManag er.flush(BatchingOperationOrderUpdateManager.java:61) at com.ibm.ws.persistence.jdbc.kernel.OperationOrderUpdateManager.f lush(OperationOrderUpdateManager.java:82) at com.ibm.ws.persistence.jdbc.kernel.OperationOrderUpdateManager.f lush(OperationOrderUpdateManager.java:64) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreM anager.java:713) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(Delegatin gStoreManager.java:131) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2174) at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2 072) at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl .java:1990) at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManage dRuntime.java:81) at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1514 ) at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBrok er.java:933) at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityMa nagerImpl.java:570) at com.ibm.ws.management.system.smgr.jpa.services.impl.JobProcessin gHelper.processStatusUpdate(JobProcessingHelper.java:303) at com.ibm.ws.management.system.smgr.jpa.services.impl.JobProcessin gHelper.processJobStatus(JobProcessingHelper.java:239) at com.ibm.ws.management.system.smgr.jpa.services.impl.JobProcessin gHelper.processJobStatus(JobProcessingHelper.java:210) at com.ibm.ws.management.system.smgr.protocolengine.omadm.WASFlexib leMgmtOMADMResults.processResults(WASFlexibleMgmtOMADMResults.ja va:425) at com.ibm.otis.protocolengine.omadm.JavaAPITask.resultsCallback(Ja vaAPITask.java:588) at com.ibm.otis.protocolengine.omadm.JavaAPITask.process(JavaAPITas k.java:516) at com.ibm.otis.protocolengine.omadm.OMADMReqResultsHandler.process (OMADMReqResultsHandler.java:71) at com.ibm.otis.protocolengine.omadm.OMADMDeviceObject.process(OMAD MDeviceObject.java:901) at com.ibm.otis.protocolengine.omadm.OMADMServlet.doPost(OMADMServl et.java:946) at com.ibm.otis.protocolengine.omadm.OMADMServlet.service(OMADMServ let.java:476) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWr apper.java:1214) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(Ser vletWrapper.java:774) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(Ser vletWrapper.java:456) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest (ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters (WebAppFilterManager.java:1027) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleReques t(CacheServletWrapper.java:87) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer. java:895) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContai ner.java:1662) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLin k.java:195) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscr imination(HttpInboundLink.java:458) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRe quest(HttpInboundLink.java:522) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequ est(HttpInboundLink.java:311) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpI nboundLink.java:282) at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.determineNextChann el(SSLConnectionLink.java:1048) at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.readyInboundPostHa ndshake(SSLConnectionLink.java:716) at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.readyInbound(SSLCo nnectionLink.java:570) at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.ready(SSLConnectio nLink.java:294) at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sen dToDiscriminators(NewConnectionInitialReadCallback.java:214) at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.com plete(NewConnectionInitialReadCallback.java:113) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureComp leted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyn cFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncC hannelFuture.java) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHand ler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1783)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of migrated WebSphere * * Application Server V8.5 who make use of * * the Job Manager. * **************************************************************** * PROBLEM DESCRIPTION: After migrating the target node and * * Job Manager node to version 8.5 and * * running an inventory job, the version * * of the target node still shows the * * version from before the migration. * **************************************************************** * RECOMMENDATION: * **************************************************************** After migrating the target node and Job Manager node to version 8.5 and running an inventory job, the version of the target node still shows the version from before the migration. An example of the logged error is: NestedThrowables: <openjpa-2.2.1-SNAPSHOT-r422266:1325904 fatal store error> org.apache.openjpa.util.ReferentialIntegrityException: A truncation error was encountered trying to shrink VARCHAR 'WebSphere:specName=WS_UDDIRuntime;WebSphere:specName=WS_Acti&' to length 256. Unknown macro: {prepstmnt -760249216 UPDATE ENDPOINT_PROPS SET VALUE = ? WHERE id = ? [params=?, ?]} code=20000, state=22001 FailedObject: com.ibm.ws.management.system.smgr.db.model.EndpointProp-32 .................. at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityMa nagerImpl.java:570) at com.ibm.ws.management.system.smgr.jpa.services.impl.JobProcessin gHelper.processStatusUpdate(JobProcessingHelper.java:303) at com.ibm.ws.management.system.smgr.jpa.services.impl.JobProcessin gHelper.processJobStatus(JobProcessingHelper.java:239) at com.ibm.ws.management.system.smgr.jpa.services.impl.JobProcessin gHelper.processJobStatus(JobProcessingHelper.java:210) at com.ibm.ws.management.system.smgr.protocolengine.omadm.WASFlexib leMgmtOMADMResults.processResults(WASFlexibleMgmtOMADMResults.ja va:425)
Problem conclusion
Code is changed to correctly handle the migrated V8.5 environment. The fix for this APAR is currently targeted for inclusion in fixpack 8.5.0.1. Please refer to the recommended updates page for delivery information: http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
Temporary fix
Comments
APAR Information
APAR number
PM63587
Reported component name
WEBS APP SERV N
Reported component ID
5724H8800
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-04-30
Closed date
2012-06-11
Last modified date
2012-06-11
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WEBS APP SERV N
Fixed component ID
5724H8800
Applicable component levels
R850 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
01 November 2021