valeskyt

I think this is a permissions issue: - Jaspersoft Server is running as a local system account, which by default doesn't have network access Any Windows-network-saavy folks out there have a best-practices solution to this?

Server is Jaspersoft Community Edition 7.2.0, Windows 64 edition OS is Windows 10, and the network environment is Windows/Active Directory I've enabled filesystem output via the enableSaveToHostFS variable. I am able to save files to the locsl filesystem successfully. (for example, c:temp) However, when I try to save to a network share, I always get the error message "Enter a Valid Path" I've tried mounting the share to a local drive, using the full sharename, and all sorts of combinations thereof. I always get the error. Is there a way to save to a Windows share? I mean, I can set up a batch job to copy the output somewhere, but I'd rather not.

I'm having the same issue. I've tried linking it to a letter drive and using the full network path, and nothing seems to work.

I ended up wrapping the query in a CTE and adding a column with the value in question cast as an integer. I had to modify the validation string on the server to permit the CTE syntax, but it works fine, and I didn't need to rewrite the query or fiddle with the database schema. For a simpler query, I'd have simply added the extra column to the select statement.

What I'll probably end up doing is to edit the SQL to add a column where I cast the value to an integer, then sort on that in the crosstab instead of the "real" column. But I'm hoping there's a way to fix this at the Jaspersoft level.

Environment is Jaspersoft Studio Community Edition version 6.9.0 User has a crosstab report. The row values are integers from 1 to 12, but they are stored as Strings in the database. The issue is that, in String sort order, the rows are sorting as "1 10 11 2 3 4". They'd like them to sort in integer sort order: "1 2 3 ... 9 10 11 12". I'm trying to figure out how to make this happen. I think it's possible, but I can't find any documentation about crosstabs that goes this deep into the detail. I think the right answer will have something to do with the bucket grouping for the row group, but nothing I've tried so far has done the trick. Can anyone post an example of how to do this? Thanks, Tom

Platform is JasperReports Server Community Edition, v. 7.1 I have a user who has 10-12 reports. They'd like to run all the reports, then send the results out in a single email. I can't figure out a way to do this -- it seems like a scheduled job allows me to associate 1 PDF output file with 1 email, but I can't find a way to associate more than 1 PDF with the email. I envision setting up something like: schedule all the reports to run at 10:00, then schedule a followup job to send the generated PDFs out later. Is this possible? Is is possible on Jaspersoft Enterprise Server? Thanks, Tom

I have filed this as bug report 12026 https://community.jaspersoft.com/jaspersoft-studio/issues/12026

I have a user who is getting the same error. When I try the suggested workaround, I get a 404 error. On my desktop, I can deploy to the same server without error using the REST protocol, which indicates that it's an issue with the user's installation of Jaspersoft Studio. Are there any other settings I can fiddle with to fix this? It seems like a classpath problem from the error message.

Is there a way to create a parameter within the report creation wizard? What's the standard practice for creating a report that uses parameters in query? Do you just skip the query portion of the wizard, then create the parameters, then do the query in the "dataset and query" tool, then drag all the fields onto the report? Or do you just start out with the query without parameters, and add them later once you're done with the wizard and have the initial form created?

I'm using TIBCO Jaspersoft® Studio 6.8.0 - Visual Designer for JasperReports 6.8.0. I'm working through this tutorial https://community.jaspersoft.com/wiki/report-books-jaspersoft-studio When I enter the query in the section "Creating a Report Part for the Detail Section", it fails with this exception: net.sf.jasperreports.engine.JRRuntimeException: Parameter "country" does not exist. The query is: select * from orders where shipcountry = $P{country} order by shipcity The exception is correct; the tutorial does not define the 'country' parameter until close to the end, but I can't get past this point due to the exception. So how did the tutorial author get past this point without getting an exception? Thanks, Tom

I'm assisting a user with developing a report. The envirionment is: Jaspersoft Studio Community 6.8.0 Jaspersoft Reports Server Community Edition, version 7.1.0 The user has developed a report with a pie chart on it. The behavior I'm seeing is - When the report runs in Jaspersoft Studio, the pie chart displays - When I run the report on the server and export it to PDF, the pie chart appears in the PDF - But when I run the report in the browser, the chart does not appear. I'm guessing that this is something trivial, but I did some initial searching and couldn't find any similar questions. Does this issue sound familiar to anyone? Thanks, Tom

Found it! The problem was that there was a string literal with a semicolon embedded in it. After removing the semicolon, the query runs without error.

I turned off SQL validation, and the query runs successfully. I tried setting the master logging level to DEBUG to see if I'd get any more details about exactly what's failing, but I just get the generic exception I posted above. I suspect that the validator is just choking on the sheer size of the query (it's 857 lines long). At any rate, I'm not getting any info about exactly what the validator doesn't like about the query. I'd rather not turn off validation completly. Is there an "ignore validation for just this specific report" option?

I have a rather large SQL query that run successfully in the Jaspersoft Studio environment, but fails when I try to run it on the Jaspsersoft server. Here is the exception I see in the logs. Does this look familiar to anyone? If so, is there a fix/workaround? I have other queries of similar size that run OK. Thanks, Tom 2018-12-21 14:05:59,972 ERROR ErrorPageHandlerAction,http-nio-8080-exec-6:115 - Error UID 6eed9a99-d558-4b7b-9e55-b6a016df5086 com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) Arguments: at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:497) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:165) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:429) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:570) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:961) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:169) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1840) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1159) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1088) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:983) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 2018-12-21 14:10:03,743 ERROR Validator,pool-4-thread-29:496 - Invalid SQL:An error has occurred. Please contact your system administrator. (6632), SQL: (lengthy dump of SQL follows)