topic Re: 3.4 upgrade scripts failing in Alfresco Archive

3.4 upgrade scripts failing

jriker1 — Thu, 30 Sep 2010 19:32:42 GMT

Took my 3.3 instance and replaced with the new war files on Linux. Starting implementing script upgrades and got a failure that hung things up. See below:18:03:32,105 INFO [admin.patch.PatchExecuter] Applying patch 'patch.migrateAttrChainingURS' (Migrate old Chaining User Registry Synchr

Re: 3.4 upgrade scripts failing

jriker1 — Fri, 01 Oct 2010 15:54:06 GMT

I also tried the latest code out there but no joy. Also tried updating the mysql connector but same deal. Created a JIRA ticket. Has anyone else upgraded and have the before mentioned error?

Thanks.

JR

Re: 3.4 upgrade scripts failing

loftux — Fri, 01 Oct 2010 17:27:22 GMT

What database (including version) are you running?
Whats the default character set of your db?
What are your settings in alfresco-global.properties (those related to database)?

Re: 3.4 upgrade scripts failing

jriker1 — Fri, 01 Oct 2010 18:35:45 GMT

What database (including version) are you running?
Whats the default character set of your db?
What are your settings in alfresco-global.properties (those related to database)?

I am running MySQL 5.0.67 on OpenSuse.
I believe the default character set is Latin-1 however DB for Alfresco is UTF-8.

My global's relative to the DB are:

db.name=alfresco
db.username=alfresco
db.password=<my pass>
db.host=<server name>
db.port=3306
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode=true&characterEncoding=utf-8
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
index.recovery.mode=AUTO

Re: 3.4 upgrade scripts failing

jriker1 — Fri, 01 Oct 2010 20:55:32 GMT

I think the only thing that concerned me on the above with the DB connection is Alfresco said they stopped using Hibernate however I'm using Hibernate for the DB connection. If that isn't used anymore there is no 3.4 documentation on what should be used now.

Thanks.

JR

Re: 3.4 upgrade scripts failing

loftux — Fri, 01 Oct 2010 21:32:48 GMT

That looks ok,

Only thing I can think of is to do a mysqldump with the –no-data option of your current database, and then do a clean install of Alfresco with the same version as your current install. Do a mysqldump with –no-data of that db, then do a diff to see if you can find anything.

Re: 3.4 upgrade scripts failing

jriker1 — Sat, 02 Oct 2010 02:19:13 GMT

The way I see it there has to be some kind of bug. The below piece of log data for example:

18:03:32,270 ERROR [admin.patch.PatchExecuter] 08300000 org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
— The error occurred in alfresco/ibatis/#resource.dialect#/patch-common-SqlMap.xml.
— The error occurred while applying a result map.
— Check the alfresco.patch.result_ChainingURS.
— Check the result mapping for the 'lastModified' property.

So it's referring to the result_ChainingURS of the above XML file. It also shows that a null was returned if I'm looking at this right and from the lastModified property. If I run the query that pulls the data from the DB for ChainingURS I do get a string of a date value out of the database. It's not blank or null.

JR