AnsweredAssumed Answered

Upgrading from Alfresco 3.0b labs to 3.4b, LDAP Sync problem

Question asked by andrea.benedetti on Dec 7, 2010
I'm upgrading the portal of my company from Alfresco 3.0.0 Labs to Community  3.4.0 b, passing throught Alfresco 3.2.
Alfresco runs with JBoss Portal 2.7.2 on JBoss 4.2.3.GA and Red Hat Enterprice Linux ES release 4.
Alfresco and JBoss Portal use Oracle 10g DBMS, so I installed oracle-3.2-community.amp into Alfresco 3.2 war and oracle-alfresco-3.4_a.amp plugin into Alfresco 3.4 war.
I had some problems with upgrading dm tables, but I solved by editing some sql script, both for 3.2 and 3.4 versions.
My Alfresco 3.4 can see all groups and users with their files and it can also login to LDAP new LDAP users, but I have some strange problems with LDAP synchronization when I start JBoss:

Groups problem:

2010-12-06 11:21:38,607 INFO  [STDOUT] 11:21:38,607  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Synchronization' subsystem, ID: [Synchronization, default]
2010-12-06 11:21:38,618 INFO  [STDOUT] 11:21:38,618  INFO  [alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
2010-12-06 11:21:38,635 INFO  [STDOUT] 11:21:38,635  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
2010-12-06 11:21:38,635 INFO  [STDOUT] 11:21:38,635  INFO  [alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
2010-12-06 11:21:38,635 INFO  [STDOUT] 11:21:38,635  INFO  [alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
2010-12-06 11:21:38,650 INFO  [STDOUT] 11:21:38,650  INFO  [alfresco.util.AbstractTriggerBean] Job syncTrigger is active
2010-12-06 11:21:38,680 INFO  [STDOUT] 11:21:38,680 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] Synchronizing users and groups with user registry 'ldap1'
2010-12-06 11:21:38,685 INFO  [STDOUT] 11:21:38,685 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] Retrieving all groups from user registry 'ldap1'
2010-12-06 11:21:38,791 INFO  [STDOUT] 11:21:38,791 User:System DEBUG [sync.ldap.LDAPUserRegistry] Found 15
2010-12-06 11:21:38,797 INFO  [STDOUT] 11:21:38,797 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] ldap1 Group Analysis: Commencing batch of 15 entries
2010-12-06 11:21:38,904 INFO  [STDOUT] 11:21:38,902  WARN  [security.sync.ChainingUserRegistrySynchronizer] ldap1 Group Analysis: Failed to process entry "cn=***,ou=***,ou=Groups,dc=***,dc=it".
org.alfresco.error.AlfrescoRuntimeException: 11060001 Required path not found: {http://www.alfresco.org/model/system/1.0}authorities
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getSystemContainer(AuthorityDAOImpl.java:715)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityContainer(AuthorityDAOImpl.java:680)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityOrNull(AuthorityDAOImpl.java:658)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityZones(AuthorityDAOImpl.java:809)
   at org.alfresco.repo.security.authority.AuthorityServiceImpl.getAuthorityZones(AuthorityServiceImpl.java:431)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1Analyzer.process(ChainingUserRegistrySynchronizer.java:676)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1Analyzer.process(ChainingUserRegistrySynchronizer.java:622)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.execute(BatchProcessor.java:706)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:377)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.run(BatchProcessor.java:752)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:619)
2010-12-06 11:21:38,907 INFO  [STDOUT] 11:21:38,907  WARN  [security.sync.ChainingUserRegistrySynchronizer] ldap1 Group Analysis: Failed to process entry "cn=***,ou=***,ou=Groups,dc=***,dc=it".
org.alfresco.error.AlfrescoRuntimeException: 11060002 Required path not found: {http://www.alfresco.org/model/system/1.0}authorities
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getSystemContainer(AuthorityDAOImpl.java:715)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityContainer(AuthorityDAOImpl.java:680)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityOrNull(AuthorityDAOImpl.java:658)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityZones(AuthorityDAOImpl.java:809)
   at org.alfresco.repo.security.authority.AuthorityServiceImpl.getAuthorityZones(AuthorityServiceImpl.java:431)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1Analyzer.process(ChainingUserRegistrySynchronizer.java:676)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1Analyzer.process(ChainingUserRegistrySynchronizer.java:622)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.execute(BatchProcessor.java:706)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:377)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.run(BatchProcessor.java:752)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:619)
2010-12-06 11:21:38,909 INFO  [STDOUT] 11:21:38,909  WARN  [security.sync.ChainingUserRegistrySynchronizer] ldap1 Group Analysis: Failed to process entry "cn=***,ou=***,ou=Groups,dc=***,dc=it".
org.alfresco.error.AlfrescoRuntimeException: 11060003 Required path not found: {http://www.alfresco.org/model/system/1.0}authorities
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getSystemContainer(AuthorityDAOImpl.java:715)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityContainer(AuthorityDAOImpl.java:680)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityOrNull(AuthorityDAOImpl.java:658)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityZones(AuthorityDAOImpl.java:809)
   at org.alfresco.repo.security.authority.AuthorityServiceImpl.getAuthorityZones(AuthorityServiceImpl.java:431)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1Analyzer.process(ChainingUserRegistrySynchronizer.java:676)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1Analyzer.process(ChainingUserRegistrySynchronizer.java:622)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.execute(BatchProcessor.java:706)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:377)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.run(BatchProcessor.java:752)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:619)
2010-12-06 11:21:38,911 INFO  [STDOUT] 11:21:38,910  WARN  [security.sync.ChainingUserRegistrySynchronizer] ldap1 Group Analysis: Failed to process entry "cn=***,ou=***,ou=Groups,dc=***,dc=it".
org.alfresco.error.AlfrescoRuntimeException: 11060004 Required path not found: {http://www.alfresco.org/model/system/1.0}authorities
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getSystemContainer(AuthorityDAOImpl.java:715)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityContainer(AuthorityDAOImpl.java:680)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityOrNull(AuthorityDAOImpl.java:658)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getAuthorityZones(AuthorityDAOImpl.java:809)
   at org.alfresco.repo.security.authority.AuthorityServiceImpl.getAuthorityZones(AuthorityServiceImpl.java:431)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1Analyzer.process(ChainingUserRegistrySynchronizer.java:676)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1Analyzer.process(ChainingUserRegistrySynchronizer.java:622)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.execute(BatchProcessor.java:706)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:377)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.run(BatchProcessor.java:752)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:619)
2010-12-06 11:21:38,912 INFO  [STDOUT] 11:21:38,912  WARN  [security.sync.ChainingUserRegistrySynchronizer] ldap1 Group Analysis: Failed to process entry "cn=CCO,ou=AssoCat,ou=Groups,dc=sose,dc=it".
org.alfresco.error.AlfrescoRuntimeException: 11060005 Required path not found: {http://www.alfresco.org/model/system/1.0}authorities

Users problem:

2010-12-06 11:21:39,187 INFO  [STDOUT] 11:21:39,187  WARN  [security.sync.ChainingUserRegistrySynchronizer] Updating user '***'. This user will in future be assumed to originate from user registry 'ldap1'.
2010-12-06 11:21:39,192 INFO  [STDOUT] 11:21:39,192  WARN  [security.sync.ChainingUserRegistrySynchronizer] ldap1 User Creation and Association: Failed to process entry "cn=***,ou=Users,dc=***,dc=it".
org.alfresco.error.AlfrescoRuntimeException: 11060016 Required path not found: {http://www.alfresco.org/model/system/1.0}zones
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getSystemContainer(AuthorityDAOImpl.java:715)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getZoneContainer(AuthorityDAOImpl.java:688)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getOrCreateZone(AuthorityDAOImpl.java:779)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getOrCreateZone(AuthorityDAOImpl.java:774)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.addAuthorityToZones(AuthorityDAOImpl.java:858)
   at org.alfresco.repo.security.authority.AuthorityServiceImpl.addAuthorityToZones(AuthorityServiceImpl.java:451)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1PersonWorker.process(ChainingUserRegistrySynchronizer.java:1232)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1PersonWorker.process(ChainingUserRegistrySynchronizer.java:1154)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.execute(BatchProcessor.java:706)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:377)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.run(BatchProcessor.java:752)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:619)
2010-12-06 11:21:39,199 INFO  [STDOUT] 11:21:39,199  WARN  [security.sync.ChainingUserRegistrySynchronizer] Updating user '***'. This user will in future be assumed to originate from user registry 'ldap1'.
2010-12-06 11:21:39,206 INFO  [STDOUT] 11:21:39,206  WARN  [security.sync.ChainingUserRegistrySynchronizer] ldap1 User Creation and Association: Failed to process entry "cn=***,ou=Users,dc=sose,dc=it".
org.alfresco.error.AlfrescoRuntimeException: 11060017 Required path not found: {http://www.alfresco.org/model/system/1.0}zones
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getSystemContainer(AuthorityDAOImpl.java:715)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getZoneContainer(AuthorityDAOImpl.java:688)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getOrCreateZone(AuthorityDAOImpl.java:779)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.getOrCreateZone(AuthorityDAOImpl.java:774)
   at org.alfresco.repo.security.authority.AuthorityDAOImpl.addAuthorityToZones(AuthorityDAOImpl.java:858)
   at org.alfresco.repo.security.authority.AuthorityServiceImpl.addAuthorityToZones(AuthorityServiceImpl.java:451)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1PersonWorker.process(ChainingUserRegistrySynchronizer.java:1232)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$1PersonWorker.process(ChainingUserRegistrySynchronizer.java:1154)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.execute(BatchProcessor.java:706)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:377)
   at org.alfresco.repo.batch.BatchProcessor$TxnCallback.run(BatchProcessor.java:752)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:619)

I have this errors repeated for all my groups and users, so I put only some.
I used * to not reveal real values.

Thank for a reply

Outcomes