Jump to content
Changes to the Jaspersoft community edition download ×

JasperServer "exception getting dataset from cache"


sheav

Recommended Posts

Can anyone assist with this error?:

Error Message

exception getting dataset from cache

Error Trace

java.lang.RuntimeException: exception getting dataset from cache at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:145) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:81) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1352) at com.jaspersoft.ji.adhoc.strategy.CompiledDomainQuery.getWorkingDataSet(CompiledDomainQuery.java:93) at com.jaspersoft.ji.adhoc.InteractiveDataLayoutEngine.initWorkingDataSet(InteractiveDataLayoutEngine.java:339) at com.jaspersoft.ji.adhoc.InteractiveCrosstabEngine.initWorkingDataSet(InteractiveCrosstabEngine.java:872) at com.jaspersoft.ji.adhoc.InteractiveCrosstabBaseEngine$DimensionDataSetInitializer.initDimensionDataSet(InteractiveCrosstabBaseEngine.java:125) at com.jaspersoft.ji.adhoc.InteractiveCrosstabBaseEngine$DimensionDataSetInitializer.init(InteractiveCrosstabBaseEngine.java:94) at com.jaspersoft.ji.adhoc.InteractiveCrosstabEngine.generateViewModel(InteractiveCrosstabEngine.java:137) at com.jaspersoft.ji.adhoc.action.AdhocAction.setReportModelInContext(AdhocAction.java:1561) at com.jaspersoft.ji.adhoc.action.AdhocAction.view(AdhocAction.java:632) at com.jaspersoft.ji.adhoc.action.AdhocAction.initForQueryBuilder(AdhocAction.java:534) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:77) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:393) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) at org.springframework.webflow.engine.SubflowState.handleEvent(SubflowState.java:116) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:388) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.impl.FlowExecutionImpl.endActiveFlowSession(FlowExecutionImpl.java:412) at org.springframework.webflow.engine.impl.RequestControlContextImpl.endActiveFlowSession(RequestControlContextImpl.java:238) at org.springframework.webflow.engine.EndState.doEnter(EndState.java:107) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:393) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:388) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:232) at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) at org.springframework.webflow.engine.Flow.resume(Flow.java:545) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:261) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:169) at sun.reflect.GeneratedMethodAccessor421.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy138.resumeExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:844) at javax.servlet.http.HttpServlet.service(HttpServlet.java:624) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.owasp.csrfguard.CsrfGuardFilter.doFilter(CsrfGuardFilter.java:88) at com.jaspersoft.jasperserver.api.security.csrf.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:72) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.api.security.csrf.CrossDomainCommunicationFilter.doFilter(CrossDomainCommunicationFilter.java:116) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.ji.jaxrs.diagnostic.DiagnosticLoggingFilterPRO.doFilter(DiagnosticLoggingFilterPRO.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.common.JSSwitchUserProcessingFilter.doFilter(JSSwitchUserProcessingFilter.java:157) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:143) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:99) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:194) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:235) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:103) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:86) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:235) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:57) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:95) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilter(ResourceHTTPHeadersFilter.java:77) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:614) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1082) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:623) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching from cache at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:287) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:108) ... 183 more Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching data at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:252) at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:283) ... 184 more Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select "PUB_container"."box_code" as "PUB_container_box_code", "PUB_container"."box_en_week" as "PUB_container_box_en_week", "PUB_container"."box_st_week" as "PUB_container_box_st_week", "PUB_container"."cc_code" as "PUB_container_cc_code", "PUB_container"."con_area" as "PUB_container_con_area", "PUB_container"."con_code" as "PUB_container_con_code", "PUB_container"."con_desc" as "PUB_container_con_desc", "PUB_container"."con_factor" as "PUB_container_con_factor", "PUB_container"."con_filler1" as "PUB_container_con_filler1", "PUB_container"."con_filler2" as "PUB_container_con_filler2", "PUB_container"."con_g_units" as "PUB_container_con_g_units", "PUB_container"."con_group" as "PUB_container_con_group", "PUB_container"."con_lit" as "PUB_container_con_lit", "PUB_container"."con_organic" as "PUB_container_con_organic", "PUB_container"."con_per_box" as "PUB_container_con_per_box", "PUB_container"."con_per_layer" as "PUB_container_con_per_layer", "PUB_container"."con_per_rack" as "PUB_container_con_per_rack", "PUB_container"."con_s_units" as "PUB_container_con_s_units", "PUB_container"."con_status" as "PUB_container_con_status", "PUB_container"."con_vol" as "PUB_container_con_vol", "PUB_container"."con_weight" as "PUB_container_con_weight", "PUB_container"."dc_field" as "PUB_container_dc_field", "PUB_container"."labels_per_container" as "PUB_container_labels_per_contain", "PUB_container"."plants_per_row" as "PUB_container_plants_per_row", "PUB_container"."print_both_sides" as "PUB_container_print_both_sides", "PUB_container"."tag_qty" as "PUB_container_tag_qty", "PUB_container"."unique_id" as "PUB_container_unique_id", "PUB_container"."units_per_tray" as "PUB_container_units_per_tray", "PUB_container"."weight_and_measures" as "PUB_container_weight_and_measure", "PUB_customer"."ar_cust_no" as "PUB_customer_ar_cust_no", "PUB_customer"."bol_default_sort" as "PUB_customer_bol_default_sort", "PUB_customer"."bol_show_barcode" as "PUB_customer_bol_show_barcode", "PUB_customer"."bol_show_pricing" as "PUB_customer_bol_show_pricing", "PUB_customer"."contact_code" as "PUB_customer_contact_code", "PUB_customer"."cur_code" as "PUB_customer_cur_code", "PUB_customer"."cust_added" as "PUB_customer_cust_added", "PUB_customer"."cust_address1" as "PUB_customer_cust_address1", "PUB_customer"."cust_address2" as "PUB_customer_cust_address2", "PUB_customer"."cust_b2b_company" as "PUB_customer_cust_b2b_company", "PUB_customer"."cust_balance" as "PUB_customer_cust_balance", "PUB_customer"."cust_cell" as "PUB_customer_cust_cell", "PUB_customer"."cust_city" as "PUB_customer_cust_city", "PUB_customer"."cust_cntry" as "PUB_customer_cust_cntry", "PUB_customer"."cust_consignment" as "PUB_customer_cust_consignment", "PUB_customer"."cust_credit_account" as "PUB_customer_cust_credit_account", "PUB_customer"."cust_def_frt" as "PUB_customer_cust_def_frt", "PUB_customer"."cust_default_inv" as "PUB_customer_cust_default_inv", "PUB_customer"."cust_default_ship" as "PUB_customer_cust_default_ship", "PUB_customer"."cust_disc" as "PUB_customer_cust_disc", "PUB_customer"."cust_email" as "PUB_customer_cust_email", "PUB_customer"."cust_fax" as "PUB_customer_cust_fax", "PUB_customer"."cust_filler1" as "PUB_customer_cust_filler1", "PUB_customer"."cust_finance" as "PUB_customer_cust_finance", "PUB_customer"."cust_finance_override" as "PUB_customer_cust_finance_overri", "PUB_customer"."cust_last_act" as "PUB_customer_cust_last_act", "PUB_customer"."cust_limit" as "PUB_customer_cust_limit", "PUB_customer"."cust_name" as "PUB_customer_cust_name", "PUB_customer"."cust_no" as "PUB_customer_cust_no", "PUB_customer"."cust_notify" as "PUB_customer_cust_notify", "PUB_customer"."cust_notify_ack" as "PUB_customer_cust_notify_ack", "PUB_customer"."cust_notify_back" as "PUB_customer_cust_notify_back", "PUB_customer"."cust_notify_bol" as "PUB_customer_cust_notify_bol", "PUB_customer"."cust_notify_epicasDNN" as "PUB_customer_cust_notify_epicasD", "PUB_customer"."cust_notify_epicasemail" as "PUB_customer_cust_notify_epicase", "PUB_customer"."cust_notify_inv" as "PUB_customer_cust_notify_inv", "PUB_customer"."cust_notify_invemail" as "PUB_customer_cust_notify_invemai", "PUB_customer"."cust_notify_invfax" as "PUB_customer_cust_notify_invfax", "PUB_customer"."cust_notify_options" as "PUB_customer_cust_notify_options", "PUB_customer"."cust_notify_sta" as "PUB_customer_cust_notify_sta", "PUB_customer"."cust_notify_staemail" as "PUB_customer_cust_notify_staemai", "PUB_customer"."cust_notify_stafax" as "PUB_customer_cust_notify_stafax", "PUB_customer"."cust_notify_sub" as "PUB_customer_cust_notify_sub", "PUB_customer"."cust_notify_team" as "PUB_customer_cust_notify_team", "PUB_customer"."cust_optional_lic" as "PUB_customer_cust_optional_lic", "PUB_customer"."cust_pay_req" as "PUB_customer_cust_pay_req", "PUB_customer"."cust_pay_req_pct" as "PUB_customer_cust_pay_req_pct", "PUB_customer"."cust_phone" as "PUB_customer_cust_phone", "PUB_customer"."cust_phone_ext" as "PUB_customer_cust_phone_ext", "PUB_customer"."cust_po_req" as "PUB_customer_cust_po_req", "PUB_customer"."cust_prc_type" as "PUB_customer_cust_prc_type", "PUB_customer"."cust_pricing" as "PUB_customer_cust_pricing", "PUB_customer"."cust_print_declared" as "PUB_customer_cust_print_declared", "PUB_customer"."cust_sales_account" as "PUB_customer_cust_sales_account", "PUB_customer"."cust_short" as "PUB_customer_cust_short", "PUB_customer"."cust_state" as "PUB_customer_cust_state", "PUB_customer"."cust_status" as "PUB_customer_cust_status", "PUB_customer"."cust_type" as "PUB_customer_cust_type", "PUB_customer"."cust_web" as "PUB_customer_cust_web", "PUB_customer"."cust_zip" as "PUB_customer_cust_zip", "PUB_customer"."default_ship_doc" as "PUB_customer_default_ship_doc", "PUB_customer"."entry_type" as "PUB_customer_entry_type", "PUB_customer"."frm_number" as "PUB_customer_frm_number", "PUB_customer"."gl_account" as "PUB_customer_gl_account", "PUB_customer"."new_order_status" as "PUB_customer_new_order_status", "PUB_customer"."sales_tax_license" as "PUB_customer_sales_tax_license", "PUB_customer"."shipper_format" as "PUB_customer_shipper_format", "PUB_customer"."sig_required" as "PUB_customer_sig_required", "PUB_customer"."tax_code" as "PUB_customer_tax_code", "PUB_customer"."term_code" as "PUB_customer_term_code", "PUB_customer"."ups_label_form" as "PUB_customer_ups_label_form", "PUB_customer"."user_name" as "PUB_customer_user_name", "PUB_customer"."user_pass" as "PUB_customer_user_pass", "PUB_customer"."v_number" as "PUB_customer_v_number", "PUB_oe_head"."actual_exchange_rate" as "PUB_oe_head_actual_exchange_rate", "PUB_oe_head"."air_carrier" as "PUB_oe_head_air_carrier", "PUB_oe_head"."blanket_status" as "PUB_oe_head_blanket_status", "PUB_oe_head"."cart_id" as "PUB_oe_head_cart_id", "PUB_oe_head"."contact_code" as "PUB_oe_head_contact_code", "PUB_oe_head"."cust_no" as "PUB_oe_head_cust_no", "PUB_oe_head"."eorderno" as "PUB_oe_head_eorderno", "PUB_oe_head"."exchange_rate" as "PUB_oe_head_exchange_rate", "PUB_oe_head"."exp_date" as "PUB_oe_head_exp_date", "PUB_oe_head"."exp_time" as "PUB_oe_head_exp_time", "PUB_oe_head"."export_batch_no" as "PUB_oe_head_export_batch_no", "PUB_oe_head"."hub_code" as "PUB_oe_head_hub_code", "PUB_oe_head"."internal_contact_code" as "PUB_oe_head_internal_contact_cod", "PUB_oe_head"."oe_exch_code" as "PUB_oe_head_oe_exch_code", "PUB_oe_head"."oe_exch_ratio" as "PUB_oe_head_oe_exch_ratio", "PUB_oe_head"."oeh_act_ship" as "PUB_oe_head_oeh_act_ship", "PUB_oe_head"."oeh_act_time" as "PUB_oe_head_oeh_act_time", "PUB_oe_head"."oeh_add_by" as "PUB_oe_head_oeh_add_by", "PUB_oe_head"."oeh_added" as "PUB_oe_head_oeh_added", "PUB_oe_head"."oeh_added_time" as "PUB_oe_head_oeh_added_time", "PUB_oe_head"."oeh_address1" as "PUB_oe_head_oeh_address1", "PUB_oe_head"."oeh_address2" as "PUB_oe_head_oeh_address2", "PUB_oe_head"."oeh_air_com" as "PUB_oe_head_oeh_air_com", "PUB_oe_head"."oeh_air_dest" as "PUB_oe_head_oeh_air_dest", "PUB_oe_head"."oeh_air_flag" as "PUB_oe_head_oeh_air_flag", "PUB_oe_head"."oeh_air_from" as "PUB_oe_head_oeh_air_from", "PUB_oe_head"."oeh_air_no" as "PUB_oe_head_oeh_air_no", "PUB_oe_head"."oeh_alt_addr" as "PUB_oe_head_oeh_alt_addr", "PUB_oe_head"."oeh_alt_frt" as "PUB_oe_head_oeh_alt_frt", "PUB_oe_head"."oeh_apply_to" as "PUB_oe_head_oeh_apply_to", "PUB_oe_head"."oeh_boxes" as "PUB_oe_head_oeh_boxes", "PUB_oe_head"."oeh_city" as "PUB_oe_head_oeh_city", "PUB_oe_head"."oeh_confirm_cust" as "PUB_oe_head_oeh_confirm_cust", "PUB_oe_head"."oeh_confirm_vend" as "PUB_oe_head_oeh_confirm_vend", "PUB_oe_head"."oeh_country" as "PUB_oe_head_oeh_country", "PUB_oe_head"."oeh_date" as "PUB_oe_head_oeh_date", "PUB_oe_head"."oeh_discount" as "PUB_oe_head_oeh_discount", "PUB_oe_head"."oeh_drop_alt" as "PUB_oe_head_oeh_drop_alt", "PUB_oe_head"."oeh_drop_ship" as "PUB_oe_head_oeh_drop_ship", "PUB_oe_head"."oeh_dsc_perc" as "PUB_oe_head_oeh_dsc_perc", "PUB_oe_head"."oeh_edi" as "PUB_oe_head_oeh_edi", "PUB_oe_head"."oeh_edi_status" as "PUB_oe_head_oeh_edi_status", "PUB_oe_head"."oeh_filler1" as "PUB_oe_head_oeh_filler1", "PUB_oe_head"."oeh_freight" as "PUB_oe_head_oeh_freight", "PUB_oe_head"."oeh_frt_brok" as "PUB_oe_head_oeh_frt_brok", "PUB_oe_head"."oeh_frt_cd" as "PUB_oe_head_oeh_frt_cd", "PUB_oe_head"."oeh_frt_paid" as "PUB_oe_head_oeh_frt_paid", "PUB_oe_head"."oeh_frt_reg" as "PUB_oe_head_oeh_frt_reg", "PUB_oe_head"."oeh_inv_date" as "PUB_oe_head_oeh_inv_date", "PUB_oe_head"."oeh_inv_no" as "PUB_oe_head_oeh_inv_no", "PUB_oe_head"."oeh_load_no" as "PUB_oe_head_oeh_load_no", "PUB_oe_head"."oeh_load_seq" as "PUB_oe_head_oeh_load_seq", "PUB_oe_head"."oeh_load_status" as "PUB_oe_head_oeh_load_status", "PUB_oe_head"."oeh_load_yw" as "PUB_oe_head_oeh_load_yw", "PUB_oe_head"."oeh_master_boxes" as "PUB_oe_head_oeh_master_boxes", "PUB_oe_head"."oeh_master_no" as "PUB_oe_head_oeh_master_no", "PUB_oe_head"."oeh_miles" as "PUB_oe_head_oeh_miles", "PUB_oe_head"."oeh_misc" as "PUB_oe_head_oeh_misc", "PUB_oe_head"."oeh_misc_lit" as "PUB_oe_head_oeh_misc_lit", "PUB_oe_head"."oeh_no_subs" as "PUB_oe_head_oeh_no_subs", "PUB_oe_head"."oeh_notes" as "PUB_oe_head_oeh_notes", "PUB_oe_head"."oeh_number" as "PUB_oe_head_oeh_number", "PUB_oe_head"."oeh_orig_no" as "PUB_oe_head_oeh_orig_no", "PUB_oe_head"."oeh_orig_rel" as "PUB_oe_head_oeh_orig_rel", "PUB_oe_head"."oeh_placed" as "PUB_oe_head_oeh_placed", "PUB_oe_head"."oeh_po_no" as "PUB_oe_head_oeh_po_no", "PUB_oe_head"."oeh_posted_frt" as "PUB_oe_head_oeh_posted_frt", "PUB_oe_head"."oeh_price" as "PUB_oe_head_oeh_price", "PUB_oe_head"."oeh_quantity" as "PUB_oe_head_oeh_quantity", "PUB_oe_head"."oeh_racks" as "PUB_oe_head_oeh_racks", "PUB_oe_head"."oeh_racks_dec" as "PUB_oe_head_oeh_racks_dec", "PUB_oe_head"."oeh_recalc_boxes" as "PUB_oe_head_oeh_recalc_boxes", "PUB_oe_head"."oeh_recalc_frt" as "PUB_oe_head_oeh_recalc_frt", "PUB_oe_head"."oeh_region" as "PUB_oe_head_oeh_region", "PUB_oe_head"."oeh_rel_type" as "PUB_oe_head_oeh_rel_type", "PUB_oe_head"."oeh_release" as "PUB_oe_head_oeh_release", "PUB_oe_head"."oeh_ship_by" as "PUB_oe_head_oeh_ship_by", "PUB_oe_head"."oeh_ship_lit" as "PUB_oe_head_oeh_ship_lit", "PUB_oe_head"."oeh_ship_yw" as "PUB_oe_head_oeh_ship_yw", "PUB_oe_head"."oeh_shipping_loc" as "PUB_oe_head_oeh_shipping_loc", "PUB_oe_head"."oeh_shp_date" as "PUB_oe_head_oeh_shp_date", "PUB_oe_head"."oeh_shp_inst" as "PUB_oe_head_oeh_shp_inst", "PUB_oe_head"."oeh_shp_week" as "PUB_oe_head_oeh_shp_week", "PUB_oe_head"."oeh_spec" as "PUB_oe_head_oeh_spec", "PUB_oe_head"."oeh_state" as "PUB_oe_head_oeh_state", "PUB_oe_head"."oeh_status" as "PUB_oe_head_oeh_status", "PUB_oe_head"."oeh_tag_exchange" as "PUB_oe_head_oeh_tag_exchange", "PUB_oe_head"."oeh_tags" as "PUB_oe_head_oeh_tags", "PUB_oe_head"."oeh_tracking_no" as "PUB_oe_head_oeh_tracking_no", "PUB_oe_head"."oeh_type" as "PUB_oe_head_oeh_type", "PUB_oe_head"."oeh_units" as "PUB_oe_head_oeh_units", "PUB_oe_head"."oeh_vol_type" as "PUB_oe_head_oeh_vol_type", "PUB_oe_head"."oeh_volume" as "PUB_oe_head_oeh_volume", "PUB_oe_head"."oeh_weight" as "PUB_oe_head_oeh_weight", "PUB_oe_head"."oeh_zipcode" as "PUB_oe_head_oeh_zipcode", "PUB_oe_head"."orig_exp_date" as "PUB_oe_head_orig_exp_date", "PUB_oe_head"."orig_exp_time" as "PUB_oe_head_orig_exp_time", "PUB_oe_head"."orig_load_seq" as "PUB_oe_head_orig_load_seq", "PUB_oe_head"."posted_exchange_rate" as "PUB_oe_head_posted_exchange_rate", "PUB_oe_head"."reas_code" as "PUB_oe_head_reas_code", "PUB_oe_head"."ship_desc" as "PUB_oe_head_ship_desc", "PUB_oe_head"."ship_to" as "PUB_oe_head_ship_to", "PUB_oe_head"."shp_via" as "PUB_oe_head_shp_via", "PUB_oe_head"."tax_code" as "PUB_oe_head_tax_code", "PUB_oe_head"."term_code" as "PUB_oe_head_term_code", "PUB_oe_head"."v_number" as "PUB_oe_head_v_number", "PUB_oe_line"."blnk_po_no" as "PUB_oe_line_blnk_po_no", "PUB_oe_line"."box_id" as "PUB_oe_line_box_id", "PUB_oe_line"."con_code" as "PUB_oe_line_con_code", "PUB_oe_line"."contract_no" as "PUB_oe_line_contract_no", "PUB_oe_line"."cust_item_sku" as "PUB_oe_line_cust_item_sku", "PUB_oe_line"."cust_no" as "PUB_oe_line_cust_no", "PUB_oe_line"."edi_ship_to" as "PUB_oe_line_edi_ship_to", "PUB_oe_line"."frm_number" as "PUB_oe_line_frm_number", "PUB_oe_line"."genera_id" as "PUB_oe_line_genera_id", "PUB_oe_line"."gift_message" as "PUB_oe_line_gift_message", "PUB_oe_line"."last_ack_price" as "PUB_oe_line_last_ack_price", "PUB_oe_line"."last_ack_qty" as "PUB_oe_line_last_ack_qty", "PUB_oe_line"."loc_no" as "PUB_oe_line_loc_no", "PUB_oe_line"."matl_no" as "PUB_oe_line_matl_no", "PUB_oe_line"."oeh_bck_ord" as "PUB_oe_line_oeh_bck_ord", "PUB_oe_line"."oeh_mst_blank" as "PUB_oe_line_oeh_mst_blank", "PUB_oe_line"."oeh_number" as "PUB_oe_line_oeh_number", "PUB_oe_line"."oeh_release" as "PUB_oe_line_oeh_release", "PUB_oe_line"."oeh_type" as "PUB_oe_line_oeh_type", "PUB_oe_line"."oeh_vol_type" as "PUB_oe_line_oeh_vol_type", "PUB_oe_line"."oel_back_flag" as "PUB_oe_line_oel_back_flag", "PUB_oe_line"."oel_bck_rel" as "PUB_oe_line_oel_bck_rel", "PUB_oe_line"."oel_bck_seq" as "PUB_oe_line_oel_bck_seq", "PUB_oe_line"."oel_boxes" as "PUB_oe_line_oel_boxes", "PUB_oe_line"."oel_broker_seq" as "PUB_oe_line_oel_broker_seq", "PUB_oe_line"."oel_cmp_flag" as "PUB_oe_line_oel_cmp_flag", "PUB_oe_line"."oel_com_type" as "PUB_oe_line_oel_com_type", "PUB_oe_line"."oel_comment" as "PUB_oe_line_oel_comment", "PUB_oe_line"."oel_con_back" as "PUB_oe_line_oel_con_back", "PUB_oe_line"."oel_con_ord" as "PUB_oe_line_oel_con_ord", "PUB_oe_line"."oel_con_rel" as "PUB_oe_line_oel_con_rel", "PUB_oe_line"."oel_con_req" as "PUB_oe_line_oel_con_req", "PUB_oe_line"."oel_con_ship" as "PUB_oe_line_oel_con_ship", "PUB_oe_line"."oel_desc" as "PUB_oe_line_oel_desc", "PUB_oe_line"."oel_edi_item" as "PUB_oe_line_oel_edi_item", "PUB_oe_line"."oel_eod" as "PUB_oe_line_oel_eod", "PUB_oe_line"."oel_extra" as "PUB_oe_line_oel_extra", "PUB_oe_line"."oel_filler1" as "PUB_oe_line_oel_filler1", "PUB_oe_line"."oel_filler2" as "PUB_oe_line_oel_filler2", "PUB_oe_line"."oel_from_blanket" as "PUB_oe_line_oel_from_blanket", "PUB_oe_line"."oel_inv_date" as "PUB_oe_line_oel_inv_date", "PUB_oe_line"."oel_license" as "PUB_oe_line_oel_license", "PUB_oe_line"."oel_partial" as "PUB_oe_line_oel_partial", "PUB_oe_line"."oel_price" as "PUB_oe_line_oel_price", "PUB_oe_line"."oel_price_type" as "PUB_oe_line_oel_price_type", "PUB_oe_line"."oel_qty_back" as "PUB_oe_line_oel_qty_back", "PUB_oe_line"."oel_qty_ord" as "PUB_oe_line_oel_qty_ord", "PUB_oe_line"."oel_qty_rel" as "PUB_oe_line_oel_qty_rel", "PUB_oe_line"."oel_qty_ship" as "PUB_oe_line_oel_qty_ship", "PUB_oe_line"."oel_re_ship" as "PUB_oe_line_oel_re_ship", "PUB_oe_line"."oel_rel_from" as "PUB_oe_line_oel_rel_from", "PUB_oe_line"."oel_req_status" as "PUB_oe_line_oel_req_status", "PUB_oe_line"."oel_reship_qty" as "PUB_oe_line_oel_reship_qty", "PUB_oe_line"."oel_seq" as "PUB_oe_line_oel_seq", "PUB_oe_line"."oel_ship_yw" as "PUB_oe_line_oel_ship_yw", "PUB_oe_line"."oel_shipper_seq" as "PUB_oe_line_oel_shipper_seq", "PUB_oe_line"."oel_shp_date" as "PUB_oe_line_oel_shp_date", "PUB_oe_line"."oel_shp_week" as "PUB_oe_line_oel_shp_week", "PUB_oe_line"."oel_status" as "PUB_oe_line_oel_status", "PUB_oe_line"."oel_sub_con" as "PUB_oe_line_oel_sub_con", "PUB_oe_line"."oel_sub_date" as "PUB_oe_line_oel_sub_date", "PUB_oe_line"."oel_sub_flag" as "PUB_oe_line_oel_sub_flag", "PUB_oe_line"."oel_sub_item" as "PUB_oe_line_oel_sub_item", "PUB_oe_line"."oel_sub_yw" as "PUB_oe_line_oel_sub_yw", "PUB_oe_line"."oel_tag_exchange" as "PUB_oe_line_oel_tag_exchange", "PUB_oe_line"."oel_tags" as "PUB_oe_line_oel_tags", "PUB_oe_line"."oel_um" as "PUB_oe_line_oel_um", "PUB_oe_line"."oel_um_qty" as "PUB_oe_line_oel_um_qty", "PUB_oe_line"."oel_units_suspend" as "PUB_oe_line_oel_units_suspend", "PUB_oe_line"."oel_vol_levl" as "PUB_oe_line_oel_vol_levl", "PUB_oe_line"."oel_warning" as "PUB_oe_line_oel_warning", "PUB_oe_line"."p_number" as "PUB_oe_line_p_number", "PUB_oe_line"."po_confirm" as "PUB_oe_line_po_confirm", "PUB_oe_line"."prd_line" as "PUB_oe_line_prd_line", "PUB_oe_line"."price_cd" as "PUB_oe_line_price_cd", "PUB_oe_line"."promo_code" as "PUB_oe_line_promo_code", "PUB_oe_line"."qty_per_box" as "PUB_oe_line_qty_per_box", "PUB_oe_line"."reas_code" as "PUB_oe_line_reas_code", "PUB_oe_line"."ship_to" as "PUB_oe_line_ship_to", "PUB_oe_line"."type_code" as "PUB_oe_line_type_code", "PUB_oe_line"."upc_code" as "PUB_oe_line_upc_code", "PUB_oe_line"."v_number" as "PUB_oe_line_v_number", "PUB_oe_line"."vol_code" as "PUB_oe_line_vol_code", "PUB_prod_line"."cst_cat" as "PUB_prod_line_cst_cat", "PUB_prod_line"."prd_cogs_account" as "PUB_prod_line_prd_cogs_account", "PUB_prod_line"."prd_credit_acct" as "PUB_prod_line_prd_credit_acct", "PUB_prod_line"."prd_desc" as "PUB_prod_line_prd_desc", "PUB_prod_line"."prd_e_week" as "PUB_prod_line_prd_e_week", "PUB_prod_line"."prd_early" as "PUB_prod_line_prd_early", "PUB_prod_line"."prd_exp_acct" as "PUB_prod_line_prd_exp_acct", "PUB_prod_line"."prd_inv_asset_acct" as "PUB_prod_line_prd_inv_asset_acct", "PUB_prod_line"."prd_line" as "PUB_prod_line_prd_line", "PUB_prod_line"."prd_prc_en" as "PUB_prod_line_prd_prc_en", "PUB_prod_line"."prd_prc_st" as "PUB_prod_line_prd_prc_st", "PUB_prod_line"."prd_prc_year" as "PUB_prod_line_prd_prc_year", "PUB_prod_line"."prd_roy_acct" as "PUB_prod_line_prd_roy_acct", "PUB_prod_line"."prd_roy_cat" as "PUB_prod_line_prd_roy_cat", "PUB_prod_line"."prd_s_week" as "PUB_prod_line_prd_s_week", "PUB_prod_line"."prd_sal_acct" as "PUB_prod_line_prd_sal_acct", "PUB_prod_line"."prd_sea_en" as "PUB_prod_line_prd_sea_en", "PUB_prod_line"."prd_sea_st" as "PUB_prod_line_prd_sea_st", "PUB_prod_line"."prd_seasons" as "PUB_prod_line_prd_seasons", "PUB_prod_line"."prd_status" as "PUB_prod_line_prd_status", "PUB_prod_line"."prd_type" as "PUB_prod_line_prd_type", "PUB_prod_line"."prd_wip_account" as "PUB_prod_line_prd_wip_account", "PUB_prod_line"."prod_e_ship" as "PUB_prod_line_prod_e_ship", "PUB_prod_line"."prod_s_ship" as "PUB_prod_line_prod_s_ship", "PUB_shipto"."cart_id" as "PUB_shipto_cart_id", "PUB_shipto"."cht_country" as "PUB_shipto_cht_country", "PUB_shipto"."contact_code" as "PUB_shipto_contact_code", "PUB_shipto"."delivery_close_time" as "PUB_shipto_delivery_close_time", "PUB_shipto"."delivery_min_time" as "PUB_shipto_delivery_min_time", "PUB_shipto"."delivery_open_time" as "PUB_shipto_delivery_open_time", "PUB_shipto"."internal_contact_code" as "PUB_shipto_internal_contact_code", "PUB_shipto"."ship_to" as "PUB_shipto_ship_to", "PUB_shipto"."shipping_loc" as "PUB_shipto_shipping_loc", "PUB_shipto"."shp_via" as "PUB_shipto_shp_via", "PUB_shipto"."shp_via_2" as "PUB_shipto_shp_via_2", "PUB_shipto"."sht_added" as "PUB_shipto_sht_added", "PUB_shipto"."sht_address1" as "PUB_shipto_sht_address1", "PUB_shipto"."sht_address2" as "PUB_shipto_sht_address2", "PUB_shipto"."sht_airport" as "PUB_shipto_sht_airport", "PUB_shipto"."sht_alt_no" as "PUB_shipto_sht_alt_no", "PUB_shipto"."sht_attention" as "PUB_shipto_sht_attention", "PUB_shipto"."sht_cell" as "PUB_shipto_sht_cell", "PUB_shipto"."sht_city" as "PUB_shipto_sht_city", "PUB_shipto"."sht_declared" as "PUB_shipto_sht_declared", "PUB_shipto"."sht_def_frt" as "PUB_shipto_sht_def_frt", "PUB_shipto"."sht_direct" as "PUB_shipto_sht_direct", "PUB_shipto"."sht_email" as "PUB_shipto_sht_email", "PUB_shipto"."sht_fax" as "PUB_shipto_sht_fax", "PUB_shipto"."sht_filler1" as "PUB_shipto_sht_filler1", "PUB_shipto"."sht_instr" as "PUB_shipto_sht_instr", "PUB_shipto"."sht_last_act" as "PUB_shipto_sht_last_act", "PUB_shipto"."sht_lat" as "PUB_shipto_sht_lat", "PUB_shipto"."sht_leave_racks" as "PUB_shipto_sht_leave_racks", "PUB_shipto"."sht_length_limit" as "PUB_shipto_sht_length_limit", "PUB_shipto"."sht_long" as "PUB_shipto_sht_long", "PUB_shipto"."sht_mailing_alt_no" as "PUB_shipto_sht_mailing_alt_no", "PUB_shipto"."sht_name" as "PUB_shipto_sht_name", "PUB_shipto"."sht_notify" as "PUB_shipto_sht_notify", "PUB_shipto"."sht_notify_ASN" as "PUB_shipto_sht_notify_ASN", "PUB_shipto"."sht_notify_ack" as "PUB_shipto_sht_notify_ack", "PUB_shipto"."sht_notify_back" as "PUB_shipto_sht_notify_back", "PUB_shipto"."sht_notify_bol" as "PUB_shipto_sht_notify_bol", "PUB_shipto"."sht_notify_ePicasemail" as "PUB_shipto_sht_notify_ePicasemai", "PUB_shipto"."sht_notify_options" as "PUB_shipto_sht_notify_options", "PUB_shipto"."sht_notify_sub" as "PUB_shipto_sht_notify_sub", "PUB_shipto"."sht_phone" as "PUB_shipto_sht_phone", "PUB_shipto"."sht_phone_ext" as "PUB_shipto_sht_phone_ext", "PUB_shipto"."sht_region" as "PUB_shipto_sht_region", "PUB_shipto"."sht_require_lift" as "PUB_shipto_sht_require_lift", "PUB_shipto"."sht_residential" as "PUB_shipto_sht_residential", "PUB_shipto"."sht_seq" as "PUB_shipto_sht_seq", "PUB_shipto"."sht_shipping_loc" as "PUB_shipto_sht_shipping_loc", "PUB_shipto"."sht_state" as "PUB_shipto_sht_state", "PUB_shipto"."sht_status" as "PUB_shipto_sht_status", "PUB_shipto"."sht_subs" as "PUB_shipto_sht_subs", "PUB_shipto"."sht_vol" as "PUB_shipto_sht_vol", "PUB_shipto"."sht_weight_limit" as "PUB_shipto_sht_weight_limit", "PUB_shipto"."sht_work_order" as "PUB_shipto_sht_work_order", "PUB_shipto"."sht_zip" as "PUB_shipto_sht_zip", "PUB_shipto"."sht_zone" as "PUB_shipto_sht_zone", "PUB_shipto"."sig_required" as "PUB_shipto_sig_required", "load_file"."dist_id" as "load_file_dist_id", "load_file"."ld_app_by" as "load_file_ld_app_by", "load_file"."ld_app_date" as "load_file_ld_app_date", "load_file"."ld_charge_after" as "load_file_ld_charge_after", "load_file"."ld_crossref" as "load_file_ld_crossref", "load_file"."ld_date" as "load_file_ld_date", "load_file"."ld_driver" as "load_file_ld_driver", "load_file"."ld_drop_rate" as "load_file_ld_drop_rate", "load_file"."ld_drops" as "load_file_ld_drops", "load_file"."ld_exp" as "load_file_ld_exp", "load_file"."ld_filler1" as "load_file_ld_filler1", "load_file"."ld_filler2" as "load_file_ld_filler2", "load_file"."ld_filler3" as "load_file_ld_filler3", "load_file"."ld_fuel_add_calc" as "load_file_ld_fuel_add_calc", "load_file"."ld_fuel_surchg" as "load_file_ld_fuel_surchg", "load_file"."ld_max_carts" as "load_file_ld_max_carts", "load_file"."ld_miles" as "load_file_ld_miles", "load_file"."ld_notes" as "load_file_ld_notes", "load_file"."ld_other" as "load_file_ld_other", "load_file"."ld_rack_rate" as "load_file_ld_rack_rate", "load_file"."ld_rate" as "load_file_ld_rate", "load_file"."ld_region_rate" as "load_file_ld_region_rate", "load_file"."ld_return_date" as "load_file_ld_return_date", "load_file"."ld_return_time" as "load_file_ld_return_time", "load_file"."ld_returned_racks" as "load_file_ld_returned_racks", "load_file"."ld_round_trip" as "load_file_ld_round_trip", "load_file"."ld_sales" as "load_file_ld_sales", "load_file"."ld_status" as "load_file_ld_status", "load_file"."ld_time" as "load_file_ld_time", "load_file"."ld_tractor" as "load_file_ld_tractor", "load_file"."ld_unload_fee" as "load_file_ld_unload_fee", "load_file"."ld_yw" as "load_file_ld_yw", "load_file"."load_grower" as "load_file_load_grower", "load_file"."load_number" as "load_file_load_number", "load_file"."load_prefix" as "load_file_load_prefix", "load_file"."poh_number" as "load_file_poh_number", "load_file"."poh_release" as "load_file_poh_release", "load_file"."shipping_loc" as "load_file_shipping_loc", "load_file"."v_number" as "load_file_v_number", "materials"."loc_no" as "materials_loc_no", "materials"."matl_avg_cst" as "materials_matl_avg_cst", "materials"."matl_cost" as "materials_matl_cost", "materials"."matl_cycl_cd" as "materials_matl_cycl_cd", "materials"."matl_cycl_dt" as "materials_matl_cycl_dt", "materials"."matl_desc" as "materials_matl_desc", "materials"."matl_en_week" as "materials_matl_en_week", "materials"."matl_forms" as "materials_matl_forms", "materials"."matl_image" as "materials_matl_image", "materials"."matl_inv" as "materials_matl_inv", "materials"."matl_large_image" as "materials_matl_large_image", "materials"."matl_limit_extra" as "materials_matl_limit_extra", "materials"."matl_no" as "materials_matl_no", "materials"."matl_on_hnd" as "materials_matl_on_hnd", "materials"."matl_on_ord" as "materials_matl_on_ord", "materials"."matl_per_box" as "materials_matl_per_box", "materials"."matl_per_rack" as "materials_matl_per_rack", "materials"."matl_price" as "materials_matl_price", "materials"."matl_qty_per" as "materials_matl_qty_per", "materials"."matl_reorder" as "materials_matl_reorder", "materials"."matl_st_week" as "materials_matl_st_week", "materials"."matl_status" as "materials_matl_status", "materials"."matl_taxable" as "materials_matl_taxable", "materials"."matl_thumb_image" as "materials_matl_thumb_image", "materials"."matl_typ_cd" as "materials_matl_typ_cd", "materials"."matl_type" as "materials_matl_type", "materials"."matl_u_m" as "materials_matl_u_m", "materials"."prd_line" as "materials_prd_line", "materials"."price_cd" as "materials_price_cd", "materials"."price_cd2" as "materials_price_cd2", "materials"."price_cd_starts" as "materials_price_cd_starts", "materials"."sub_code" as "materials_sub_code", "materials"."vol_code" as "materials_vol_code", "truck_file"."cost_per_drop" as "truck_file_cost_per_drop", "truck_file"."cost_per_hour" as "truck_file_cost_per_hour", "truck_file"."cost_per_mile" as "truck_file_cost_per_mile", "truck_file"."dist_id" as "truck_file_dist_id", "truck_file"."trk_box" as "truck_file_trk_box", "truck_file"."trk_code" as "truck_file_trk_code", "truck_file"."trk_desc" as "truck_file_trk_desc", "truck_file"."trk_filler1" as "truck_file_trk_filler1", "truck_file"."trk_filler2" as "truck_file_trk_filler2", "truck_file"."trk_length" as "truck_file_trk_length", "truck_file"."trk_lift_gate" as "truck_file_trk_lift_gate", "truck_file"."trk_one_way" as "truck_file_trk_one_way", "truck_file"."trk_rack" as "truck_file_trk_rack", "truck_file"."trk_seq" as "truck_file_trk_seq", "truck_file"."trk_size" as "truck_file_trk_size", "truck_file"."trk_units" as "truck_file_trk_units", "truck_file"."trk_vol" as "truck_file_trk_vol", "truck_file"."trk_weight" as "truck_file_trk_weight", "truck_file"."trk_width" as "truck_file_trk_width", "truck_file"."v_number" as "truck_file_v_number" from "oe_line" "PUB_oe_line" left outer join "container" "PUB_container" on ("PUB_oe_line"."con_code" = "PUB_container"."con_code") left outer join "prod_line" "PUB_prod_line" on ("PUB_oe_line"."prd_line" = "PUB_prod_line"."prd_line") inner join "oe_head" "PUB_oe_head" on ("PUB_oe_line"."oeh_number" = "PUB_oe_head"."oeh_number" and "PUB_oe_line"."oeh_release" = "PUB_oe_head"."oeh_release") left outer join "customer" "PUB_customer" on ("PUB_oe_head"."cust_no" = "PUB_customer"."cust_no") left outer join "shipto" "PUB_shipto" on ("PUB_oe_head"."ship_to" = "PUB_shipto"."ship_to") left outer join "load_file" on ("PUB_oe_head"."oeh_load_no" = "load_file"."load_number") left outer join "truck_file" on ("load_file"."ld_tractor" = "truck_file"."trk_code") left outer join "materials" on ("PUB_oe_line"."upc_code" = "materials"."matl_no") where ("PUB_oe_head"."oeh_ship_yw" > 201501) at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:433) at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:215) ... 185 more Caused by: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query: select "PUB_container"."box_code" as "PUB_container_box_code", "PUB_container"."box_en_week" as "PUB_container_box_en_week", "PUB_container"."box_st_week" as "PUB_container_box_st_week", "PUB_container"."cc_code" as "PUB_container_cc_code", "PUB_container"."con_area" as "PUB_container_con_area", "PUB_container"."con_code" as "PUB_container_con_code", "PUB_container"."con_desc" as "PUB_container_con_desc", "PUB_container"."con_factor" as "PUB_container_con_factor", "PUB_container"."con_filler1" as "PUB_container_con_filler1", "PUB_container"."con_filler2" as "PUB_container_con_filler2", "PUB_container"."con_g_units" as "PUB_container_con_g_units", "PUB_container"."con_group" as "PUB_container_con_group", "PUB_container"."con_lit" as "PUB_container_con_lit", "PUB_container"."con_organic" as "PUB_container_con_organic", "PUB_container"."con_per_box" as "PUB_container_con_per_box", "PUB_container"."con_per_layer" as "PUB_container_con_per_layer", "PUB_container"."con_per_rack" as "PUB_container_con_per_rack", "PUB_container"."con_s_units" as "PUB_container_con_s_units", "PUB_container"."con_status" as "PUB_container_con_status", "PUB_container"."con_vol" as "PUB_container_con_vol", "PUB_container"."con_weight" as "PUB_container_con_weight", "PUB_container"."dc_field" as "PUB_container_dc_field", "PUB_container"."labels_per_container" as "PUB_container_labels_per_contain", "PUB_container"."plants_per_row" as "PUB_container_plants_per_row", "PUB_container"."print_both_sides" as "PUB_container_print_both_sides", "PUB_container"."tag_qty" as "PUB_container_tag_qty", "PUB_container"."unique_id" as "PUB_container_unique_id", "PUB_container"."units_per_tray" as "PUB_container_units_per_tray", "PUB_container"."weight_and_measures" as "PUB_container_weight_and_measure", "PUB_customer"."ar_cust_no" as "PUB_customer_ar_cust_no", "PUB_customer"."bol_default_sort" as "PUB_customer_bol_default_sort", "PUB_customer"."bol_show_barcode" as "PUB_customer_bol_show_barcode", "PUB_customer"."bol_show_pricing" as "PUB_customer_bol_show_pricing", "PUB_customer"."contact_code" as "PUB_customer_contact_code", "PUB_customer"."cur_code" as "PUB_customer_cur_code", "PUB_customer"."cust_added" as "PUB_customer_cust_added", "PUB_customer"."cust_address1" as "PUB_customer_cust_address1", "PUB_customer"."cust_address2" as "PUB_customer_cust_address2", "PUB_customer"."cust_b2b_company" as "PUB_customer_cust_b2b_company", "PUB_customer"."cust_balance" as "PUB_customer_cust_balance", "PUB_customer"."cust_cell" as "PUB_customer_cust_cell", "PUB_customer"."cust_city" as "PUB_customer_cust_city", "PUB_customer"."cust_cntry" as "PUB_customer_cust_cntry", "PUB_customer"."cust_consignment" as "PUB_customer_cust_consignment", "PUB_customer"."cust_credit_account" as "PUB_customer_cust_credit_account", "PUB_customer"."cust_def_frt" as "PUB_customer_cust_def_frt", "PUB_customer"."cust_default_inv" as "PUB_customer_cust_default_inv", "PUB_customer"."cust_default_ship" as "PUB_customer_cust_default_ship", "PUB_customer"."cust_disc" as "PUB_customer_cust_disc", "PUB_customer"."cust_email" as "PUB_customer_cust_email", "PUB_customer"."cust_fax" as "PUB_customer_cust_fax", "PUB_customer"."cust_filler1" as "PUB_customer_cust_filler1", "PUB_customer"."cust_finance" as "PUB_customer_cust_finance", "PUB_customer"."cust_finance_override" as "PUB_customer_cust_finance_overri", "PUB_customer"."cust_last_act" as "PUB_customer_cust_last_act", "PUB_customer"."cust_limit" as "PUB_customer_cust_limit", "PUB_customer"."cust_name" as "PUB_customer_cust_name", "PUB_customer"."cust_no" as "PUB_customer_cust_no", "PUB_customer"."cust_notify" as "PUB_customer_cust_notify", "PUB_customer"."cust_notify_ack" as "PUB_customer_cust_notify_ack", "PUB_customer"."cust_notify_back" as "PUB_customer_cust_notify_back", "PUB_customer"."cust_notify_bol" as "PUB_customer_cust_notify_bol", "PUB_customer"."cust_notify_epicasDNN" as "PUB_customer_cust_notify_epicasD", "PUB_customer"."cust_notify_epicasemail" as "PUB_customer_cust_notify_epicase", "PUB_customer"."cust_notify_inv" as "PUB_customer_cust_notify_inv", "PUB_customer"."cust_notify_invemail" as "PUB_customer_cust_notify_invemai", "PUB_customer"."cust_notify_invfax" as "PUB_customer_cust_notify_invfax", "PUB_customer"."cust_notify_options" as "PUB_customer_cust_notify_options", "PUB_customer"."cust_notify_sta" as "PUB_customer_cust_notify_sta", "PUB_customer"."cust_notify_staemail" as "PUB_customer_cust_notify_staemai", "PUB_customer"."cust_notify_stafax" as "PUB_customer_cust_notify_stafax", "PUB_customer"."cust_notify_sub" as "PUB_customer_cust_notify_sub", "PUB_customer"."cust_notify_team" as "PUB_customer_cust_notify_team", "PUB_customer"."cust_optional_lic" as "PUB_customer_cust_optional_lic", "PUB_customer"."cust_pay_req" as "PUB_customer_cust_pay_req", "PUB_customer"."cust_pay_req_pct" as "PUB_customer_cust_pay_req_pct", "PUB_customer"."cust_phone" as "PUB_customer_cust_phone", "PUB_customer"."cust_phone_ext" as "PUB_customer_cust_phone_ext", "PUB_customer"."cust_po_req" as "PUB_customer_cust_po_req", "PUB_customer"."cust_prc_type" as "PUB_customer_cust_prc_type", "PUB_customer"."cust_pricing" as "PUB_customer_cust_pricing", "PUB_customer"."cust_print_declared" as "PUB_customer_cust_print_declared", "PUB_customer"."cust_sales_account" as "PUB_customer_cust_sales_account", "PUB_customer"."cust_short" as "PUB_customer_cust_short", "PUB_customer"."cust_state" as "PUB_customer_cust_state", "PUB_customer"."cust_status" as "PUB_customer_cust_status", "PUB_customer"."cust_type" as "PUB_customer_cust_type", "PUB_customer"."cust_web" as "PUB_customer_cust_web", "PUB_customer"."cust_zip" as "PUB_customer_cust_zip", "PUB_customer"."default_ship_doc" as "PUB_customer_default_ship_doc", "PUB_customer"."entry_type" as "PUB_customer_entry_type", "PUB_customer"."frm_number" as "PUB_customer_frm_number", "PUB_customer"."gl_account" as "PUB_customer_gl_account", "PUB_customer"."new_order_status" as "PUB_customer_new_order_status", "PUB_customer"."sales_tax_license" as "PUB_customer_sales_tax_license", "PUB_customer"."shipper_format" as "PUB_customer_shipper_format", "PUB_customer"."sig_required" as "PUB_customer_sig_required", "PUB_customer"."tax_code" as "PUB_customer_tax_code", "PUB_customer"."term_code" as "PUB_customer_term_code", "PUB_customer"."ups_label_form" as "PUB_customer_ups_label_form", "PUB_customer"."user_name" as "PUB_customer_user_name", "PUB_customer"."user_pass" as "PUB_customer_user_pass", "PUB_customer"."v_number" as "PUB_customer_v_number", "PUB_oe_head"."actual_exchange_rate" as "PUB_oe_head_actual_exchange_rate", "PUB_oe_head"."air_carrier" as "PUB_oe_head_air_carrier", "PUB_oe_head"."blanket_status" as "PUB_oe_head_blanket_status", "PUB_oe_head"."cart_id" as "PUB_oe_head_cart_id", "PUB_oe_head"."contact_code" as "PUB_oe_head_contact_code", "PUB_oe_head"."cust_no" as "PUB_oe_head_cust_no", "PUB_oe_head"."eorderno" as "PUB_oe_head_eorderno", "PUB_oe_head"."exchange_rate" as "PUB_oe_head_exchange_rate", "PUB_oe_head"."exp_date" as "PUB_oe_head_exp_date", "PUB_oe_head"."exp_time" as "PUB_oe_head_exp_time", "PUB_oe_head"."export_batch_no" as "PUB_oe_head_export_batch_no", "PUB_oe_head"."hub_code" as "PUB_oe_head_hub_code", "PUB_oe_head"."internal_contact_code" as "PUB_oe_head_internal_contact_cod", "PUB_oe_head"."oe_exch_code" as "PUB_oe_head_oe_exch_code", "PUB_oe_head"."oe_exch_ratio" as "PUB_oe_head_oe_exch_ratio", "PUB_oe_head"."oeh_act_ship" as "PUB_oe_head_oeh_act_ship", "PUB_oe_head"."oeh_act_time" as "PUB_oe_head_oeh_act_time", "PUB_oe_head"."oeh_add_by" as "PUB_oe_head_oeh_add_by", "PUB_oe_head"."oeh_added" as "PUB_oe_head_oeh_added", "PUB_oe_head"."oeh_added_time" as "PUB_oe_head_oeh_added_time", "PUB_oe_head"."oeh_address1" as "PUB_oe_head_oeh_address1", "PUB_oe_head"."oeh_address2" as "PUB_oe_head_oeh_address2", "PUB_oe_head"."oeh_air_com" as "PUB_oe_head_oeh_air_com", "PUB_oe_head"."oeh_air_dest" as "PUB_oe_head_oeh_air_dest", "PUB_oe_head"."oeh_air_flag" as "PUB_oe_head_oeh_air_flag", "PUB_oe_head"."oeh_air_from" as "PUB_oe_head_oeh_air_from", "PUB_oe_head"."oeh_air_no" as "PUB_oe_head_oeh_air_no", "PUB_oe_head"."oeh_alt_addr" as "PUB_oe_head_oeh_alt_addr", "PUB_oe_head"."oeh_alt_frt" as "PUB_oe_head_oeh_alt_frt", "PUB_oe_head"."oeh_apply_to" as "PUB_oe_head_oeh_apply_to", "PUB_oe_head"."oeh_boxes" as "PUB_oe_head_oeh_boxes", "PUB_oe_head"."oeh_city" as "PUB_oe_head_oeh_city", "PUB_oe_head"."oeh_confirm_cust" as "PUB_oe_head_oeh_confirm_cust", "PUB_oe_head"."oeh_confirm_vend" as "PUB_oe_head_oeh_confirm_vend", "PUB_oe_head"."oeh_country" as "PUB_oe_head_oeh_country", "PUB_oe_head"."oeh_date" as "PUB_oe_head_oeh_date", "PUB_oe_head"."oeh_discount" as "PUB_oe_head_oeh_discount", "PUB_oe_head"."oeh_drop_alt" as "PUB_oe_head_oeh_drop_alt", "PUB_oe_head"."oeh_drop_ship" as "PUB_oe_head_oeh_drop_ship", "PUB_oe_head"."oeh_dsc_perc" as "PUB_oe_head_oeh_dsc_perc", "PUB_oe_head"."oeh_edi" as "PUB_oe_head_oeh_edi", "PUB_oe_head"."oeh_edi_status" as "PUB_oe_head_oeh_edi_status", "PUB_oe_head"."oeh_filler1" as "PUB_oe_head_oeh_filler1", "PUB_oe_head"."oeh_freight" as "PUB_oe_head_oeh_freight", "PUB_oe_head"."oeh_frt_brok" as "PUB_oe_head_oeh_frt_brok", "PUB_oe_head"."oeh_frt_cd" as "PUB_oe_head_oeh_frt_cd", "PUB_oe_head"."oeh_frt_paid" as "PUB_oe_head_oeh_frt_paid", "PUB_oe_head"."oeh_frt_reg" as "PUB_oe_head_oeh_frt_reg", "PUB_oe_head"."oeh_inv_date" as "PUB_oe_head_oeh_inv_date", "PUB_oe_head"."oeh_inv_no" as "PUB_oe_head_oeh_inv_no", "PUB_oe_head"."oeh_load_no" as "PUB_oe_head_oeh_load_no", "PUB_oe_head"."oeh_load_seq" as "PUB_oe_head_oeh_load_seq", "PUB_oe_head"."oeh_load_status" as "PUB_oe_head_oeh_load_status", "PUB_oe_head"."oeh_load_yw" as "PUB_oe_head_oeh_load_yw", "PUB_oe_head"."oeh_master_boxes" as "PUB_oe_head_oeh_master_boxes", "PUB_oe_head"."oeh_master_no" as "PUB_oe_head_oeh_master_no", "PUB_oe_head"."oeh_miles" as "PUB_oe_head_oeh_miles", "PUB_oe_head"."oeh_misc" as "PUB_oe_head_oeh_misc", "PUB_oe_head"."oeh_misc_lit" as "PUB_oe_head_oeh_misc_lit", "PUB_oe_head"."oeh_no_subs" as "PUB_oe_head_oeh_no_subs", "PUB_oe_head"."oeh_notes" as "PUB_oe_head_oeh_notes", "PUB_oe_head"."oeh_number" as "PUB_oe_head_oeh_number", "PUB_oe_head"."oeh_orig_no" as "PUB_oe_head_oeh_orig_no", "PUB_oe_head"."oeh_orig_rel" as "PUB_oe_head_oeh_orig_rel", "PUB_oe_head"."oeh_placed" as "PUB_oe_head_oeh_placed", "PUB_oe_head"."oeh_po_no" as "PUB_oe_head_oeh_po_no", "PUB_oe_head"."oeh_posted_frt" as "PUB_oe_head_oeh_posted_frt", "PUB_oe_head"."oeh_price" as "PUB_oe_head_oeh_price", "PUB_oe_head"."oeh_quantity" as "PUB_oe_head_oeh_quantity", "PUB_oe_head"."oeh_racks" as "PUB_oe_head_oeh_racks", "PUB_oe_head"."oeh_racks_dec" as "PUB_oe_head_oeh_racks_dec", "PUB_oe_head"."oeh_recalc_boxes" as "PUB_oe_head_oeh_recalc_boxes", "PUB_oe_head"."oeh_recalc_frt" as "PUB_oe_head_oeh_recalc_frt", "PUB_oe_head"."oeh_region" as "PUB_oe_head_oeh_region", "PUB_oe_head"."oeh_rel_type" as "PUB_oe_head_oeh_rel_type", "PUB_oe_head"."oeh_release" as "PUB_oe_head_oeh_release", "PUB_oe_head"."oeh_ship_by" as "PUB_oe_head_oeh_ship_by", "PUB_oe_head"."oeh_ship_lit" as "PUB_oe_head_oeh_ship_lit", "PUB_oe_head"."oeh_ship_yw" as "PUB_oe_head_oeh_ship_yw", "PUB_oe_head"."oeh_shipping_loc" as "PUB_oe_head_oeh_shipping_loc", "PUB_oe_head"."oeh_shp_date" as "PUB_oe_head_oeh_shp_date", "PUB_oe_head"."oeh_shp_inst" as "PUB_oe_head_oeh_shp_inst", "PUB_oe_head"."oeh_shp_week" as "PUB_oe_head_oeh_shp_week", "PUB_oe_head"."oeh_spec" as "PUB_oe_head_oeh_spec", "PUB_oe_head"."oeh_state" as "PUB_oe_head_oeh_state", "PUB_oe_head"."oeh_status" as "PUB_oe_head_oeh_status", "PUB_oe_head"."oeh_tag_exchange" as "PUB_oe_head_oeh_tag_exchange", "PUB_oe_head"."oeh_tags" as "PUB_oe_head_oeh_tags", "PUB_oe_head"."oeh_tracking_no" as "PUB_oe_head_oeh_tracking_no", "PUB_oe_head"."oeh_type" as "PUB_oe_head_oeh_type", "PUB_oe_head"."oeh_units" as "PUB_oe_head_oeh_units", "PUB_oe_head"."oeh_vol_type" as "PUB_oe_head_oeh_vol_type", "PUB_oe_head"."oeh_volume" as "PUB_oe_head_oeh_volume", "PUB_oe_head"."oeh_weight" as "PUB_oe_head_oeh_weight", "PUB_oe_head"."oeh_zipcode" as "PUB_oe_head_oeh_zipcode", "PUB_oe_head"."orig_exp_date" as "PUB_oe_head_orig_exp_date", "PUB_oe_head"."orig_exp_time" as "PUB_oe_head_orig_exp_time", "PUB_oe_head"."orig_load_seq" as "PUB_oe_head_orig_load_seq", "PUB_oe_head"."posted_exchange_rate" as "PUB_oe_head_posted_exchange_rate", "PUB_oe_head"."reas_code" as "PUB_oe_head_reas_code", "PUB_oe_head"."ship_desc" as "PUB_oe_head_ship_desc", "PUB_oe_head"."ship_to" as "PUB_oe_head_ship_to", "PUB_oe_head"."shp_via" as "PUB_oe_head_shp_via", "PUB_oe_head"."tax_code" as "PUB_oe_head_tax_code", "PUB_oe_head"."term_code" as "PUB_oe_head_term_code", "PUB_oe_head"."v_number" as "PUB_oe_head_v_number", "PUB_oe_line"."blnk_po_no" as "PUB_oe_line_blnk_po_no", "PUB_oe_line"."box_id" as "PUB_oe_line_box_id", "PUB_oe_line"."con_code" as "PUB_oe_line_con_code", "PUB_oe_line"."contract_no" as "PUB_oe_line_contract_no", "PUB_oe_line"."cust_item_sku" as "PUB_oe_line_cust_item_sku", "PUB_oe_line"."cust_no" as "PUB_oe_line_cust_no", "PUB_oe_line"."edi_ship_to" as "PUB_oe_line_edi_ship_to", "PUB_oe_line"."frm_number" as "PUB_oe_line_frm_number", "PUB_oe_line"."genera_id" as "PUB_oe_line_genera_id", "PUB_oe_line"."gift_message" as "PUB_oe_line_gift_message", "PUB_oe_line"."last_ack_price" as "PUB_oe_line_last_ack_price", "PUB_oe_line"."last_ack_qty" as "PUB_oe_line_last_ack_qty", "PUB_oe_line"."loc_no" as "PUB_oe_line_loc_no", "PUB_oe_line"."matl_no" as "PUB_oe_line_matl_no", "PUB_oe_line"."oeh_bck_ord" as "PUB_oe_line_oeh_bck_ord", "PUB_oe_line"."oeh_mst_blank" as "PUB_oe_line_oeh_mst_blank", "PUB_oe_line"."oeh_number" as "PUB_oe_line_oeh_number", "PUB_oe_line"."oeh_release" as "PUB_oe_line_oeh_release", "PUB_oe_line"."oeh_type" as "PUB_oe_line_oeh_type", "PUB_oe_line"."oeh_vol_type" as "PUB_oe_line_oeh_vol_type", "PUB_oe_line"."oel_back_flag" as "PUB_oe_line_oel_back_flag", "PUB_oe_line"."oel_bck_rel" as "PUB_oe_line_oel_bck_rel", "PUB_oe_line"."oel_bck_seq" as "PUB_oe_line_oel_bck_seq", "PUB_oe_line"."oel_boxes" as "PUB_oe_line_oel_boxes", "PUB_oe_line"."oel_broker_seq" as "PUB_oe_line_oel_broker_seq", "PUB_oe_line"."oel_cmp_flag" as "PUB_oe_line_oel_cmp_flag", "PUB_oe_line"."oel_com_type" as "PUB_oe_line_oel_com_type", "PUB_oe_line"."oel_comment" as "PUB_oe_line_oel_comment", "PUB_oe_line"."oel_con_back" as "PUB_oe_line_oel_con_back", "PUB_oe_line"."oel_con_ord" as "PUB_oe_line_oel_con_ord", "PUB_oe_line"."oel_con_rel" as "PUB_oe_line_oel_con_rel", "PUB_oe_line"."oel_con_req" as "PUB_oe_line_oel_con_req", "PUB_oe_line"."oel_con_ship" as "PUB_oe_line_oel_con_ship", "PUB_oe_line"."oel_desc" as "PUB_oe_line_oel_desc", "PUB_oe_line"."oel_edi_item" as "PUB_oe_line_oel_edi_item", "PUB_oe_line"."oel_eod" as "PUB_oe_line_oel_eod", "PUB_oe_line"."oel_extra" as "PUB_oe_line_oel_extra", "PUB_oe_line"."oel_filler1" as "PUB_oe_line_oel_filler1", "PUB_oe_line"."oel_filler2" as "PUB_oe_line_oel_filler2", "PUB_oe_line"."oel_from_blanket" as "PUB_oe_line_oel_from_blanket", "PUB_oe_line"."oel_inv_date" as "PUB_oe_line_oel_inv_date", "PUB_oe_line"."oel_license" as "PUB_oe_line_oel_license", "PUB_oe_line"."oel_partial" as "PUB_oe_line_oel_partial", "PUB_oe_line"."oel_price" as "PUB_oe_line_oel_price", "PUB_oe_line"."oel_price_type" as "PUB_oe_line_oel_price_type", "PUB_oe_line"."oel_qty_back" as "PUB_oe_line_oel_qty_back", "PUB_oe_line"."oel_qty_ord" as "PUB_oe_line_oel_qty_ord", "PUB_oe_line"."oel_qty_rel" as "PUB_oe_line_oel_qty_rel", "PUB_oe_line"."oel_qty_ship" as "PUB_oe_line_oel_qty_ship", "PUB_oe_line"."oel_re_ship" as "PUB_oe_line_oel_re_ship", "PUB_oe_line"."oel_rel_from" as "PUB_oe_line_oel_rel_from", "PUB_oe_line"."oel_req_status" as "PUB_oe_line_oel_req_status", "PUB_oe_line"."oel_reship_qty" as "PUB_oe_line_oel_reship_qty", "PUB_oe_line"."oel_seq" as "PUB_oe_line_oel_seq", "PUB_oe_line"."oel_ship_yw" as "PUB_oe_line_oel_ship_yw", "PUB_oe_line"."oel_shipper_seq" as "PUB_oe_line_oel_shipper_seq", "PUB_oe_line"."oel_shp_date" as "PUB_oe_line_oel_shp_date", "PUB_oe_line"."oel_shp_week" as "PUB_oe_line_oel_shp_week", "PUB_oe_line"."oel_status" as "PUB_oe_line_oel_status", "PUB_oe_line"."oel_sub_con" as "PUB_oe_line_oel_sub_con", "PUB_oe_line"."oel_sub_date" as "PUB_oe_line_oel_sub_date", "PUB_oe_line"."oel_sub_flag" as "PUB_oe_line_oel_sub_flag", "PUB_oe_line"."oel_sub_item" as "PUB_oe_line_oel_sub_item", "PUB_oe_line"."oel_sub_yw" as "PUB_oe_line_oel_sub_yw", "PUB_oe_line"."oel_tag_exchange" as "PUB_oe_line_oel_tag_exchange", "PUB_oe_line"."oel_tags" as "PUB_oe_line_oel_tags", "PUB_oe_line"."oel_um" as "PUB_oe_line_oel_um", "PUB_oe_line"."oel_um_qty" as "PUB_oe_line_oel_um_qty", "PUB_oe_line"."oel_units_suspend" as "PUB_oe_line_oel_units_suspend", "PUB_oe_line"."oel_vol_levl" as "PUB_oe_line_oel_vol_levl", "PUB_oe_line"."oel_warning" as "PUB_oe_line_oel_warning", "PUB_oe_line"."p_number" as "PUB_oe_line_p_number", "PUB_oe_line"."po_confirm" as "PUB_oe_line_po_confirm", "PUB_oe_line"."prd_line" as "PUB_oe_line_prd_line", "PUB_oe_line"."price_cd" as "PUB_oe_line_price_cd", "PUB_oe_line"."promo_code" as "PUB_oe_line_promo_code", "PUB_oe_line"."qty_per_box" as "PUB_oe_line_qty_per_box", "PUB_oe_line"."reas_code" as "PUB_oe_line_reas_code", "PUB_oe_line"."ship_to" as "PUB_oe_line_ship_to", "PUB_oe_line"."type_code" as "PUB_oe_line_type_code", "PUB_oe_line"."upc_code" as "PUB_oe_line_upc_code", "PUB_oe_line"."v_number" as "PUB_oe_line_v_number", "PUB_oe_line"."vol_code" as "PUB_oe_line_vol_code", "PUB_prod_line"."cst_cat" as "PUB_prod_line_cst_cat", "PUB_prod_line"."prd_cogs_account" as "PUB_prod_line_prd_cogs_account", "PUB_prod_line"."prd_credit_acct" as "PUB_prod_line_prd_credit_acct", "PUB_prod_line"."prd_desc" as "PUB_prod_line_prd_desc", "PUB_prod_line"."prd_e_week" as "PUB_prod_line_prd_e_week", "PUB_prod_line"."prd_early" as "PUB_prod_line_prd_early", "PUB_prod_line"."prd_exp_acct" as "PUB_prod_line_prd_exp_acct", "PUB_prod_line"."prd_inv_asset_acct" as "PUB_prod_line_prd_inv_asset_acct", "PUB_prod_line"."prd_line" as "PUB_prod_line_prd_line", "PUB_prod_line"."prd_prc_en" as "PUB_prod_line_prd_prc_en", "PUB_prod_line"."prd_prc_st" as "PUB_prod_line_prd_prc_st", "PUB_prod_line"."prd_prc_year" as "PUB_prod_line_prd_prc_year", "PUB_prod_line"."prd_roy_acct" as "PUB_prod_line_prd_roy_acct", "PUB_prod_line"."prd_roy_cat" as "PUB_prod_line_prd_roy_cat", "PUB_prod_line"."prd_s_week" as "PUB_prod_line_prd_s_week", "PUB_prod_line"."prd_sal_acct" as "PUB_prod_line_prd_sal_acct", "PUB_prod_line"."prd_sea_en" as "PUB_prod_line_prd_sea_en", "PUB_prod_line"."prd_sea_st" as "PUB_prod_line_prd_sea_st", "PUB_prod_line"."prd_seasons" as "PUB_prod_line_prd_seasons", "PUB_prod_line"."prd_status" as "PUB_prod_line_prd_status", "PUB_prod_line"."prd_type" as "PUB_prod_line_prd_type", "PUB_prod_line"."prd_wip_account" as "PUB_prod_line_prd_wip_account", "PUB_prod_line"."prod_e_ship" as "PUB_prod_line_prod_e_ship", "PUB_prod_line"."prod_s_ship" as "PUB_prod_line_prod_s_ship", "PUB_shipto"."cart_id" as "PUB_shipto_cart_id", "PUB_shipto"."cht_country" as "PUB_shipto_cht_country", "PUB_shipto"."contact_code" as "PUB_shipto_contact_code", "PUB_shipto"."delivery_close_time" as "PUB_shipto_delivery_close_time", "PUB_shipto"."delivery_min_time" as "PUB_shipto_delivery_min_time", "PUB_shipto"."delivery_open_time" as "PUB_shipto_delivery_open_time", "PUB_shipto"."internal_contact_code" as "PUB_shipto_internal_contact_code", "PUB_shipto"."ship_to" as "PUB_shipto_ship_to", "PUB_shipto"."shipping_loc" as "PUB_shipto_shipping_loc", "PUB_shipto"."shp_via" as "PUB_shipto_shp_via", "PUB_shipto"."shp_via_2" as "PUB_shipto_shp_via_2", "PUB_shipto"."sht_added" as "PUB_shipto_sht_added", "PUB_shipto"."sht_address1" as "PUB_shipto_sht_address1", "PUB_shipto"."sht_address2" as "PUB_shipto_sht_address2", "PUB_shipto"."sht_airport" as "PUB_shipto_sht_airport", "PUB_shipto"."sht_alt_no" as "PUB_shipto_sht_alt_no", "PUB_shipto"."sht_attention" as "PUB_shipto_sht_attention", "PUB_shipto"."sht_cell" as "PUB_shipto_sht_cell", "PUB_shipto"."sht_city" as "PUB_shipto_sht_city", "PUB_shipto"."sht_declared" as "PUB_shipto_sht_declared", "PUB_shipto"."sht_def_frt" as "PUB_shipto_sht_def_frt", "PUB_shipto"."sht_direct" as "PUB_shipto_sht_direct", "PUB_shipto"."sht_email" as "PUB_shipto_sht_email", "PUB_shipto"."sht_fax" as "PUB_shipto_sht_fax", "PUB_shipto"."sht_filler1" as "PUB_shipto_sht_filler1", "PUB_shipto"."sht_instr" as "PUB_shipto_sht_instr", "PUB_shipto"."sht_last_act" as "PUB_shipto_sht_last_act", "PUB_shipto"."sht_lat" as "PUB_shipto_sht_lat", "PUB_shipto"."sht_leave_racks" as "PUB_shipto_sht_leave_racks", "PUB_shipto"."sht_length_limit" as "PUB_shipto_sht_length_limit", "PUB_shipto"."sht_long" as "PUB_shipto_sht_long", "PUB_shipto"."sht_mailing_alt_no" as "PUB_shipto_sht_mailing_alt_no", "PUB_shipto"."sht_name" as "PUB_shipto_sht_name", "PUB_shipto"."sht_notify" as "PUB_shipto_sht_notify", "PUB_shipto"."sht_notify_ASN" as "PUB_shipto_sht_notify_ASN", "PUB_shipto"."sht_notify_ack" as "PUB_shipto_sht_notify_ack", "PUB_shipto"."sht_notify_back" as "PUB_shipto_sht_notify_back", "PUB_shipto"."sht_notify_bol" as "PUB_shipto_sht_notify_bol", "PUB_shipto"."sht_notify_ePicasemail" as "PUB_shipto_sht_notify_ePicasemai", "PUB_shipto"."sht_notify_options" as "PUB_shipto_sht_notify_options", "PUB_shipto"."sht_notify_sub" as "PUB_shipto_sht_notify_sub", "PUB_shipto"."sht_phone" as "PUB_shipto_sht_phone", "PUB_shipto"."sht_phone_ext" as "PUB_shipto_sht_phone_ext", "PUB_shipto"."sht_region" as "PUB_shipto_sht_region", "PUB_shipto"."sht_require_lift" as "PUB_shipto_sht_require_lift", "PUB_shipto"."sht_residential" as "PUB_shipto_sht_residential", "PUB_shipto"."sht_seq" as "PUB_shipto_sht_seq", "PUB_shipto"."sht_shipping_loc" as "PUB_shipto_sht_shipping_loc", "PUB_shipto"."sht_state" as "PUB_shipto_sht_state", "PUB_shipto"."sht_status" as "PUB_shipto_sht_status", "PUB_shipto"."sht_subs" as "PUB_shipto_sht_subs", "PUB_shipto"."sht_vol" as "PUB_shipto_sht_vol", "PUB_shipto"."sht_weight_limit" as "PUB_shipto_sht_weight_limit", "PUB_shipto"."sht_work_order" as "PUB_shipto_sht_work_order", "PUB_shipto"."sht_zip" as "PUB_shipto_sht_zip", "PUB_shipto"."sht_zone" as "PUB_shipto_sht_zone", "PUB_shipto"."sig_required" as "PUB_shipto_sig_required", "load_file"."dist_id" as "load_file_dist_id", "load_file"."ld_app_by" as "load_file_ld_app_by", "load_file"."ld_app_date" as "load_file_ld_app_date", "load_file"."ld_charge_after" as "load_file_ld_charge_after", "load_file"."ld_crossref" as "load_file_ld_crossref", "load_file"."ld_date" as "load_file_ld_date", "load_file"."ld_driver" as "load_file_ld_driver", "load_file"."ld_drop_rate" as "load_file_ld_drop_rate", "load_file"."ld_drops" as "load_file_ld_drops", "load_file"."ld_exp" as "load_file_ld_exp", "load_file"."ld_filler1" as "load_file_ld_filler1", "load_file"."ld_filler2" as "load_file_ld_filler2", "load_file"."ld_filler3" as "load_file_ld_filler3", "load_file"."ld_fuel_add_calc" as "load_file_ld_fuel_add_calc", "load_file"."ld_fuel_surchg" as "load_file_ld_fuel_surchg", "load_file"."ld_max_carts" as "load_file_ld_max_carts", "load_file"."ld_miles" as "load_file_ld_miles", "load_file"."ld_notes" as "load_file_ld_notes", "load_file"."ld_other" as "load_file_ld_other", "load_file"."ld_rack_rate" as "load_file_ld_rack_rate", "load_file"."ld_rate" as "load_file_ld_rate", "load_file"."ld_region_rate" as "load_file_ld_region_rate", "load_file"."ld_return_date" as "load_file_ld_return_date", "load_file"."ld_return_time" as "load_file_ld_return_time", "load_file"."ld_returned_racks" as "load_file_ld_returned_racks", "load_file"."ld_round_trip" as "load_file_ld_round_trip", "load_file"."ld_sales" as "load_file_ld_sales", "load_file"."ld_status" as "load_file_ld_status", "load_file"."ld_time" as "load_file_ld_time", "load_file"."ld_tractor" as "load_file_ld_tractor", "load_file"."ld_unload_fee" as "load_file_ld_unload_fee", "load_file"."ld_yw" as "load_file_ld_yw", "load_file"."load_grower" as "load_file_load_grower", "load_file"."load_number" as "load_file_load_number", "load_file"."load_prefix" as "load_file_load_prefix", "load_file"."poh_number" as "load_file_poh_number", "load_file"."poh_release" as "load_file_poh_release", "load_file"."shipping_loc" as "load_file_shipping_loc", "load_file"."v_number" as "load_file_v_number", "materials"."loc_no" as "materials_loc_no", "materials"."matl_avg_cst" as "materials_matl_avg_cst", "materials"."matl_cost" as "materials_matl_cost", "materials"."matl_cycl_cd" as "materials_matl_cycl_cd", "materials"."matl_cycl_dt" as "materials_matl_cycl_dt", "materials"."matl_desc" as "materials_matl_desc", "materials"."matl_en_week" as "materials_matl_en_week", "materials"."matl_forms" as "materials_matl_forms", "materials"."matl_image" as "materials_matl_image", "materials"."matl_inv" as "materials_matl_inv", "materials"."matl_large_image" as "materials_matl_large_image", "materials"."matl_limit_extra" as "materials_matl_limit_extra", "materials"."matl_no" as "materials_matl_no", "materials"."matl_on_hnd" as "materials_matl_on_hnd", "materials"."matl_on_ord" as "materials_matl_on_ord", "materials"."matl_per_box" as "materials_matl_per_box", "materials"."matl_per_rack" as "materials_matl_per_rack", "materials"."matl_price" as "materials_matl_price", "materials"."matl_qty_per" as "materials_matl_qty_per", "materials"."matl_reorder" as "materials_matl_reorder", "materials"."matl_st_week" as "materials_matl_st_week", "materials"."matl_status" as "materials_matl_status", "materials"."matl_taxable" as "materials_matl_taxable", "materials"."matl_thumb_image" as "materials_matl_thumb_image", "materials"."matl_typ_cd" as "materials_matl_typ_cd", "materials"."matl_type" as "materials_matl_type", "materials"."matl_u_m" as "materials_matl_u_m", "materials"."prd_line" as "materials_prd_line", "materials"."price_cd" as "materials_price_cd", "materials"."price_cd2" as "materials_price_cd2", "materials"."price_cd_starts" as "materials_price_cd_starts", "materials"."sub_code" as "materials_sub_code", "materials"."vol_code" as "materials_vol_code", "truck_file"."cost_per_drop" as "truck_file_cost_per_drop", "truck_file"."cost_per_hour" as "truck_file_cost_per_hour", "truck_file"."cost_per_mile" as "truck_file_cost_per_mile", "truck_file"."dist_id" as "truck_file_dist_id", "truck_file"."trk_box" as "truck_file_trk_box", "truck_file"."trk_code" as "truck_file_trk_code", "truck_file"."trk_desc" as "truck_file_trk_desc", "truck_file"."trk_filler1" as "truck_file_trk_filler1", "truck_file"."trk_filler2" as "truck_file_trk_filler2", "truck_file"."trk_length" as "truck_file_trk_length", "truck_file"."trk_lift_gate" as "truck_file_trk_lift_gate", "truck_file"."trk_one_way" as "truck_file_trk_one_way", "truck_file"."trk_rack" as "truck_file_trk_rack", "truck_file"."trk_seq" as "truck_file_trk_seq", "truck_file"."trk_size" as "truck_file_trk_size", "truck_file"."trk_units" as "truck_file_trk_units", "truck_file"."trk_vol" as "truck_file_trk_vol", "truck_file"."trk_weight" as "truck_file_trk_weight", "truck_file"."trk_width" as "truck_file_trk_width", "truck_file"."v_number" as "truck_file_v_number" from "oe_line" "PUB_oe_line" left outer join "container" "PUB_container" on ("PUB_oe_line"."con_code" = "PUB_container"."con_code") left outer join "prod_line" "PUB_prod_line" on ("PUB_oe_line"."prd_line" = "PUB_prod_line"."prd_line") inner join "oe_head" "PUB_oe_head" on ("PUB_oe_line"."oeh_number" = "PUB_oe_head"."oeh_number" and "PUB_oe_line"."oeh_release" = "PUB_oe_head"."oeh_release") left outer join "customer" "PUB_customer" on ("PUB_oe_head"."cust_no" = "PUB_customer"."cust_no") left outer join "shipto" "PUB_shipto" on ("PUB_oe_head"."ship_to" = "PUB_shipto"."ship_to") left outer join "load_file" on ("PUB_oe_head"."oeh_load_no" = "load_file"."load_number") left outer join "truck_file" on ("load_file"."ld_tractor" = "truck_file"."trk_code") left outer join "materials" on ("PUB_oe_line"."upc_code" = "materials"."matl_no") where ("PUB_oe_head"."oeh_ship_yw" > 201501) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:528) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:297) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:169) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:156) ... 1 more Caused by: java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Table/view/synonynm "SYSPROGRESS.oe_line" cannot be found. (15814) at com.ddtek.jdbc.openedge.client.dde.ac(Unknown Source) at com.ddtek.jdbc.openedge.client.dde.ab(Unknown Source) at com.ddtek.jdbc.openedge.ddf.a(Unknown Source) at com.ddtek.jdbc.openedgebase.ddc_.b(Unknown Source) at com.ddtek.jdbc.openedgebase.ddde.a(Unknown Source) at com.ddtek.jdbc.openedgebase.ddek.b(Unknown Source) at com.ddtek.jdbc.openedgebase.ddde.a(Unknown Source) at com.ddtek.jdbc.openedgebase.ddp.a(Unknown Source) at com.ddtek.jdbc.openedgebase.BaseConnection.prepareStatement(Unknown Source) at com.ddtek.jdbc.openedgebase.BaseConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:384) ... 4 more[/code]

Copyright © 2005-2017 TIBCO Software Inc.

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...