Untitled - Pastebin

From Bulky Bongo, 11 Months ago, written in Plain Text.

Embed

Download Paste or View Raw
Hits: 94

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

Author

Title

Language

Your paste - Paste your paste here

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")
        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

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

Private - Private paste aren't shown in recent listings.

Delete After - When should we delete your paste?

Spam protection -

Reply to "Untitled"