Access Denied when Import Jasperserver 6.0 from 5.5

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

starrlingo's picture
Joined: Aug 23 2013 - 1:06am
Last seen: 5 years 1 month ago

3 Answers:

JasperReports Server changed security framework from SpringSecurity 2 to SpringSecurity3. You'll need to set your ldap again for SpringSecurity3.

hozawa's picture
170317
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 9 months ago

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. angry

 

starrlingo's picture
Joined: Aug 23 2013 - 1:06am
Last seen: 5 years 1 month ago

The Read-Only permission fixed worked for me.  We upgraded from 6.0.0 to 6.2

steveo250k's picture
Joined: Jan 7 2012 - 6:29am
Last seen: 7 years 3 months ago
Feedback
randomness