Hi,
I have upgrade my Jasperserver to v6.0.1 from v5.5. And my user are all registered by internal LDAP.
Unfortunately, all user with folder permission can't access the domain and reports(adhoc and report) after import.
When clicking the adhoc report, it always prompt access denied.
I check every permission setting on domain, role, temp folder, datasource... all the setting is the same as jasperserver v5.5.
Do anyone have this same issue? please help......
Many thanks
The error stack shown as following:
Error Message
org.springframework.security.access.AccessDeniedException: Access is denied
Error Trace
com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: org.springframework.security.access.AccessDeniedException: Access is denied at com.jaspersoft.ji.adhoc.strategy.StrategyAwareDomainQueryExecuter.createDatasource(StrategyAwareDomainQueryExecuter.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRQueryExecuterAdapter.executeQuery(JRQueryExecuterAdapter.java:108) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRQueryExecuterAdapter.executeQuery(JRQueryExecuterAdapter.java:83) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:2154) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at
Error Message
net.sf.jasperreports.engine.JRException: org.springframework.security.access.AccessDeniedException: Access is denied
Error Trace
net.sf.jasperreports.engine.JRException: org.springframework.security.access.AccessDeniedException: Access is denied at com.jaspersoft.ji.adhoc.strategy.StrategyAwareDomainQueryExecuter.createDatasource(StrategyAwareDomainQueryExecuter.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRQueryExecuterAdapter.executeQuery(JRQueryExecuterAdapter.java:108) at
Error Message
org.springframework.security.access.AccessDeniedException: Access is denied
Error Trace
org.springframework.security.access.AccessDeniedException: Access is denied at org.springframework.security.access.vote.AffirmativeBased.decide(AffirmativeBased.java:83) at org.springframework.security.access.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:206) at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:60) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at
3 Answers:
My problem was solved by this post
http://community.jaspersoft.com/questions/847936/accessdeniedexception-a...
"Appears to be a regression in 6.0.1 and at least a Read-Only permission on a Data Source is now required, while Execute-Only was sufficient in 5.5."
And the /temp folder should change to Read + Write + Delete , while Read + Write Only was sufficient in 5.5.
Jasper change the permission rule but no announcement or document about this.