Can' t log on Alfresco

[boonthung]

Hi, All

Alfresco hang  2-3 time per day, first page appear but  user can't logon

Version: 4.2

Data size   400GB

Alfresco log, show.

Caused by: org.alfresco.repo.security.permissions.AccessDeniedException: 09130050 Access Denied.  You do not have the appropriate permissions to perform this operation.

  at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:50)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

  at org.alfresco.repo.audit.AuditMethodInterceptor.proceedWithAudit(AuditMethodInterceptor.java:247)

  at org.alfresco.repo.audit.AuditMethodInterceptor.proceed(AuditMethodInterceptor.java:213)

  at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:166)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

  at org.alfresco.repo.transaction.RetryingTransactionInterceptor$1.execute(RetryingTransactionInterceptor.java:79)

  at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)

  at org.alfresco.repo.transaction.RetryingTransactionInterceptor.invoke(RetryingTransactionInterceptor.java:69)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

  at com.sun.proxy.$Proxy9.getChildAssocsByPropertyValue(Unknown Source)

  at org.alfresco.repo.publishing.PublishingEventHelper$3.apply(PublishingEventHelper.java:421)

  at org.alfresco.repo.publishing.PublishingEventHelper$3.apply(PublishingEventHelper.java:417)

  at org.alfresco.repo.publishing.PublishingEventHelper.getEventNodesForPublishedNode(PublishingEventHelper.java:392)

  at org.alfresco.repo.publishing.PublishServiceImpl.getPublishEventsForNode(PublishServiceImpl.java:76)

  at org.alfresco.repo.web.scripts.publishing.PublishingEventsGet.getSortedPublishingEvents(PublishingEventsGet.java:71)

  at org.alfresco.repo.web.scripts.publishing.PublishingEventsGet.executeImpl(PublishingEventsGet.java:58)

  ... 29 more

Caused by: net.sf.acegisecurity.AccessDeniedException: Access is denied.

  at net.sf.acegisecurity.vote.AffirmativeBased.decide(AffirmativeBased.java:86)

  at net.sf.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:398)

  at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:77)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

  at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)

  ... 46 more

14:16:13,241 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: 09130004 Failed to query for publishing events for node: workspace://SpacesStore/6e58d648-37d6-4a37-8213-a3cf5d0f8cbc

org.springframework.extensions.webscripts.WebScriptException: 09130004 Failed to query for publishing events for node: workspace://SpacesStore/6e58d648-37d6-4a37-8213-a3cf5d0f8cbc

  at org.alfresco.repo.web.scripts.publishing.PublishingEventsGet.executeImpl(PublishingEventsGet.java:65)

  at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)

  at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:429)

  at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)

  at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:491)

  at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:529)

  at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:341)

  at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)

  at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)

  at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)

  at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

  at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

  at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)

  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)

  at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

  at java.lang.Thread.run(Thread.java:724)

Caused by: org.alfresco.repo.security.permissions.AccessDeniedException: 09130053 Access Denied.  You do not have the appropriate permissions to perform this operation.

  at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:50)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

  at org.alfresco.repo.audit.AuditMethodInterceptor.proceedWithAudit(AuditMethodInterceptor.java:247)

  at org.alfresco.repo.audit.AuditMethodInterceptor.proceed(AuditMethodInterceptor.java:213)

  at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:166)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

  at org.alfresco.repo.transaction.RetryingTransactionInterceptor$1.execute(RetryingTransactionInterceptor.java:79)

  at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)

  at org.alfresco.repo.transaction.RetryingTransactionInterceptor.invoke(RetryingTransactionInterceptor.java:69)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

  at com.sun.proxy.$Proxy9.getChildAssocsByPropertyValue(Unknown Source)

  at org.alfresco.repo.publishing.PublishingEventHelper$3.apply(PublishingEventHelper.java:421)

  at org.alfresco.repo.publishing.PublishingEventHelper$3.apply(PublishingEventHelper.java:417)

  at org.alfresco.repo.publishing.PublishingEventHelper.getEventNodesForPublishedNode(PublishingEventHelper.java:392)

  at org.alfresco.repo.publishing.PublishServiceImpl.getPublishEventsForNode(PublishServiceImpl.java:76)

  at org.alfresco.repo.web.scripts.publishing.PublishingEventsGet.getSortedPublishingEvents(PublishingEventsGet.java:71)

  at org.alfresco.repo.web.scripts.publishing.PublishingEventsGet.executeImpl(PublishingEventsGet.java:58)

  ... 29 more

Caused by: net.sf.acegisecurity.AccessDeniedException: Access is denied.

  at net.sf.acegisecurity.vote.AffirmativeBased.decide(AffirmativeBased.java:86)

  at net.sf.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:398)

  at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:77)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

  at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)

[mrks_js1]

do you have to restart the application to be able to login again?

you seem to have some issues with the db as well. please also post your alfresco-global.properties

[boonthung]

Thank  you, joobs

when alfresco hang,  can't stop tomcat and status show alway running

database look OK,  because I can connect and  select data from some tables as attachment,

Boonthung,

[boonthung]

###############################

## Common Alfresco Properties #

###############################

dir.root=C:/ALFRES~1/alf_data

alfresco.context=alfresco

alfresco.host=xxx.xxx.xxx.xxx

alfresco.port=8080

alfresco.protocol=http

share.context=share

share.host=xxx.xxx.xxx.xxx

share.port=8080

share.protocol=http

### database connection properties ###

db.driver=org.postgresql.Driver

db.username=alfresco

db.password=1234

db.name=alfresco

db.url=jdbcostgresql://localhost:5432/${db.name}

### FTP Server Configuration ###

ftp.enabled=true

ftp.port=21

### RMI service ports ###

alfresco.rmi.services.port=50500

avm.rmi.service.port=0

avmsync.rmi.service.port=0

attribute.rmi.service.port=0

authentication.rmi.service.port=0

repo.rmi.service.port=0

action.rmi.service.port=0

deployment.rmi.service.port=0

### External executable locations ###

ooo.exe=C:/Alfresco1/libreoffice/App/libreoffice/program/soffice.exe

ooo.enabled=true

ooo.port=8100

img.root=C:\\Alfresco1\\imagemagick

img.coders=${img.root}\\modules\\coders

img.config=${img.root}\\config

img.gslib=${img.root}\\lib

img.exe=${img.root}\\convert.exe

swf.exe=C:/ALFRES~1/swftools/pdf2swf.exe

swf.languagedir=C:/ALFRES~1/swftools/japanese

jodconverter.enabled=false

jodconverter.officeHome=C:/Alfresco1/libreoffice/App/libreoffice

jodconverter.portNumbers=8100

### Initial admin password ###

alfresco_user_store.adminpassword=7ce21f17c0aee7fb9ceba532d0546ad6

### E-mail site invitation setting ###

notification.email.siteinvite=false

### License location ###

dir.license.external=C:/ALFRES~1

### Solr indexing ###

index.subsystem.name=solr

dir.keystore=${dir.root}/keystore

solr.port.ssl=8443

### BPM Engine ###

system.workflow.engine.jbpm.enabled=false

# Sample Gmail settings

mail.host=192.168.1.210

mail.port=25

mail.username=alfresco@xxxx.com

#Audit Log

audit.enabled=true

audit.alfresco-access.enabled=true

#Add By Boonthung 19/04/59

db.schema.update=false

[boonthung]

[angelborroy]

How many RAM are you using for Alfresco repo? With that size 16-24 GB seems required.

[boonthung]

Hi, Borroy

Alfreco server run on ESxi 5

OS: Windows 2008 R2 std

Memory 16GB

CPU: 8vCPU

[angelborroy]

And how many of this RAM is dedicated to Tomcat?

If 16 GB is for the whole server, maybe you need to increase your RAM.

Check "Tomcat and JAVA_OPTS" point at Technical Tips

[boonthung]

Hi, Borroy

Thank you,

I already increase memory as attachment, Should I increase memory more then this?

[angelborroy]

4 GB is too low for your repository size.

IMO, you should use (at least) 16 GB.