- 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
- 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
- Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
- Error Code: 904
- 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
- bind => [5 parameters bound]
- 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")
- 2018-12-21 10:36:05:522 [SEVERE] [Class: com.daimler.proplan.tci.ExceptionInterceptor], L001, Not caught exception
- 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
- Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
- Error Code: 904
- 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
- bind => [5 parameters bound]
- 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")
- at com.ibm.ejs.container.BusinessExceptionMappingStrategy.mapCSIException(BusinessExceptionMappingStrategy.java:152)
- at com.ibm.ejs.container.BusinessExceptionMappingStrategy.mapCSITransactionRolledBackException(BusinessExceptionMappingStrategy.java:613)
- at com.ibm.ejs.container.EJSDeployedSupport.mapCSITransactionRolledBackException(EJSDeployedSupport.java:602)
- at com.ibm.ejs.container.EJSContainer.postInvokeRolledbackException(EJSContainer.java:4382)
- at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4073)
- at com.daimler.proplan.tci.domain.torquechange.EJSLocalNSLTorqueChangeFacade_750236c2.getSimpleTorqueChanges(EJSLocalNSLTorqueChangeFacade_750236c2.java)
- at com.daimler.proplan.tci.torquechange.TorqueChangeResource.getTorqueChanges(TorqueChangeResource.java:82)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
- at java.lang.reflect.Method.invoke(Method.java:508)
- at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652)
- at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:120)
- at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140)
- at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56)
- at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
- at java.lang.reflect.Method.invoke(Method.java:508)
- at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
- at com.daimler.proplan.tci.ExceptionInterceptor.handleException(ExceptionInterceptor.java:28)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
- at java.lang.reflect.Method.invoke(Method.java:508)
- at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
- at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
- at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58)
- at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
- at java.lang.reflect.Method.invoke(Method.java:508)
- at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273)
- at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215)
- at com.daimler.proplan.tci.torquechange.EJSLocalNSLTorqueChangeResource_da90f492.getTorqueChanges(EJSLocalNSLTorqueChangeResource_da90f492.java)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
- at java.lang.reflect.Method.invoke(Method.java:508)
- at com.ibm.ws.jaxrs20.ejb.JaxRsFactoryBeanEJBCustomizer.serviceInvoke(JaxRsFactoryBeanEJBCustomizer.java:338)
- at com.ibm.ws.jaxrs20.server.LibertyJaxRsServerFactoryBean.performInvocation(LibertyJaxRsServerFactoryBean.java:636)
- at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.performInvocation(LibertyJaxRsInvoker.java:108)
- at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)
- at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:174)
- at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200)
- at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:346)
- at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99)
- at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:61)
- at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:99)
- at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307)
- at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
- at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:256)
- at com.ibm.ws.jaxrs20.endpoint.AbstractJaxRsWebEndpoint.invoke(AbstractJaxRsWebEndpoint.java:140)
- at com.ibm.websphere.jaxrs.server.IBMRestServlet.handleRequest(IBMRestServlet.java:179)
- at com.ibm.websphere.jaxrs.server.IBMRestServlet.doGet(IBMRestServlet.java:145)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
- at com.ibm.websphere.jaxrs.server.IBMRestServlet.service(IBMRestServlet.java:125)
- at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1235)
- at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
- at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
- at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
- at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1124)
- at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:4144)
- at com.ibm.ws.webcontainer.webapp.WebAppImpl.handleRequest(WebAppImpl.java:2208)
- at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
- at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1030)
- at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
- at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:382)
- at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
- at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:532)
- at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:318)
- at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:289)
- at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
- at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
- at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
- at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
- at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
- at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
- at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
- at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
- at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
- at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)
- 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
- Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
- Error Code: 904
- 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
- bind => [5 parameters bound]
- 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")
- at com.ibm.ejs.container.BusinessExceptionMappingStrategy.mapCSIException(BusinessExceptionMappingStrategy.java:152)
- at com.ibm.ejs.container.BusinessExceptionMappingStrategy.mapCSITransactionRolledBackException(BusinessExceptionMappingStrategy.java:613)
- at com.ibm.ejs.container.EJSDeployedSupport.mapCSITransactionRolledBackException(EJSDeployedSupport.java:602)
- at com.ibm.ejs.container.EJSContainer.postInvokeRolledbackException(EJSContainer.java:4382)
- at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4073)
- at com.daimler.proplan.tci.domain.torquechange.EJSLocalNSLTorqueChangeDao_211759df.getTorqueChanges(EJSLocalNSLTorqueChangeDao_211759df.java)
- at com.daimler.proplan.tci.domain.torquechange.TorqueChangeFacade.getSimpleTorqueChanges(TorqueChangeFacade.java:73)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
- at java.lang.reflect.Method.invoke(Method.java:508)
- at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652)
- at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:120)
- at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140)
- at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56)
- at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
- at java.lang.reflect.Method.invoke(Method.java:508)
- at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
- at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
- at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58)
- at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
- at java.lang.reflect.Method.invoke(Method.java:508)
- at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273)
- at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215)
- ... 81 more
- 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
- Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
- Error Code: 904
- 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
- bind => [5 parameters bound]
- 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")
- at com.ibm.ejs.container.util.ExceptionUtil.EJBException(ExceptionUtil.java:503)
- at com.ibm.ejs.container.util.ExceptionUtil.EJBException(ExceptionUtil.java:379)
- at com.ibm.ejs.container.BusinessExceptionMappingStrategy.mapException(BusinessExceptionMappingStrategy.java:376)
- at com.ibm.ejs.container.BusinessExceptionMappingStrategy.setUncheckedException(BusinessExceptionMappingStrategy.java:549)
- at com.ibm.ejs.container.EJSDeployedSupport.setUncheckedLocalException(EJSDeployedSupport.java:470)
- ... 107 more
- Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.WAS-v20170126-3a0c50f): org.eclipse.persistence.exceptions.DatabaseException
- Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
- Error Code: 904
- 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
- bind => [5 parameters bound]
- 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")
- at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:382)
- at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
- at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473)
- at com.daimler.proplan.tci.domain.torquechange.TorqueChangeDao.getTorqueChanges(TorqueChangeDao.java:186)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
- at java.lang.reflect.Method.invoke(Method.java:508)
- at com.ibm.ejs.container.EJSContainer.invokeProceed(EJSContainer.java:5323)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:652)
- at com.ibm.ws.cdi.ejb.impl.InterceptorChain.proceed(InterceptorChain.java:120)
- at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.invokeInterceptors(EJBCDIInterceptorWrapper.java:140)
- at com.ibm.ws.cdi.ejb.impl.EJBCDIInterceptorWrapper.aroundInvoke(EJBCDIInterceptorWrapper.java:56)
- at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
- at java.lang.reflect.Method.invoke(Method.java:508)
- at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
- at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
- at com.ibm.ws.cdi.ejb.impl.WeldSessionBeanInterceptorWrapper.aroundInvoke(WeldSessionBeanInterceptorWrapper.java:58)
- at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
- at java.lang.reflect.Method.invoke(Method.java:508)
- at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:201)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:632)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInterceptor(InvocationContextImpl.java:306)
- at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:273)
- at com.ibm.ejs.container.EJSContainer.invoke(EJSContainer.java:5215)
- ... 107 more
- Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.WAS-v20170126-3a0c50f): org.eclipse.persistence.exceptions.DatabaseException
- Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
- Error Code: 904
- 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
- bind => [5 parameters bound]
- 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")
- at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
- at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684)
- at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
- at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2061)
- at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)
- at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
- at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
- at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
- at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694)
- at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740)
- at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693)
- at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:559)
- at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1175)
- at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911)
- at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1134)
- at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:460)
- at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1222)
- at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2899)
- at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1863)
- at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1845)
- at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1810)
- at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
- ... 133 more
- Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "T2"."PLANNING_SCOPE_ID": invalid identifier
- at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
- at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
- at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
- at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
- at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
- at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
- at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
- at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
- at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
- at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
- at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
- at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
- at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
- at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
- at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1194)
- at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:726)
- at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1009)
- at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
- ... 153 more