Jasper Report not working

Rohan Hazarika shared this question 24 days ago
Awaiting Reply

I have a JasperReport that is working perfectly in JasperSoftStudio6.17. After i import the JRXML file into yellowfin, i get a 'An error occurred retrieving the results from the database. Please check the SQL syntax and try again'. Why is it not working? What should i be checking? The SQL in the JRXL works fine when i run it in the DB.

Comments (4)

photo
1

Hi Rohan,

Could you let me know exactly which version of Yellowfin 9 you are running, please?

Have you succeeded before in importing other Jasper reports?

If this is your first time, we have a Wiki guide on importing Jasper Reports to Yellowfin here.

It may also aid us in solving your problem if you could provide a copy of the yellowfin.log file from yellowfin/appserver/logs along with a timestamp of when you were able to reproduce the error.

Kind regards,

Chris

photo
1

Hi Rohan,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?


Kind regards,

Chris

photo
1

Hey Chris, thanks for checking in. Im checking the reports, but i havent been getting consistent behaviour so im not sure. It works at times and doesnt at other times. I'll get in touch again if i find a pattern. Thanks

photo
1

Hi Rohan,

That's no worries. I'll leave this open for a little longer while you investigate.

Kind regards,

Chris