ffranco_1

Hi, I'm having the following error message where running report using the ReportExecutions API ValidationErrorImpl{errorCode='null', arguments=null, properties=null, defaultMessage='Non acceptable value: 4500.00', field='orderAmount'} When running the same report from jasperserver itelf, the report is wokring fine. I'm passing the below value in the field mentioned in the error "name": "orderAmount", "value": [ "4500.00" ] see error when trying to extract the export : "exports": [ { "status": "failed", "errorDescriptor": { "message": "Input controls validation failure", "errorCode": "input.controls.validation.error", "parameters": [ "com.jaspersoft.jasperserver.api.ErrorDescriptorException: Input controls validation failure\r\n\tat com.jaspersoft.jasperserver.remote.services.ReportExecution.getFinalReportUnitResult(ReportExecution.java:173)\r\n\tat com.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl$2.run(RunReportServiceImpl.java:498)\r\n\tat com.jaspersoft.jasperserver.api.logging.util.LoggableExecutorService$1.run(LoggableExecutorService.java:84)\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\r\n\tat java.lang.Thread.run(Thread.java:750)\r\n" ] }, "id": "a6d0876d-1d36-433a-8e2b-0baff38dbcd0" Extract of Jasperserver log 2023-12-13T13:45:42,318 ERROR SecureExceptionHandlerImpl,pool-24-thread-3510:125 - Input controls validation failure com.jaspersoft.jasperserver.api.ErrorDescriptorException: Input controls validation failure at com.jaspersoft.jasperserver.remote.services.ReportExecution.getFinalReportUnitResult(ReportExecution.java:173) at com.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl$2.run(RunReportServiceImpl.java:498) at com.jaspersoft.jasperserver.api.logging.util.LoggableExecutorService$1.run(LoggableExecutorService.java:84) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Did someone encounter this isssue already and have a fix for it ? Thanks for your help. Frederic

Hi, I'm generating report using the reportExecutions endpoint. The output is a PDF file I need to password protect my PDF. Ideally I want the password to be dynamically retrieved in the query of my report and assigned when report is generating Is it possible ? If not is there any API that I can call to get the output of my report and setup the PDF export option like the user password ? I did not find anything in the reportExecutions in order to achieve this request. Thanks for your help.

Hello, I'm using Jasper server 8.0.2 version and I need to create a report using 2 queries from 2 different oracle databases. What is the best option 2 define the 2 datasource. I have tried defining the databases as file as below but i'm getting the error below when running the report any recommendation or help on the setup to do will be much appreciated. Sorry if this question was already asked and asnwered but i was not able to find it. Thanks, Frederic

Hello, I have a requirement from users to encrypt the PDF files generated based on the result of one query. The password should be set dynamically based on the value returned by a query. Is it possible ? And if yes this would be good if example can be shared. Thanks, Frederic