Simple & Silly issue: net.sf.jasperreports.engine.JRException: Unknown column name

[rccos]

Hi All,

I am facing since 3 days one silly issue with Jasper Report.

I have created 2 months back one jasper report and being used succesfully in the application.  The query gets executed in ireports as well as in Java code.

=========Existing query, Begin

SELECT
     QA_SHIPS_EVALUATION."SHIPS_MGMT_COMMENTS" AS QA_SHIPS_EVALUATION_SHIPS_MGMT_COMMENTS,

(select QA_CLIENTS.CLIENT_FIRSTNAME
from QA_CLIENTS where
QA_CLIENTS.CLIENT_ID_PK=CLIENT_ID_FK) as FirstName,
(select QA_CLIENTS.CLIENT_LASTNAME
from QA_CLIENTS where
QA_CLIENTS.CLIENT_ID_PK=CLIENT_ID_FK) as LastName,MONTH_ENTERED
FROM
     QA_SHIPS_EVALUATION
where SHIPLODGE_ID_FK=$P{shipLodge_id} and MONTH_ENTERED=$P{month}

================End

 

Now I have a requirement which is a simple modification to get Ship name as well.

=====================My new query Begin

SELECT
     QA_SHIPS_EVALUATION."SHIPS_MGMT_COMMENTS" AS QA_SHIPS_EVALUATION_SHIPS_MGMT_COMMENTS,

(select QA_CLIENTS.CLIENT_FIRSTNAME
from QA_CLIENTS where
QA_CLIENTS.CLIENT_ID_PK=CLIENT_ID_FK) as FirstName,
(select QA_CLIENTS.CLIENT_LASTNAME
from QA_CLIENTS where
QA_CLIENTS.CLIENT_ID_PK=CLIENT_ID_FK) as LastName,MONTH_ENTERED,
(select QA_SHIP_LODGE_DETAILS.NAME
from QA_SHIP_LODGE_DETAILS where
QA_SHIP_LODGE_DETAILS.SHIP_LODGE_ID_PK=SHIPLODGE_ID_FK) as EupName
FROM
     QA_SHIPS_EVALUATION

where SHIPLODGE_ID_FK=$P{shipLodge_id} and MONTH_ENTERED=$P{month}

==============End

The above query works in ireport upon preview and in sql server editor (my database is on sql server 2008). Once I use it in the my application the following error occurs.

net.sf.jasperreports.engine.JRException: Unknown column name : EupName	at net.sf.jasperreports.engine.JRResultSetDataSource.getColumnIndex(JRResultSetDataSource.java:355)	at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:112)	at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:823)	at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:787)	at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1478)	at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:125)	at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:942)	at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:841)	at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)	at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)	at servlet.ReportServlet.generatePDFReport(ReportServlet.java:2208)	at servlet.ReportServlet.doGet(ReportServlet.java:159)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)....................................................................................I am kind of lost here in understanding why the above error since 3 days. Any ideas where I am making blunder, please?I really really appreciate the help. I use Ireports 3.7.6.

 

 

Thanks

rccos

 

 

 

 

[rccos]

Further thourough checking of the my application logs shows some possible reasons. My applicaiton is having some jasper related exception and my new query is not reflecting there.

Could it be due to the following...??

Caused by: java.lang.NoSuchFieldException: AXIS_LABEL_FONT_SIZE

Caused by: java.lang.NoSuchFieldException: AXIS_LABEL_FONT_SIZE

java.lang.NoSuchFieldException: AXIS_TICK_LABEL_FONT_SIZE

etc...

Detailed log in the attachments. Is it possible because of the above following exceptions , my new query is not deployed into my application?

Any clue or ideas highly appreciated.

 

Thanks

rccos