[Input controls validation failure when running reportExecutions API]

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

 

[Password protect PDF using reportExecutions API ?]

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.

[How to use 2 datasources from 2 differents from Oracle database in Jasper server]

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

[Is it possible to set net.sf.jasperreports.export.pdf.user.password property dinamically]

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