There was an error on the server. Try again or contact site administrators.

[himabindu.meduri]

Can you please help me with the "Access is denied" on the input controls when running the report?

Request: Create a new role and assign permissions to the role to execute the report on-demand or schedule the report for immediate execution.

Created a new LDAP group and also edited js.externalAuth.properties and applicationContext-externalAuth.xml.

Validated that user is being generated with RoleA and ROLE_USER successfully.

Also, the user is able to see the report in the Reports list.

When the user tries to run the report, failing for authentication error for input controls.

Permissions tried:

Read Only for Role_A and ROLE_USER

Execute Only for Role A and Read only for ROLE_USER.

Observing the same error for both scenarios.

Root

Organization

FolderA

subfolderb under A

subfolder of subfolderb : Report exists in this subfolder

Server: Jasper 7.2

 

2021-09-30 16:32:34,654 ERROR ErrorPageHandlerAction,https-jsse-nio-8081-exec-9:118 - Error UID fc2140ce-3bb7-40ec-a1c3-b575e553d6ff
org.springframework.security.access.AccessDeniedException: Access is denied
        at org.springframework.security.access.vote.AffirmativeBased.decide(AffirmativeBased.java:84)
        at org.springframework.security.access.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:233)
        at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:65)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy106.getResource(Unknown Source)
        at com.jaspersoft.jasperserver.multipleTenancy.PathTransformationRepositoryService.getResource(PathTransformationRepositoryService.java:304)
        at com.jaspersoft.jasperserver.multipleTenancy.PathTransformationRepositoryService$$FastClassBySpringCGLIB$$48f48d6b.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:736)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:671)
        at com.jaspersoft.jasperserver.multipleTenancy.PathTransformationRepositoryService$$EnhancerBySpringCGLIB$$13fb158a.getResource(<generated>)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getRepositoryResource(EngineServiceImpl.java:2043)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getFinalFileResource(EngineServiceImpl.java:2076)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.loadFinalResources(EngineServiceImpl.java:1526)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.setContextClassLoader(EngineServiceImpl.java:1518)
        at com.jaspersoft.ji.engine.ProEngineServiceImpl.getReportInputControlsInformation(ProEngineServiceImpl.java:54)
        at com.jaspersoft.ji.engine.ProEngineServiceImpl.getReportInputControlsInformation(ProEngineServiceImpl.java:192)
        at com.jaspersoft.ji.engine.ProEngineServiceImpl$$FastClassBySpringCGLIB$$fd2f8cb9.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:736)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:9

[bigalex]

Check if Role A has the Execute Only permission for Data Source as well. The Execute Only for Input controls is enough. 

[dulanjanan]

Hi, Yes was able to fix my issue. it was with datasource permission. Thanks.!