数据库查询时延导致的报错

我是社区第81826位番薯,欢迎点我头像关注我哦~

发表于 2018-10-22 18:14:47
java.lang.RuntimeException: 错误代码:11300001 数据集配置错误<br>Query:<br>ORA-01013: 用户请求取消当前的操作<br><br> at com.fr.report.core.A.J.dealWithBEDSColumn(Unknown Source)<br> at com.fr.report.core.A.m.cc_ce_array(Unknown Source)<br> at com.fr.report.core.A.J.A(Unknown Source)<br> at com.fr.report.core.A.J.A(Unknown Source)<br> at com.fr.report.core.A.J.A(Unknown Source)<br> at com.fr.report.core.A.J.A(Unknown Source)<br> at com.fr.report.core.A.J.A(Unknown Source)<br> at com.fr.report.core.A.J.C(Unknown Source)<br> at com.fr.report.core.A.J.execute4Expand(Unknown Source)<br> at com.fr.report.core.A.J.execute(Unknown Source)<br> at com.fr.report.worksheet.WorkSheet.execute(Unknown Source)<br> at com.fr.report.core.sheet.AbstractWorkBookExecutor._execute(Unknown Source)<br> at com.fr.report.core.sheet.AbstractWorkBookExecutor.execute(Unknown Source)<br> at com.fr.main.impl.WorkBook.execute(Unknown Source)<br> at com.fr.main.impl.WorkBook.execute(Unknown Source)<br> at com.fr.web.cache.ReportCache.getResultWorkBook(Unknown Source)<br> at com.fr.stable.PageActor.getResultBookFromCacheIfNeed(Unknown Source)<br> at com.fr.main.impl.WorkBookTemplateDelegate.execute(Unknown Source)<br> at com.fr.web.core.ReportSessionIDInfor.execute$original$1nNGCsdU(Unknown Source)<br> at com.fr.web.core.ReportSessionIDInfor.execute$original$1nNGCsdU$accessor$zQy70kuO(Unknown Source)<br> at com.fr.web.core.ReportSessionIDInfor$auxiliary$6x74GzfH.call(Unknown Source)<br> at com.fr.intelli.metrics.MonitorInterceptor.intercept(Unknown Source)<br> at com.fr.web.core.ReportSessionIDInfor.execute(Unknown Source)<br> at com.fr.web.core.ReportSessionIDInfor.initBook2Show(Unknown Source)<br> at com.fr.web.core.ReportSessionIDInfor.getWorkBook2Show(Unknown Source)<br> at com.fr.plugin.reportfit.ReportFitImpl.getResultWorkBook(Unknown Source)<br> at com.fr.web.core.ReportSessionIDInfor.getResultWorkBook(Unknown Source)<br> at com.fr.web.core.ReportSessionIDInfor.createPageSetChain(Unknown Source)<br> at com.fr.web.core.ReportSessionIDInfor.getReportPage(Unknown Source)<br> at com.fr.web.core.B.KB.A(Unknown Source)<br> at com.fr.web.core.B.KB.A(Unknown Source)<br> at com.fr.web.core.B.CB.A(Unknown Source)<br> at com.fr.web.core.B.ZA.actionCMD(Unknown Source)<br> at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)<br> at com.fr.web.core.WebActionsDispatcher.dealForActionDefaultCmd(Unknown Source)<br> at com.fr.web.core.B.$B.process(Unknown Source)<br> at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source)<br> at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)<br> at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)<br> at com.fr.web.controller.BaseRequestService.preview(Unknown Source)<br> at com.fr.web.controller.ReportRequestService.preview(Unknown Source)<br> at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.lang.reflect.Method.invoke(Method.java:498)<br> at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)<br> at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)<br> at com.fr.third.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)<br> at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:747)<br> at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:676)<br> at com.fr.third.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)<br> at com.fr.third.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)<br> at com.fr.third.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)<br> at com.fr.third.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)<br> at com.fr.third.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)<br> at com.fr.third.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)<br> at com.fr.third.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)<br> at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)<br> at com.fr.decision.base.DecisionServletInitializer$4.doFilter(Unknown Source)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)<br> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)<br> at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)<br> at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)<br> at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)<br> at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)<br> at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)<br> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)<br> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)<br> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)<br> at java.lang.Thread.run(Thread.java:748)<br>Caused by: com.fr.general.data.TableDataException: 错误代码:11300001 数据集配置错误<br>Query:<br>ORA-01013: 用户请求取消当前的操作<br><br> at com.fr.data.impl.AbstractDBDataModel.initConnectionAndResultAndCheckInColumns(Unknown Source)<br> at com.fr.data.impl.AbstractDBDataModel.getColumnCount(Unknown Source)<br> at com.fr.data.index.AbstractIndexDataModel.getColumnCount(Unknown Source)<br> ... 82 more<br>Caused by: java.sql.SQLException: ORA-01013: 用户请求取消当前的操作<br><br> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)<br> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)<br> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)<br> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)<br> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)<br> at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:956)<br> at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1061)<br> at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:840)<br> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1125)<br> at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)<br> at com.fr.third.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:140)<br> at com.fr.data.core.db.dialect.base.key.create.executequery.DialectExecuteQueryKey.execute(Unknown Source)<br> at com.fr.data.core.db.dialect.base.key.create.executequery.DialectExecuteQueryKey.execute(Unknown Source)<br> at com.fr.data.core.db.dialect.AbstractDialect.execute(Unknown Source)<br> at com.fr.data.core.db.dialect.DefaultDialect.executeQuery(Unknown Source)<br> ... 85 more<br>
发表于 2018-10-22 18:29:35
语句在哪里???可以贴出来看下
发表于 2018-10-23 10:06:34
和语句没关系,我加了子句把查询时间缩短后,就好了
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

3回帖数 1关注人数 4429浏览人数
最后回复于:2018-10-23 10:06

返回顶部 返回列表