Facebook
From Bulky Bongo, 11 Months ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 94
  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.