| Category: | Bug report |
Priority: | High |
Status: | New |
| Project: | Severity: | Block |
Resolution: | Open |
|
| Component: | Reproducibility: | N/A |
Assigned to: |
Caused by: com.jaspersoft.jasperserver.api.JSException: ADH_1009_SQL_GENERATE_ERROR
at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy$CacheListener.stateChanged(CommonDomainDataStrategy.java:1066)
at com.jaspersoft.commons.datarator.CachedData.setState(CachedData.java:181)
at com.jaspersoft.commons.datarator.CachedData.setThrowable(CachedData.java:193)
at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:163)
at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:138)
... 101 more
Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select "public_ahinterval"."month" as "public_ahinterval_month",
sum("public_ahvitalstatistics"."age") as "public_ahvitalstatistics_age_Sum",
sum("public_ahpersoncompensation"."monthlycompamount") as "public_ahpersoncompensation_monthlycompamount_Sum"
from "public"."ahperson" "public_ahperson"
inner join "public"."ahpersoncompensation" "public_ahpersoncompensation" on ("public_ahperson"."personid" = "public_ahpersoncompensation"."personid" and "public_ahperson"."asofdate" = "public_ahpersoncompensation"."asofdate")
inner join "public"."ahinterval" "public_ahinterval" on ("public_ahperson"."asofdate" = "public_ahinterval"."monthend")
inner join "public"."ahvitalstatistics" "public_ahvitalstatistics" on ("public_ahperson"."personid" = "public_ahvitalstatistics"."personid" and "public_ahperson"."asofdate" = "public_ahvitalstatistics"."asofdate")
inner join "public"."ahcompanyid" "public_ahcompanyid" on ("public_ahperson"."companyid" = "public_ahcompanyid"."companyid")
where ("public_ahcompanyid"."username" in ('X27')) and "public_ahinterval"."asofyear" = 2012 and "public_ahinterval"."quarter" = 4
group by "public_ahinterval"."month"
order by "public_ahinterval_month"
limit 1000
at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:300)
at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:129)
... 102 more
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : null
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:246)
at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113)
at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet.getJRDataSource(JRQueryDataSet.java:174)
at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet.access$100(JRQueryDataSet.java:44)
at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:291)
... 103 more
Caused by: org.postgresql.util.PSQLException: ERROR: column public_ahvitalstatistics.age does not exist
Position: 71
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:239)
... 108 more
