[#2578] - Jasper Server Crashes on SQL_GENERATE_ERROR

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
gdurbin's picture
Joined: Nov 4 2012 - 3:35pm
Last seen: 9 years 6 months ago
Feedback
randomness