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

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

报表如图

截图202208111045556261.png (50.37 KB, 下载次数: )

下载附件

2022-8-11 10:45 上传

问题日志如下

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)