I am trying (and failing) to upgrade enterprise 2.0 to enterprise 3.0. We have an Oracle back end and the supplied scripts for upgrading fall over with constraint violations. Even trolling the internet and picking up a new script to resolve an issue does not sucessfully upgrade the DB.
I am currently trying (in this order)
node-status-fix-2.1.1-oracle.sql
AlfrescoSchemaUpdate-2.1-NotNullColumns.sql
AlfrescoSchemaUpdate-2.2-ACL.sql
upgrade-from-2.1.sql
Apart from the node fix they are run automatically on startup with auto-upgrade set to 'yes'
These scripts fall over with a constraint violation in upgrade-from-2.1.sql. Does anyone have a definitive list of scripts that will upgrade 2.0 to 3.0?
The ability to upgrade is a basic requirement and I am disappointed that the supposedly 'tested' enterprise version falls over like this.
