topic Re: force upgrade db schema 4.2a in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/force-upgrade-db-schema-4-2a/m-p/275985#M229115 <HTML><HEAD></HEAD><BODY><SPAN>I got this error when locally upgrading from 4.0.0 to 4.1.2 because I had done the following:</SPAN><BR /><BR /><SPAN>* Built and started 4.1.2 locally, which created alf_tenant tables in my local database</SPAN><BR /><SPAN>* Executed a remote cold backup (from 4.0.0) and local restore into my local database, but </SPAN><EM>didn't delete the existing alfresco database before importing</EM><BR /><SPAN>* Tried to start 4.1.2, displaying the same error</SPAN><BR /><BR /><SPAN>The problem was that the data thought it was running pre-4.1.2, but the database had a table schema of 4.1.2 (such as a new alf_tenant table). The cold backup process only drops existing tables, not new tables that didn't exist before.</SPAN><BR /><BR /><SPAN>By deleting the existing database and executing the cold backup restore again, the database upgrade process continued as expected.</SPAN></BODY></HTML> Mon, 14 Jan 2013 22:27:51 GMT jevon 2013-01-14T22:27:51Z force upgrade db schema 4.2a https://connect.hyland.com/t5/alfresco-archive/force-upgrade-db-schema-4-2a/m-p/275984#M229114 I am trying to upgrade to 4.2a. I have succefully upgraded one but my second server does not want to upgradeit keeps barking the followingINFO: ProcessEngine default created2012-10-25 07:59:57,007&nbsp; INFO&nbsp; [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template pr Thu, 25 Oct 2012 13:08:23 GMT https://connect.hyland.com/t5/alfresco-archive/force-upgrade-db-schema-4-2a/m-p/275984#M229114 sharifu 2012-10-25T13:08:23Z Re: force upgrade db schema 4.2a https://connect.hyland.com/t5/alfresco-archive/force-upgrade-db-schema-4-2a/m-p/275985#M229115 <HTML><HEAD></HEAD><BODY><SPAN>I got this error when locally upgrading from 4.0.0 to 4.1.2 because I had done the following:</SPAN><BR /><BR /><SPAN>* Built and started 4.1.2 locally, which created alf_tenant tables in my local database</SPAN><BR /><SPAN>* Executed a remote cold backup (from 4.0.0) and local restore into my local database, but </SPAN><EM>didn't delete the existing alfresco database before importing</EM><BR /><SPAN>* Tried to start 4.1.2, displaying the same error</SPAN><BR /><BR /><SPAN>The problem was that the data thought it was running pre-4.1.2, but the database had a table schema of 4.1.2 (such as a new alf_tenant table). The cold backup process only drops existing tables, not new tables that didn't exist before.</SPAN><BR /><BR /><SPAN>By deleting the existing database and executing the cold backup restore again, the database upgrade process continued as expected.</SPAN></BODY></HTML> Mon, 14 Jan 2013 22:27:51 GMT https://connect.hyland.com/t5/alfresco-archive/force-upgrade-db-schema-4-2a/m-p/275985#M229115 jevon 2013-01-14T22:27:51Z