Integration

Hi,
We have existing env running with WebSphere, Oracle, Toplink without any issues.

Dev have upgraded EclipseLink to EclipseLink 2.3.2 version and during test, we found following exceptions and our transactions are failing.

We see following exceptions in WebSphere.

Any suggestions ??

#####################
] FFDC Exception:javax.persistence.PersistenceException SourceId:com.ibm.ejs.container.LocalExceptionMappingStrategy.setUncheckedException ProbeId:178 Reporter:com.ibm.ejs.container.LocalExceptionMappingStrategy@3fddaf9a
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.Error Code: 0
Call: UPDATE REQUEST_JOBS SET LAST_UPDATED_BY = 'PMSInterface', LAST_UPDATED_WHEN = to_timestamp('2013-04-15 09:23:06.964','yyyy-mm-dd HH24:MI:SS.FF'), VERSION_NUMBER = 43 WHERE ((REQUEST_ID = 1111111) AND (VERSION_NUMBER = 42))
Query: UpdateObjectQuery(ID: 1111111)
at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:786)
at com.saic.ct.sys.persistence.common.UnitOfWorkHolder.executeQueryHelperBodyAudited(UnitOfWorkHolder.java:798)
at com.saic.ct.sys.persistence.common.UnitOfWorkHolder.executeQueryHelperBody(UnitOfWorkHolder.java:781)
at com.saic.ct.sys.persistence.common.UnitOfWorkHolder.access$100(UnitOfWorkHolder.java:82)
at com.saic.ct.sys.persistence.common.UnitOfWorkHolder$2.executeWithReturn(UnitOfWorkHolder.java:772)
at com.saic.ct.sys.persistence.common.UnitOfWorkHolder.workaroundConcurrentModificationException(UnitOfWorkHolder.java:424)
at com.saic.ct.sys.persistence.common.UnitOfWorkHolder.executeQueryHelper(UnitOfWorkHolder.java:769)
at com.saic.ct.sys.persistence.common.UnitOfWorkHolder.executeQuery(UnitOfWorkHolder.java:728)
at com.saic.ct.sys.persistence.common.UnitOfWorkHolder.executeQuery(UnitOfWorkHolder.java:758)
at com.saic.ct.sys.persistence.common.UnitOfWorkHolder.executeQuery(UnitOfWorkHolder.java:649)
at com.saic.ct.sys.persistence.common.BaseDAO.executeSelectingCallQuery(BaseDAO.java:1712)
at com.saic.ct.sys.persistence.common.BaseDAO.executeSelectingCallQuery(BaseDAO.java:1681)
at com.saic.ct.sys.persistence.person.PersonDAO.getCurrentEmploymentSummaries(PersonDAO.java:1818)
at com.saic.ct.sys.persistence.person.PersonDAO.findCurrentEmploymentSummaries(PersonDAO.java:1852)
at com.saic.ct.sys.svc.person.CurrentEmploymentSummaryManager.findCurrentEmploymentSummariesBase(CurrentEmploymentSummaryManager.java:465)
at com.saic.ct.sys.svc.person.CurrentEmploymentSummaryManager.findExactDateCurrentEmploymentSummaries(CurrentEmploymentSummaryManager.java:333)
at com.saic.ct.sys.svc.person.CurrentEmploymentSummarySvcEJB.findExactDateCurrentEmploymentSummaries(CurrentEmploymentSummarySvcEJB.java:223)
at com.saic.ct.sys.svc.person.EJSLocalCSLCurrentEmploymentSummarySvcEJB_7634f201.findExactDateCurrentEmploymentSummaries(EJSLocalCSLCurrentEmploymentSummarySvcEJB_7634f201.java)
at com.saic.ct.sys.svc.workflow.WorkflowManager.getCurrentEmploymentSummary(WorkflowManager.java:1658)
at com.saic.ct.sys.svc.workflow.WorkflowManager.getWorkflowConfigModel(WorkflowManager.java:1622)
at com.saic.ct.sys.svc.workflow.WorkflowManager.getWorkflowConfig(WorkflowManager.java:1582)
at com.saic.ct.sys.svc.workflow.WorkflowManager.getWorkflowConfigVal(WorkflowManager.java:395)
at com.saic.ct.sys.svc.workflow.WorkflowManager.processWorkflowRouting(WorkflowManager.java:846)
at com.saic.ct.sys.svc.workflow.WorkflowSvcEJB.processWorkflowRouting(WorkflowSvcEJB.java:313)
at com.saic.ct.sys.svc.workflow.EJSLocalCSLWorkflowSvcEJB_6f2693df.processWorkflowRouting(EJSLocalCSLWorkflowSvcEJB_6f2693df.java)
at com.saic.ct.sys.svc.job.JobSvcEJB.reprocess(JobSvcEJB.java:1105)
at com.saic.ct.sys.svc.job.JobSvcEJB.advanceJobStateAndCreateReprocessingEventIfJobFailed(JobSvcEJB.java:1263)
at com.saic.ct.sys.svc.job.JobSvcEJB.handleExistingPlee(JobSvcEJB.java:1135)
at com.saic.ct.sys.svc.job.JobSvcEJB.processPLTR(JobSvcEJB.java:772)
at com.saic.ct.sys.svc.job.JobSvcEJB.processPLTR(JobSvcEJB.java:736)
at com.saic.ct.sys.svc.job.EJSLocalCSLJobSvcEJB_b617bb57.processPLTR(EJSLocalCSLJobSvcEJB_b617bb57.java)
at com.saic.ct.sys.svc.person.PersonSvcEJB$1.executeForEachItem(PersonSvcEJB.java:1025)
at com.saic.ct.sys.domain.common.PMSCallbackLoop.calledForEachItem(PMSCallbackLoop.java:59)
at com.saic.ct.sys.svc.common.OneTransactionByItem$1.execute(OneTransactionByItem.java:53)
at com.saic.ct.sys.svc.common.LookupSvcEJB.executeInNewTransaction(LookupSvcEJB.java:195)
at com.saic.ct.sys.svc.common.EJSLocalCSLLookupSvcEJB_bf981ab1.executeInNewTransaction(EJSLocalCSLLookupSvcEJB_bf981ab1.java)
at com.saic.ct.sys.svc.common.OneTransactionByItem.executeItem(OneTransactionByItem.java:21)
at com.saic.ct.sys.domain.common.DefaultTransaction.execute(DefaultTransaction.java:46)
at com.saic.ct.sys.svc.common.ManyItemsByTransaction.switchToOneTransactionByItem(ManyItemsByTransaction.java:70)
at com.saic.ct.sys.svc.common.ManyItemsByTransaction.execute(ManyItemsByTransaction.java:45)
at com.saic.ct.sys.svc.common.PMSExecutor.execute(PMSExecutor.java:17)
at com.saic.ct.sys.svc.person.PersonSvcEJB.executeCallBack(PersonSvcEJB.java:5808)
at com.saic.ct.sys.svc.person.PersonSvcEJB.processPMSPerson(PersonSvcEJB.java:1041)
at com.saic.ct.sys.svc.person.PersonSvcEJB.processConsolidatedEmploymentMessage(PersonSvcEJB.java:942)
at com.saic.ct.sys.svc.person.EJSLocalCSLPersonSvcEJB_274c11fa.processConsolidatedEmploymentMessage(EJSLocalCSLPersonSvcEJB_274c11fa.java)
at com.saic.ct.sys.svc.agent.pms.EmploymentDeltaAgent.execute(EmploymentDeltaAgent.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.saic.ct.sys.svc.pms.PmsDataProcessor.invokeAgent(PmsDataProcessor.java:202)
at com.saic.ct.sys.svc.pms.PmsDataProcessor.invokeServiceAgent(PmsDataProcessor.java:131)
at com.saic.ct.sys.svc.pms.PmsDataProcessor.processMessage(PmsDataProcessor.java:94)
at com.saic.ct.sys.svc.pms.EmployeeMDB.processPMSMessage(EmployeeMDB.java:57)
at com.saic.ct.sys.svc.common.PMSMDB.processMessage(PMSMDB.java:56)
at com.saic.ct.sys.svc.common.BaseMDB.onMessage(BaseMDB.java:97)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1093)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:778)
at $Proxy28.onMessage(Unknown Source)
at com.ibm.mq.connector.inbound.MessageEndpointWrapper.onMessage(MessageEndpointWrapper.java:131)
at com.ibm.mq.jms.MQSession$FacadeMessageListener.onMessage(MQSession.java:147)
at com.ibm.msg.client.jms.internal.JmsSessionImpl.run(JmsSessionImpl.java:2846)
at com.ibm.mq.jms.MQSession.run(MQSession.java:862)
at com.ibm.mq.connector.inbound.WorkImpl.run(WorkImpl.java:297)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1613)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
Error Code: 0
Call: UPDATE REQUEST_JOBS SET LAST_UPDATED_BY = 'PMSInterface', LAST_UPDATED_WHEN = to_timestamp('2013-04-15 09:23:06.964','yyyy-mm-dd HH24:MI:SS.FF'), VERSION_NUMBER = 43 WHERE ((REQUEST_ID = 1111111) AND (VERSION_NUMBER = 42))
Query: UpdateObjectQuery(ID: 1111111)



#############

Edited by: 1000360 on Apr 16, 2013 1:43 PM

Edited by: 1000360 on Apr 16, 2013 1:44 PM