CTrimble Posted August 19, 2014 Share Posted August 19, 2014 Error Message:An error occurred. Please contact your system administrator.Error Trace:com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connectioncom.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:62) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:52) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:67) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:1026) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:987) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.executeQuery(ReportParametersAction.java:514) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:477) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:414) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:123) at com.jaspersoft.jasperserver.war.action.ViewReportAction.checkForParams(ViewReportAction.java:148) at sun.reflect.GeneratedMethodAccessor488.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203) at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142) at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61)[/code] Link to comment Share on other sites More sharing options...
CTrimble Posted August 19, 2014 Author Share Posted August 19, 2014 Not sure how to fix this. Any help is greatly appriciated. Link to comment Share on other sites More sharing options...
hozawa Posted August 19, 2014 Share Posted August 19, 2014 Did you define and test your datasource? You'll need to define your datasource in JasperReports Server. Jaspersoft Studio should have asked you to specify a datasource when you uploaded your report layout. Link to comment Share on other sites More sharing options...
CTrimble Posted August 20, 2014 Author Share Posted August 20, 2014 I did not upload the report. This system was in place when I took over. Since the report is already there, how do I define and test my datasource? Link to comment Share on other sites More sharing options...
Solution CTrimble Posted September 30, 2014 Author Solution Share Posted September 30, 2014 The problem was that the server this was point towards was moved off site to a hosted environment and the firewall had to be configured for an IPSEC tunnel to that server's ip in order for the connection to work. Only then could the datasource connect. 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