[亿信BI4.2.2] 设置计划任务将报表以pdf格式发送出去时出现问题

1507
4

bobcardif 小试身手Lv3

发表于2022-8-11 10:47

悬赏100

未解决

楼主

此报表在potal上导出PDF正常,只是在计划任务中执行出现问题。

报表如图
截图202208111045556261.png

问题日志如下

2022-08-11 10:33:33 计划任务“业绩达成排名报表”开始执行
2022-08-11 10:33:34 开始成批处理
2022-08-11 10:33:34 计算表:业绩达成排名表_VNB_渠道;参数:
2022-08-11 10:33:34 开始计算报表:copyof_0_copyof_copyof_B45703(内存情况:FREE=2G TOTAL=3.8G MAX=7.1G)
2022-08-11 10:33:34 引用的主题表:PORTAL_CDM_104
2022-08-11 10:33:34 查询的数据级次范围:没有做限制。
2022-08-11 10:33:34 计算表格GRID1
2022-08-11 10:33:34 生成SQL耗时0毫秒
2022-08-11 10:33:34 执行SQL:
   select row_.*,rownum from ( select sum(a.ACC_VNB/10000) as C3,sum(a.VNB_ACC_TARGET/10000) as D3,sum(a.TB_VNB/10000) as G3,sum(a.VNB_YEAR_TARGET/10000) as J3,case when sum(a.VNB_ACC_TARGET/10000)=0 then null else (sum(a.ACC_VNB/10000))/(sum(a.VNB_ACC_TARGET/10000)) end  as F3,a.SALECHNL as B3,max(b.SALECHNL_NAME) as mc_B30
   from PORTAL_CDM_104 a
   ,CDM_DIM_SALECHNL b
   where (A.SALECHNL=B.SALECHNL(+)) and (((a.SALECHNL <> '2' or a.SALECHNL is null)) AND (a.BRANCH LIKE '86%') AND (a.CAL_DATE_ID = 20220810))
   group by a.SALECHNL
   order by case when sum(a.VNB_ACC_TARGET/10000)=0 then null else (sum(a.ACC_VNB/10000))/(sum(a.VNB_ACC_TARGET/10000)) end  desc  nulls last )row_ where rownum <= 1000
2022-08-11 10:33:34 SQL执行完毕,查询出4条数据,耗时:15毫秒;其中生成SQL耗时0毫秒;初始获取连接耗时:0毫秒;查询准备总耗时:0毫秒;执行查询sql耗时:0毫秒;
2022-08-11 10:33:34 执行查询耗时15毫秒。(内存情况:FREE=2G TOTAL=3.8G MAX=7.1G)
2022-08-11 10:33:34 构造结果表耗时16毫秒。
2022-08-11 10:33:34 计算“copyof_0_copyof_copyof_B45703”耗时31毫秒。(内存情况:FREE=2G TOTAL=3.8G MAX=7.1G)
2022-08-11 10:33:34 导出表:业绩达成排名表_VNB_渠道,格式为:pdf
2022-08-11 10:33:34 java.lang.NullPointerException
    at com.esen.irpt.rp.pdf.itextimpl.TableMaker.createLinkCell(TableMaker.java:333)
    at com.esen.irpt.rp.pdf.itextimpl.TableMaker.createCell(TableMaker.java:294)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeCell(TableMakerForView.java:882)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeWidgetGrid(TableMakerForView.java:1123)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeWidgetObject(TableMakerForView.java:429)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView$2.eachNode(TableMakerForView.java:394)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1103)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1107)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeSingleSheet(TableMakerForView.java:352)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.access$600(TableMakerForView.java:109)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView$1.eachNode(TableMakerForView.java:339)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1103)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1107)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1107)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeSheetList(TableMakerForView.java:272)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.make(TableMakerForView.java:199)
    at com.esen.bi.export.impl.pdf.ReportPageExportPdfImpl.paintSingleReport(ReportPageExportPdfImpl.java:129)
    at com.esen.bi.export.impl.pdf.ReportPageExportPdfImpl.exportOnePage(ReportPageExportPdfImpl.java:112)
    at com.esen.bi.export.AbstractReportPageExport.addReport(AbstractReportPageExport.java:140)
    at com.esen.bi.export.AbstractReportPageExport.add(AbstractReportPageExport.java:89)
    at com.esen.irpt.req.batch.BatchOprProcess.exportResultReport(BatchOprProcess.java:613)
    at com.esen.irpt.req.batch.BatchOprProcess.doExport(BatchOprProcess.java:1002)
    at com.esen.irpt.req.batch.BatchOprProcess.exportReport(BatchOprProcess.java:1177)
    at com.esen.irpt.req.batch.BatchOprProcess.exportReport(BatchOprProcess.java:523)
    at com.esen.irpt.req.batch.BatchOprProcess.exportReportWithExceptionHandle(BatchOprProcess.java:312)
    at com.esen.irpt.req.batch.BatchOprProcess.processReport(BatchOprProcess.java:252)
    at com.esen.irpt.req.batch.BatchOprProcess.process(BatchOprProcess.java:167)
    at com.esen.irpt.req.batch.BatchOprRequestTask.doRun(BatchOprRequestTask.java:136)
    at com.esen.irpt.req.AbstractRequestTask.call(AbstractRequestTask.java:51)
    at com.esen.bi.schedule.refactor.runner.ReportCalculatorTaskRunner.execute(ReportCalculatorTaskRunner.java:65)
    at com.esen.platform.executable.schedule.ScheduledTaskRunner.execute(ScheduledTaskRunner.java:30)
    at com.esen.platform.executable.schedule.RunabledScheduledTask$1.run(RunabledScheduledTask.java:145)
    at com.esen.thread.LocaleTask.run(LocaleTask.java:105)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
2022-08-11 10:33:34 失败1:导出<业绩达成排名表_VNB_渠道>为pdf时出现异常
2022-08-11 10:33:34 java.lang.NullPointerException: java.lang.NullPointerException
    at com.esen.irpt.rp.pdf.itextimpl.TableMaker.createLinkCell(TableMaker.java:333)
    at com.esen.irpt.rp.pdf.itextimpl.TableMaker.createCell(TableMaker.java:294)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeCell(TableMakerForView.java:882)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeWidgetGrid(TableMakerForView.java:1123)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeWidgetObject(TableMakerForView.java:429)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView$2.eachNode(TableMakerForView.java:394)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1103)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1107)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeSingleSheet(TableMakerForView.java:352)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.access$600(TableMakerForView.java:109)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView$1.eachNode(TableMakerForView.java:339)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1103)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1107)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1107)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeSheetList(TableMakerForView.java:272)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.make(TableMakerForView.java:199)
    at com.esen.bi.export.impl.pdf.ReportPageExportPdfImpl.paintSingleReport(ReportPageExportPdfImpl.java:129)
    at com.esen.bi.export.impl.pdf.ReportPageExportPdfImpl.exportOnePage(ReportPageExportPdfImpl.java:112)
    at com.esen.bi.export.AbstractReportPageExport.addReport(AbstractReportPageExport.java:140)
    at com.esen.bi.export.AbstractReportPageExport.add(AbstractReportPageExport.java:89)
    at com.esen.irpt.req.batch.BatchOprProcess.exportResultReport(BatchOprProcess.java:613)
    at com.esen.irpt.req.batch.BatchOprProcess.doExport(BatchOprProcess.java:1002)
    at com.esen.irpt.req.batch.BatchOprProcess.exportReport(BatchOprProcess.java:1177)
    at com.esen.irpt.req.batch.BatchOprProcess.exportReport(BatchOprProcess.java:523)
    at com.esen.irpt.req.batch.BatchOprProcess.exportReportWithExceptionHandle(BatchOprProcess.java:312)
    at com.esen.irpt.req.batch.BatchOprProcess.processReport(BatchOprProcess.java:252)
    at com.esen.irpt.req.batch.BatchOprProcess.process(BatchOprProcess.java:167)
    at com.esen.irpt.req.batch.BatchOprRequestTask.doRun(BatchOprRequestTask.java:136)
    at com.esen.irpt.req.AbstractRequestTask.call(AbstractRequestTask.java:51)
    at com.esen.bi.schedule.refactor.runner.ReportCalculatorTaskRunner.execute(ReportCalculatorTaskRunner.java:65)
    at com.esen.platform.executable.schedule.ScheduledTaskRunner.execute(ScheduledTaskRunner.java:30)
    at com.esen.platform.executable.schedule.RunabledScheduledTask$1.run(RunabledScheduledTask.java:145)
    at com.esen.thread.LocaleTask.run(LocaleTask.java:105)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
2022-08-11 10:33:34 线程因异常而中止
2022-08-11 10:33:34 执行计划任务出现异常java.lang.NullPointerException: java.lang.NullPointerException
    at com.esen.irpt.rp.pdf.itextimpl.TableMaker.createLinkCell(TableMaker.java:333)
    at com.esen.irpt.rp.pdf.itextimpl.TableMaker.createCell(TableMaker.java:294)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeCell(TableMakerForView.java:882)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeWidgetGrid(TableMakerForView.java:1123)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeWidgetObject(TableMakerForView.java:429)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView$2.eachNode(TableMakerForView.java:394)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1103)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1107)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeSingleSheet(TableMakerForView.java:352)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.access$600(TableMakerForView.java:109)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView$1.eachNode(TableMakerForView.java:339)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1103)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1107)
    at com.esen.bi.reportpage.base.widget.WidgetObject.iterateWidgetNode(WidgetObject.java:1107)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.makeSheetList(TableMakerForView.java:272)
    at com.esen.irpt.rp.pdf.itextimpl.TableMakerForView.make(TableMakerForView.java:199)
    at com.esen.bi.export.impl.pdf.ReportPageExportPdfImpl.paintSingleReport(ReportPageExportPdfImpl.java:129)
    at com.esen.bi.export.impl.pdf.ReportPageExportPdfImpl.exportOnePage(ReportPageExportPdfImpl.java:112)
    at com.esen.bi.export.AbstractReportPageExport.addReport(AbstractReportPageExport.java:140)
    at com.esen.bi.export.AbstractReportPageExport.add(AbstractReportPageExport.java:89)
    at com.esen.irpt.req.batch.BatchOprProcess.exportResultReport(BatchOprProcess.java:613)
    at com.esen.irpt.req.batch.BatchOprProcess.doExport(BatchOprProcess.java:1002)
    at com.esen.irpt.req.batch.BatchOprProcess.exportReport(BatchOprProcess.java:1177)
    at com.esen.irpt.req.batch.BatchOprProcess.exportReport(BatchOprProcess.java:523)
    at com.esen.irpt.req.batch.BatchOprProcess.exportReportWithExceptionHandle(BatchOprProcess.java:312)
    at com.esen.irpt.req.batch.BatchOprProcess.processReport(BatchOprProcess.java:252)
    at com.esen.irpt.req.batch.BatchOprProcess.process(BatchOprProcess.java:167)
    at com.esen.irpt.req.batch.BatchOprRequestTask.doRun(BatchOprRequestTask.java:136)
    at com.esen.irpt.req.AbstractRequestTask.call(AbstractRequestTask.java:51)
    at com.esen.bi.schedule.refactor.runner.ReportCalculatorTaskRunner.execute(ReportCalculatorTaskRunner.java:65)
    at com.esen.platform.executable.schedule.ScheduledTaskRunner.execute(ScheduledTaskRunner.java:30)
    at com.esen.platform.executable.schedule.RunabledScheduledTask$1.run(RunabledScheduledTask.java:145)
    at com.esen.thread.LocaleTask.run(LocaleTask.java:105)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

最近看过此主题的会员

sunhaoyang

勇敢向前

没人知道吗

明明如月

touchi4

15662116958

15350939

两包辣条约吗

小怪兽

ESENSOFT官方技术支持

K-tim

4个回答

只看楼主

小怪兽 数据达人Lv4

发表于2022-8-11 10:59

只看该作者

取消 关注该作者的回复

沙发

看日志里直接报空指针,空指针一般是代码问题。目前定位为BUG,您这边可以联系项目组反馈BUG,让研发出补丁解决。

bobcardif 小试身手Lv3

发表于2022-8-11 11:15

只看该作者

取消 关注该作者的回复

板凳

小怪兽 发表于 2022-8-11 10:59
看日志里直接报空指针,空指针一般是代码问题。目前定位为BUG,您这边可以联系项目组反馈BUG,让研发出补丁 ...

这边目前没有华宇的厂商在现场。我们是自己开发的报表。这个应该怎么联系呢

小怪兽 数据达人Lv4

发表于2022-8-11 11:47

只看该作者

取消 关注该作者的回复

地板

bobcardif 发表于 2022-8-11 11:15
这边目前没有华宇的厂商在现场。我们是自己开发的报表。这个应该怎么联系呢 ...

那您可以问问您这边的项目经理。

小怪兽 数据达人Lv4

发表于2022-8-11 16:13

只看该作者

取消 关注该作者的回复

5#

了解到该问题已联系到项目上的技术人员进行跟进

登录后可回答问题,请登录注册

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

小时

全天响应

分钟

快速处理问题

工程师强势助力

明星产品
解决方案
联系合作

渠道咨询电话:137-0120-6790

技术支持QQ:400-0011-866(工作日9:00-18:00)

产品建议邮箱yixin@esensoft.com

关注我们

扫TA学习更多干货

一对一专家交流

版权所有© 2006-2024 北京亿信华辰软件有限责任公司 京ICP备07017321号 京公网安备11010802016281号