Jump to content
We've recently updated our Privacy Statement, available here ×

JasperServer migration v7.5 to v8.2.0 - Input controls validation failure

naumchik2301

By naumchik2301
in Products

 Share

Recommended Posts

naumchik2301 Rookie

naumchik2301

Posted
Posted

Hello,

After migration JRS from v7.5 to v8.2  we have problem with input parameter that used as temporary password in PDF file.

For tests I have created parameter as Query :  

select md5(cast(1+random() as text)) fkey;

When I open report I can see calculated parameter

image.png.6f3a090298c250069a88931cb54f6899.png

 

When I push "Apply",  It raise exception and in log file I see: 

2023-12-11T08:46:54,422 DEBUG ReportExecution,http-nio-8089-exec-4:201 - Report unit result is provided for report execution '06437f19-4fb9-4f23-acd8-bb28f16656a2'
2023-12-11T08:46:54,423 DEBUG ReportExecution,http-nio-8089-exec-4:333 - Setting report execution status to: execution
2023-12-11T08:46:54,423 DEBUG ReportExecution,http-nio-8089-exec-4:340 - Status of report execution '06437f19-4fb9-4f23-acd8-bb28f16656a2' is changed to execution
2023-12-11T08:46:54,423 DEBUG ReportExecution,http-nio-8089-exec-4:333 - Setting report execution status to: queued
2023-12-11T08:46:54,424 DEBUG ReportExecution,http-nio-8089-exec-4:340 - Status of report execution '06437f19-4fb9-4f23-acd8-bb28f16656a2' is changed to queued
2023-12-11T08:46:54,424 DEBUG ReportExecution,http-nio-8089-exec-4:201 - Report unit result is provided for report execution '06437f19-4fb9-4f23-acd8-bb28f16656a2'
2023-12-11T08:46:54,444 DEBUG EngineServiceImpl,pool-6-thread-4:2520 - Setting report parameter LoggedInUser to MetadataUserDetails: jasperadmin
2023-12-11T08:46:54,444 DEBUG EngineServiceImpl,pool-6-thread-4:2520 - Setting report parameter LoggedInUsername to jasperadmin
2023-12-11T08:46:54,450 DEBUG ReportExecution,pool-6-thread-4:287 - Status of report execution '06437f19-4fb9-4f23-acd8-bb28f16656a2' is changed to failed. Error descriptor: ErrorDescriptor{message='Input controls validation failure', errorCode='input.controls.validation.error', parameters=[ValidationErrorImpl{errorCode='null', arguments=null, properties=null, defaultMessage='Non acceptable value: f3ba742bc6cf2b8a95618a29ecce0d74', field='passkey'}], properties=null, details=null, errorUid='null', exception=null}
2023-12-11T08:46:54,604 ERROR SecureExceptionHandlerImpl,pool-6-thread-4:125 - There was an error on the server. Try again or contact site administrators. (Error UID: fea0661c-0cc6-4f6a-8ad2-d5d0efc8b201) 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:538)
        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:748)

If I change SQL to select 'cd985d978efa1746a9dd9de9d63b2dc7 '  fkey; it works

All validation settings are OFF.

Maybe Somebody takes the same problem and know how to solve it.

BR, Oleg

Thx

 

Link to comment
Share on other sites
  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Posted Images

Mehak Rajkumar Enthusiast

Mehak Rajkumar

Posted
Posted

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.
 

Link to comment
Share on other sites
Akshay Khedkar Rookie

Akshay Khedkar

Posted
Posted

Kindly set the following loggers in the debug mode and provide the jasperserver.log file to us. (JRS-> Manage-> Server Setting-> Log Setting)

1. com.jaspersoft.jasperserver.api.metadata.common.util.ValidationUtil

2.SQL query executer -> net.sf.jasperreports.engine.query.JRJdbcQueryExecuter

3.Cascading input control parameter resolution -> com.jaspersoft.jasperserver.war.cascade.token.FilterCore

4. Input control value queries -> valueQueryLog

5.Cascading input control parameter resolution -> com.jaspersoft.jasperserver.war.cascade.token.FilterCore
 

Link to comment
Share on other sites
naumchik2301 Rookie

naumchik2301

Posted
  • Author
Posted

Greeting All,

Log settings changed

image.thumb.png.d2039951e9de207c1431d05a7b7e0056.png

Please find Josperserver log below: 

[root@reports-jasper-01 logs]# cat ./jasperserver.log
2023-12-15T08:12:29,625 ERROR JNDIResourceProvider,Catalina-utility-2:75 - error closing context javax.naming.OperationNotSupportedException: Context is read only
        at org.apache.naming.NamingContext.checkWritable(NamingContext.java:1002)
        at org.apache.naming.NamingContext.close(NamingContext.java:765)
        at com.tonbeller.tbutils.res.JNDIResourceProvider.close(JNDIResourceProvider.java:72)
        at com.tonbeller.tbutils.res.CompositeResourceProvider.close(CompositeResourceProvider.java:56)
        at com.tonbeller.tbutils.res.ResourcesFactory.initialize(ResourcesFactory.java:163)
        at com.tonbeller.tbutils.res.ResourcesFactory.<init>(ResourcesFactory.java:92)
        at com.tonbeller.tbutils.res.ResourcesFactory.<clinit>(ResourcesFactory.java:89)
        at com.tonbeller.tbutils.res.ResourcesFactoryContextListener.contextInitialized(ResourcesFactoryContextListener.java:23)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4493)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4939)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:683)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:658)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:662)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1184)
        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1932)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)

2023-12-15T08:12:44,186 ERROR CsrfGuard,http-nio-8089-exec-1:45 - potential cross-site request forgery (CSRF) attack thwarted (user:<anonymous>, ip:10.21.12.9, method:POST, uri:/jasperserver/exituser.html, error:CsrfGuard expects the token to exist in session at this point)
2023-12-15T08:13:06,092 DEBUG EngineServiceImpl,http-nio-8089-exec-1:2901 - compiling report /GDPR/DataAccess_test_files/Main jrxml
2023-12-15T08:13:06,492 DEBUG EngineServiceImpl,http-nio-8089-exec-1:2209 - compiling report DataAccess_test
2023-12-15T08:13:07,174 DEBUG EngineServiceImpl,http-nio-8089-exec-5:2520 - Setting report parameter LoggedInUser to MetadataUserDetails: jasperadmin
2023-12-15T08:13:07,175 DEBUG EngineServiceImpl,http-nio-8089-exec-5:2520 - Setting report parameter LoggedInUsername to jasperadmin
2023-12-15T08:13:07,196 DEBUG EngineServiceImpl,http-nio-8089-exec-7:2520 - Setting report parameter LoggedInUser to MetadataUserDetails: jasperadmin
2023-12-15T08:13:07,196 DEBUG EngineServiceImpl,http-nio-8089-exec-7:2520 - Setting report parameter LoggedInUsername to jasperadmin
2023-12-15T08:13:07,235 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:154 - DB is PostgreSQL version 14.9 (14/9)
2023-12-15T08:13:07,235 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:158 - driver is PostgreSQL JDBC Driver version 42.5.4 (42/5)
2023-12-15T08:13:07,235 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:162 - jdbc 4/2
2023-12-15T08:13:07,235 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:164 - connection URL is jdbc:postgresql://master.bi3.pgsql:5441/bi
2023-12-15T08:13:07,236 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:206 - system timezone is sun.util.calendar.ZoneInfo[id="UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]
2023-12-15T08:13:07,236 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:207 - report timezone is null
2023-12-15T08:13:07,236 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:208 - JDBC timezone parameter is null
2023-12-15T08:13:07,236 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:209 - JDBC timezone property is null
2023-12-15T08:13:07,236 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:215 - JDBC parameters timezone parameter is null
2023-12-15T08:13:07,237 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:227 - JDBC parameters timezone property is null
2023-12-15T08:13:07,237 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:234 - parameters timezone null
2023-12-15T08:13:07,237 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:240 - JDBC fields timezone parameter is null
2023-12-15T08:13:07,237 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:252 - JDBC fields timezone property is null
2023-12-15T08:13:07,238 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:259 - fields timezone null
2023-12-15T08:13:07,239 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:382 - SQL query string: select md5(cast(1+random() as text)) fkey;

2023-12-15T08:13:07,241 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:307 - Executing query
2023-12-15T08:13:07,243 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-5:322 - Query execution done
2023-12-15T08:13:07,248 DEBUG valueQueryLog,http-nio-8089-exec-5:2420 - query took 23 ms: select md5(cast(1+random() as text)) fkey;

2023-12-15T08:13:07,249 DEBUG valueQueryLog,http-nio-8089-exec-5:2421 - params: {LoggedInUsername=jasperadmin, datasourceURI=/config/bi3, REPORT_CONNECTION=jdbc:postgresql://server:5441/bi, UserName=bi, PostgreSQL JDBC Driver, DATABASE_TIMEZONE=sun.util.calendar.ZoneInfo[id="UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null], LoggedInUser=MetadataUserDetails: jasperadmin}
2023-12-15T08:13:07,250 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:154 - DB is PostgreSQL version 14.9 (14/9)
2023-12-15T08:13:07,251 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:158 - driver is PostgreSQL JDBC Driver version 42.5.4 (42/5)
2023-12-15T08:13:07,251 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:162 - jdbc 4/2
2023-12-15T08:13:07,251 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:164 - connection URL is jdbc:postgresql://server:5441/bi
2023-12-15T08:13:07,251 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:206 - system timezone is sun.util.calendar.ZoneInfo[id="UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]
2023-12-15T08:13:07,251 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:207 - report timezone is null
2023-12-15T08:13:07,252 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:208 - JDBC timezone parameter is null
2023-12-15T08:13:07,252 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:209 - JDBC timezone property is null
2023-12-15T08:13:07,252 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:215 - JDBC parameters timezone parameter is null
2023-12-15T08:13:07,252 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:227 - JDBC parameters timezone property is null
2023-12-15T08:13:07,252 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:234 - parameters timezone null
2023-12-15T08:13:07,253 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:240 - JDBC fields timezone parameter is null
2023-12-15T08:13:07,253 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:252 - JDBC fields timezone property is null
2023-12-15T08:13:07,253 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:259 - fields timezone null
2023-12-15T08:13:07,254 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:382 - SQL query string: select md5(cast(1+random() as text)) fkey;

2023-12-15T08:13:07,254 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:307 - Executing query
2023-12-15T08:13:07,255 DEBUG JRJdbcQueryExecuter,http-nio-8089-exec-7:322 - Query execution done
2023-12-15T08:13:07,256 DEBUG valueQueryLog,http-nio-8089-exec-7:2420 - query took 5 ms: select md5(cast(1+random() as text)) fkey;

2023-12-15T08:13:07,256 DEBUG valueQueryLog,http-nio-8089-exec-7:2421 - params: {LoggedInUsername=jasperadmin, datasourceURI=/config/bi3, REPORT_CONNECTION=jdbc:postgresql://server:5441/bi, UserName=bi, PostgreSQL JDBC Driver, DATABASE_TIMEZONE=sun.util.calendar.ZoneInfo[id="UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null], LoggedInUser=MetadataUserDetails: jasperadmin}
2023-12-15T08:13:10,973 DEBUG ReportExecution,http-nio-8089-exec-10:201 - Report unit result is provided for report execution '6172c44d-6654-4534-b243-32771e58b224'
2023-12-15T08:13:10,974 DEBUG ReportExecution,http-nio-8089-exec-10:333 - Setting report execution status to: execution
2023-12-15T08:13:10,974 DEBUG ReportExecution,http-nio-8089-exec-10:340 - Status of report execution '6172c44d-6654-4534-b243-32771e58b224' is changed to execution
2023-12-15T08:13:10,976 DEBUG ReportExecution,http-nio-8089-exec-10:333 - Setting report execution status to: queued
2023-12-15T08:13:10,976 DEBUG ReportExecution,http-nio-8089-exec-10:340 - Status of report execution '6172c44d-6654-4534-b243-32771e58b224' is changed to queued
2023-12-15T08:13:10,977 DEBUG ReportExecution,http-nio-8089-exec-10:201 - Report unit result is provided for report execution '6172c44d-6654-4534-b243-32771e58b224'
2023-12-15T08:13:11,084 DEBUG EngineServiceImpl,pool-6-thread-1:2520 - Setting report parameter LoggedInUser to MetadataUserDetails: jasperadmin
2023-12-15T08:13:11,084 DEBUG EngineServiceImpl,pool-6-thread-1:2520 - Setting report parameter LoggedInUsername to jasperadmin
2023-12-15T08:13:11,085 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:154 - DB is PostgreSQL version 14.9 (14/9)
2023-12-15T08:13:11,085 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:158 - driver is PostgreSQL JDBC Driver version 42.5.4 (42/5)
2023-12-15T08:13:11,085 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:162 - jdbc 4/2
2023-12-15T08:13:11,085 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:164 - connection URL is jdbc:postgresql://server:5441/bi
2023-12-15T08:13:11,085 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:206 - system timezone is sun.util.calendar.ZoneInfo[id="UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]
2023-12-15T08:13:11,085 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:207 - report timezone is null
2023-12-15T08:13:11,085 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:208 - JDBC timezone parameter is null
2023-12-15T08:13:11,085 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:209 - JDBC timezone property is null
2023-12-15T08:13:11,086 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:215 - JDBC parameters timezone parameter is null
2023-12-15T08:13:11,086 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:227 - JDBC parameters timezone property is null
2023-12-15T08:13:11,086 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:234 - parameters timezone null
2023-12-15T08:13:11,086 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:240 - JDBC fields timezone parameter is null
2023-12-15T08:13:11,086 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:252 - JDBC fields timezone property is null
2023-12-15T08:13:11,086 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:259 - fields timezone null
2023-12-15T08:13:11,086 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:382 - SQL query string: select md5(cast(1+random() as text)) fkey;

2023-12-15T08:13:11,087 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:307 - Executing query
2023-12-15T08:13:11,088 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:322 - Query execution done
2023-12-15T08:13:11,088 DEBUG valueQueryLog,pool-6-thread-1:2420 - query took 4 ms: select md5(cast(1+random() as text)) fkey;

2023-12-15T08:13:11,088 DEBUG valueQueryLog,pool-6-thread-1:2421 - params: {LoggedInUsername=jasperadmin, datasourceURI=/config/bi3, REPORT_CONNECTION=jdbc:postgresql://server:5441/bi, UserName=bi, PostgreSQL JDBC Driver, DATABASE_TIMEZONE=sun.util.calendar.ZoneInfo[id="UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null], LoggedInUser=MetadataUserDetails: jasperadmin}
2023-12-15T08:13:11,098 DEBUG ReportExecution,pool-6-thread-1:287 - Status of report execution '6172c44d-6654-4534-b243-32771e58b224' is changed to failed. Error descriptor: ErrorDescriptor{message='Input controls validation failure', errorCode='input.controls.validation.error', parameters=[ValidationErrorImpl{errorCode='null', arguments=null, properties=null, defaultMessage='Non acceptable value: 1d1a92059d50b87319f0e4541a805890', field='passkey'}], properties=null, details=null, errorUid='null', exception=null}
2023-12-15T08:13:11,196 ERROR SecureExceptionHandlerImpl,pool-6-thread-1:125 - There was an error on the server. Try again or contact site administrators. (Error UID: 49f1438d-5ff8-4e6c-9da4-d20467617f67) 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:538)
        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:748)

2023-12-15T08:13:13,450 DEBUG ReportExecution,http-nio-8089-exec-6:201 - Report unit result is provided for report execution '303d9074-dd5d-4369-99b8-4365979862bf'
2023-12-15T08:13:13,450 DEBUG ReportExecution,http-nio-8089-exec-6:333 - Setting report execution status to: execution
2023-12-15T08:13:13,450 DEBUG ReportExecution,http-nio-8089-exec-6:340 - Status of report execution '303d9074-dd5d-4369-99b8-4365979862bf' is changed to execution
2023-12-15T08:13:13,450 DEBUG ReportExecution,http-nio-8089-exec-6:333 - Setting report execution status to: queued
2023-12-15T08:13:13,451 DEBUG ReportExecution,http-nio-8089-exec-6:340 - Status of report execution '303d9074-dd5d-4369-99b8-4365979862bf' is changed to queued
2023-12-15T08:13:13,451 DEBUG ReportExecution,http-nio-8089-exec-6:201 - Report unit result is provided for report execution '303d9074-dd5d-4369-99b8-4365979862bf'
2023-12-15T08:13:13,482 DEBUG EngineServiceImpl,pool-6-thread-1:2520 - Setting report parameter LoggedInUser to MetadataUserDetails: jasperadmin
2023-12-15T08:13:13,483 DEBUG EngineServiceImpl,pool-6-thread-1:2520 - Setting report parameter LoggedInUsername to jasperadmin
2023-12-15T08:13:13,483 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:154 - DB is PostgreSQL version 14.9 (14/9)
2023-12-15T08:13:13,483 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:158 - driver is PostgreSQL JDBC Driver version 42.5.4 (42/5)
2023-12-15T08:13:13,483 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:162 - jdbc 4/2
2023-12-15T08:13:13,483 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:164 - connection URL is jdbc:postgresql://master.bi3.pgsql:5441/bi
2023-12-15T08:13:13,483 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:206 - system timezone is sun.util.calendar.ZoneInfo[id="UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null]
2023-12-15T08:13:13,483 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:207 - report timezone is null
2023-12-15T08:13:13,483 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:208 - JDBC timezone parameter is null
2023-12-15T08:13:13,483 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:209 - JDBC timezone property is null
2023-12-15T08:13:13,484 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:215 - JDBC parameters timezone parameter is null
2023-12-15T08:13:13,484 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:227 - JDBC parameters timezone property is null
2023-12-15T08:13:13,484 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:234 - parameters timezone null
2023-12-15T08:13:13,484 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:240 - JDBC fields timezone parameter is null
2023-12-15T08:13:13,484 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:252 - JDBC fields timezone property is null
2023-12-15T08:13:13,484 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:259 - fields timezone null
2023-12-15T08:13:13,484 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:382 - SQL query string: select md5(cast(1+random() as text)) fkey;

2023-12-15T08:13:13,484 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:307 - Executing query
2023-12-15T08:13:13,485 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:322 - Query execution done
2023-12-15T08:13:13,485 DEBUG valueQueryLog,pool-6-thread-1:2420 - query took 2 ms: select md5(cast(1+random() as text)) fkey;

2023-12-15T08:13:13,485 DEBUG valueQueryLog,pool-6-thread-1:2421 - params: {LoggedInUsername=jasperadmin, datasourceURI=/config/bi3, REPORT_CONNECTION=jdbc:postgresql://mserver:5441/bi, UserName=bi, PostgreSQL JDBC Driver, DATABASE_TIMEZONE=sun.util.calendar.ZoneInfo[id="UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null], LoggedInUser=MetadataUserDetails: jasperadmin}
2023-12-15T08:13:13,489 DEBUG ReportExecution,pool-6-thread-1:287 - Status of report execution '303d9074-dd5d-4369-99b8-4365979862bf' is changed to failed. Error descriptor: ErrorDescriptor{message='Input controls validation failure', errorCode='input.controls.validation.error', parameters=[ValidationErrorImpl{errorCode='null', arguments=null, properties=null, defaultMessage='Non acceptable value: 1d1a92059d50b87319f0e4541a805890', field='passkey'}], properties=null, details=null, errorUid='null', exception=null}
2023-12-15T08:13:13,607 ERROR SecureExceptionHandlerImpl,pool-6-thread-1:125 - There was an error on the server. Try again or contact site administrators. (Error UID: f152f5bf-c916-4315-a659-aaf2c89c950e) 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:538)
        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:748)

 

Link to comment
Share on other sites
  • 4 months later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore