请选择 进入手机版 | 继续访问电脑版
麦粉社区
>
帖子详情

数据库连接正常,新建报表预览报错

数据连接 发表于 2020-4-9 17:40
发表于 2020-4-9 17:40:43
数据源选关系型数据库,测试连接正常,并能已经导入数据表,预览数据正常。

但原生SQL查询和透视分析的时候,预览都报错,报错信息如下:

连接池初始化失败
at smartbi.freequery.querydata.store.DBSQLResultStore.createConnection(DBSQLResultStore.java:5982)
at smartbi.freequery.querydata.store.DBSQLResultStore.getCurrentConnection(DBSQLResultStore.java:6199)
at smartbi.freequery.querydata.store.DBSQLResultStore.executeInDatabaseInner(DBSQLResultStore.java:1811)
at smartbi.freequery.querydata.store.DBSQLResultStore.executeInDatabase(DBSQLResultStore.java:1672)
at smartbi.freequery.querydata.store.DBSQLResultStore.ensureGridDataInMemDB(DBSQLResultStore.java:5905)
at smartbi.freequery.querydata.store.DBSQLResultStore.getGridDataInternal(DBSQLResultStore.java:5107)
at smartbi.freequery.querydata.store.SQLResultStore.getGridData(SQLResultStore.java:165)
at smartbi.freequery.querydata.store.SQLResultStore.getGridData(SQLResultStore.java:160)
at smartbi.insight.metadata.BaseInsightBO.getGridDataInCache(BaseInsightBO.java:2099)
at smartbi.insight.metadata.InsightBO.getOriginalData(InsightBO.java:1194)
at smartbi.insight.metadata.InsightBO.getOriginalAndAggregateData(InsightBO.java:987)
at smartbi.insight.metadata.InsightBO.getGridData(InsightBO.java:900)
at smartbi.insight.InsightService.refreshData(InsightService.java:296)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at smartbi.framework.rmi.ClientService.execute(Smartbi:118)
at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:219)
at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:157)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
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 smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:164)
at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:153)
at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:176)
at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:102)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:177)
at smartbi.freequery.filter.Filter.doFilter(Filter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:151)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:59)
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:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:444)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:319)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)


37105e8eecea3ae58.png

发表于 2020-4-9 17:41:18
查了很多资料都找不到解决方法,求助各位大神
回复

使用道具 举报

发表于 2020-4-10 15:16:23
Smartbi的版本是什么?发下截图上来看看。
回复

使用道具 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

2回帖数 0关注人数 2756浏览人数
最后回复于:2020-4-10 15:16
快速回复 返回顶部 返回列表