1. 2018-12-21 10:36:05:431 [INFO] [Class: com.daimler.proplan.tci.torquechange.TorqueChangeResource], L001, GET TorqueChangeList with br c204, position 0100, raster 240804, plant 054, planningScopeTid 1000006408
2. 2018-12-21 10:36:05:522 [SEVERE] [Class: com.daimler.proplan.tci.ExceptionInterceptor], L001, nested exception is: javax.ejb.EJBException: See nested exception; nested exception is: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.WAS-v20170126-3a0c50f): org.eclipse.persistence.exceptions.DatabaseException
3. Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
4.  
5. Error Code: 904
6. Call: SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO
7.         bind => [5 parameters bound]
8. Query: ReadAllQuery(name="TorqueChange.getTorqueChangesBySearchParams" referenceClass=TorqueChange sql="SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO")
9. 2018-12-21 10:36:05:522 [SEVERE] [Class: com.daimler.proplan.tci.ExceptionInterceptor], L001, Not caught exception
10. javax.ejb.EJBTransactionRolledbackException: nested exception is: javax.ejb.EJBTransactionRolledbackException: nested exception is: javax.ejb.EJBException: See nested exception; nested exception is: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.WAS-v20170126-3a0c50f): org.eclipse.persistence.exceptions.DatabaseException
11. Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
12.  
13. Error Code: 904
14. Call: SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO
15.         bind => [5 parameters bound]
16. Query: ReadAllQuery(name="TorqueChange.getTorqueChangesBySearchParams" referenceClass=TorqueChange sql="SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO")
17.         at com.ibm.ejs.container.BusinessExceptionMappingStrategy.mapCSIException(BusinessExceptionMappingStrategy.java:152)
18.         at com.ibm.ejs.container.BusinessExceptionMappingStrategy.mapCSITransactionRolledBackException(BusinessExceptionMappingStrategy.java:613)
19.         at com.ibm.ejs.container.EJSDeployedSupport.mapCSITransactionRolledBackException(EJSDeployedSupport.java:602)
20.         at com.ibm.ejs.container.EJSContainer.postInvokeRolledbackException(EJSContainer.java:4382)
21.         at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4073)
22.         at com.daimler.proplan.tci.domain.torquechange.EJSLocalNSLTorqueChangeFacade_750236c2.getSimpleTorqueChanges(EJSLocalNSLTorqueChangeFacade_750236c2.java)
23.         at com.daimler.proplan.tci.torquechange.TorqueChangeResource.getTorqueChanges(TorqueChangeResource.java:82)
24.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
25.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
26.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
27.         at java.lang.reflect.Method.invoke(Method.java:508)
28.         at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323)
29.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652)
30.         at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:120)
31.         at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140)
32.         at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56)
33.         at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
34.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
35.         at java.lang.reflect.Method.invoke(Method.java:508)
36.         at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
37.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
38.         at com.daimler.proplan.tci.ExceptionInterceptor.handleException(ExceptionInterceptor.java:28)
39.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
40.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
41.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
42.         at java.lang.reflect.Method.invoke(Method.java:508)
43.         at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
44.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
45.         at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
46.         at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58)
47.         at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)
48.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
49.         at java.lang.reflect.Method.invoke(Method.java:508)
50.         at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
51.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
52.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306)
53.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273)
54.         at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215)
55.         at com.daimler.proplan.tci.torquechange.EJSLocalNSLTorqueChangeResource_da90f492.getTorqueChanges(EJSLocalNSLTorqueChangeResource_da90f492.java)
56.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
57.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
58.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
59.         at java.lang.reflect.Method.invoke(Method.java:508)
60.         at com.ibm.ws.jaxrs20.ejb.JaxRsFactoryBeanEJBCustomizer.serviceInvoke(JaxRsFactoryBeanEJBCustomizer.java:338)
61.         at com.ibm.ws.jaxrs20.server.LibertyJaxRsServerFactoryBean.performInvocation(LibertyJaxRsServerFactoryBean.java:636)
62.         at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.performInvocation(LibertyJaxRsInvoker.java:108)
63.         at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)
64.         at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:174)
65.         at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200)
66.         at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:346)
67.         at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99)
68.         at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:61)
69.         at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:99)
70.         at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307)
71.         at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
72.         at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:256)
73.         at com.ibm.ws.jaxrs20.endpoint.AbstractJaxRsWebEndpoint.invoke(AbstractJaxRsWebEndpoint.java:140)
74.         at com.ibm.websphere.jaxrs.server.IBMRestServlet.handleRequest(IBMRestServlet.java:179)
75.         at com.ibm.websphere.jaxrs.server.IBMRestServlet.doGet(IBMRestServlet.java:145)
76.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
77.         at com.ibm.websphere.jaxrs.server.IBMRestServlet.service(IBMRestServlet.java:125)
78.         at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1235)
79.         at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
80.         at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
81.         at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
82.         at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1124)
83.         at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:4144)
84.         at com.ibm.ws.webcontainer.webapp.WebAppImpl.handleRequest(WebAppImpl.java:2208)
85.         at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
86.         at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1030)
87.         at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
88.         at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:382)
89.         at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
90.         at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:532)
91.         at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:318)
92.         at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:289)
93.         at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
94.         at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
95.         at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
96.         at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
97.         at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
98.         at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
99.         at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
100.         at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
101.         at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
102.         at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)
103. Caused by: javax.ejb.EJBTransactionRolledbackException: nested exception is: javax.ejb.EJBException: See nested exception; nested exception is: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.WAS-v20170126-3a0c50f): org.eclipse.persistence.exceptions.DatabaseException
104. Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
105.  
106. Error Code: 904
107. Call: SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO
108.         bind => [5 parameters bound]
109. Query: ReadAllQuery(name="TorqueChange.getTorqueChangesBySearchParams" referenceClass=TorqueChange sql="SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO")
110.         at com.ibm.ejs.container.BusinessExceptionMappingStrategy.mapCSIException(BusinessExceptionMappingStrategy.java:152)
111.         at com.ibm.ejs.container.BusinessExceptionMappingStrategy.mapCSITransactionRolledBackException(BusinessExceptionMappingStrategy.java:613)
112.         at com.ibm.ejs.container.EJSDeployedSupport.mapCSITransactionRolledBackException(EJSDeployedSupport.java:602)
113.         at com.ibm.ejs.container.EJSContainer.postInvokeRolledbackException(EJSContainer.java:4382)
114.         at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4073)
115.         at com.daimler.proplan.tci.domain.torquechange.EJSLocalNSLTorqueChangeDao_211759df.getTorqueChanges(EJSLocalNSLTorqueChangeDao_211759df.java)
116.         at com.daimler.proplan.tci.domain.torquechange.TorqueChangeFacade.getSimpleTorqueChanges(TorqueChangeFacade.java:73)
117.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
118.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
119.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
120.         at java.lang.reflect.Method.invoke(Method.java:508)
121.         at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323)
122.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652)
123.         at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:120)
124.         at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140)
125.         at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56)
126.         at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
127.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
128.         at java.lang.reflect.Method.invoke(Method.java:508)
129.         at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
130.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
131.         at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
132.         at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58)
133.         at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)
134.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
135.         at java.lang.reflect.Method.invoke(Method.java:508)
136.         at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
137.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
138.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306)
139.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273)
140.         at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215)
141.         ... 81 more
142. Caused by: javax.ejb.EJBException: See nested exception; nested exception is: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.WAS-v20170126-3a0c50f): org.eclipse.persistence.exceptions.DatabaseException
143. Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
144.  
145. Error Code: 904
146. Call: SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO
147.         bind => [5 parameters bound]
148. Query: ReadAllQuery(name="TorqueChange.getTorqueChangesBySearchParams" referenceClass=TorqueChange sql="SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO")
149.         at com.ibm.ejs.container.util.ExceptionUtil.EJBException(ExceptionUtil.java:503)
150.         at com.ibm.ejs.container.util.ExceptionUtil.EJBException(ExceptionUtil.java:379)
151.         at com.ibm.ejs.container.BusinessExceptionMappingStrategy.mapException(BusinessExceptionMappingStrategy.java:376)
152.         at com.ibm.ejs.container.BusinessExceptionMappingStrategy.setUncheckedException(BusinessExceptionMappingStrategy.java:549)
153.         at com.ibm.ejs.container.EJSDeployedSupport.setUncheckedLocalException(EJSDeployedSupport.java:470)
154.         ... 107 more
155. Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.WAS-v20170126-3a0c50f): org.eclipse.persistence.exceptions.DatabaseException
156. Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
157.  
158. Error Code: 904
159. Call: SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO
160.         bind => [5 parameters bound]
161. Query: ReadAllQuery(name="TorqueChange.getTorqueChangesBySearchParams" referenceClass=TorqueChange sql="SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO")
162.         at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:382)
163.         at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
164.         at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473)
165.         at com.daimler.proplan.tci.domain.torquechange.TorqueChangeDao.getTorqueChanges(TorqueChangeDao.java:186)
166.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
167.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
168.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
169.         at java.lang.reflect.Method.invoke(Method.java:508)
170.         at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323)
171.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652)
172.         at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:120)
173.         at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140)
174.         at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56)
175.         at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
176.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
177.         at java.lang.reflect.Method.invoke(Method.java:508)
178.         at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
179.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
180.         at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
181.         at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58)
182.         at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)
183.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
184.         at java.lang.reflect.Method.invoke(Method.java:508)
185.         at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
186.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
187.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306)
188.         at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273)
189.         at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215)
190.         ... 107 more
191. Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.WAS-v20170126-3a0c50f): org.eclipse.persistence.exceptions.DatabaseException
192. Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
193.  
194. Error Code: 904
195. Call: SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO
196.         bind => [5 parameters bound]
197. Query: ReadAllQuery(name="TorqueChange.getTorqueChangesBySearchParams" referenceClass=TorqueChange sql="SELECT t1.ID, t1.AA, t1.BR, t1.CLASSIFICATION, t1.CREATED_BY, t1.EMERGENCYSTRATEGY, t1.LOCKED_AT, t1.LOCKED_BY, t1.MODIFIED_AT, t1.MODIFIED_BY, t1.MODIFIEDQSTORQUEAT, t1.PARTNAME, t1.PARTNUMBER, t1.POS_V, t1.POSITION, t1.PRODUCTION_LINE, t1.QUANTITY, t1.RASTER, t1.READYFORQSTORQUE, t1.READYFORQSTORQUEDATE, t1.TCI_VERSION, t1.TORQUELOWERLIMITDEGREE, t1.TORQUELOWERLIMITNM, t1.TORQUENOMINALDEGREE, t1.TORQUENOMINALNM, t1.TORQUESPEED, t1.TORQUETEXT, t1.TORQUEUPPERLIMITDEGREE, t1.TORQUEUPPERLIMITNM, t1.VERSION, t1.VWTEXT, t1.PS_AVO_ID, t1.STAGE_ID, t1.STATUS_ID, t0.ID, t0.SHORT_NAME, t0.SORT_ORDER, t2.ID, t2.COST_CENTER, t2.COST_CENTER_TID, t2.MODIFIED_AT, t2.MODIFIED_BY, t2.NAME, t2.NOTE, t2.PLAN_NO, t2.PLANNER_USERID, t2.SHOPFLOOR_TEAM, t2.SHOPFLOOR_TEAM_TID, t2.TYPE, t2.VALID_FROM, t2.VALID_UNTIL, t2.VERSION, t2.PLANNING_SCOPE_ID, t2.PS_WORKPLACE_ID FROM S52R_TORQUE_CHANGE t1 LEFT OUTER JOIN S52R_PS_AVO t2 ON (t2.ID = t1.PS_AVO_ID) LEFT OUTER JOIN S52R_PLANNING_SCOPE t4 ON (t4.ID = t2.PLANNING_SCOPE_ID) LEFT OUTER JOIN S52R_TORQUE_CHANGE_STATUS t0 ON (t0.ID = t1.STATUS_ID), S52R_PS_PLANT t3 WHERE ((((((UPPER(t1.BR) = ?) AND (UPPER(t1.POSITION) = ?)) AND (UPPER(t1.RASTER) = ?)) AND (UPPER(t3.PLANT_NO) = ?)) AND (UPPER(t4.TID) = ?)) AND (t3.ID = t4.PS_PLANT_ID)) ORDER BY t3.PLANT_NO, t4.TID, t1.PRODUCTION_LINE, t2.PLAN_NO")
198.         at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
199.         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684)
200.         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
201.         at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2061)
202.         at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)
203.         at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
204.         at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
205.         at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
206.         at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694)
207.         at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740)
208.         at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693)
209.         at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:559)
210.         at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1175)
211.         at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911)
212.         at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1134)
213.         at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:460)
214.         at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1222)
215.         at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2899)
216.         at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1863)
217.         at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845)
218.         at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1810)
219.         at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
220.         ... 133 more
221. Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
222.  
223.         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
224.         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
225.         at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
226.         at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
227.         at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
228.         at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
229.         at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
230.         at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
231.         at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
232.         at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
233.         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
234.         at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
235.         at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
236.         at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
237.         at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1194)
238.         at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:726)
239.         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1009)
240.         at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
241.         ... 153 more
242.  
243.