我的位置：首页 › 一站式数据分析平台-亿信ABI › 亿信ABI-问题求助 › 计划任务计算报表导出成PNG格式的时候出现报 ...

[ABI 5.2] 计划任务计算报表导出成PNG格式的时候出现报错

复制链接 | 收藏本帖

6927

: kiro 小试身手Lv3

发表于2022-2-25 10:01

悬赏10

已解决

楼主

计划任务计算一个报表，设定几个不同参数，计算预警推送导出PNG格式发到邮箱报错，但是导出成excel格式没问题，请问这是什么原因？以下是报错，报表是正常运行的
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 Calculation table :RBR; parameters

RBR=RBR3
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 Start calculation report: AUTOMAIL-RBR (memory condition: FREE=3G TOTAL=4G MAX=5.9G)
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 Referenced theme table: F_RBR3MT
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 Query data level range: no restrictions.
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 001Start multi-table parallel analysis of each analysis area
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 [GRID7(0.0.9.2)]Generating SQL...
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 [GRID7(0.0.9.2)]Calculation table GRID7
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 [GRID7(0.0.9.2)]Time to generate SQL 0 ms
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 [GRID7(0.0.9.2)]Current connection pool:【MaintenanceData】,Execute SQL :
select top 1000 a.B2 as B2,a.C2 as C2,a.D2 as D2,a.F2 as F2,b.E2 as E2,a.A2 as A2
from (
select MAX(a.PERIOD) as B2,MAX(a.MAINTENANCE) as C2,MAX(a.WHBYCZ) as D2,MAX(a.DT) as F2,a.ID as A2
from F_RBRMTN1933 a
group by a.ID) a
inner join (
select MAX(a.SELECT_) as E2,a.ID as A2
from F_RBRMTN1933 a
where (a.SELECT_ = '1')
group by a.ID) b
on (a.A2=b.A2)
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 [GRID7(0.0.9.2)]SQL execution is complete, querying 19 data, time consuming: 5 ms (start time: 2022-02-25 08:58:45.620; end time: 2022-02-25 08:58:45.625 ); which takes time to generate SQL 0 ms; Initial connection acquisition time:0 ms;Total query preparation time:5 ms;Time to execute query sql:0 ms;
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 002Complete parallel calculation of all analysis areas of multi-table
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 It takes 33 ms to execute the query. (Memory situation: FREE=3G TOTAL=4G MAX=5.9G)
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 It takes 13 ms to construct the result table.
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 It takes 46 ms to calculate "AUTOMAIL-RBR". (Memory situation: FREE=3G TOTAL=4G MAX=5.9G)
[color=rgb(138, 138, 138) !important]2022-02-25 08:58:45 Export table: RBR, format: img
[color=rgb(255, 132, 0) !important]2022-02-25 08:58:45 java.lang.NullPointerException
at com.esen.ebibase.export.AbstractReportPageExport.getScreenshotParam(AbstractReportPageExport.java:840)
at com.esen.ebibase.export.impl.img.ReportPageExportImgImpl.doExport(ReportPageExportImgImpl.java:39)
at com.esen.ebibase.req.batch.BatchOprProcess.writeToFile(BatchOprProcess.java:1429)
at com.esen.ebibase.req.batch.BatchOprProcess.saveExporter(BatchOprProcess.java:1411)
at com.esen.ebibase.req.batch.BatchOprProcess.exportReport(BatchOprProcess.java:1366)
at com.esen.ebibase.req.batch.BatchOprProcess.exportReport(BatchOprProcess.java:592)
at com.esen.ebibase.req.batch.BatchOprProcess.exportReportWithExceptionHandle(BatchOprProcess.java:360)
at com.esen.ebibase.req.batch.BatchOprProcess.processReport(BatchOprProcess.java:308)
at com.esen.ebibase.req.batch.BatchOprProcess.process(BatchOprProcess.java:210)
at com.esen.ebibase.req.batch.BatchOprRequestTask.doRun(BatchOprRequestTask.java:134)
at com.esen.ebibase.req.AbstractRequestTask.call(AbstractRequestTask.java:87)
at com.esen.ebibase.schedule.runner.ReportCalculatorTaskRunner.execute(ReportCalculatorTaskRunner.java:117)
at com.esen.ebibase.schedule.runner.ReportCalculatorTaskRunner.execute(ReportCalculatorTaskRunner.java:57)
at com.esen.eschedule.RunabledScheduledTask.doRun(RunabledScheduledTask.java:198)
at com.esen.eschedule.RunabledScheduledTask.access$000(RunabledScheduledTask.java:41)
at com.esen.eschedule.RunabledScheduledTask$1.run(RunabledScheduledTask.java:283)
at com.esen.scheduling.LocaleTask.run(LocaleTask.java:101)
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)