三月下旬新内容速递丨JVM调优、权限体系与函数进阶

春日渐暖,学习正酣!三月下旬更新聚焦JVM参数实战、权限体系拆解、多种分析法与AI架构入门,助你在数据与技术的融合中持续进阶!


一、场景应用精选

【数析课堂】别只盯着总数!用“结构分析法”一眼看穿业务真相》→跳出总量思维,深入业务结构发现机会。
【旭日图】数据的“家族族谱”与深度透视镜》→通过旭日图展示多层级数据关系,助力钻取分析。
【函数课堂】Fixed 与 Exclude 怎么选?》→场景化讲解函数选择逻辑,告别计算度量困惑。
【数析课堂】分组法:分析师的“分层透视眼”,一眼看穿客户与业务本质》→掌握分组分析法,实现精细化运营洞察。

二、技术经验分享

那些年漏配错配的,JVM参数们》→深入解析JVM常见配置误区,提升系统性能与稳定性。
别慌!权限体系其实超简单》→轻松掌握权限设计核心逻辑,快速落地数据安全管控。

三、AI知识更新

【AI每日一学】讲一下单Agent架构vs多Agent系统的特征、优点和缺点》→对比单Agent与多Agent系统,为智能体选型提供参考。

四、任务持续上线

【BI知识闯关】那些年漏配错配的,JVM参数们》→通过闯关巩固JVM参数配置要点。
【AI知识巩固】讲一下单Agent架构vs多Agent系统的特征、优点和缺点》→强化AI架构理解,夯实智能体基础知识。
【数析课堂】结构分析法知识巩固》→练习结构分析,掌握业务构成洞察技巧。
【图表应用】旭日图—你的专属“层级解码器”》→实战旭日图绘制,解锁层级数据可视化。
【BI知识闯关】别慌!权限体系其实超简单》→检验权限体系学习成果,提升实战能力。
【函数】Fixed 与 Exclude 怎么选?》→深入辨析两类函数,精准匹配分析场景。
【数析课堂】分组法知识巩固》→强化分层分组思维,提升客户与业务分析效率。

阳春三月,学习正当时,快来社区参与挑战,一起探索数据新视界!

麦粉社区
>
帖子详情

报表预览时报错

其它 发表于 2022-3-8 13:13
发表于 2022-3-8 13:13:49

查询失败:errorMessageMondrian Error:Internal error: Error while looking up jdbcDriver!


errorStackTrace=mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while looking up jdbcDriver!


发表于 2022-3-8 14:00:25
94936226f0ec2a276.png 错误的图片
回复

使用道具 举报

发表于 2022-3-8 15:03:56
看报错是找驱动的时候出错了,可能是数据源没有对应驱动,拖拽的字段是来源数据集之类的?在数据集或者数据源那块预览是正常的不?

回复

使用道具 举报

发表于 2022-3-8 17:06:18
报错那个"显示栈信息"里面的全部报错,发我看看

回复

使用道具 举报

发表于 2022-3-10 11:32:00
查询失败:errorMessageMondrian Error:Internal error: Error while looking up jdbcDriver!
errorStackTrace=mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while looking up jdbcDriver!
        at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1002)
        at mondrian.olap.Util.newInternal(Util.java:2508)
        at mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:428)
        at mondrian.rolap.RolapConnection.(RolapConnection.java:151)
        at mondrian.rolap.RolapConnection.(RolapConnection.java:108)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:113)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:69)
        at mondrian.olap4j.MondrianOlap4jConnection.(MondrianOlap4jConnection.java:164)
        at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.(FactoryJdbc4Plus.java:323)
        at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.(FactoryJdbc41Impl.java:118)
        at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
        at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:97)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at mondrian.xmla.SmartbiQueryServlet.getConnection(SmartbiQueryServlet.java:678)
        at mondrian.xmla.SmartbiQueryServlet.doPost(SmartbiQueryServlet.java:389)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        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)
Caused by: java.lang.ClassNotFoundException: com.kingbase8.Driver
        at mondrian.olap.DynamicLoadLibManager.loadClass(DynamicLoadLibManager.java:390)
        at mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:419)
        ... 36 more

        at smartbix.augmenteddataset.util.AugmentedDataSetException.create(AugmentedDataSetException.java:34)
        at smartbix.augmenteddataset.olap.impl.OlapQueryService.createException(OlapQueryService.java:389)
        at smartbix.augmenteddataset.olap.impl.OlapQueryService.executeQuery(OlapQueryService.java:369)
        at smartbix.augmenteddataset.olap.impl.OlapQueryService$$FastClassBySpringCGLIB$$d01e6225.invoke()
        at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:737)
        at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:672)
        at smartbix.augmenteddataset.olap.impl.OlapQueryService$$EnhancerBySpringCGLIB$$a0783ac5.executeQuery()
        at smartbix.augmenteddataset.query.mondrian.MondrianQueryExecutor.getData(MondrianQueryExecutor.java:33)
        at smartbix.augmenteddataset.service.AugmentedDataSetQueryService.getDataSetData(AugmentedDataSetQueryService.java:165)
        at smartbix.augmenteddataset.service.AugmentedDataSetQueryService$$FastClassBySpringCGLIB$$3c7d00ce.invoke()
        at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:737)
        at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:672)
        at smartbix.augmenteddataset.service.AugmentedDataSetQueryService$$EnhancerBySpringCGLIB$$9172fb67.getDataSetData()
        at smartbix.smartbi.AugmentedDataSetForVModule.getDataSetData(AugmentedDataSetForVModule.java:557)
        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.cp.a(Smartbi:61)
        at smartbi.spreadsheetreport.core.GridDataFactory$a.a(Smartbi:434)
        at smartbi.spreadsheetreport.core.GridDataFactory$a.b(Smartbi:208)
        at smartbi.spreadsheetreport.core.GridDataFactory$a.a(Smartbi:172)
        at smartbi.spreadsheetreport.core.GridDataFactory$a.call(Smartbi:117)
        at smartbi.freequery.client.simplereport.JobService$1.call(JobService.java:74)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
        Suppressed: java.lang.RuntimeException: errorMessageMondrian Error:Internal error: Error while looking up jdbcDriver!
errorStackTrace=mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while looking up jdbcDriver!
        at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1002)
        at mondrian.olap.Util.newInternal(Util.java:2508)
        at mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:428)
        at mondrian.rolap.RolapConnection.(RolapConnection.java:151)
        at mondrian.rolap.RolapConnection.(RolapConnection.java:108)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:113)
        at mondrian.olap.DriverManager.getConnection(DriverManager.java:69)
        at mondrian.olap4j.MondrianOlap4jConnection.(MondrianOlap4jConnection.java:164)
        at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.(FactoryJdbc4Plus.java:323)
        at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.(FactoryJdbc41Impl.java:118)
        at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
        at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:97)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at mondrian.xmla.SmartbiQueryServlet.getConnection(SmartbiQueryServlet.java:678)
        at mondrian.xmla.SmartbiQueryServlet.doPost(SmartbiQueryServlet.java:389)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        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)
Caused by: java.lang.ClassNotFoundException: com.kingbase8.Driver
        at mondrian.olap.DynamicLoadLibManager.loadClass(DynamicLoadLibManager.java:390)
        at mondrian.rolap.RolapConnection.createDataSource(RolapConnection.java:419)
        ... 36 more

                at smartbix.augmenteddataset.olap.impl.OlapQueryService.throwRequestFailException(OlapQueryService.java:611)
                at smartbix.augmenteddataset.olap.impl.OlapQueryService.executeQuery(OlapQueryService.java:366)
                ... 33 more
回复

使用道具 举报

发表于 2022-3-10 13:38:53
数据库连的是kingbase?把数据源那里怎么写的截图看下

回复

使用道具 举报

发表于 2022-3-10 15:03:13
数据源的配置
回复

使用道具 举报

发表于 2022-3-10 15:03:55
462176229a2d5e7237.png
  •   打工人的一天
    kingbase8的驱动本身产品是不带的,你使用的smartbi版本是什么时候的?
    获取版本信息可以查看:https://wiki.smartbi.com.cn/pages/viewpage.action?pageId=76679842
    
    如果V95以上的,可以查看这个文档添加驱动测试验证:https://wiki.smartbi.com.cn/pages/viewpage.action?pageId=76677820
    
    另外确认驱动类 com.kingbase8.Driver 是否能成功加载可以参考文档进行确认是否能找到匹配的驱动:https://wiki.smartbi.com.cn/pages/viewpage.action?pageId=44500299
    2022-3-21 18:05| 回复

回复

使用道具 举报

发表于 2022-3-21 18:04:46
本帖最后由 月 于 2022-3-23 09:25 编辑

https://wiki.smartbi.com.cn/pages/viewpage.action?pageId=76677820你看看这个~

回复

使用道具 举报

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

14回帖数 0关注人数 3659浏览人数
最后回复于:2022-3-21 18:04

社区

指南

AI

搜索

快速回复 返回顶部 返回列表