Upgrade from 4.0 b

Table of Contents Note System Known Issues Unable to validate database schema Context initialization failed Workaround Cleanup database schema after upgrade Drop ALF_*ATTRIBUTE* tables (if exist) Recreate IDX_AVM_VR_UQ and drop unnamed constraint Fix type of column ID_ in table ACT_HI_DETAIL

Note

Our tests has been done without data. Please run a test migration with a copy of your real data. Some of the old schemes contains small errors, which we were not able to fix at the current time. If you want a clean scheme, you need to fix it manually.

System

Linux: Ubuntu Linux Server

Java: Oracle JDK 1.7

Alfresco version: 4.0_b

Alfresco Oracle version: 4.0_b (from Paul Web)

Oracle version: 10.2g

Known Issues

Unable to validate database schema

 java.lang.RuntimeException: Unable to execute export.
        at org.alfresco.util.schemacomp.ExportDb.execute(ExportDb.java:178)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.attemptValidateSchema(SchemaBootstrap.java:1865)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.validateSchema(SchemaBootstrap.java:1812)
        at org.alfresco.repo.domain.schema.SchemaBootstrap.validateSchema(SchemaBootstrap.java:1799)
 ...
 Caused by: java.lang.NullPointerException
        at org.alfresco.util.schemacomp.ExportDb.extractSchema(ExportDb.java:333)
        at org.alfresco.util.schemacomp.ExportDb.execute(ExportDb.java:209)
        at org.alfresco.util.schemacomp.ExportDb.execute(ExportDb.java:174)

This message is shown, when the old schema has a table without primary key. Normally this issue will be fixed automatically. So you can safely ignore this message if it is not shown again.

Context initialization failed

 java.lang.IllegalStateException: Unauthenticated
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl.hasPermission(PermissionServiceImpl.java:655)
        at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl.hasPermission(PermissionServiceImpl.java:632)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

Details: https://issues.alfresco.com/jira/browse/ALF-19924

Workaround

Disable the ConfigurationChecker.

Create the file shared/classes/alfresco/extension/alf19924-context.xml with following content:

 <?xml version='1.0' encoding='UTF-8'?>
 <!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>
 <beans>
    <bean id="configurationChecker" class="java.util.ArrayList" />
 </beans>

Cleanup database schema after upgrade

Drop ALF_*ATTRIBUTE* tables (if exist)

 drop sequence ALF_ATTRIBUTES_SEQ;
 drop table ALF_GLOBAL_ATTRIBUTES;
 drop table ALF_LIST_ATTRIBUTE_ENTRIES;
 drop table ALF_MAP_ATTRIBUTE_ENTRIES;
 drop table ALF_ATTRIBUTES;

Recreate IDX_AVM_VR_UQ and drop unnamed constraint

Find constraint:

 select index_name
 from user_ind_columns
 where table_name = 'AVM_VERSION_ROOTS'
 and column_name = 'VERSION_ID'
 and index_name like 'SYS%';

The result is the name of the constraint we want to drop:

 INDEX_NAME
 ------------------------------
 SYS_C0067296

Now drop the constraint and recreate IDX_AVM_VR_UQ:

 alter table avm_version_roots drop constraint idx_avm_vr_uq;
 alter table avm_version_roots drop constraint SYS_C0067296;
 alter table avm_version_roots
    add constraint idx_avm_vr_uq
    unique (avm_store_id, version_id);

Fix type of column ID_ in table ACT_HI_DETAIL

 alter table ACT_HI_DETAIL modify (ID_ NVARCHAR2(64));