#93 Error in report generation

version 1.50
open
nobody
Reports (3)
5
2007-10-30
2007-10-30
genthor-RE
No

System config:
OS: Ubuntu 7.04 Feisty Fawn
DB: Postgres 8.2.5.
Java: Java 1.6.0-b105

When I try to generate a report (artifact summary), I get the following SQL-related error:

net.sf.jasperreports.engine.JRException: Error executing SQL statement for : artifact_summary
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:121)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:673)
at net.sf.jasperreports.engine.fill.JRFillDataset.setDatasource(JRFillDataset.java:610)
at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:599)
at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:864)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:702)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:660)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234)
at com.osframework.ejb.reportwriter.ReportWriterBean.runReport(ReportWriterBean.java:156)
at com.osframework.ejb.reportwriter.ReportWriterBean.runReport(ReportWriterBean.java:203)
at com.osframework.ejb.reportwriter.ReportWriterBean.runReport(ReportWriterBean.java:184)
at com.osframework.appclient.services.ReportWriterServices.runReport(ReportWriterServices.java:82)
at com.osrmt.appclient.wizards.ReportWizard$5$1.doNonUILogic(ReportWizard.java:215)
at com.osframework.appclient.ui.common.SwingWorker.construct(SwingWorker.java:139)
at com.osframework.appclient.ui.common.SwingWorker.access$000(SwingWorker.java:42)
at com.osframework.appclient.ui.common.SwingWorker$2.run(SwingWorker.java:96)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.postgresql.util.PSQLException: ERREUR: droit refusé pour la relation artifactsummary
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:257)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:115)
... 18 more

Discussion