lio38

Hi, I defined a report with studio that includes a google map with some markers in the summary section. When I connect to the web interface of jasperserver (jasperreports-server-cp-6.1.1), I can run my report and I have the map displayed on my screen. My problem is that when I try to generate a pdf a get an error and a stack trace below. When I put the faulty URL in a browser running on the server, I get again the map on the screen without any problem. Any idea ? Thanks Lionel 2015-11-27 08:54:54,890 ERROR errorPage_jsp,http-nio-8080-exec-3:583 - stack trace of exception that redirected to errorPage.jspjava.lang.RuntimeException: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error opening input stream from URL: http://maps.google.com/maps/api/staticmap?center=25.0,45.0&size=556x600&zoom=5&maptype=roadmap&format=png&scale=1&markers=color:0xFF0000%7C24.68773,46.72185&markers=color:0xFF0000%7C21.54238,39.19797&markers=color:0xFF0000%7C19.0,40.0&markers=color:0xFFC800%7C26.43442,50.10326&markers=color:0xFFC800%7C28.3998,36.57151&markers=color:0xFFC800%7C24.46861,39.61417&markers=color:0xFFC800%7C21.42664,39.82563&markers=color:0x00FF00%7C16.88917,42.55111&markers=color:0x00FF00%7C21.27028,40.41583&markers=color:0x00FF00%7C26.27944,50.20833&markers=color:0x00FF00%7C24.08912,38.06374&markers=color:0x00FF00%7C26.32599,43.97497&markers=color:0x00FF00%7C17.49326,44.12766&markers=color:0x00FF00%7C18.3,42.73333&markers=color:0x00FF00%7C18.21639,42.50528&markers=color:0x00FF00%7C20.01288,41.46767&markers=color:0x00FF00%7C18.02896,43.12061&markers=color:0x00FF00%7C17.72285,42.25261&markers=color:0x00FF00%7C18.19974,42.87328&markers=color:0x0000FF%7C26.64389,50.15917&markers=color:0x0000FF%7C20.49173,45.15665&markers=color:0x0000FF%7C27.52188,41.69073&markers=color:0x0000FF%7C27.48055,47.87371&markers=color:0x0000FF%7C16.59601,42.94435&markers=color:0x0000FF%7C18.95353,42.17026&markers=color:0x0000FF%7C27.1,44.13333&markers=color:0x0000FF%7C24.73333,42.91667&markers=color:0x0000FF%7C17.96361,43.60417&markers=color:0x0000FF%7C29.96974,40.20641&markers=color:0x0000FF%7C26.28864,50.11396&markers=color:0x0000FF%7C28.43279,45.97077&markers=color:0x0000FF%7C26.64986,49.95223&markers=color:0x0000FF%7C26.64986,49.95223&sensor=false&language=en. at net.sf.jasperreports.components.map.MapElementPdfHandler.exportElement(MapElementPdfHandler.java:55) at net.sf.jasperreports.engine.export.JRPdfExporter.exportGenericElement(JRPdfExporter.java:2892) at net.sf.jasperreports.engine.export.JRPdfExporter.exportElements(JRPdfExporter.java:1011) at net.sf.jasperreports.engine.export.JRPdfExporter.exportPage(JRPdfExporter.java:962) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:826) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:525) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.exportToPdf(EngineServiceImpl.java:571) at com.jaspersoft.jasperserver.war.action.ReportPdfExporter.export(ReportPdfExporter.java:66) at com.jaspersoft.jasperserver.war.action.AbstractReportExporter.exportBuffered(AbstractReportExporter.java:191) at com.jaspersoft.jasperserver.war.action.AbstractReportExporter.export(AbstractReportExporter.java:98) at com.jaspersoft.jasperserver.war.action.ReportExporterAction.export(ReportExporterAction.java:158) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)... at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error opening input stream from URL: http://maps.google.com/maps/api/staticmap?center=25.0,45.0&size=556x600&zoom=5&maptype=roadmap&format=png&scale=1&markers=color:0xFF0000%7C24.68773,46.72185&markers=color:0xFF0000%7C21.54238,39.19797&markers=color:0xFF0000%7C19.0,40.0&markers=color:0xFFC800%7C26.43442,50.10326&markers=color:0xFFC800%7C28.3998,36.57151&markers=color:0xFFC800%7C24.46861,39.61417&markers=color:0xFFC800%7C21.42664,39.82563&markers=color:0x00FF00%7C16.88917,42.55111&markers=color:0x00FF00%7C21.27028,40.41583&markers=color:0x00FF00%7C26.27944,50.20833&markers=color:0x00FF00%7C24.08912,38.06374&markers=color:0x00FF00%7C26.32599,43.97497&markers=color:0x00FF00%7C17.49326,44.12766&markers=color:0x00FF00%7C18.3,42.73333&markers=color:0x00FF00%7C18.21639,42.50528&markers=color:0x00FF00%7C20.01288,41.46767&markers=color:0x00FF00%7C18.02896,43.12061&markers=color:0x00FF00%7C17.72285,42.25261&markers=color:0x00FF00%7C18.19974,42.87328&markers=color:0x0000FF%7C26.64389,50.15917&markers=color:0x0000FF%7C20.49173,45.15665&markers=color:0x0000FF%7C27.52188,41.69073&markers=color:0x0000FF%7C27.48055,47.87371&markers=color:0x0000FF%7C16.59601,42.94435&markers=color:0x0000FF%7C18.95353,42.17026&markers=color:0x0000FF%7C27.1,44.13333&markers=color:0x0000FF%7C24.73333,42.91667&markers=color:0x0000FF%7C17.96361,43.60417&markers=color:0x0000FF%7C29.96974,40.20641&markers=color:0x0000FF%7C26.28864,50.11396&markers=color:0x0000FF%7C28.43279,45.97077&markers=color:0x0000FF%7C26.64986,49.95223&markers=color:0x0000FF%7C26.64986,49.95223&sensor=false&language=en. at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:118) at net.sf.jasperreports.repo.InputStreamPersistenceService.load(InputStreamPersistenceService.java:47) at net.sf.jasperreports.repo.DefaultRepositoryService.getResource(DefaultRepositoryService.java:159) at net.sf.jasperreports.repo.RepositoryUtil.findInputStream(RepositoryUtil.java:190) at net.sf.jasperreports.repo.RepositoryUtil.getBytesFromLocation(RepositoryUtil.java:206) at net.sf.jasperreports.engine.RenderableUtil.getRenderable(RenderableUtil.java:122) at net.sf.jasperreports.components.map.MapElementImageProvider.getImage(MapElementImageProvider.java:210) at net.sf.jasperreports.components.map.MapElementPdfHandler.exportElement(MapElementPdfHandler.java:51) ... 163 moreCaused by: net.sf.jasperreports.engine.JRException: Error opening input stream from URL: http://maps.google.com/maps/api/staticmap?center=25.0,45.0&size=556x600&zoom=5&maptype=roadmap&format=png&scale=1&markers=color:0xFF0000%7C24.68773,46.72185&markers=color:0xFF0000%7C21.54238,39.19797&markers=color:0xFF0000%7C19.0,40.0&markers=color:0xFFC800%7C26.43442,50.10326&markers=color:0xFFC800%7C28.3998,36.57151&markers=color:0xFFC800%7C24.46861,39.61417&markers=color:0xFFC800%7C21.42664,39.82563&markers=color:0x00FF00%7C16.88917,42.55111&markers=color:0x00FF00%7C21.27028,40.41583&markers=color:0x00FF00%7C26.27944,50.20833&markers=color:0x00FF00%7C24.08912,38.06374&markers=color:0x00FF00%7C26.32599,43.97497&markers=color:0x00FF00%7C17.49326,44.12766&markers=color:0x00FF00%7C18.3,42.73333&markers=color:0x00FF00%7C18.21639,42.50528&markers=color:0x00FF00%7C20.01288,41.46767&markers=color:0x00FF00%7C18.02896,43.12061&markers=color:0x00FF00%7C17.72285,42.25261&markers=color:0x00FF00%7C18.19974,42.87328&markers=color:0x0000FF%7C26.64389,50.15917&markers=color:0x0000FF%7C20.49173,45.15665&markers=color:0x0000FF%7C27.52188,41.69073&markers=color:0x0000FF%7C27.48055,47.87371&markers=color:0x0000FF%7C16.59601,42.94435&markers=color:0x0000FF%7C18.95353,42.17026&markers=color:0x0000FF%7C27.1,44.13333&markers=color:0x0000FF%7C24.73333,42.91667&markers=color:0x0000FF%7C17.96361,43.60417&markers=color:0x0000FF%7C29.96974,40.20641&markers=color:0x0000FF%7C26.28864,50.11396&markers=color:0x0000FF%7C28.43279,45.97077&markers=color:0x0000FF%7C26.64986,49.95223&markers=color:0x0000FF%7C26.64986,49.95223&sensor=false&language=en. at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:343) at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:101) ... 170 moreCaused by: java.net.ConnectException: Connection timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at java.net.Socket.connect(Socket.java:538) at sun.net.NetworkClient.doConnect(NetworkClient.java:180) at sun.net.www.http.HttpClient.openServer(HttpClient.java:432) at sun.net.www.http.HttpClient.openServer(HttpClient.java:527) at sun.net.www.http.HttpClient.<init>(HttpClient.java:211) at sun.net.www.http.HttpClient.New(HttpClient.java:308) at sun.net.www.http.HttpClient.New(HttpClient.java:326) at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:1168) at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1104) at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:998) at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:932) at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1512) at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1440) at java.net.URL.openStream(URL.java:1038) at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:339) ... 171 more

Hi, I think that I'm facing the same problem. I've been blocked by that for 2 weeks now. I really think that there is a bug behind. http://community.jaspersoft.com/questions/952406/error-jrjdbcqueryexecuter-supplied-javasqlconnection-object-null

Hi, I have problem to have my report created with studio work in Jasperreports Server. Actually, I always get a no data report. I've activated full traces on the server and I have the following: 4904 2015-09-30 13:36:06,418 DEBUG JdbcReportDataSourceServiceFactory,pool-6-thread-5:152 - Using cached connection pool for driver="tibcosoftware.jdbc.impala.ImpalaDriver", url="jdbc:tibcosoftware:impala://vmcloudera.xxx.fr:21050;Transacti onMode=ignore", username="cloudera". 4905 2015-09-30 13:36:06,418 DEBUG DataSourceResolverImpl,pool-6-thread-5:76 - opening connection #5: com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService@e34483f 4906 2015-09-30 13:36:06,419 DEBUG JRQueryDataSet,pool-6-thread-5:210 - running JR query for SL: language = sql, query = select `durationavg`, 4907 `durationtotal`, 4908 `error`, 4909 `success`, 4910 `thedate`, 4911 `total` 4912 from (SELECT from_unixtime(unix_timestamp(theDate,"dd/MM/yyyy"),"yyyy-MM-dd") as theDate, total, success, error, durationtotal, durationavg FROM smsdailystat ORDER BY theDate DESC) `query` 4913 limit 200001 4914 4915 2015-09-30 13:36:06,423 DEBUG JRDataSourceFactory,pool-6-thread-5:155 - 13 values left over after going through dataset: {REPORT_CONNECTION=null, JASPER_REPORT=null, REPORT_FILE_RESOLVER=null, REPORT_PARAMETERS_MAP={LoggedInUser=MetadataUserDe tails: jasperadmin, REPORT_LOCALE=en_US, slSchema=com.jaspersoft.commons.semantic.impl.SchemaImpl@0, HTTP_SERVLET_REQUEST=org.springframework.security.web.context.HttpSessionSecurityContextRepository$Servlet3SaveToSessionRequestWrapper@97a1cf3 , REPORT_VIRTUALIZER=net.sf.jasperreports.engine.fill.JRFileVirtualizer@30029a61, REPORT_TIME_ZONE=sun.util.calendar.ZoneInfo[id="Europe/Paris",offset=3600000,dstSavings=3600000,useDaylight=true,transitions=184,lastRule=java.util.SimpleTimeZon e[id=Europe/Paris,offset=3600000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,startTimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTimeMode= 2]], REPORT_TEMPLATES=[], LoggedInUsername=jasperadmin, slFactory=com.jaspersoft.commons.semantic.datasource.SemanticLayerFactory$$EnhancerBySpringCGLIB$$e25d8170@7d20bba8, REPORT_CONTEXT=com.jaspersoft.jasperserver.war.action.WebflowReportCon text@d09e480, LEAVE_ORIGINAL_CASE_FOR_IDS=true, REPORT_URL_HANDLER_FACTORY=com.jaspersoft.jasperserver.api.engine.jasperreports.util.repo.RepositoryURLHandlerFactory@700052c5}, REPORT_CLASS_LOADER=null, REPORT_DATA_SOURCE=null, IS_IGNORE_PAGIN ATION=null, SORT_FIELDS=null, REPORT_SCRIPTLET=null, FILTER=null, JASPER_REPORTS_CONTEXT=null, REPORT_FORMAT_FACTORY=null, REPORT_RESOURCE_BUNDLE=null} 4916 2015-09-30 13:36:06,423 WARN JRJdbcQueryExecuter,pool-6-thread-5:133 - The supplied java.sql.Connection object is null. 4917 2015-09-30 13:36:06,428 DEBUG JRJdbcQueryExecuter,Thread-223:285 - SQL query string: select `durationavg`, 4918 `durationtotal`, 4919 `error`, 4920 `success`, 4921 `thedate`, 4922 `total` 4923 from (SELECT from_unixtime(unix_timestamp(theDate,"dd/MM/yyyy"),"yyyy-MM-dd") as theDate, total, success, error, durationtotal, durationavg FROM smsdailystat ORDER BY theDate DESC) `query` 4924 limit 200001 4925 4926 2015-09-30 13:36:06,429 DEBUG JSControlledJdbcQueryExecuter,pool-6-thread-5:183 - Execution time 0.005 secs 4927 2015-09-30 13:36:06,429 DEBUG CachedData,pool-6-thread-5:243 - done with data set, number of rows = 0 Apparently, my report manage to get the "connection" to the domain which gets the connection to the actual data source. But it seems that the connection is not "transfered" to the report leading to the WARNING which itself leads to the 0 row result. Did I miss something or is there a bug ? I'm on jasperreports-server-6.1.0 Thanks

Thanks for the reply. Actually, I've done all of that. The data source has been created directly from the server web interface and ad-hoc views on the data of the domain works well. The problem seems to be related only to the report. Do you see anything else to analyze ? Thanks

Hi, I've created a report in Studio. In that report, I've declared a dataset and a query (using domain). From the studio, when I go on preview for the data, it fetches my data and displays it. Still from the Studio, I can execute and see my report properly. Then, I upload my report on the server and there when I execute my report every thing goes properly a I have my report on the screen. My problem is that if I execute my report again 2 hours after, it displays no data (the No data band is displayed). After investigation, I understood why it works after having fetched the data from studio: The data are kept in a cache in the server for a while and then when the report is executed on the server it works. When I execute the report on the server when the data are not in the cache, the server is not able to fetch the data. I don't understand why. In both case, I can see the correct (and the same) DB request in the server cache. But when the request is inserted in the server on a request coming from the Studio it says that some rows have been fetched and when the request is inserted on a request from the server is says that there is no row. Does anyone have an idea on what I did wrong ? Thanks

Thanks for the response. Yes, my report has a data source defined. Actually, I've defined one through the jrxml file which is pushed to the server. When I click "edit" on the report in the server, I can see my data source which looks correct. I've tried in the server to unlink the data source and to redo the link in the server. It has leaded to the same result. I want to add that I use a "domain" as the data source. So far, I'm still stuck on the issue. Regards, Lionel

Hi, I'm new to Jasper and I shall admit that after a week fighting with it I'm about to resign. In JasperReports Server, I've defined a domain and an ad-hoc view on some data. It was pretty strait forward. Then I wanted to define a report on my data. Then I've installed Studio and in Studio, I've defined my report. In that report, I've defined what I wanted to see (a table and a chart in the summary). I've defined the data set. At that point every things seem to work properly: When defining the dataset, I can have the data preview. On my report, when I use the preview, I can see my report with its 15 records sorted as requested. Great ! Then I used Studio to push the report to JasperReports server. The push worked as I can see my report from JasperReports Server web GUI. But when I click to view that report from the web GUI, it displays no data (0 record) and the chart is present but empty. Does someone have an idea of what I might have missed ? Thanks