Bugzilla – Full Text Bug Listing
| Summary: | WebSphere specific randomised org.eclipse.persistence.exceptions.JPQLException error on startup | ||
|---|---|---|---|
| Product: | z_Archived | Reporter: | Nathan Drew <nathan.drew> |
| Component: | Eclipselink | Assignee: | Nobody - feel free to take it <nobody> |
| Status: | CLOSED DUPLICATE | QA Contact: | |
| Severity: | critical | ||
| Priority: | P2 | CC: | eclipselink.orm-inbox, tom.ware |
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Linux | ||
| Whiteboard: | |||
As requested on the mailing list, have retried the example with 2.3.1-RC1 as the eclipselink version:
11/1/11 14:52:30:785 UTC] 00000023 SystemOut O [EL Severe]: 2011-11-01 14:52:30.765--ServerSession(1642750442)--Local Exception Stack:
Exception [EclipseLink-8030] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Error compiling the query [InstrumentProductAudit.findSummaryAuditByMainKey: SELECT NEW biz.wss.interfaces.entities.foureyes.auditmaker.SummaryRow( a.auditId.auditDateTime, a.auditFields.state, a.auditId.id, a.statusField.status, a.auditFields.auditUser, a.auditId.id, i.description ) FROM InstrumentProductAudit a, InstrumentClass i WHERE a.auditId.id = :id and i.sequenceNum = a.sequenceNum and a.auditId.auditDateTime between :start and :end ORDER BY a.auditId.auditDateTime DESC], line 1, column 99: unknown state or association field [auditFields] of class [biz.wss.interfaces.entities.credit.instrumentclass.foureyes.InstrumentProductAudit].
at org.eclipse.persistence.exceptions.JPQLException.unknownAttribute(JPQLException.java:457)
at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:87)
at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:72)
at org.eclipse.persistence.internal.jpa.parsing.ConstructorNode.validate(ConstructorNode.java:73)
at org.eclipse.persistence.internal.jpa.parsing.SelectNode.validate(SelectNode.java:293)
at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:201)
at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:183)
at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:173)
at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateReadQueryInternal(JPQLParseTree.java:110)
at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateQuery(JPQLParseTree.java:84)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:219)
at org.eclipse.persistence.internal.jpa.JPAQuery.processJPQLQuery(JPAQuery.java:106)
at org.eclipse.persistence.internal.jpa.JPAQuery.prepare(JPAQuery.java:90)
at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:613)
at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:575)
at org.eclipse.persistence.internal.sessions.AbstractSession.processJPAQueries(AbstractSession.java:2161)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:442)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:676)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:621)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206)
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:279)
at com.ibm.ws.jpa.management.JPAEMPool.getEntityManager(JPAEMPool.java:140)
at com.ibm.ws.jpa.management.JPATxEntityManager.getEMInvocationInfo(JPATxEntityManager.java:235)
at com.ibm.ws.jpa.management.JPAEntityManager.createNamedQuery(JPAEntityManager.java:302)
at biz.wss.jpa.DbType.createNamedQuery(DbType.java:62)
at biz.wss.server.services.local.dao.readers.wss.ParameterDaoEjb.readParameter(ParameterDaoEjb.java:131)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586)
at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217)
at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766)
at biz.wss.server.services.local.dao.readers.wss.EJSLocal0SLParameterDaoEjb_0aa63f49.readParameter(EJSLocal0SLParameterDaoEjb_0aa63f49.java)
at biz.wss.server.services.local.fx.pricing.fotinfo.FotDAOEJB.getConfig(FotDAOEJB.java:70)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586)
at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217)
at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766)
at biz.wss.interfaces.services.fx.pricing.fotinfo.EJSLocal0SLFotDAOEJB_73eeba3d.getConfig(EJSLocal0SLFotDAOEJB_73eeba3d.java)
at biz.wss.server.services.local.fx.pricing.fotinfo.FotRepository.initialise(FotRepository.java:72)
at biz.wss.server.services.local.fx.pricing.fotinfo.FotInitialiser.start(FotInitialiser.java:80)
at biz.wss.server.services.local.fx.pricing.fotinfo.FotInitialiser.onMessage(FotInitialiser.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586)
at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1080)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:778)
at $Proxy42.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:233)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:900)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:552)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)
[11/1/11 14:52:30:789 UTC] 00000023 BusinessExcep E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "readParameter" on bean "BeanId(Bedrock-EAR#Bedrock.server.services.local.jar#ParameterDaoEjb, null)". Exception data: javax.persistence.PersistenceException: Exception [EclipseLink-8030] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Error compiling the query [InstrumentProductAudit.findSummaryAuditByMainKey: SELECT NEW biz.wss.interfaces.entities.foureyes.auditmaker.SummaryRow( a.auditId.auditDateTime, a.auditFields.state, a.auditId.id, a.statusField.status, a.auditFields.auditUser, a.auditId.id, i.description ) FROM InstrumentProductAudit a, InstrumentClass i WHERE a.auditId.id = :id and i.sequenceNum = a.sequenceNum and a.auditId.auditDateTime between :start and :end ORDER BY a.auditId.auditDateTime DESC], line 1, column 99: unknown state or association field [auditFields] of class [biz.wss.interfaces.entities.credit.instrumentclass.foureyes.InstrumentProductAudit].
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:517)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:279)
at com.ibm.ws.jpa.management.JPAEMPool.getEntityManager(JPAEMPool.java:140)
at com.ibm.ws.jpa.management.JPATxEntityManager.getEMInvocationInfo(JPATxEntityManager.java:235)
at com.ibm.ws.jpa.management.JPAEntityManager.createNamedQuery(JPAEntityManager.java:302)
at biz.wss.jpa.DbType.createNamedQuery(DbType.java:62)
at biz.wss.server.services.local.dao.readers.wss.ParameterDaoEjb.readParameter(ParameterDaoEjb.java:131)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586)
at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217)
at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766)
at biz.wss.server.services.local.dao.readers.wss.EJSLocal0SLParameterDaoEjb_0aa63f49.readParameter(EJSLocal0SLParameterDaoEjb_0aa63f49.java)
at biz.wss.server.services.local.fx.pricing.fotinfo.FotDAOEJB.getConfig(FotDAOEJB.java:70)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586)
at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217)
at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766)
at biz.wss.interfaces.services.fx.pricing.fotinfo.EJSLocal0SLFotDAOEJB_73eeba3d.getConfig(EJSLocal0SLFotDAOEJB_73eeba3d.java)
at biz.wss.server.services.local.fx.pricing.fotinfo.FotRepository.initialise(FotRepository.java:72)
at biz.wss.server.services.local.fx.pricing.fotinfo.FotInitialiser.start(FotInitialiser.java:80)
at biz.wss.server.services.local.fx.pricing.fotinfo.FotInitialiser.onMessage(FotInitialiser.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586)
at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1080)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:778)
at $Proxy42.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:233)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:900)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:552)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)
Caused by: Exception [EclipseLink-8030] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Error compiling the query [InstrumentProductAudit.findSummaryAuditByMainKey: SELECT NEW biz.wss.interfaces.entities.foureyes.auditmaker.SummaryRow( a.auditId.auditDateTime, a.auditFields.state, a.auditId.id, a.statusField.status, a.auditFields.auditUser, a.auditId.id, i.description ) FROM InstrumentProductAudit a, InstrumentClass i WHERE a.auditId.id = :id and i.sequenceNum = a.sequenceNum and a.auditId.auditDateTime between :start and :end ORDER BY a.auditId.auditDateTime DESC], line 1, column 99: unknown state or association field [auditFields] of class [biz.wss.interfaces.entities.credit.instrumentclass.foureyes.InstrumentProductAudit].
at org.eclipse.persistence.exceptions.JPQLException.unknownAttribute(JPQLException.java:457)
at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:87)
at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:72)
at org.eclipse.persistence.internal.jpa.parsing.ConstructorNode.validate(ConstructorNode.java:73)
at org.eclipse.persistence.internal.jpa.parsing.SelectNode.validate(SelectNode.java:293)
at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:201)
at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:183)
at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:173)
at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateReadQueryInternal(JPQLParseTree.java:110)
at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateQuery(JPQLParseTree.java:84)
at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:219)
at org.eclipse.persistence.internal.jpa.JPAQuery.processJPQLQuery(JPAQuery.java:106)
at org.eclipse.persistence.internal.jpa.JPAQuery.prepare(JPAQuery.java:90)
at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:613)
at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:575)
at org.eclipse.persistence.internal.sessions.AbstractSession.processJPAQueries(AbstractSession.java:2161)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:442)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:676)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:621)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206)
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488)
... 67 more
[11/1/11 14:52:30:880 UTC] 00000023 DMAdapter I com.ibm.ws.ffdc.impl.DMAdapter getAnalysisEngine FFDC1009I: Analysis Engine using data base: /rndvm/java/profiles/AppSrvRNDVM/properties/logbr/ffdc/adv/ffdcdb.xml
[11/1/11 14:52:32:085 UTC] 00000025 BusinessExcep E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "readParameter" on bean "BeanId(Bedrock-EAR#Bedrock.server.services.local.jar#ParameterDaoEjb, null)". Exception data: Local Exception Stack:
Exception [EclipseLink-7092] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.ValidationException
Exception Description: Cannot add a query whose types conflict with an existing query. Query To Be Added: [ReportQuery(name="BookArea.getUnitsInMis" referenceClass=BookArea jpql="SELECT b.areaUnit FROM BookArea b WHERE b.misArea1 = :misUnit OR b.misArea2 = :misUnit OR b.misArea3 = :misUnit OR b.misArea4 = :misUnit OR b.misArea5 = :misUnit OR b.misArea6 = :misUnit ORDER BY b.areaUnit")] is named: [BookArea.getUnitsInMis] with arguments [[class java.lang.String]].The existing conflicting query: [ReportQuery(name="BookArea.getUnitsInMis" referenceClass=BookArea jpql="SELECT b.areaUnit FROM BookArea b WHERE b.misArea1 = :misUnit OR b.misArea2 = :misUnit OR b.misArea3 = :misUnit OR b.misArea4 = :misUnit OR b.misArea5 = :misUnit OR b.misArea6 = :misUnit ORDER BY b.areaUnit")] is named: [BookArea.getUnitsInMis] with arguments: [[class java.lang.String]].
at org.eclipse.persistence.exceptions.ValidationException.existingQueryTypeConflict(ValidationException.java:914)
at org.eclipse.persistence.internal.sessions.AbstractSession.addQuery(AbstractSession.java:428)
at org.eclipse.persistence.internal.sessions.AbstractSession.addQuery(AbstractSession.java:401)
at org.eclipse.persistence.internal.sessions.AbstractSession.processJPAQueries(AbstractSession.java:2163)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:442)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:676)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:634)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:284)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:279)
at com.ibm.ws.jpa.management.JPAEMPool.getEntityManager(JPAEMPool.java:140)
at com.ibm.ws.jpa.management.JPATxEntityManager.getEMInvocationInfo(JPATxEntityManager.java:235)
at com.ibm.ws.jpa.management.JPAEntityManager.createNamedQuery(JPAEntityManager.java:302)
at biz.wss.jpa.DbType.createNamedQuery(DbType.java:62)
at biz.wss.server.services.local.dao.readers.wss.ParameterDaoEjb.readParameter(ParameterDaoEjb.java:131)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586)
at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161)
at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217)
at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766)
at biz.wss.server.services.local.dao.readers.wss.EJSLocal0SLParameterDaoEjb_0aa63f49.readParameter(EJSLocal0SLParameterDaoEjb_0aa63f49.java)
at biz.wss.server.services.local.api.FXConfigurationDAOEJB.getParameter(FXConfigurationDAOEJB.java:72)
at biz.wss.server.services.local.api.FXConfigurationDAOEJB.getFxQuickDealCodes(FXConfigurationDAOEJB.java:45)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586)
at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217)
at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766)
at biz.wss.server.services.local.api.EJSLocal0SLFXConfigurationDAOEJB_32a3839e.getFxQuickDealCodes(EJSLocal0SLFXConfigurationDAOEJB_32a3839e.java)
at biz.wss.server.services.fx.configuration.FXConfigurationServiceEJB.getQuickDealCodes(FXConfigurationServiceEJB.java:183)
at biz.wss.server.services.fx.configuration.FXConfigurationServiceEJB.getAllQuickDealCodes(FXConfigurationServiceEJB.java:169)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586)
at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566)
at biz.wss.server.services.logging.analysis.ExceptionAnalyzerInterceptor.intercept(ExceptionAnalyzerInterceptor.java:63)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217)
at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766)
at biz.wss.interfaces.services.fx.configuration.EJSLocal0SLFXConfigurationServiceEJB_758a8b2b.getAllQuickDealCodes(EJSLocal0SLFXConfigurationServiceEJB_758a8b2b.java)
at biz.wss.server.services.local.fx.deal.book.QuickDealCodeInitialiser.start(QuickDealCodeInitialiser.java:70)
at biz.wss.server.services.local.fx.deal.book.QuickDealCodeInitialiser.onMessage(QuickDealCodeInitialiser.java:54)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586)
at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566)
at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1080)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:778)
at $Proxy42.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:233)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:900)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:552)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)
Setting target and priority. See the following page for the meanings of these fields: http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines Community: Please vote for this bug if it is important to you. Votes are one of the main criteria we use to determine which bugs to fix next. I have been working on triaging this. I may retarget when the issue is found. *** This bug has been marked as a duplicate of bug 365623 *** The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink |
Build Identifier: 2.3.1-RC1 We develop our application (I've been unable to reproduce in a mock-up application), to run on both GlassFish 2.1.1, WebLogic 10.3.4 and WebSphere Application Server 7.0 (fixpack 17 currently) and have recently switched from TopLink to EclipseLink across all of the above platforms. Both GlassFish and WebLogic don't ever encounter the issue I am about to describe - so after several tests going back through different previous versions of EclipseLink (I've tried 2.2.1, 2.2.1-20110721, 2.1.3, 2.3.1-M6 and 2.3.1-RC1) WAS often starts up with an irrecoverable error coming from EclipseLink. If you restart the application server, or even just the application, you have a chance of getting it to start up successfully. Based on the fact that GlassFish and WebLogic don't have this error with the exact same codebase of our application and the eclipselink release, and that it is sometimes possible to cleanly start up without error with WebSphere, we've come to the conclusion that it is most likely an EclipseLink-WebSphere compatibility issue. During a failed startup scenario, after the application has started we see a single JPQL exception regarding a different query each time, followed by many of "org.eclipse.persistence.exceptions.ValidationException Exception Description: Cannot add a query whose types conflict with an existing query.". Having looked into the second exception on the internet and from other bugs that have been raised, it is usually down to an issue with a separate query. Which makes sense in this case as it thinks it has an issue relating to the first JPQL exception, however the queries all appear to be fine (and work ok on GlassFish and WebLogic). As you can see in the 10 startups documented below, this error does not always occur! Example below: Startup 1) [11/1/11 12:16:36:933 UTC] 00000026 SystemOut O [EL Severe]: 2011-11-01 12:16:36.913--ServerSession(217124081)--Local Exception Stack: Exception [EclipseLink-8030] (Eclipse Persistence Services - 2.2.1.v20110721-r9766): org.eclipse.persistence.exceptions.JPQLException Exception Description: Error compiling the query [DataElementGroupAudit.checkPrevAuditsByNaturalKey: SELECT NEW biz.wss.interfaces.entities.foureyes.auditmaker.AuditStateUser(a.auditFields.currentState, a.auditFields.auditUser) FROM DataElementGroupAudit a WHERE a.code = :code ORDER BY a.auditFields.auditDateTime DESC], line 1, column 76: unknown state or association field [auditFields] of class [biz.wss.interfaces.entities.bo.dataelement.group.foureyes.DataElementGroupAudit]. at org.eclipse.persistence.exceptions.JPQLException.unknownAttribute(JPQLException.java:457) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:88) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.ConstructorNode.validate(ConstructorNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.SelectNode.validate(SelectNode.java:293) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:201) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:183) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:173) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateReadQueryInternal(JPQLParseTree.java:110) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateQuery(JPQLParseTree.java:84) at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:216) at org.eclipse.persistence.internal.jpa.JPAQuery.processJPQLQuery(JPAQuery.java:106) at org.eclipse.persistence.internal.jpa.JPAQuery.prepare(JPAQuery.java:90) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:579) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:539) at org.eclipse.persistence.internal.sessions.AbstractSession.processJPAQueries(AbstractSession.java:2173) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:414) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:680) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:628) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:233) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:394) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:185) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:242) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:237) at com.ibm.ws.jpa.management.JPAEMPool.getEntityManager(JPAEMPool.java:140) at com.ibm.ws.jpa.management.JPATxEntityManager.getEMInvocationInfo(JPATxEntityManager.java:235) at com.ibm.ws.jpa.management.JPAEntityManager.createNamedQuery(JPAEntityManager.java:302) at biz.wss.jpa.DbType.createNamedQuery(DbType.java:62) at biz.wss.server.services.local.dao.readers.wss.ParameterDaoEjb.readParameter(ParameterDaoEjb.java:131) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586) at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566) at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217) at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766) at biz.wss.server.services.local.dao.readers.wss.EJSLocal0SLParameterDaoEjb_0aa63f49.readParameter(EJSLocal0SLParameterDaoEjb_0aa63f49.java) at biz.wss.server.services.local.fx.pricing.fotinfo.FotDAOEJB.getConfig(FotDAOEJB.java:70) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586) at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566) at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217) at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766) at biz.wss.interfaces.services.fx.pricing.fotinfo.EJSLocal0SLFotDAOEJB_73eeba3d.getConfig(EJSLocal0SLFotDAOEJB_73eeba3d.java) at biz.wss.server.services.local.fx.pricing.fotinfo.FotRepository.initialise(FotRepository.java:72) at biz.wss.server.services.local.fx.pricing.fotinfo.FotInitialiser.start(FotInitialiser.java:80) at biz.wss.server.services.local.fx.pricing.fotinfo.FotInitialiser.onMessage(FotInitialiser.java:65) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586) at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566) at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217) at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1080) at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:778) at $Proxy42.onMessage(Unknown Source) at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:233) at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:900) at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:552) at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604 [11/1/11 12:16:36:937 UTC] 00000026 BusinessExcep E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "readParameter" on bean "BeanId(Bedrock-EAR#Bedrock.server.services.local.jar#ParameterDaoEjb, null)". Exception data: javax.persistence.PersistenceException: Exception [EclipseLink-8030] (Eclipse Persistence Services - 2.2.1.v20110721-r9766): org.eclipse.persistence.exceptions.JPQLException Exception Description: Error compiling the query [DataElementGroupAudit.checkPrevAuditsByNaturalKey: SELECT NEW biz.wss.interfaces.entities.foureyes.auditmaker.AuditStateUser(a.auditFields.currentState, a.auditFields.auditUser) FROM DataElementGroupAudit a WHERE a.code = :code ORDER BY a.auditFields.auditDateTime DESC], line 1, column 76: unknown state or association field [auditFields] of class [biz.wss.interfaces.entities.bo.dataelement.group.foureyes.DataElementGroupAudit]. at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:422) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:185) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:242) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:237) at com.ibm.ws.jpa.management.JPAEMPool.getEntityManager(JPAEMPool.java:140) at com.ibm.ws.jpa.management.JPATxEntityManager.getEMInvocationInfo(JPATxEntityManager.java:235) at com.ibm.ws.jpa.management.JPAEntityManager.createNamedQuery(JPAEntityManager.java:302) at biz.wss.jpa.DbType.createNamedQuery(DbType.java:62) at biz.wss.server.services.local.dao.readers.wss.ParameterDaoEjb.readParameter(ParameterDaoEjb.java:131) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586) at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566) at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217) at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766) at biz.wss.server.services.local.dao.readers.wss.EJSLocal0SLParameterDaoEjb_0aa63f49.readParameter(EJSLocal0SLParameterDaoEjb_0aa63f49.java) at biz.wss.server.services.local.fx.pricing.fotinfo.FotDAOEJB.getConfig(FotDAOEJB.java:70) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586) at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566) at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217) at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766) at biz.wss.interfaces.services.fx.pricing.fotinfo.EJSLocal0SLFotDAOEJB_73eeba3d.getConfig(EJSLocal0SLFotDAOEJB_73eeba3d.java) at biz.wss.server.services.local.fx.pricing.fotinfo.FotRepository.initialise(FotRepository.java:72) at biz.wss.server.services.local.fx.pricing.fotinfo.FotInitialiser.start(FotInitialiser.java:80) at biz.wss.server.services.local.fx.pricing.fotinfo.FotInitialiser.onMessage(FotInitialiser.java:65) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586) at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566) at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217) at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1080) at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:778) at $Proxy42.onMessage(Unknown Source) at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:233) at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:900) at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:552) at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604) Caused by: Exception [EclipseLink-8030] (Eclipse Persistence Services - 2.2.1.v20110721-r9766): org.eclipse.persistence.exceptions.JPQLException Exception Description: Error compiling the query [DataElementGroupAudit.checkPrevAuditsByNaturalKey: SELECT NEW biz.wss.interfaces.entities.foureyes.auditmaker.AuditStateUser(a.auditFields.currentState, a.auditFields.auditUser) FROM DataElementGroupAudit a WHERE a.code = :code ORDER BY a.auditFields.auditDateTime DESC], line 1, column 76: unknown state or association field [auditFields] of class [biz.wss.interfaces.entities.bo.dataelement.group.foureyes.DataElementGroupAudit]. at org.eclipse.persistence.exceptions.JPQLException.unknownAttribute(JPQLException.java:457) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:88) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.ConstructorNode.validate(ConstructorNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.SelectNode.validate(SelectNode.java:293) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:201) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:183) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:173) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateReadQueryInternal(JPQLParseTree.java:110) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateQuery(JPQLParseTree.java:84) at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:216) at org.eclipse.persistence.internal.jpa.JPAQuery.processJPQLQuery(JPAQuery.java:106) at org.eclipse.persistence.internal.jpa.JPAQuery.prepare(JPAQuery.java:90) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:579) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:539) at org.eclipse.persistence.internal.sessions.AbstractSession.processJPAQueries(AbstractSession.java:2173) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:414) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:680) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:628) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:233) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:394) ... 66 more [11/1/11 12:16:37:008 UTC] 00000026 DMAdapter I com.ibm.ws.ffdc.impl.DMAdapter getAnalysisEngine FFDC1009I: Analysis Engine using data base: /rndvm/java/profiles/AppSrvRNDVM/properties/logbr/ffdc/adv/ffdcdb.xml [11/1/11 12:16:39:030 UTC] 0000002c BusinessExcep E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "refresh" on bean "BeanId(Bedrock-EAR#Bedrock.server.services.local.jar#TimerSchedulerEJB, null)". Exception data: Local Exception Stack: Exception [EclipseLink-7092] (Eclipse Persistence Services - 2.2.1.v20110721-r9766): org.eclipse.persistence.exceptions.ValidationException Exception Description: Cannot add a query whose types conflict with an existing query. Query To Be Added: [ReportQuery(name="BookArea.getUnitsInMis" referenceClass=BookArea jpql="SELECT b.areaUnit FROM BookArea b WHERE b.misArea1 = :misUnit OR b.misArea2 = :misUnit OR b.misArea3 = :misUnit OR b.misArea4 = :misUnit OR b.misArea5 = :misUnit OR b.misArea6 = :misUnit ORDER BY b.areaUnit")] is named: [BookArea.getUnitsInMis] with arguments [[class java.lang.String]].The existing conflicting query: [ReportQuery(name="BookArea.getUnitsInMis" referenceClass=BookArea jpql="SELECT b.areaUnit FROM BookArea b WHERE b.misArea1 = :misUnit OR b.misArea2 = :misUnit OR b.misArea3 = :misUnit OR b.misArea4 = :misUnit OR b.misArea5 = :misUnit OR b.misArea6 = :misUnit ORDER BY b.areaUnit")] is named: [BookArea.getUnitsInMis] with arguments: [[class java.lang.String]]. at org.eclipse.persistence.exceptions.ValidationException.existingQueryTypeConflict(ValidationException.java:891) at org.eclipse.persistence.internal.sessions.AbstractSession.addQuery(AbstractSession.java:422) at org.eclipse.persistence.internal.sessions.AbstractSession.addQuery(AbstractSession.java:395) at org.eclipse.persistence.internal.sessions.AbstractSession.processJPAQueries(AbstractSession.java:2175) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:414) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:680) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:641) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:249) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:237) at com.ibm.ws.jpa.management.JPAEMPool.getEntityManager(JPAEMPool.java:140) at com.ibm.ws.jpa.management.JPATxEntityManager.getEMInvocationInfo(JPATxEntityManager.java:235) at com.ibm.ws.jpa.management.JPAEntityManager.createNamedQuery(JPAEntityManager.java:302) at biz.wss.server.services.local.scheduler.TimerSchedulerEJB.findAllActiveSchedules(TimerSchedulerEJB.java:864) at biz.wss.server.services.local.scheduler.TimerSchedulerEJB.refresh(TimerSchedulerEJB.java:787) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586) at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161) at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566) at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217) at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766) at biz.wss.interfaces.services.scheduler.EJSLocal0SLTimerSchedulerEJB_299ec695.refresh(EJSLocal0SLTimerSchedulerEJB_299ec695.java) at biz.wss.server.services.local.scheduler.TimerSchedulerInitialiser.start(TimerSchedulerInitialiser.java:123) at biz.wss.server.services.local.scheduler.TimerSchedulerInitialiser.onMessage(TimerSchedulerInitialiser.java:94) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586) at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161) at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566) at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217) at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1080) at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:778) at $Proxy42.onMessage(Unknown Source) at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:233) at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:900) at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:552) at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604) The last exception is repeated several times. Then on a separate restart the first error changes: Startup 2) [11/1/11 12:22:18:776 UTC] 00000031 SystemOut O [EL Severe]: 2011-11-01 12:22:18.757--ServerSession(255397689)--Local Exception Stack: Exception [EclipseLink-8030] (Eclipse Persistence Services - 2.2.1.v20110721-r9766): org.eclipse.persistence.exceptions.JPQLException Exception Description: Error compiling the query [CreditLineMaker.findSummaryMaker: SELECT NEW biz.wss.interfaces.entities.foureyes.auditmaker.SummaryRow( a.makerFields.auditDateTime, a.makerFields.state, a.lineId, a.statusField.status, a.makerFields.makerUser) FROM CreditLineMaker a ORDER BY a.makerFields.auditDateTime], line 1, column 134: unknown state or association field [statusField] of class [biz.wss.interfaces.entities.credit.lines.foureyes.CreditLineMaker]. at org.eclipse.persistence.exceptions.JPQLException.unknownAttribute(JPQLException.java:457) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:88) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.ConstructorNode.validate(ConstructorNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.SelectNode.validate(SelectNode.java:293) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:201) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:183) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:173) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateReadQueryInternal(JPQLParseTree.java:110) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateQuery(JPQLParseTree.java:84) at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:216) at org.eclipse.persistence.internal.jpa.JPAQuery.processJPQLQuery(JPAQuery.java:106) at org.eclipse.persistence.internal.jpa.JPAQuery.prepare(JPAQuery.java:90) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:579) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:539) at org.eclipse.persistence.internal.sessions.AbstractSession.processJPAQueries(AbstractSession.java:2173) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:414) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:680) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:628) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:233) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:394) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:185) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:242) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:237) at com.ibm.ws.jpa.management.JPAEMPool.getEntityManager(JPAEMPool.java:140) at com.ibm.ws.jpa.management.JPATxEntityManager.getEMInvocationInfo(JPATxEntityManager.java:235) at com.ibm.ws.jpa.management.JPAEntityManager.createNamedQuery(JPAEntityManager.java:302) at biz.wss.jpa.DbType.createNamedQuery(DbType.java:62) at biz.wss.server.services.local.dao.readers.wss.ParameterDaoEjb.readParameter(ParameterDaoEjb.java:131) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586) at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566) at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217) at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766) at biz.wss.server.services.local.dao.readers.wss.EJSLocal0SLParameterDaoEjb_0aa63f49.readParameter(EJSLocal0SLParameterDaoEjb_0aa63f49.java) at biz.wss.server.services.local.fx.pricing.fotinfo.FotDAOEJB.getConfig(FotDAOEJB.java:70) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586) at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566) at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217) at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5766) at biz.wss.interfaces.services.fx.pricing.fotinfo.EJSLocal0SLFotDAOEJB_73eeba3d.getConfig(EJSLocal0SLFotDAOEJB_73eeba3d.java) at biz.wss.server.services.local.fx.pricing.fotinfo.FotRepository.initialise(FotRepository.java:72) at biz.wss.server.services.local.fx.pricing.fotinfo.FotInitialiser.start(FotInitialiser.java:80) at biz.wss.server.services.local.fx.pricing.fotinfo.FotInitialiser.onMessage(FotInitialiser.java:65) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:586) at biz.wss.server.services.logging.analysis.MethodTimerInterceptor.intercept(MethodTimerInterceptor.java:161) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227) at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:566) at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:217) at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1080) at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:778) at $Proxy42.onMessage(Unknown Source) at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:233) at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:900) at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:552) at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604) Startup 3) On the next restart the system started up without this exception and carried on to initialise, however because of the previous bad start up you see unique key constraint violations until it settles back down. If you manage to get two consecutive startups without the above error then you don't see any unique key constraint violations. JPA functional. Startup 4) The next restart happens to succeed. No unique key constraint violations. JPA fully functional. Startup 5) This restart also happens to succeed. Startup 6) This restart also happens to succeed. Startup 7) This restart also happens to succeed. (It appears to be having a good run just because I need to capture error logs!) Startup 8) (I think it was listening to me!) On this restart the first exception is different: [11/1/11 12:41:20:261 UTC] 00000023 SystemOut O [EL Severe]: 2011-11-01 12:41:20.242--ServerSession(1288064198)--Local Exception Stack: Exception [EclipseLink-8030] (Eclipse Persistence Services - 2.2.1.v20110721-r9766): org.eclipse.persistence.exceptions.JPQLException Exception Description: Error compiling the query [CPartyMaker.findSummaryMaker: SELECT NEW biz.wss.interfaces.entities.foureyes.auditmaker.SummaryRow( a.makerFields.auditDateTime, a.makerFields.state, a.custTran, a.statusField.status, a.makerFields.makerUser, a.fullName, a.customerCity, a.countryDomicileId) FROM CPartyMaker a ORDER BY a.makerFields.auditDateTime], line 1, column 136: unknown state or association field [statusField] of class [biz.wss.interfaces.entities.cparty.foureyes.CPartyMaker]. at org.eclipse.persistence.exceptions.JPQLException.unknownAttribute(JPQLException.java:457) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:88) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.ConstructorNode.validate(ConstructorNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.SelectNode.validate(SelectNode.java:293) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:201) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:183) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:173) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateReadQueryInternal(JPQLParseTree.java:110) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateQuery(JPQLParseTree.java:84) at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:216) at org.eclipse.persistence.internal.jpa.JPAQuery.processJPQLQuery(JPAQuery.java:106) at org.eclipse.persistence.internal.jpa.JPAQuery.prepare(JPAQuery.java:90) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:579) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:539) at org.eclipse.persistence.internal.sessions.AbstractSession.processJPAQueries(AbstractSession.java:2173) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:414) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:680) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:628) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:233) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:394) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:185) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:242) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:237) at com.ibm.ws.jpa.management.JPAEMPool.getEntityManager(JPAEMPool.java:140) at com.ibm.ws.jpa.management.JPATxEntityManager.getEMInvocationInfo(JPATxEntityManager.java:235) at com.ibm.ws.jpa.management.JPAEntityManager.createNamedQuery(JPAEntityManager.java:302) at biz.wss.jpa.DbType.createNamedQuery(DbType.java:62) at biz.wss.server.services.local.dao.readers.wss.ParameterDaoEjb.readParameter(ParameterDaoEjb.java:131) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) <snip> Startup 9) After another restart we get another error and it happens to be complaining about the same query as in Startup 8: [11/1/11 12:44:43:461 UTC] 00000026 SystemOut O [EL Severe]: 2011-11-01 12:44:43.443--ServerSession(896284012)--Local Exception Stack: Exception [EclipseLink-8030] (Eclipse Persistence Services - 2.2.1.v20110721-r9766): org.eclipse.persistence.exceptions.JPQLException Exception Description: Error compiling the query [CPartyMaker.findSummaryMaker: SELECT NEW biz.wss.interfaces.entities.foureyes.auditmaker.SummaryRow( a.makerFields.auditDateTime, a.makerFields.state, a.custTran, a.statusField.status, a.makerFields.makerUser, a.fullName, a.customerCity, a.countryDomicileId) FROM CPartyMaker a ORDER BY a.makerFields.auditDateTime], line 1, column 136: unknown state or association field [statusField] of class [biz.wss.interfaces.entities.cparty.foureyes.CPartyMaker]. at org.eclipse.persistence.exceptions.JPQLException.unknownAttribute(JPQLException.java:457) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:88) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.ConstructorNode.validate(ConstructorNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.SelectNode.validate(SelectNode.java:293) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:201) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:183) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:173) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateReadQueryInternal(JPQLParseTree.java:110) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateQuery(JPQLParseTree.java:84) at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:216) at org.eclipse.persistence.internal.jpa.JPAQuery.processJPQLQuery(JPAQuery.java:106) at org.eclipse.persistence.internal.jpa.JPAQuery.prepare(JPAQuery.java:90) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:579) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:539) at org.eclipse.persistence.internal.sessions.AbstractSession.processJPAQueries(AbstractSession.java:2173) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:414) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:680) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:628) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:233) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:394) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:185) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:242) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:237) at com.ibm.ws.jpa.management.JPAEMPool.getEntityManager(JPAEMPool.java:140) at com.ibm.ws.jpa.management.JPATxEntityManager.getEMInvocationInfo(JPATxEntityManager.java:235) at com.ibm.ws.jpa.management.JPAEntityManager.createNamedQuery(JPAEntityManager.java:302) at biz.wss.jpa.DbType.createNamedQuery(DbType.java:62) at biz.wss.server.services.local.dao.readers.wss.ParameterDaoEjb.readParameter(ParameterDaoEjb.java:131) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) <snip> Startup 10) This one also fails but with a different query as the first exception: [11/1/11 12:48:02:776 UTC] 0000002a SystemOut O [EL Severe]: 2011-11-01 12:48:02.755--ServerSession(706488860)--Local Exception Stack: Exception [EclipseLink-8030] (Eclipse Persistence Services - 2.2.1.v20110721-r9766): org.eclipse.persistence.exceptions.JPQLException Exception Description: Error compiling the query [PortfolioGroupAudit.findSummaryAuditByChanger: SELECT NEW biz.wss.interfaces.entities.foureyes.auditmaker.SummaryRow( a.auditId.auditDateTime, a.auditFields.state, a.auditId.id, a.statusField.status, a.auditFields.auditUser, a.auditId.id, a.description) FROM PortfolioGroupAudit a WHERE a.auditId.auditDateTime between :start and :end and a.auditFields.auditUser = :madeBy ORDER BY a.auditId.auditDateTime DESC], line 1, column 134: unknown state or association field [statusField] of class [biz.wss.interfaces.entities.pfolio.foureyes.PortfolioGroupAudit]. at org.eclipse.persistence.exceptions.JPQLException.unknownAttribute(JPQLException.java:457) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:88) at org.eclipse.persistence.internal.jpa.parsing.DotNode.validate(DotNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.ConstructorNode.validate(ConstructorNode.java:73) at org.eclipse.persistence.internal.jpa.parsing.SelectNode.validate(SelectNode.java:293) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:201) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:183) at org.eclipse.persistence.internal.jpa.parsing.ParseTree.validate(ParseTree.java:173) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateReadQueryInternal(JPQLParseTree.java:110) at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateQuery(JPQLParseTree.java:84) at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:216) at org.eclipse.persistence.internal.jpa.JPAQuery.processJPQLQuery(JPAQuery.java:106) at org.eclipse.persistence.internal.jpa.JPAQuery.prepare(JPAQuery.java:90) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:579) at org.eclipse.persistence.queries.DatabaseQuery.checkPrepare(DatabaseQuery.java:539) at org.eclipse.persistence.internal.sessions.AbstractSession.processJPAQueries(AbstractSession.java:2173) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:414) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:680) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:628) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:233) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:394) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:185) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:242) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:237) at com.ibm.ws.jpa.management.JPAEMPool.getEntityManager(JPAEMPool.java:140) at com.ibm.ws.jpa.management.JPATxEntityManager.getEMInvocationInfo(JPATxEntityManager.java:235) at com.ibm.ws.jpa.management.JPAEntityManager.createNamedQuery(JPAEntityManager.java:302) at biz.wss.jpa.DbType.createNamedQuery(DbType.java:62) at biz.wss.server.services.local.dao.readers.wss.ParameterDaoEjb.readParameter(ParameterDaoEjb.java:131) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5874) <snip> Given that we are unable to reproduce with our mock up application, please let me know what other information is needed to help investigate. I have marked this as critical as the software crashes completely when this error occurs. Many Thanks Nathan Reproducible: Sometimes Steps to Reproduce: We have been unable to reproduce in a mock up application.