AnsweredAssumed Answered

Alfresco 3.2 community and Jboss 4.2.3 GA

Question asked by konsultex on Oct 26, 2009
Latest reply on Dec 30, 2009 by konsultex
I have an Alfresco 2.1 installation (community) with no customizations working fine in JBoss 4.0.5GA with JDK 1.5.0_x on FC4 but I need to upgrade Alfresco 2.1 to 3.2. Alfresco is one of 4 applications in this JBoss. Here's what I did, following the instructions in the wiki (

a) Stopped Jboss
b) backed up alf_data and the Mysql alfresco database
c) upgarded JDK to 1.6.0_16 (I felt that a newer Java would be e good idea)
d) upgraded to JBoss 4.2.3GA
e) Copied the old conf/alfresco to the new JBoss and copied the new war to /deploy
f) When I first restarted I got the error about the avm_issuer_ids table and I solved it:
g) I started again with a fresh restore of my SQL and alf_data backups (database with avm_issuer_ids) .
hI still get an error but I have no clue about the origin of the problem.

2009-10-25 22:22:23,938 INFO  [STDOUT] 22:22:23,938 User:System INFO  [admin.patch.PatchExecuter]       Applying patch 'patch.wcmPostPermissionSnapshotPatch3' (Snapshot stores (after fixing ACLs so they are only set on the staging area store).).                                          
2009-10-25 22:22:23,943 INFO  [STDOUT] 22:22:23,943 User:System ERROR [admin.patch.PatchExecuter] 09250001 com.ibatis.sqlmap.client.SqlMapException: There is no statement named select.AVMNodeEntitiesCountWhereNewInStore in this SqlMap.                                                    
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(                            
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(                                
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(                                
        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(                                          
        at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(                               
        at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(                                          
        at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(                                   
        at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(                                   
        at org.alfresco.repo.domain.patch.ibatis.PatchDAOImpl.getAVMNodeEntitiesCountWhereNewInStore(                     
        at org.alfresco.repo.domain.patch.AbstractPatchDAOImpl.getAVMNodesCountWhereNewInStore(                   
        at org.alfresco.repo.domain.hibernate.AclDaoComponentImpl.getNewInStore(                                 
        at org.alfresco.repo.admin.patch.impl.WCMPostPermissionSnapshotPatch.applyInternal(  

This happens about 40% into the completion of the "Patch".

Am I missing something else?