AnsweredAssumed Answered

3.4 upgrade scripts failing

Question asked by jriker1 on Sep 30, 2010
Latest reply on Oct 2, 2010 by jriker1
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 Synchronizer attributes).
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.
— Cause: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/ibatis/#resource.dialect#/propval-common-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.propval.select_PropertyValueByStringValue-InlineParameterMap.
— Check the statement (query failed).
— Cause: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'sv.string_end_lower' in 'where clause'; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— 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.
— Cause: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in alfresco/ibatis/#resource.dialect#/propval-common-SqlMap.xml.
— The error occurred while applying a parameter map.
— Check the alfresco.propval.select_PropertyValueByStringValue-InlineParameterMap.
— Check the statement (query failed).
— Cause: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'sv.string_end_lower' in 'where clause'
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
        at org.springframework.orm.ibatis.SqlMapClientTemplate.queryWithRowHandler(SqlMapClientTemplate.java:327)
        at org.springframework.orm.ibatis.SqlMapClientTemplate.queryWithRowHandler(SqlMapClientTemplate.java:320)
        at org.alfresco.repo.domain.patch.ibatis.PatchDAOImpl.getOldAttrChainingURSImpl(PatchDAOImpl.java:458)
        at org.alfresco.repo.domain.patch.AbstractPatchDAOImpl.migrateOldAttrChainingURS(AbstractPatchDAOImpl.java:255)
        at org.alfresco.repo.admin.patch.impl.MigrateAttrChainingURSPatch.applyInternal(MigrateAttrChainingURSPatch.java:64)
        at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:415)
        at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:409)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:325)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:232)
        at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:441)
        at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:405)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:508)
        at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:445)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:297)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:50)
        at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:226)
        at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:223)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:325)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:229)
        at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:163)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

Can provide more info if needed.  Not sure if this is something that anyone knows what's going on.  This is from the catalina.out file.

Thanks.

JR

Outcomes