麦粉社区
>
帖子详情

自助数据集开发自助仪表盘出错

电子表格 发表于 2021-6-21 11:51
发表于 2021-6-21 11:51:41
8662660d00baad676b.png
如上图我新建[backcolor=rgba(30, 149, 193, 0.3)]原生SQL数据集(带参数)
7942560d00c3727352.png
1254560d00c4fe51ac.png
然后自助数据集使用[backcolor=rgba(30, 149, 193, 0.3)]原生SQL数据集.目前都看可以看到数据
4789960d00c8349002.png
使用数据集建自助仪表盘的时候报错
4066760d00cc528afa.png
请问是怎么回事?
[backcolor=rgba(30, 149, 193, 0.3)]

发表于 2021-6-22 10:19:21
我也是,预览数据可以看到,但是抽取数据会报错,什么SQL错误,连选一个表什么都不做直接抽取都报这个错。你这个应该是没有抽取数据吧

回复

使用道具 举报

发表于 2021-6-22 18:49:09
抽取未完成或抽取失败,是因为这个数据集是要抽取的,但是实际没有抽取成功。而预览数据集不一定会执行抽取。到数据集监控管理中,重新抽取该数据集。如抽取成功,查看报表是否还报错。如还未成功,发送相关日志,这边做进一步分析。
数据集监控管理具体操作可参考Wiki文档:https://wiki.smartbi.com.cn/pages/viewpage.action?pageId=40440299
回复

使用道具 举报

发表于 2021-6-24 15:34:50
zhudanyan 发表于 2021-6-22 18:49
抽取未完成或抽取失败,是因为这个数据集是要抽取的,但是实际没有抽取成功。而预览数据集不一定会执行抽取 ...

抽取也报这个错,怎么定义需不需要抽取呀,我不想抽取的。

抽取错误日志如下:
java.util.concurrent.ExecutionException: smartbix.SmartbiXException: 抽取未完成或抽取失败: 从数据库查询结果集失败
org.hibernate.LazyInitializationException: could not initialize proxy - the owning Session was closed
        at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:60)
        at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:111)
        at org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:140)
        at smartbi.catalogtree.ResourceTreeNode$$EnhancerByCGLIB$$9ace977a.getType(<generated>)
        at smartbi.catalogtree.ResourcePermissionBO.accessible(ResourcePermissionBO.java:344)
        at smartbi.catalogtree.CatalogTreeModule.isAccessibleInternal(CatalogTreeModule.java:4420)
        at smartbi.catalogtree.CatalogTreeModule.isAccessibleIgnoreParent(CatalogTreeModule.java:4358)
        at smartbi.catalogtree.CatalogTreeModule.getCatalogElementById(CatalogTreeModule.java:502)
        at smartbi.catalogtree.CatalogTreeModule.getCatalogElementById(CatalogTreeModule.java:82)
        at smartbi.freequery.metadata.RawSqlQuery.splitExp(RawSqlQuery.java:162)
        at smartbi.freequery.metadata.RawSqlQuery.setExpressionText(RawSqlQuery.java:274)
        at smartbi.freequery.metadata.BusinessViewBO.runRawSqlQuery(BusinessViewBO.java:294)
        at smartbi.freequery.report.OltpParamValueProvider.getParamDefaultValue(OltpParamValueProvider.java:889)
        at smartbi.param.ParameterPanel.getParamDefaultValue(ParameterPanel.java:137)
        at smartbi.param.ParameterPanelService.getParamDefaultValue(ParameterPanelService.java:344)
        at smartbi.freequery.client.simplereport.ClientReportService.initFromBizViewAddition(ClientReportService.java:427)
        at smartbi.freequery.client.simplereport.ClientReportService.initFromBizViewEx(ClientReportService.java:458)
        at smartbix.smartbi.BusinessViewCacheExtractor.getDataIterator(BusinessViewCacheExtractor.java:193)
        at smartbix.dataprocess.node.save2db.SmartbiCacheExtractor.extractDbTable(SmartbiCacheExtractor.java:526)
        at smartbix.dataprocess.node.save2db.SmartbiCacheExtractor.export(SmartbiCacheExtractor.java:222)
        at smartbix.dataprocess.node.save2db.SmartbiCacheExtractor$$FastClassBySpringCGLIB$$1b18a29a.invoke(<generated>)
        at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:736)
        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:671)
        at smartbix.smartbi.BusinessViewCacheExtractor$$EnhancerBySpringCGLIB$$fbced7fb.export(<generated>)
        at smartbix.smartbi.SmartbiDataExtractTaskBO.extractInternal(SmartbiDataExtractTaskBO.java:365)
        at smartbix.smartbi.dataset.SmartbiDataSetProvider.extract(SmartbiDataSetProvider.java:385)
        at smartbix.smartbi.dataset.SmartbiTable.setId(SmartbiTable.java:104)
        at smartbix.dataprocess.node.TableNode.executeInternal(TableNode.java:149)
        at smartbix.dataprocess.flow.FlowNode.execute(FlowNode.java:258)
        at smartbix.dataprocess.flow.FlowNode.run(FlowNode.java:215)
        at smartbix.util.ThreadUtil$SubmitRunnable.call(ThreadUtil.java:140)
        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)

        at java.util.concurrent.FutureTask.report(FutureTask.java:122)
        at java.util.concurrent.FutureTask.get(FutureTask.java:192)
        at smartbix.smartbi.SmartbiXDataExtractTaskBO.extract(SmartbiXDataExtractTaskBO.java:145)
        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 org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161)
        at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247)
        at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1701)
        at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:854)
        at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:164)
        at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:426)
        at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3178)
        at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:175)
        at org.mozilla.javascript.Context.evaluateString(Context.java:1111)
        at smartbi.scheduletask.task.TaskBO.execute_v2(TaskBO.java:430)
        at smartbi.scheduletask.task.TaskBO.execute(TaskBO.java:318)
        at smartbi.scheduletask.task.TaskBO.call(TaskBO.java:310)
        at smartbi.scheduletask.runner.JobImpl$1.call(JobImpl.java:316)
        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)
Caused by: smartbix.SmartbiXException: 抽取未完成或抽取失败: 从数据库查询结果集失败
org.hibernate.LazyInitializationException: could not initialize proxy - the owning Session was closed
        at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:60)
        at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:111)
        at org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:140)
        at smartbi.catalogtree.ResourceTreeNode$$EnhancerByCGLIB$$9ace977a.getType(<generated>)
        at smartbi.catalogtree.ResourcePermissionBO.accessible(ResourcePermissionBO.java:344)
        at smartbi.catalogtree.CatalogTreeModule.isAccessibleInternal(CatalogTreeModule.java:4420)
        at smartbi.catalogtree.CatalogTreeModule.isAccessibleIgnoreParent(CatalogTreeModule.java:4358)
        at smartbi.catalogtree.CatalogTreeModule.getCatalogElementById(CatalogTreeModule.java:502)
        at smartbi.catalogtree.CatalogTreeModule.getCatalogElementById(CatalogTreeModule.java:82)
        at smartbi.freequery.metadata.RawSqlQuery.splitExp(RawSqlQuery.java:162)
        at smartbi.freequery.metadata.RawSqlQuery.setExpressionText(RawSqlQuery.java:274)
        at smartbi.freequery.metadata.BusinessViewBO.runRawSqlQuery(BusinessViewBO.java:294)
        at smartbi.freequery.report.OltpParamValueProvider.getParamDefaultValue(OltpParamValueProvider.java:889)
        at smartbi.param.ParameterPanel.getParamDefaultValue(ParameterPanel.java:137)
        at smartbi.param.ParameterPanelService.getParamDefaultValue(ParameterPanelService.java:344)
        at smartbi.freequery.client.simplereport.ClientReportService.initFromBizViewAddition(ClientReportService.java:427)
        at smartbi.freequery.client.simplereport.ClientReportService.initFromBizViewEx(ClientReportService.java:458)
        at smartbix.smartbi.BusinessViewCacheExtractor.getDataIterator(BusinessViewCacheExtractor.java:193)
        at smartbix.dataprocess.node.save2db.SmartbiCacheExtractor.extractDbTable(SmartbiCacheExtractor.java:526)
        at smartbix.dataprocess.node.save2db.SmartbiCacheExtractor.export(SmartbiCacheExtractor.java:222)
        at smartbix.dataprocess.node.save2db.SmartbiCacheExtractor$$FastClassBySpringCGLIB$$1b18a29a.invoke(<generated>)
        at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:736)
        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:671)
        at smartbix.smartbi.BusinessViewCacheExtractor$$EnhancerBySpringCGLIB$$fbced7fb.export(<generated>)
        at smartbix.smartbi.SmartbiDataExtractTaskBO.extractInternal(SmartbiDataExtractTaskBO.java:365)
        at smartbix.smartbi.dataset.SmartbiDataSetProvider.extract(SmartbiDataSetProvider.java:385)
        at smartbix.smartbi.dataset.SmartbiTable.setId(SmartbiTable.java:104)
        at smartbix.dataprocess.node.TableNode.executeInternal(TableNode.java:149)
        at smartbix.dataprocess.flow.FlowNode.execute(FlowNode.java:258)
        at smartbix.dataprocess.flow.FlowNode.run(FlowNode.java:215)
        at smartbix.util.ThreadUtil$SubmitRunnable.call(ThreadUtil.java:140)
        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)

        at smartbix.SmartbiXException.create(SmartbiXException.java:18)
        at smartbix.smartbi.SmartbiDataExtractTaskBO.extractInternal(SmartbiDataExtractTaskBO.java:450)
        at smartbix.smartbi.dataset.SmartbiDataSetProvider.extract(SmartbiDataSetProvider.java:385)
        at smartbix.smartbi.dataset.SmartbiTable.setId(SmartbiTable.java:104)
        at smartbix.dataprocess.node.TableNode.executeInternal(TableNode.java:149)
        at smartbix.dataprocess.flow.FlowNode.execute(FlowNode.java:258)
        at smartbix.dataprocess.flow.FlowNode.run(FlowNode.java:215)
        at smartbix.util.ThreadUtil$SubmitRunnable.call(ThreadUtil.java:140)
        ... 4 more

回复

使用道具 举报

发表于 2021-6-24 18:28:47
怀疑是个bug,换新的war吧
回复

使用道具 举报

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

本版积分规则

4回帖数 0关注人数 3784浏览人数
最后回复于:2021-6-24 18:28
快速回复 返回顶部 返回列表