niki76 Posted March 31, 2021 Share Posted March 31, 2021 Hello,I need to fill a single report with data from two different databases.I searched and found these instructions:https://community.jaspersoft.com/wiki/how-use-multiple-data-sources-jaspersoft-studio-or-jasperreports-serverhttps://community.jaspersoft.com/wiki/multiple-datasources-ireport-lists-tables-and-subreportsSo I followed them and I could get it to work locally, in Jaspersoft Studio.When I deploy it on the JasperReports Server, though, it does not work, returning this error:There was an error on the server. Try again or contact site administrators. (Error UID: c432759b-10a4-4b70-91b9-630f13281425)I am running JasperReports Server 7.5.0, Build: 20191206_1440.I searched the Community for hints, but I could not find what I wish for.Here in attachment a simple report that (with the correct connection string, that I changed here for obvious reasons) works fine locally.Thanks for your help.Kind regards,Niki Link to comment Share on other sites More sharing options...
niki76 Posted April 1, 2021 Author Share Posted April 1, 2021 SolvedGot it: driver issue.The client used a jdbc:jtds driver, not available on the server, which works using a jdbc-only driver.I wish the error message was more meaningful, but that's it.Kind regards,Niki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now