抽取错误日志如下:
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