导出报错Export Column Out Of Limit!,超出列限制处理,文档里好像没对应解释

1,导出文档:https://help.fanruan.com/finebi5.1/doc-view-161.html

2,错误信息:Export Column Out Of Limit!

3,错误堆栈:

com.finebi.common.exception.conf.table.FineTableExportColumnOutOfLimitException: Export Column Out Of Limit!

at com.finebi.common.api.datasource.export.ExcelRestriction.checkColumn(ExcelRestriction.java:57)

at com.finebi.dashboard.impl.aspect.ExcelRestrictionAccept.checkColumnSize(ExcelRestrictionAccept.java:114)

at com.finebi.dashboard.impl.aspect.ExcelRestrictionAccept.checkCrossRestriction(ExcelRestrictionAccept.java:149)

at com.finebi.dashboard.impl.aspect.ExcelRestrictionAccept.after(ExcelRestrictionAccept.java:87)

at com.finebi.dashboard.impl.aspect.ExcelRestrictionAccept.after(ExcelRestrictionAccept.java:38)

at com.finebi.dashboard.impl.manager.EngineWidgetExecutorManagerWrapper.getBiResult(EngineWidgetExecutorManagerWrapper.java:69)

at com.finebi.dashboard.impl.manager.EngineWidgetExecutorManagerWrapper.visit(EngineWidgetExecutorManagerWrapper.java:81)

at com.finebi.dashboard.impl.manager.EngineWidgetExecutorManagerWrapper.visit(EngineWidgetExecutorManagerWrapper.java:42)

at com.finebi.dashboard.api.widget.CrossTableWidget.accept(CrossTableWidget.java:50)

at com.finebi.dashboard.impl.widget.DashboardWidgetExecutorCellImpl.getEngineExportResult(DashboardWidgetExecutorCellImpl.java:48)

at com.finebi.dashboard.impl.service.export.GlobalExportExecutor.getEngineExportResult(GlobalExportExecutor.java:87)

at com.finebi.dashboard.impl.service.export.GlobalExportExecutor.visit(GlobalExportExecutor.java:95)

at com.finebi.dashboard.impl.service.export.GlobalExportExecutor.visit(GlobalExportExecutor.java:41)

at com.finebi.dashboard.api.widget.CrossTableWidget.accept(CrossTableWidget.java:50)

at com.finebi.dashboard.impl.service.export.creator.FineReportExportManager.buildGlobalWorkBook(FineReportExportManager.java:129)

at com.finebi.dashboard.impl.service.FineDashboardExportServiceImpl.exportGlobalExcel(FineDashboardExportServiceImpl.java:45)

at com.finebi.dashboard.impl.service.FineWidgetExecutorServiceImpl.exportGlobalExcel(FineWidgetExecutorServiceImpl.java:293)

at com.finebi.web.action.v5.conf.FineExportAction.exportDashboardExcel(FineExportAction.java:151)

at sun.reflect.GeneratedMethodAccessor4751.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)

at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)

at com.fr.third.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)

at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)

at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)

at com.fr.third.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)

at com.fr.third.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)

at com.fr.third.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)

at com.fr.third.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)

at com.fr.third.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)

at com.fr.third.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at com.fr.decision.webservice.BackupActivator$1.doFilter(BackupActivator.java:77)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

FineBI 冥河 发布于 2023-3-16 11:32 (编辑于 2023-3-16 11:33)
1min目标场景问卷 立即参与
回答问题
悬赏:4 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共1回答
最佳回答
0
snrtuemcLv8专家互助
发布于2023-3-16 11:42

文档解释是,预览因为会自动适应分页原因,不会报错,到时导出,超过底层代码最大值,所以报错了

可以的减少BI仪表盘的列数,不然只能咨询帆软技术支持了

  • 冥河 冥河(提问者) 分页列数控制了展示时的列数,但是导出时,算的是实际列数,导出时,有100列限制。超过就报,Column Out Of Limit!
    2023-03-16 17:27 
  • 1关注人数
  • 999浏览人数
  • 最后回答于:2023-3-16 11:42
    请选择关闭问题的原因
    确定 取消
    返回顶部