Unknown HQL return alias "" with a specific query

[jpasquier]

Hi,

I read some posts about this error but in my case error only occured with a specific query :

select
    wo.Status As BStat, Count(wo.Id.CodeW) As Nb
from
    TblW wo
where
    ( wo.Es between $P{DATED} and $P{DATEF}
      OR wo.Es between $P{DATED} and $P{DATEF} )
    and wo.Id.FkCo = $P{S}
group by
    wo.Status 
having
    wo.Status is not null
    and wo.Status not like '' 
order by
    wo.Status

I tried other cases, without any condition, without aliases, ... but error is already raised. Can this error occured because of the name of the field "Status" ?

 

[EDIT]

iReport 3.5.3 -> Error occured

iReport 3.0.0 -> No Error

[/EDIT]

 

Thanks for helping me,

 

Jonathan

 

The stacktrace is :

net.sf.jasperreports.engine.JRRuntimeException: Unknown HQL return alias "".
at net.sf.jasperreports.engine.data.JRHibernateAbstractDataSource.getFieldReader(JRHibernateAbstractDataSource.java:189)
at net.sf.jasperreports.engine.data.JRHibernateAbstractDataSource.assignReaders(JRHibernateAbstractDataSource.java:132)
at net.sf.jasperreports.engine.data.JRHibernateAbstractDataSource.<init>(JRHibernateAbstractDataSource.java:69)
at net.sf.jasperreports.engine.data.JRHibernateListDataSource.<init>(JRHibernateListDataSource.java:55)
at net.sf.jasperreports.engine.query.JRHibernateQueryExecuter.createResultDatasource(JRHibernateQueryExecuter.java:161)
at net.sf.jasperreports.engine.query.JRHibernateQueryExecuter.createDatasource(JRHibernateQueryExecuter.java:132)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:685)
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605)
at net.sf.jasperreports.engine.fill.JRFillDatasetRun.evaluate(JRFillDatasetRun.java:134)
at net.sf.jasperreports.engine.fill.JRFillElementDataset.evaluateDatasetRun(JRFillElementDataset.java:226)
at net.sf.jasperreports.engine.fill.JRFillChart.evaluateDatasetRun(JRFillChart.java:1828)
at net.sf.jasperreports.engine.fill.JRFillChart.evaluateChart(JRFillChart.java:1275)
at net.sf.jasperreports.engine.fill.JRFillChart.evaluateRenderer(JRFillChart.java:1252)
at net.sf.jasperreports.engine.fill.JRFillChart.evaluate(JRFillChart.java:1241)
at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:260)
at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:486)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:425)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnHeader(JRVerticalFiller.java:468)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:252)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:114)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:911)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:439)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:275)
at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:913)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)

Post Edited by jpasquier at 08/12/2009 13:10

Post Edited by jpasquier at 08/12/2009 13:11

Post Edited by jpasquier at 08/12/2009 13:32

Post Edited by jpasquier at 08/12/2009 13:33

[mblasi]

I have the same problem with ireports-3.5.3 and ireports-3.6.0

 

My hql query:

SELECT i.indicator as indicator, i.consession as consession, i.period as period, i.value as value FROM IndicatorValue i

 

 

My preview try:

Hibernate session opened Error filling print... Unknown HQL return alias "". net.sf.jasperreports.engine.JRRuntimeException: Unknown HQL return alias '".

at net.sf.jasperreports.engine.data.JRHibernateAbstractDataSource.getFieldReader(JRHibernateAbstractDataSource.java:185)

at net.sf.jasperreports.engine.data.JRHibernateAbstractDataSource.assignReaders(JRHibernateAbstractDataSource.java:128)

at net.sf.jasperreports.engine.data.JRHibernateAbstractDataSource.(JRHibernateAbstractDataSource.java:65)

at net.sf.jasperreports.engine.data.JRHibernateListDataSource.(JRHibernateListDataSource.java:51)

at net.sf.jasperreports.engine.query.JRHibernateQueryExecuter.createResultDatasource(JRHibernateQueryExecuter.java:157)

at net.sf.jasperreports.engine.query.JRHibernateQueryExecuter.createDatasource(JRHibernateQueryExecuter.java:128)

at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:681)

at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:601)

at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1232)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:862)

at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:119)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:271)

at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:904)

at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)

at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Print not filled. Try to use an EmptyDataSource...

Thanks a lot!

Post Edited by mblasi at 09/10/2009 14:28

Post Edited by mblasi at 09/10/2009 14:42

[alexdjkaos]

 The Hibernate data source implicitly uses field descriptions (if present) to map values from the result. If you want to suppress this behaviour, set the "net.sf.jasperreports.hql.field.mapping.descriptions" to false either globally (e.g. in jasperreports.properties) or locally in the report (using a <property/> element). Go to "Tools > Options > JasperReports Properties" to modify this atribute.

Obs: To avoid problems with your hql, set a default value to all your parameters, because sometimes the hql return "null" because of this.

(sorry my english, i'm from brazil)

 

 

Para solucionar este problema no ireport vá em "Ferramentas > Opções > JasperReports porperties" e mude o valor do atributo "net.sf.jasperreports.hql.field.mapping.descriptions" para false.

 

obs: Para evitar problemas na sua hql, coloque um valor default para todos os seus parametros, porque as vezes a hql retorna null por nao conseguir inicializar os parametros.

 

By: Alex from PHD Sistemas

[raggy]

I'm having the same problem as above, whenever I use a sub-query or a JOIN statement for my HQL it throws me this error

Error filling print... Unknown HQL return alias "".    net.sf.jasperreports.engine.JRRuntimeException: Unknown HQL return alias "".

As said above I tried to change the global JasperReport properties in the Options but I couldn't becuase every field was disabled in my iReport. How am I suppose to resolve this problem now? Kindly help me out.

[raggy]

ok guys, found a solution. After adding the property tag like said above it is working fine.

 

<property name="net.sf.jasperreports.hql.field.mapping.descriptions" value="false"></property>