Error while Running report with Report Parameters

Hi Team,

I have created a report with parameter called - CustometID

I want to pass this value to the where clause. So i have changed my SQL query as below :


if I preview the report from Jasper Studio, Input controll is coming and after entering data, report is generated successfully.

After that I published the report in Jasper Server and created a Input Controll called - CustometID and mapped to report.

if i run report, its giving below error :

2018-02-21 23:21:20,166 ERROR AsyncJasperPrintAccessor,pool-6-thread-20:321 - Error during report execution
net.sf.jasperreports.engine.JRException: Error executing SQL statement for: CrossCheck
JRXML Gist link:
Log file :
Could you anybody please help me out. I facing this problem from couple of days.
Thank you.
Naresh. Naredla
nareshbangaram24's picture
Joined: Feb 20 2018 - 11:25am
Last seen: 5 years 3 weeks ago

Could anybody please suggest me on the above error please...

Thank you :)

nareshbangaram24 - 5 years 1 month ago

Please help me somebody. Thank you.

nareshbangaram24 - 5 years 1 month ago

Cool, glad you could figure it out


joseng62 - 5 years 4 weeks ago

2 Answers:

Thnaks  joseng62 for replying.

I resolved it by specifying schema name before table name.

Thank you.

nareshbangaram24's picture
Joined: Feb 20 2018 - 11:25am
Last seen: 5 years 3 weeks ago

Hi Naresh. First of all I know how you feel, needing help and no one is answering. When I started my Jaspersoft journey, I made a promise to myself to assist Jasper Dev that started like me with answering question and passing over knowledge in the forums. 

Ok so you strack trace error is clearly SQL related. 

So your query is "select * from JSW_LOCATION_MASTER where ID_NO=$P!{CustometID}"  
First of all you tested the datasource connection your created ? 
2nd you assigned the correct data soure the report when deplying to JasperServer. 

Then are you planning on injecting SQL or building the SQL query as you are using $P! which is used in such case. If you just passing over a normal parameter value then  $P{CustometID}, would surfice. 
I would recommend adding a default correct Customer ID in the parameter expression section, just to test with. 

Then the CustometID input control data is it gotten from list or another query ? And is that setup correctly. 

Trouble shoot and test the report apart. First test report with default value, and declaring the input control as single select first. 
Then if that works more on to improve the import control data fill. 

Also to help troubleshoot sql queries. In jasperserver as admin, go to manage tab, then under log settings set SQL query executer to debug level and set Input control value queries to debug level. That would at least assist you with the SQL. 

joseng62's picture
Joined: Dec 5 2014 - 2:43am
Last seen: 1 month 3 weeks ago