异常birt:irunandrender

oiopk7p5  于 2021-07-13  发布在  Java
关注(0)|答案(1)|浏览(427)

运行任务birt(irunandrender.run)时出现此错误
注意:表的值“2783072953”在postgresql中是oid
以下项目有错误:

`ReportDesign (id = 1):
    - Cannot get the native data type name for column: 1
    Cannot get the column type name.
    SQL error #1: Mauvaise valeur pour le type int : 2783072953
    Cannot get the native data type name for column: 1
    Cannot get the column type name.
    SQL error #1: Mauvaise valeur pour le type int : 2783072953
     ( 1 time(s) )
    detail : org.eclipse.birt.report.data.adapter.api.AdapterException: Cannot get the native data type name for column: 1
    Cannot get the column type name.
    SQL error #1: Mauvaise valeur pour le type int : 2783072953

     at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:435)
     at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:149)
     at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:115)
     at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:178)
     at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1678)
     at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:82)
     at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:61)
     at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
     at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
     at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
     at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
     at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layoutChildren(HTMLPageLM.java:126)
     at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:84)
     at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:90)
     at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:148)
     at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:71)
     at urssaf.cfe.stats.BirtStats.runBirt(BirtStats.java:61)
     at urssaf.cfe.stats.etats.EvtAnalyse.genererRapportSuivant(EvtAnalyse.java:97)
     at urssaf.cfe.stats.AffichageStatsHtml.Traitement(AffichageStatsHtml.java:51)
     at urssaf.cfe.stats.AffichageStats.doService(AffichageStats.java:76)
     at urssaf.cfe.Service.doService(Service.java:321)
     at urssaf.cfe.Service.doPost(Service.java:340)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
     at ...
  `
iqih9akk

iqih9akk1#

将列的数据类型设置为支持您正在接收的值的类型,例如bigint。postgresql网站声明:
整数4字节-2147483648到+214748364的整数的典型选择http://www.postgresql.org/docs/9.1/static/datatype-numeric.html
您接收的数字对于整数数据类型太大。

相关问题