topic upgrade 3.3C to 3.4C issues in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/upgrade-3-3c-to-3-4c-issues/m-p/241695#M194825 <HTML><HEAD></HEAD><BODY><SPAN>I am having issues upgrading from 3.3 Community to 3.4 Community. We are using Ubuntu server (v 10.04 for 3.3 v10.10 for 3.4). Here are the steps I have taken:</SPAN><BR /><SPAN>1. cold back up of alf_data and cold mysqldump of alfresco database.</SPAN><BR /><SPAN>2. clean install of Ubuntu and Alfresco - all works, I can log in as admin, etc.</SPAN><BR /><SPAN>3. stop Alfresco (/etc/init.d/alfresco stop)</SPAN><BR /><SPAN>4. make backup directory alf_backup and move contentstore and lucene-indexes to backup directory.</SPAN><BR /><SPAN>5. move backup of contentstore from step 1 to alf_data/contentstore and backup-lucene-indexes from step 1 to alf_data/lucene-indexes</SPAN><BR /><SPAN>6. change owner for contentstore and lucene-indexes (chown -R root:root contentstore lucene-indexes)</SPAN><BR /><SPAN>6. restore backup of database ( mysql -u root -pxxxx –database=alfresco &lt; backup_alfresco.sql)</SPAN><BR /><SPAN>7.&nbsp; restart Alfresco</SPAN><BR /><BR /><SPAN>Share starts and the login screen comes up - can't log in, no surprise since Alfresco does not start. Here is the error message from Alfresco:</SPAN><BR /><SPAN>HTTP Status 404 -</SPAN><BR /><SPAN>type Status report</SPAN><BR /><SPAN>message</SPAN><BR /><SPAN>description The requested resource () is not available.</SPAN><BR /><BR /><SPAN>and the alfresco.log:</SPAN><BR /><SPAN>10:38:45,310 INFO&nbsp; [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properti</SPAN><BR /><SPAN>es]</SPAN><BR /><SPAN>10:38:45,311 INFO&nbsp; [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.</SPAN><BR /><SPAN>properties]</SPAN><BR /><SPAN>10:38:45,312 INFO&nbsp; [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/alfresco-3.4.a/tomcat/webapps/alfresco</SPAN><BR /><SPAN>/WEB-INF/classes/alfresco/module/test/alfresco-global.properties]</SPAN><BR /><SPAN>10:38:45,312 INFO&nbsp; [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/alfresco-3.4.a/tomcat/webapps/alfresco</SPAN><BR /><SPAN>/WEB-INF/classes/alfresco/module/tests/alfresco-global.properties]</SPAN><BR /><SPAN>10:38:45,312 INFO&nbsp; [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/alfresco-3.4.a/tomcat/webapps/alfresco</SPAN><BR /><SPAN>/WEB-INF/classes/alfresco/module/org_alfresco_module_dod5015/alfresco-global.properties]</SPAN><BR /><SPAN>10:38:45,312 INFO&nbsp; [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/alfresco-3.4.a/tomcat/webapps/alfresco</SPAN><BR /><SPAN>/WEB-INF/classes/alfresco/module/org_alfresco_module_wcmquickstart/alfresco-global.properties]</SPAN><BR /><SPAN>10:38:45,312 INFO&nbsp; [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/opt/alfresco-3.4.a/tomcat/shared/class</SPAN><BR /><SPAN>es/alfresco-global.properties]</SPAN><BR /><SPAN>10:38:45,369 INFO&nbsp; [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-sh</SPAN><BR /><SPAN>ared.properties]</SPAN><BR /><SPAN>10:38:56,074 WARN&nbsp; [org.springframework.beans.GenericTypeAwarePropertyDescriptor] Invalid JavaBean property 'serviceBeans' being accessed! Ambigu</SPAN><BR /><SPAN>ous write methods found next to actually used [public void org.apache.cxf.jaxrs.JAXRSServerFactoryBean.setServiceBeans(java.util.List)]: [public</SPAN><BR /><SPAN>void org.apache.cxf.jaxrs.JAXRSServerFactoryBean.setServiceBeans(java.lang.Object[])]</SPAN><BR /><SPAN>10:38:56,929 INFO&nbsp; [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Proces</SPAN><BR /><SPAN>sor for extension ftl</SPAN><BR /><SPAN>10:38:56,931 INFO&nbsp; [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor fo</SPAN><BR /><SPAN>r extension js</SPAN><BR /><SPAN>10:38:59,890 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.</SPAN><BR /><SPAN>10:39:00,231 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.</SPAN><BR /><SPAN>10:39:00,275 INFO&nbsp; [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default</SPAN><BR /><SPAN>]</SPAN><BR /><SPAN>10:39:00,289 INFO&nbsp; [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-sh</SPAN><BR /><SPAN>ared.properties]</SPAN><BR /><SPAN>10:39:00,331 INFO&nbsp; [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, defau</SPAN><BR /><SPAN>lt] complete</SPAN><BR /><SPAN>10:39:39,954 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed</SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: 09260040 Workflow deployment failed</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.workflow.WorkflowDeployer.init(WorkflowDeployer.java:330)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.workflow.WorkflowDeployer$1.doWork(WorkflowDeployer.java:437)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:508)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.workflow.WorkflowDeployer.onBootstrap(WorkflowDeployer.java:433)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardService.start(StandardService.java:519)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.Catalina.start(Catalina.java:581)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)</SPAN><BR /><SPAN>Caused by: org.alfresco.repo.audit.model.AuditModelException: 09260039 Failed to load audit model: file:/opt/alfresco-3.4.a/tomcat/webapps/alfres</SPAN><BR /><SPAN>co/WEB-INF/classes/alfresco/audit/alfresco-audit-cmis.xml</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.model.AuditModelRegistryImpl$AuditModelRegistryState$1.execute(AuditModelRegistryImpl.java:385)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.model.AuditModelRegistryImpl$AuditModelRegistryState$1.execute(AuditModelRegistryImpl.java:367)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:325)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.model.AuditModelRegistryImpl$AuditModelRegistryState$2.doWork(AuditModelRegistryImpl.java:400)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.model.AuditModelRegistryImpl$AuditModelRegistryState$2.doWork(AuditModelRegistryImpl.java:397)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:508)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.model.AuditModelRegistryImpl$AuditModelRegistryState.start(AuditModelRegistryImpl.java:396)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.management.subsystems.AbstractPropertyBackedBean.start(AbstractPropertyBackedBean.java:458)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.management.subsystems.AbstractPropertyBackedBean.start(AbstractPropertyBackedBean.java:440)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.management.subsystems.AbstractPropertyBackedBean.getState(AbstractPropertyBackedBean.java:221)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.model.AuditModelRegistryImpl.getState(AuditModelRegistryImpl.java:157)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.model.AuditModelRegistryImpl.getAuditPathMapper(AuditModelRegistryImpl.java:193)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.AuditComponentImpl.areAuditValuesRequired(AuditComponentImpl.java:217)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:129)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at $Proxy70.isDefinitionDeployed(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.workflow.WorkflowDeployer.init(WorkflowDeployer.java:293)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 37 more</SPAN><BR /><SPAN>Caused by: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdb</SPAN><BR /><SPAN>c.exception.NestedSQLException:</SPAN><BR /><SPAN>— The error occurred in alfresco/ibatis/#resource.dialect#/propval-common-SqlMap.xml.</SPAN><BR /><SPAN>— The error occurred while applying a parameter map.</SPAN><BR /><SPAN>— Check the alfresco.propval.insert_PropertyLink-InlineParameterMap.</SPAN><BR /><SPAN>— Check the statement (update failed).</SPAN><BR /><SPAN>— Cause: java.sql.SQLException: Unknown column 'prop_index' in 'field list'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:364)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.propval.ibatis.PropertyValueDAOImpl.createPropertyLink(PropertyValueDAOImpl.java:654)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.createPropertyImpl(AbstractPropertyValueDAOImpl.java:1007)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.access$700(AbstractPropertyValueDAOImpl.java:54)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyCallbackDAO.createValue(AbstractPropertyValueDAOImpl.java:846)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyCallbackDAO.createValue(AbstractPropertyValueDAOImpl.java:840)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.cache.lookup.EntityLookupCache.getOrCreateByValue(EntityLookupCache.java:447)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.createProperty(AbstractPropertyValueDAOImpl.java:823)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.domain.audit.AbstractAuditDAOImpl.createAuditApplication(AbstractAuditDAOImpl.java:205)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.model.AuditModelRegistryImpl$AuditModelRegistryState.cacheAuditElements(AuditModelRegistryImpl.java:601)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.model.AuditModelRegistryImpl$AuditModelRegistryState.access$500(AuditModelRegistryImpl.java:232)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.audit.model.AuditModelRegistryImpl$AuditModelRegistryState$1.execute(AuditModelRegistryImpl.java:381)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 56 more</SPAN><BR /><SPAN>Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:</SPAN><BR /><SPAN>— The error occurred in alfresco/ibatis/#resource.dialect#/propval-common-SqlMap.xml.</SPAN><BR /><SPAN>— The error occurred while applying a parameter map.</SPAN><BR /><SPAN>— Check the alfresco.propval.insert_PropertyLink-InlineParameterMap.</SPAN><BR /><SPAN>— Check the statement (update failed).</SPAN><BR /><SPAN>— Cause: java.sql.SQLException: Unknown column 'prop_index' in 'field list'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:393)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.orm.ibatis.SqlMapClientTemplate$8.doInSqlMapClient(SqlMapClientTemplate.java:366)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 68 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Unknown column 'prop_index' in 'field list'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:773)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:100)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 72 more</SPAN><BR /><SPAN>10:39:44,627 INFO&nbsp; [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 301 Web Scripts (+0 failed), 309 URLs</SPAN><BR /><SPAN>10:39:44,628 INFO&nbsp; [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)</SPAN><BR /><SPAN>10:39:44,628 INFO&nbsp; [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)</SPAN><BR /><SPAN>10:39:44,847 INFO&nbsp; [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (i</SPAN><BR /><SPAN>n 1234.7661ms)</SPAN><BR /><SPAN>10:39:44,883 INFO&nbsp; [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension f</SPAN><BR /><SPAN>tl</SPAN><BR /><SPAN>10:39:44,930 INFO&nbsp; [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js</SPAN><BR /><SPAN>10:39:44,991 INFO&nbsp; [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension f</SPAN><BR /><SPAN>tl</SPAN><BR /><SPAN>10:39:44,994 INFO&nbsp; [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js</SPAN><BR /><SPAN>10:39:45,059 INFO&nbsp; [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension f</SPAN><BR /><SPAN>tl</SPAN><BR /><SPAN>10:39:45,062 INFO&nbsp; [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js</SPAN><BR /><SPAN>root@Alfresco34C:/opt/alfresco-3.4.a#</SPAN><BR /><BR /><SPAN>What am I missing?? any help would be appreciated.</SPAN><BR /><BR /><SPAN>Best Regards,</SPAN><BR /><BR /><SPAN>Deb</SPAN></BODY></HTML> Tue, 26 Oct 2010 16:28:25 GMT ddvorak 2010-10-26T16:28:25Z upgrade 3.3C to 3.4C issues https://connect.hyland.com/t5/alfresco-archive/upgrade-3-3c-to-3-4c-issues/m-p/241695#M194825 I am having issues upgrading from 3.3 Community to 3.4 Community. We are using Ubuntu server (v 10.04 for 3.3 v10.10 for 3.4). Here are the steps I have taken:1. cold back up of alf_data and cold mysqldump of alfresco database.2. clean install of Ubuntu and Alfresco - all works, I can log in as admi Tue, 26 Oct 2010 16:28:25 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-3-3c-to-3-4c-issues/m-p/241695#M194825 ddvorak 2010-10-26T16:28:25Z Re: upgrade 3.3C to 3.4C issues https://connect.hyland.com/t5/alfresco-archive/upgrade-3-3c-to-3-4c-issues/m-p/241696#M194826 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I have the precise same problem but with a fresh install (not from backups) with an external database (mysql).</SPAN><BR /><SPAN>It does not happen with the provided mysql.</SPAN><BR /><BR /><SPAN>All ideas welcomed!</SPAN><BR /><SPAN>(ubuntu 10.10 server)</SPAN></BODY></HTML> Wed, 27 Oct 2010 10:40:21 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-3-3c-to-3-4c-issues/m-p/241696#M194826 nimbus58 2010-10-27T10:40:21Z Re: upgrade 3.3C to 3.4C issues https://connect.hyland.com/t5/alfresco-archive/upgrade-3-3c-to-3-4c-issues/m-p/241697#M194827 <HTML><HEAD></HEAD><BODY><SPAN>what version of 3.4? get 3.4b on nightly </SPAN><A href="http://dev.alfresco.com/downloads/nightly/dist/" rel="nofollow noopener noreferrer">http://dev.alfresco.com/downloads/nightly/dist/</A></BODY></HTML> Thu, 04 Nov 2010 15:26:30 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-3-3c-to-3-4c-issues/m-p/241697#M194827 tb13 2010-11-04T15:26:30Z Re: upgrade 3.3C to 3.4C issues https://connect.hyland.com/t5/alfresco-archive/upgrade-3-3c-to-3-4c-issues/m-p/241698#M194828 <HTML><HEAD></HEAD><BODY><SPAN>I am on 3.4a under windows and under ubuntu 10.10.</SPAN><BR /><SPAN>No luck!</SPAN></BODY></HTML> Fri, 05 Nov 2010 06:21:47 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-3-3c-to-3-4c-issues/m-p/241698#M194828 nimbus58 2010-11-05T06:21:47Z Re: upgrade 3.3C to 3.4C issues https://connect.hyland.com/t5/alfresco-archive/upgrade-3-3c-to-3-4c-issues/m-p/241699#M194829 <HTML><HEAD></HEAD><BODY><SPAN>I am not quite sure about your problem, but usually this sort of problem is configuration problem. Do you have the alfresco-global.properties at the right place? Do you have the correct path to alfresco data store? Can you post your alfresco-global.properties file?</SPAN></BODY></HTML> Fri, 05 Nov 2010 07:48:12 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-3-3c-to-3-4c-issues/m-p/241699#M194829 tb13 2010-11-05T07:48:12Z