topic Community 3.4d to 4.0c Nightly in Alfresco Archive

Community 3.4d to 4.0c Nightly

benswitzer — Tue, 13 Dec 2011 03:59:03 GMT

I've decided to start a new topic on upgrading from 3.4 to 4.0 as the issue for me appears to be altogether different than what I've seen other people reporting.After having successfully setup a Community 4.0c Nightly build (12-Dec-2011 23:28) I attempted to upgrade a previous installation.Using the

Re: Community 3.4d to 4.0c Nightly

mrogers — Tue, 13 Dec 2011 10:12:18 GMT

You have had a failed upgrade in the past so you are ***NOT*** 3.4.d.

Upgrade does not know what to do so does not run.

Do you have a clean backup? Failing that you will need to dig into the patches and work out which patches have run and which have had problems and fix up.

Re: Community 3.4d to 4.0c Nightly

benswitzer — Tue, 13 Dec 2011 14:40:14 GMT

Yikes.

I've got some work to do!

Re: Community 3.4d to 4.0c Nightly

benswitzer — Tue, 13 Dec 2011 16:22:14 GMT

Starting to dig into this issue.

Not sure why I can boot 3.4d and the patch PatchExecuter doesn't pick up on the fact that I'm missing patches. The log file reports that I'm running schema 4113.

mrogers, can you provide some insight on where to start with this problem. I'm looking at the dbscripts under create and update folders (that are part of my 3.4d install) and attempting to determine if each one has been applied. Is this a good approach? Is there anywhere else I should be looking?

Looking at the patch-services-context.xml file, there is a long list of 'dead patches'. Should I be using this file as a guild to work backwards and determine if each one has been applied?

What a mess. Tempted to just export what we have and import into 4.0 install.

Either way, I'm not looking forward to what has to be done.

Re: Community 3.4d to 4.0c Nightly

loftux — Tue, 13 Dec 2011 16:48:44 GMT

If you go to Alfresco Explorer as admin, the look at the Adminstrator Console, Repository Properties and you should have all listed patches there. See if you find any that have failed.

The schema comparator is a new functionality, as it looks it just reports any diffs compared to expected, but still continues to do the upgrade. If it succeeds it again reports remaining diffs. So my understanding is that it doesn't stop the upgrade, it is more a tool to diagnose what might be causing the errors. At least so is my understanding of the schema comparator. I upgraded a library to 4.0c nightly this weekend, and it reported errors about missing indexes. The upgrade patches ran as expected, and I just added the missing indexes afterwards.
In your case it seem much worse…

Re: Community 3.4d to 4.0c Nightly

benswitzer — Tue, 13 Dec 2011 17:14:12 GMT

Thanks for pointing the repository properties out. Unfortunately, all of the listed patches have been marked as successful.

Here is what I see:

Installed Schema   1002
Installed Version   3.0.0 (Stable 1526)
Server Schema   4113
Server Version   3.4.0 (d 3370)
patch.AVMGuidPatch   Fri Apr 24 11:24:19 EDT 2009 - Set GUIDs on AVM nodes. - Succeeded
patch.AVMLayeredSnapshot   Fri Apr 24 11:24:19 EDT 2009 - Set indirectionVersion on Layered Nodes. - Succeeded
patch.AVMLocking   Fri Apr 24 11:24:19 EDT 2009 - Adds existing web projects to locking service. - Succeeded
patch.InvalidNameEnding   Fri Apr 24 11:24:19 EDT 2009 - Fixes names ending with a space or full stop. - Succeeded
patch.LinkNodeFileExtension   Fri Apr 24 11:24:19 EDT 2009 - Fixes link node file extensions to have a .url extension. - Succeeded
patch.ReadmeTemplate   Fri Apr 24 11:24:19 EDT 2009 - Deployed ReadMe Template - Succeeded
patch.actionRuleDecouplingPatch   Fri Apr 24 11:24:19 EDT 2009 - Migrate existing rules to the updated model where rules are decoupled from actions. - Succeeded
patch.actions.scheduledfolder   Thu Sep 30 18:23:15 EDT 2010 - Creates the scheduled actions folder in the Data Dictionary. - Succeeded
patch.administratorGroup   Fri Apr 24 11:24:19 EDT 2009 - Adds the 'ALFRESCO_ADMINISTRATORS' group. - Succeeded
patch.authoritiesFolder   Fri Apr 24 11:24:19 EDT 2009 - Ensures the existence of the user authorities folder [JIRA: AR-497]. - Succeeded
patch.authoritiesFolderPermission   Fri Apr 24 11:24:19 EDT 2009 - Ensures group authorities are visible to everyone. - Succeeded
patch.authorityDefaultZonesPatch   Thu Aug 06 10:15:54 EDT 2009 - Adds groups and people to the appropriate zones for wcm, share and everything else. - Succeeded
patch.authorityMigration   Thu Aug 06 10:15:38 EDT 2009 - Copies any old authorities from the user store to the spaces store. - Succeeded
patch.avmFormPropertyIdentifier   Fri Apr 24 11:24:19 EDT 2009 - Reindex wca:webform to make wca:formname an identifier - Succeeded
patch.avmStoreAsIdentifier   Fri Apr 24 11:24:19 EDT 2009 - Reindex wca:webfolder to make wca:avmstore an identifier - Succeeded
patch.avmWebProjectInheritPermissions02   Fri Apr 24 11:24:19 EDT 2009 - Break inheritance of permissions on wca:webfolder object to hide access by default. - Succeeded
patch.calendarNamespaceUri   Fri Apr 24 11:24:19 EDT 2009 - Update the Calendar model namespace URI and reindex all calendar objects. - Succeeded
patch.categoryRootPermission   Fri Apr 24 11:24:19 EDT 2009 - Sets required permissions on 'Category Root' folder. - Succeeded
patch.contentFormFolderType   Fri Apr 24 11:24:19 EDT 2009 - Update WCM Content Form folder type. - Succeeded
patch.contentPermission   Fri Apr 24 11:24:19 EDT 2009 - Update permission entries from 'cm:content' to 'sys:base'. - Succeeded
patch.convertContentUrls   Thu Apr 08 15:17:03 EDT 2010 - Converts pre-3.2 content URLs to use the alf_content_data table. The conversion work can also be done on a schedule; please contact Alfresco Support for further details. - Succeeded
patch.createSiteStore   Fri Apr 24 11:24:19 EDT 2009 - Create the AVM store for site data structure for 3.0 web-tier clients. - Succeeded
patch.customMessages   Fri Apr 24 11:24:19 EDT 2009 - Adds 'Messages' folder to Data Dictionary - Succeeded
patch.customModels   Fri Apr 24 11:24:19 EDT 2009 - Adds 'Models' folder to Data Dictionary - Succeeded
patch.customWebClientExtension   Fri Apr 24 11:24:19 EDT 2009 - Adds 'Web Client Extension' folder to Data Dictionary - Succeeded
patch.customWorkflowDefs   Fri Apr 24 11:24:19 EDT 2009 - Adds 'Workflow Definitions' folder to Data Dictionary. - Succeeded
patch.db-V1.4-TxnCommitTimeIndex   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.0-ContentUrls   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.1-AuditPathIndex   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.1-JBPMProcessKey   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.1-JBPMUpdate   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.1-NotNullColumns   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.1-RemoveWcmSubmittedAspect   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.1-VersionColumns2   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.2-0-CreateMissingTables   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.2-2-MoveQNames   Fri Apr 24 11:24:19 EDT 2009 - A placeholder patch; usually marks a superceded patch. - Succeeded
patch.db-V2.2-ACL   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.2-ACL-From-2.1-A   Thu Aug 06 10:15:05 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.2-CleanNodeStatuses   Fri Nov 20 12:59:22 EST 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.2-Person   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.2-Person-2   Thu Aug 06 10:15:05 EDT 2009 - Manually executed script upgrade V2.2: Person user name also in the association qname - Succeeded
patch.db-V2.2-Person-3   Mon Oct 19 17:39:52 EDT 2009 - Manually executed script upgrade V2.2: Person user name also in the association qname - Succeeded
patch.db-V2.2-Upgrade-From-2.1   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V2.2-Upgrade-From-2.2SP1   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V3.0-0-CreateActivitiesExtras   Fri Apr 24 11:24:19 EDT 2009 - Executed script create V3.0: Created activities extras - Succeeded
patch.db-V3.0-ActivityTables   Mon Sep 27 16:33:19 EDT 2010 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V3.1-Allow-IPv6   Fri Nov 20 12:58:53 EST 2009 - Manually executed script upgrade V3.1: Increase the ipAddress field length - Succeeded
patch.db-V3.2-AddFKIndexes   Thu Sep 30 18:23:13 EDT 2010 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V3.2-AddFKIndexes-2   Sat Jan 08 15:46:34 EST 2011 - Script fix for ALF-5396: Missing FK indexes on non-MySQL databases - Succeeded
patch.db-V3.2-AuditTables   Mon Oct 19 17:39:52 EDT 2009 - Manually executed script upgrade V3.2: Audit Tables - Succeeded
patch.db-V3.2-Child-Assoc-QName-CRC   Fri Nov 20 12:58:53 EST 2009 - Manually executed script upgrade V3.2 to Add qname_crc column to alf_child_assoc and change indexes - Succeeded
patch.db-V3.2-ContentTables   Thu Aug 06 10:15:05 EDT 2009 - Manually executed script upgrade V3.2: Content Tables - Succeeded
patch.db-V3.2-ContentTables2   Thu Apr 08 15:16:36 EDT 2010 - Manually executed script upgrade V3.2: Content Tables 2 (pre 3.2 Enterprise Final) - Succeeded
patch.db-V3.2-LockTables   Thu Aug 06 10:15:05 EDT 2009 - Manually executed script upgrade V3.2: Lock Tables - Succeeded
patch.db-V3.2-Modify-AVM-MimeType   Thu Aug 06 10:15:05 EDT 2009 - Manually executed script upgrade V3.2 to modify AVM mimetype - Succeeded
patch.db-V3.2-PropertyValueTables   Mon Oct 19 17:39:52 EDT 2009 - Manually executed script upgrade V3.2: PropertyValue Tables - Succeeded
patch.db-V3.2-Remove-AVM-Issuer   Thu Aug 06 10:15:05 EDT 2009 - Manually executed script upgrade V3.2 to remove AVM Issuer - Succeeded
patch.db-V3.2-Upgrade-JBPM   Thu Aug 06 10:15:05 EDT 2009 - Manually executed script upgrade V3.2 to jbpm version 3.3.1 usage - Succeeded
patch.db-V3.3-Fix-AVM-Seqs   Mon Sep 27 16:33:18 EDT 2010 - Manually executed script upgrade V3.3 to create AVM sequences - Succeeded
patch.db-V3.3-Fix-Repo-Seqs   Mon Sep 27 16:33:18 EDT 2010 - Manually executed script upgrade V3.3 to create repo sequences - Succeeded
patch.db-V3.3-Fix-Repo-Seqs_1   Thu Apr 08 15:16:36 EDT 2010 - Manually executed script upgrade V3.3 to create repo sequences - Succeeded
patch.db-V3.3-JBPM-Extra   Mon Sep 27 16:33:18 EDT 2010 - Manually executed script upgrade V3.3 fix problems in JBPM tables - Succeeded
patch.db-V3.3-Node-Prop-Serializable   Mon Sep 27 16:33:18 EDT 2010 - Manually executed script upgrade V3.3 - Succeeded
patch.db-V3.3-Remove-VersionCount   Thu Apr 08 15:16:36 EDT 2010 - Manually executed script upgrade V3.3 to remove Version Count - Succeeded
patch.db-V3.3-modify-index-permission_id   Mon Sep 27 16:33:18 EDT 2010 - Remove context_id from the permission_id unique index (as it always contains null and therefore has no effect) - Succeeded
patch.db-V3.4-JBPM-FK-indexes   Thu Oct 20 14:33:44 EDT 2011 - Manually executed script upgrade to add FK indexes for JBPM - Succeeded
patch.db-V3.4-RemovingLinkValidationMetadata   Thu Oct 20 14:33:44 EDT 2011 - Link Validation reports metadata removed V3.4 - Succeeded
patch.db-V3.4-UsageTables   Mon Sep 27 16:33:19 EDT 2010 - Ensures that the database upgrade script has been run. - Succeeded
patch.db-V3.4-VarcharFieldSizesQuadrupleIncreasing   Thu Oct 20 14:33:44 EDT 2011 - Increasing VARCHAR field sizes quadruply for DB2 dialect V3.4 - Succeeded
patch.db-V3.4-authority-unique-idx   Thu Oct 20 14:33:44 EDT 2011 - Manually executed script upgrade V3.4 - Succeeded
patch.db-V3.4-child-assoc-indexes   Mon Sep 27 16:33:18 EDT 2010 - Manually executed script upgrade V3.4 - Succeeded
patch.db-V3.4-property-unique-ctx-idx   Thu Oct 20 14:33:44 EDT 2011 - Manually executed script upgrade V3.4 - Succeeded
patch.db-V3.4-property-unique-ctx-value   Mon Sep 27 16:33:18 EDT 2010 - Manually executed script upgrade V3.4 - Succeeded
patch.db-V4.0-AclChangeSet   Thu Oct 20 14:33:44 EDT 2011 - Manually executed script upgrade V4.0: Update ACL Change Set for Change Tracking - Succeeded
patch.db-V4.0-Node-Locale   Thu Oct 20 16:51:39 EDT 2011 - Manually executed script upgrade V4.0: Add locale_id column to alf_node - Succeeded
patch.db-V4.0-NodeAssoc-Ordering   Thu Oct 20 14:33:44 EDT 2011 - Manually executed script upgrade V4.0: Add assoc_index column to alf_node_assoc - Succeeded
patch.deploySubmitDirectProcess   Thu Aug 06 10:15:06 EDT 2009 - Deploy WCM Direct Submit Process Definition. - Succeeded
patch.deploymentMigration   Fri Apr 24 11:24:19 EDT 2009 - Migrates deployment data to the new model. - Succeeded
patch.descriptorUpdate   Fri Apr 24 11:24:19 EDT 2009 - Update Repository descriptor - Succeeded
patch.eliminateDuplicates   Sat Jan 08 15:46:35 EST 2011 - Fixes ALF-4203: Searches for AVM duplicate nodes and changes their name - Succeeded
patch.emailContributorGroup   Fri Apr 24 11:24:19 EDT 2009 - Adds the 'GROUP_EMAIL_CONTRIBUTORS' group. - Succeeded
patch.emailInviteAndNotifyTemplatesFolder   Thu Apr 08 15:16:37 EDT 2010 - Ensures the existence of the 'Email Invite Templates' and 'Email Notify Templates' folders. - Succeeded
patch.emailTemplatesContent   Fri Apr 24 11:24:19 EDT 2009 - Loads the email templates into the Email Templates folder. - Succeeded
patch.emailTemplatesFolder   Fri Apr 24 11:24:19 EDT 2009 - Ensures the existence of the 'Email Templates' folder. - Succeeded
patch.fixAuthoritiesCrcValues   Mon Sep 27 16:33:19 EDT 2010 - Fixes authority CRC32 values to match UTF-8 encoding. - Succeeded
patch.fixNameCrcValues   Thu Aug 06 10:16:00 EDT 2009 - Fixes name CRC32 values to match UTF-8 encoding. - Succeeded
patch.fixNameCrcValues-2   Fri Nov 20 12:59:22 EST 2009 - Fixes name and qname CRC32 values to match UTF-8 encoding. - Succeeded
patch.fixNodeSerializableValues   Fri Apr 24 11:24:19 EDT 2009 - Ensure that property values are not stored as Serializable if at all possible - Succeeded
patch.formsFolder   Fri Apr 24 11:24:19 EDT 2009 - Adds 'Forms' folder to Data Dictionary. - Succeeded
patch.forumsIcons   Fri Apr 24 11:24:19 EDT 2009 - Updates forums icon references - Succeeded
patch.groupMembersAsIdentifiers   Fri Apr 24 11:24:19 EDT 2009 - Reindex usr:authorityContainer members as identifiers - Succeeded
patch.groupNamesAsIdentifiers   Fri Apr 24 11:24:19 EDT 2009 - Reindex usr:authorityContainer gids as identifiers - Succeeded
patch.guestPersonPermission   Fri Apr 24 11:24:19 EDT 2009 - Change Guest Person permission from 'Consumer' to 'Read' - Succeeded
patch.guestPersonPermission2   Fri Apr 24 11:24:19 EDT 2009 - Change Guest Person permission to visible by all users as 'Consumer'. - Succeeded
patch.guestUser   Fri Apr 24 11:24:19 EDT 2009 - Add the guest user, guest home space; and fix permissions on company home, guest home and guest person. - Succeeded
patch.imapFolders   Thu Aug 06 10:16:01 EDT 2009 - Creates folders tree necessary for IMAP functionality - Succeeded
patch.invalidUserPersonAndGroup   Fri Apr 24 11:24:19 EDT 2009 - Fix up invalid uids for people and users; and invalid gids for groups - Succeeded
patch.invitationMigration   Thu Aug 06 10:15:13 EDT 2009 - Migrate invitations from old invite service to invitation service - Succeeded
patch.inviteEmailTemplate   Fri Apr 24 11:24:19 EDT 2009 - Adds invite email template to invite space - Succeeded
patch.migrateAttrAVMLocks   Thu Sep 30 18:23:13 EDT 2010 - Migrate old AVM Lock attributes - Succeeded
patch.migrateAttrChainingURS   Thu Sep 30 18:23:13 EDT 2010 - Migrate old Chaining User Registry Synchronizer attributes - Succeeded
patch.migrateAttrDelete   Thu Sep 30 18:23:13 EDT 2010 - Delete old attributes (if any) after they have been migrated - Succeeded
patch.migrateAttrPropBackedBeans   Thu Sep 30 18:23:13 EDT 2010 - Migrate old Property-Backed Bean component attributes - Succeeded
patch.migrateAttrTenants   Thu Sep 30 18:23:13 EDT 2010 - Migrate old Tenant attributes - Succeeded
patch.migrateVersionStore   Fri Apr 24 11:24:19 EDT 2009 - Migrate from lightWeightVersionStore to version2Store - Succeeded
patch.migrateVersionStoreUpdateCounter   Thu Aug 06 10:15:10 EDT 2009 - Update internal version2Store counter (if needed). - Succeeded
patch.moveWCMToGroupBasedPermissionsPatch   Thu Aug 06 10:15:07 EDT 2009 - A placeholder patch; usually marks a superceded patch. - Succeeded
patch.mtShareExistingTenants   Thu Aug 06 10:15:13 EDT 2009 - Update existing tenants for MT Share. - Succeeded
patch.multilingualBootstrap   Fri Apr 24 11:24:19 EDT 2009 - Bootstraps the node that will hold the multilingual containers. - Succeeded
patch.personUsagePatch   Fri Nov 20 12:59:22 EST 2009 - Add person 'cm:sizeCurrent' property (if missing). - Succeeded
patch.redeployInvitationProcess   Thu Aug 06 10:15:14 EDT 2009 - Re-deploy Invitation Process Definitions. - Succeeded
patch.redeployNominatedInvitationProcessWithPropsForShare   Thu Apr 08 15:16:37 EDT 2010 - Redeploy nominated invitation workflow - Succeeded
patch.redeploySubmitProcess   Fri Apr 24 11:24:19 EDT 2009 - Re-deploy WCM Submit Process Definition. - Succeeded
patch.redeploySubmitProcess4   Fri Apr 24 11:24:19 EDT 2009 - Re-deploy WCM Submit Process Definition. - Succeeded
patch.redeploySubmitProcess5   Thu Aug 06 10:15:06 EDT 2009 - Re-deploy WCM Submit Process Definition. - Succeeded
patch.redeploySubmitProcess6   Thu Aug 06 10:15:10 EDT 2009 - Re-deploy WCM Submit Process Definition. - Succeeded
patch.redeploySubmitProcess7   Thu Aug 06 10:15:10 EDT 2009 - Re-deploy WCM Submit Process Definition. - Succeeded
patch.rendition.rendering_actions   Thu Apr 08 15:16:37 EDT 2010 - Creates the Rendering Actions folder. - Succeeded
patch.replication.replication_actions   Thu Sep 30 18:23:13 EDT 2010 - Creates the Replication Actions folder. - Succeeded
patch.resetWCMToGroupBasedPermissionsPatch   Thu Aug 06 10:15:07 EDT 2009 - Reset WCM to group based permissions. - Succeeded
patch.rssFolder   Fri Apr 24 11:24:19 EDT 2009 - Ensures the existence of the 'RSS Templates' folder. - Succeeded
patch.savedSearchesFolder   Fri Apr 24 11:24:19 EDT 2009 - Ensures the existence of the 'Saved Searches' folder. - Succeeded
patch.savedSearchesPermission   Fri Apr 24 11:24:19 EDT 2009 - Sets required permissions on 'Saved Searches' folder. - Succeeded
patch.schemaUpdateScript-V1.4-1   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.schemaUpdateScript-V1.4-2   Fri Apr 24 11:24:19 EDT 2009 - Ensures that the database upgrade script has been run. - Succeeded
patch.scriptsFolder   Fri Apr 24 11:24:19 EDT 2009 - Ensures the existence of the 'Scripts' folder. - Succeeded
patch.sitePermissionRefactorPatch   Fri Apr 24 11:24:19 EDT 2009 - Create permission groups for sites. - Succeeded
patch.sitesFolder   Fri Apr 24 11:24:19 EDT 2009 - Adds 'Sites' folder to Company Home. - Succeeded
patch.spacesRootPermission   Fri Apr 24 11:24:19 EDT 2009 - Change Spaces store root permission from 'Consumer' to 'Read' - Succeeded
patch.spacesStoreGuestPermission   Fri Apr 24 11:24:19 EDT 2009 - Sets READ permissions for GUEST on root node of the SpacesStore. - Succeeded
patch.systemDescriptorContent   Fri Apr 24 11:24:19 EDT 2009 - Adds the version properties content to the system descriptor. - Succeeded
patch.systemRegistryBootstrap   Fri Apr 24 11:24:19 EDT 2009 - Bootstraps the node that will hold system registry metadata. - Succeeded
patch.systemWorkflowFolderPatch   Fri Apr 24 11:24:19 EDT 2009 - Ensures the existence of the system workflow container. - Succeeded
patch.tagRootCategory   Fri Apr 24 11:24:19 EDT 2009 - Adds 'Tags' as new top-level category root. - Succeeded
patch.thumbnailsAssocQName   Thu Apr 08 15:16:37 EDT 2010 - Update the 'cm:thumbnails' association QName to 'rn:rendition'. - Succeeded
patch.topLevelGroupParentChildAssociationTypePatch   Fri Apr 24 11:24:19 EDT 2009 - Ensure top level groups have the correct child association type. - Succeeded
patch.transfer.targetrule   Thu Sep 30 18:23:15 EDT 2010 - Creates the transfer target rule for the default transfer group. - Succeeded
patch.transfer.targetrulefolder   Thu Sep 30 18:23:14 EDT 2010 - Creates the transfer target rule folder for the default transfer group. - Succeeded
patch.transferServiceFolder   Thu Apr 08 15:17:03 EDT 2010 - Add transfer definitions folder to data dictionary. - Succeeded
patch.uifacetsTemplates   Fri Apr 24 11:24:19 EDT 2009 - Removes the incorrectly applied uifacets aspect from presentation template files. - Succeeded
patch.uniqueChildName   Fri Apr 24 11:24:19 EDT 2009 - Checks and renames duplicate children. - Succeeded
patch.updateAvmPermissionData   Fri Apr 24 11:24:19 EDT 2009 - Update avm permissions from 'webfolder' to 'cmobject'. - Succeeded
patch.updateAvmPermissions   Fri Apr 24 11:24:19 EDT 2009 - Update ACLs on all avm objects to the new 2.2 permission model - Succeeded
patch.updateDmPermissions   Fri Apr 24 11:24:19 EDT 2009 - Update ACLs on all DM node objects to the new 3.0 permission model - Succeeded
patch.updateGuestPermission   Fri Apr 24 11:24:19 EDT 2009 - Rename guest permission from 'Guest' to 'Consumer' - Succeeded
patch.updateMimetypes1   Thu Sep 30 18:22:57 EDT 2010 - Fix mimetypes for Excel and Powerpoint. - Succeeded
patch.updateMimetypes2   Thu Sep 30 18:23:16 EDT 2010 - No patch description available - Succeeded
patch.updatePermissionData   Fri Apr 24 11:24:19 EDT 2009 - Update permissions from 'folder' to 'cmobject' [JIRA: AR-344]. - Succeeded
patch.userAndPersonUserNamesAsIdentifiers   Fri Apr 24 11:24:19 EDT 2009 - Reindex usr:user and cm:person uids as identifiers - Succeeded
patch.versionHistoryPerformance   Fri Apr 24 11:24:19 EDT 2009 - Improves the performance of version history lookups. - Succeeded
patch.wcmDeployed   Thu Apr 08 15:17:03 EDT 2010 - No patch description available - Succeeded
patch.wcmFolders   Fri Apr 24 11:24:19 EDT 2009 - Ensures the existance of the WCM specific 'Web Projects' and 'Web Forms' folders. - Succeeded
patch.wcmPermissionPatch   Fri Apr 24 11:24:19 EDT 2009 - Fix ACLs so they are only set on the staging area store. - Succeeded
patch.wcmPostPermissionSnapshotPatch   Fri Apr 24 11:24:19 EDT 2009 - Snapshot stores (after fixing ACLs so they are only set on the staging area store). - Succeeded
patch.wcmPostPermissionSnapshotPatch2   Thu Aug 06 10:15:10 EDT 2009 - A placeholder patch; usually marks a superceded patch. - Succeeded
patch.wcmPostPermissionSnapshotPatch3   Thu Aug 06 10:15:10 EDT 2009 - Snapshot stores (after fixing ACLs so they are only set on the staging area store). - Succeeded
patch.webScriptsReadme   Fri Apr 24 11:24:19 EDT 2009 - Applied ReadMe template to Web Scripts folders - Succeeded
patch.webSiteAddModerated   Thu Aug 06 10:15:10 EDT 2009 - Changing Web Site visibility from a boolean to enum. - Succeeded
patch.webscripts   Fri Apr 24 11:24:19 EDT 2009 - Adds Web Scripts to Data Dictionary. - Succeeded
patch.webscripts2   Fri Apr 24 11:24:19 EDT 2009 - Adds Web Scripts (second set) to Data Dictionary. - Succeeded
patch.webscripts3   Fri Apr 24 11:24:19 EDT 2009 - Update Web Scripts ReadMe. - Succeeded
patch.webscriptsExtension   Fri Apr 24 11:24:19 EDT 2009 - Adds Web Scripts Extension to Data Dictionary. - Succeeded
patch.zonedAuthorities   Thu Aug 06 10:15:05 EDT 2009 - Adds the remodelled cm:authority container to the spaces store - Succeeded‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Community 3.4d to 4.0c Nightly

loftux — Tue, 13 Dec 2011 17:27:10 GMT

Then maybe if you are lucky (if you can call it that) it is just you db dump and import that doesn't bring along all the data. Try to redo that part of the process, and compare your production db to your test db and see if all (or a sample of to shorten what you have to check) the mentioned missing tables and indexes actually now exist.

Re: Community 3.4d to 4.0c Nightly

benswitzer — Tue, 13 Dec 2011 18:25:25 GMT

Grabbed a dump of the DB and have compared it to what was loaded in test system. Identical.

What I have noticed is that of the 24 pre-upgrade files (Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-….txt), they're all identical. In the file, there are 60 lines. It appears to me that are three types of differences in the file: expected, missing, and unexpected.

I'm going to plug through each line and script the appropriate changes.

Let you know how it turns out.

Re: Community 3.4d to 4.0c Nightly

benswitzer — Wed, 14 Dec 2011 19:50:57 GMT

Ok, so I've gone through the process of manually scripting a file to change the database based on the differences identified Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade file.

The majority of the changes had to do with renaming indexes and keys. All very straight forward.

There was two lines in the file that I could not determine what to do. They are:

Difference: expected index .alf_node.idx_alf_node_del.name="idx_alf_node_del", but was .alf_node.idx_alf_node_txn_del.name="idx_alf_node_txn_del"
Difference: expected index .alf_node.idx_alf_node_txn_del.columnNames[0]="transaction_id", but was .alf_node.idx_alf_node_txn_del.columnNames="[node_deleted]"‍‍

Can someone provide the details for those two indexes?

The other hurdle that I've not been able to get around is a situation where the pre-upgrade file listed the following tables:

Difference: unexpected table found in database with path: .alf_attributes
Difference: unexpected table found in database with path: .alf_audit_config
Difference: unexpected table found in database with path: .alf_audit_date
Difference: unexpected table found in database with path: .alf_audit_fact
Difference: unexpected table found in database with path: .alf_audit_source
Difference: unexpected table found in database with path: .alf_bootstrap_lock
Difference: unexpected table found in database with path: .alf_global_attributes
Difference: unexpected table found in database with path: .alf_list_attribute_entries
Difference: unexpected table found in database with path: .alf_map_attribute_entries
‍‍‍‍‍‍‍‍‍‍

From this I gather that the tables shouldn't be present, so I removed them. The trouble arises when I start Tomcat and patches are applied. Here is the relevant log file:

 2011-12-13 22:21:07,255  INFO  [admin.patch.PatchExecuter] [Thread-1] Checking for patches to apply …
 2011-12-13 22:21:07,865  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.fixUserQNames' (Fixes user store qnames to improve native authentication performance).
 2011-12-13 22:21:07,927  INFO  [patch.impl.FixUserQNamesPatch] [Thread-1] FixUserQNamesPatch: Commencing batch of 1 entries
 2011-12-13 22:21:08,271  INFO  [patch.impl.FixUserQNamesPatch] [Thread-1] FixUserQNamesPatch: Processed 1 entries out of 1. 100% complete. Rate: 2 per second. 0 failures detected.
 2011-12-13 22:21:08,271  INFO  [patch.impl.FixUserQNamesPatch] [Thread-1] FixUserQNamesPatch: Completed batch of 1 entries
 2011-12-13 22:21:08,474  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.redeployJbpmAdhocWorkflow' (Redeploy JBPM adhoc workflow).
 2011-12-13 22:21:08,505  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.imapSpacesLocaleTemplates' (A placeholder patch; usually marks a superceded patch.).
 2011-12-13 22:21:08,537  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.mtFixAdminExistingTenants' (Fix bootstrapped creator/modifier).
 2011-12-13 22:21:08,740  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.activitiesEmailTemplate' (null).
 2011-12-13 22:21:09,943  WARN  [admin.patch.PatchExecuter] [Thread-1] Patch description is not available: Patch[ id=patch.activitiesEmailTemplate, description=patch.activitiesEmailTemplate.description, fixesFromSchema=0, fixesToSchema=5005, targetSchema=5006]
 2011-12-13 22:21:09,974  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.newUserEmailTemplates' (Adds the email templates for notifying new users of their accounts).
 2011-12-13 22:21:10,724  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.inviteEmailTemplates' (Adds the email templates for inviting users to a Site).
 2011-12-13 22:21:11,349  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.htmlNotificationMailTemplates' (Adds HTML email templates for notifying users of new content).
 2011-12-13 22:21:12,412  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.fixAclInheritance' (Fixes any ACL inheritance issues.).
 2011-12-13 22:21:23,615  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.imap.clear.old.messages' (Remove old IMAP message templates).
 2011-12-13 22:21:24,708  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.imapSpacesTemplates2' (Replaces content templates for IMAP clients).
 2011-12-13 22:21:26,880  INFO  [admin.patch.PatchExecuter] [Thread-1]    Applying patch 'patch.migrateAttrDropOldTables' (Drops old alf_*attribute* tables and sequence).
 2011-12-13 22:21:59,738  ERROR [admin.patch.PatchExecuter] [Thread-1] 11130000 org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'alf_list_attribute_entries'
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'alf_list_attribute_entries'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'alf_list_attribute_entries'
   at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
   at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
   at $Proxy6.update(Unknown Source)
   at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:238)
   at org.alfresco.repo.domain.patch.ibatis.PatchDAOImpl.migrateOldAttrDropTables(PatchDAOImpl.java:547)
   at org.alfresco.repo.admin.patch.impl.MigrateAttrDropOldTablesPatch.applyInternal(MigrateAttrDropOldTablesPatch.java:45)
   at org.alfresco.repo.admin.patch.AbstractPatch.applyImpl(AbstractPatch.java:407)
   at org.alfresco.repo.admin.patch.AbstractPatch.access$000(AbstractPatch.java:52)
   at org.alfresco.repo.admin.patch.AbstractPatch$2$1.execute(AbstractPatch.java:466)
   at org.alfresco.repo.admin.patch.AbstractPatch$2$1.execute(AbstractPatch.java:463)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.admin.patch.AbstractPatch$2.doWork(AbstractPatch.java:469)
   at org.alfresco.repo.admin.patch.AbstractPatch$2.doWork(AbstractPatch.java:456)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
   at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:478)
   at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.applyPatch(PatchServiceImpl.java:491)
   at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.execute(PatchServiceImpl.java:403)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:258)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:235)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:171)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy93.applyOutstandingPatches(Unknown Source)
   at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:76)
   at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:124)
   at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:120)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
   at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:128)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'alf_list_attribute_entries'
   at sun.reflect.GeneratedConstructorAccessor194.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
   at com.mysql.jdbc.Util.getInstance(Util.java:384)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
   at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)
   at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)
   at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:87)
   at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:46)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:118)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:111)
   at sun.reflect.GeneratedMethodAccessor465.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
   … 68 more

 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.db-V3.4-AVM-rename-dupes
RESULT: 
Script completed: rows updated = 0
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.redeployJbpmAdhocWorkflow
RESULT: 
Re-deployed 1 workflows. 
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.imapSpacesLocaleTemplates
RESULT: 
No-op patch
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.mtFixAdminExistingTenants
RESULT: 
Fix bootstrapped creator/modifier
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.fixUserQNames
RESULT: 
Generated qnames for 1 users.
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.fixAclInheritance
RESULT: 
Fixed 0 ACLs.
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.imapSpacesTemplates2
RESULT: 
Imported view into bootstrap location: /app:company_home/app:dictionary/app:imap_configs/app:imap_templates (workspace://SpacesStore/cdb860cd-f81a-4ce8-a482-e31d965ab35f)
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.inviteEmailTemplates
RESULT: 
Imported view into bootstrap location: /app:company_home/app:dictionary/app:email_templates/cm:invite (workspace://SpacesStore/cdb860cd-f81a-4ce8-a482-e31d965ab35f)
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.newUserEmailTemplates
RESULT: 
Imported view into bootstrap location: /app:company_home/app:dictionary/app:email_templates/cm:invite (workspace://SpacesStore/cdb860cd-f81a-4ce8-a482-e31d965ab35f)
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.activitiesEmailTemplate
RESULT: 
Imported view into bootstrap location: /app:company_home/app:dictionary/app:email_templates (workspace://SpacesStore/cdb860cd-f81a-4ce8-a482-e31d965ab35f)
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.imap.clear.old.messages
RESULT: 
Old IMAP message templates have been removed from the repository
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.htmlNotificationMailTemplates
RESULT: 
Imported view into bootstrap location: /app:company_home/app:dictionary/app:email_templates/app:notify_email_templates (workspace://SpacesStore/cdb860cd-f81a-4ce8-a482-e31d965ab35f)
=====================================
 2011-12-13 22:21:59,863  ERROR [admin.patch.PatchExecuter] [Thread-1] 
=== Failed to apply patch         === 
ID: patch.migrateAttrDropOldTables
RESULT: 
11130000 org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'alf_list_attribute_entries'
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'alf_list_attribute_entries'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'alf_list_attribute_entries'
   at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
   at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
   at $Proxy6.update(Unknown Source)
   at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:238)
   at org.alfresco.repo.domain.patch.ibatis.PatchDAOImpl.migrateOldAttrDropTables(PatchDAOImpl.java:547)
   at org.alfresco.repo.admin.patch.impl.MigrateAttrDropOldTablesPatch.applyInternal(MigrateAttrDropOldTablesPatch.java:45)
   at org.alfresco.repo.admin.patch.AbstractPatch.applyImpl(AbstractPatch.java:407)
   at org.alfresco.repo.admin.patch.AbstractPatch.access$000(AbstractPatch.java:52)
   at org.alfresco.repo.admin.patch.AbstractPatch$2$1.execute(AbstractPatch.java:466)
   at org.alfresco.repo.admin.patch.AbstractPatch$2$1.execute(AbstractPatch.java:463)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.admin.patch.AbstractPatch$2.doWork(AbstractPatch.java:469)
   at org.alfresco.repo.admin.patch.AbstractPatch$2.doWork(AbstractPatch.java:456)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
   at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:478)
   at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.applyPatch(PatchServiceImpl.java:491)
   at org.alfresco.repo.admin.patch.PatchServiceImpl$PatchWork.execute(PatchServiceImpl.java:403)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:258)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:235)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:171)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy93.applyOutstandingPatches(Unknown Source)
   at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:76)
   at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:124)
   at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:120)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
   at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:128)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'alf_list_attribute_entries'
   at sun.reflect.GeneratedConstructorAccessor194.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
   at com.mysql.jdbc.Util.getInstance(Util.java:384)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
   at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)
   at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)
   at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:87)
   at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:46)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:118)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:111)
   at sun.reflect.GeneratedMethodAccessor465.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
   … 68 more

=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.db-V4.0-SubscriptionTables
RESULT: 
Script completed
=====================================
 2011-12-13 22:21:59,863  INFO  [admin.patch.PatchExecuter] [Thread-1] 
=== Applied patch                 === 
ID: patch.db-V4.0-SolrTracking
RESULT: 
Script completed
=====================================
 2011-12-13 22:21:59,863  ERROR [web.context.ContextLoader] [Thread-1] Context initialization failed
 org.alfresco.error.AlfrescoRuntimeException: 11130001 Not all patches could be applied
   at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:111)
   at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:124)
   at org.alfresco.repo.admin.patch.PatchExecuter$1.doWork(PatchExecuter.java:120)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
   at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:128)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

As you can see, its complain that the alf_list_attribute_entries table is missing. Restoring the table, I still get the same error. Help!