Alfresco Migration

[csvalavan]

Hi:

I am in the process of migrating MYSql of Alfresco 2.1 to MSSQL 2005. I have done the following steps and I get Null pointer Exception after I start alfresco.

1. Migrated MYSQL data to SQL Server by creating linked server and executing query (insert select) for each table. This has worked without any issues.
2. Configured Alfresco to use SQL Server
3. Downloaded JTDS driver and configured properties files accordingly.
4. Copied alf_data of Alfresco to this instance of Alfresco along with indexes.
5. Enabled log to info level for debugging
6. Enabled FULL index
7. Started the alfresco and am getting Null Pointer Exception.

Please help me in resolving this issue.

BTW: I have tried Full Export & Import also, it doesn't work. Also, my application has Web Projects and the document says, Web projects are not supported by Full Export .

Here is the trace:

17:43:09,051 INFO  [hibernate.cfg.SettingsFactory] RDBMS: Microsoft SQL Server, version: 09.00.3042
17:43:09,053 INFO  [hibernate.cfg.SettingsFactory] JDBC driver: jTDS Type 4 JDBC Driver for MS SQL Server and Sybase, version: 1.2
17:43:09,055 INFO  [hibernate.dialect.Dialect] Using dialect: org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect
17:43:09,059 INFO  [hibernate.transaction.TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)
17:43:09,061 INFO  [hibernate.transaction.TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-wri
te or transactional second-level cache is not recommended)
17:43:09,065 INFO  [hibernate.cfg.SettingsFactory] Automatic flush during beforeCompletion(): disabled
17:43:09,067 INFO  [hibernate.cfg.SettingsFactory] Automatic session close at end of transaction: disabled
17:43:09,069 INFO  [hibernate.cfg.SettingsFactory] JDBC batch size: 32
17:43:09,072 INFO  [hibernate.cfg.SettingsFactory] JDBC batch updates for versioned data: disabled
17:43:09,076 INFO  [hibernate.cfg.SettingsFactory] Scrollable result sets: enabled
17:43:09,078 INFO  [hibernate.cfg.SettingsFactory] JDBC3 getGeneratedKeys(): enabled
17:43:09,080 INFO  [hibernate.cfg.SettingsFactory] Connection release mode: auto
17:43:09,082 INFO  [hibernate.cfg.SettingsFactory] Maximum outer join fetch depth: 10
17:43:09,085 INFO  [hibernate.cfg.SettingsFactory] Default batch fetch size: 1
17:43:09,087 INFO  [hibernate.cfg.SettingsFactory] Generate SQL with comments: disabled
17:43:09,089 INFO  [hibernate.cfg.SettingsFactory] Order SQL updates by primary key: disabled
17:43:09,092 INFO  [hibernate.cfg.SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
17:43:09,095 INFO  [hql.ast.ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
17:43:09,097 INFO  [hibernate.cfg.SettingsFactory] Query language substitutions: {}
17:43:09,099 INFO  [hibernate.cfg.SettingsFactory] JPA-QL strict compliance: disabled
17:43:09,102 INFO  [hibernate.cfg.SettingsFactory] Second-level cache: enabled
17:43:09,104 INFO  [hibernate.cfg.SettingsFactory] Query cache: enabled
17:43:09,106 INFO  [hibernate.cfg.SettingsFactory] Cache provider: org.alfresco.repo.cache.InternalEhCacheManagerFactoryBean
17:43:09,111 INFO  [hibernate.cfg.SettingsFactory] Optimize cache for minimal puts: disabled
17:43:09,113 INFO  [hibernate.cfg.SettingsFactory] Structured second-level cache entries: disabled
17:43:09,116 INFO  [hibernate.cfg.SettingsFactory] Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
17:43:09,118 INFO  [hibernate.cfg.SettingsFactory] Statistics: disabled
17:43:09,120 INFO  [hibernate.cfg.SettingsFactory] Deleted entity synthetic identifier rollback: disabled
17:43:09,123 INFO  [hibernate.cfg.SettingsFactory] Default entity-mode: pojo
17:43:09,137 INFO  [tool.hbm2ddl.TableMetadata] table found: alfresco.dbo.avm_version_roots
17:43:09,139 INFO  [tool.hbm2ddl.TableMetadata] columns: [creator, avm_store_id, version_id, description, tag, root_id, create_date, id]
17:43:09,142 INFO  [tool.hbm2ddl.TableMetadata] foreign keys: [fk_avm_vr_store, fk_avm_vr_root]
17:43:09,146 INFO  [tool.hbm2ddl.TableMetadata] indexes: [idx_avm_vr_version, fk_avm_vr_store, pk__avm_version_root__7c4f7684, uq__avm_version_root__7
d439abd, fk_avm_vr_root]
17:43:09,251 INFO  [domain.schema.SchemaBootstrap] No changes were made to the schema.
17:44:27,284 WARN  [jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment
17:44:27,468 WARN  [jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment
17:44:27,516 WARN  [jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment
17:44:27,559 WARN  [jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment
17:44:28,393 ERROR [web.context.ContextLoader] Context initialization failed
java.lang.NullPointerException
        at org.alfresco.repo.domain.PropertyValue$ValueType.convert(PropertyValue.java:331)
        at org.alfresco.repo.domain.PropertyValue.getValue(PropertyValue.java:771)
        at org.alfresco.repo.node.AbstractNodeServiceImpl.makeSerializableValue(AbstractNodeServiceImpl.java:689)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getPropertiesImpl(DbNodeServiceImpl.java:917)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.setProperty(DbNodeServiceImpl.java:1053)
        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:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
        at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(TransactionResourceInterceptor.java:138)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
        at $Proxy2.setProperty(Unknown Source)
        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:585)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
        at $Proxy3.setProperty(Unknown Source)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:206)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
        at $Proxy2.setProperty(Unknown Source)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.updateCurrentRepositoryDescriptor(DescriptorServiceImpl.java:260)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.access$300(DescriptorServiceImpl.java:66)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.execute(DescriptorServiceImpl.java:176)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.execute(DescriptorServiceImpl.java:167)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:225)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.onBootstrap(DescriptorServiceImpl.java:182)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)

        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:448)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
        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:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
17:44:28,574 ERROR [[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.springframework.
web.context.ContextLoaderListener
java.lang.NullPointerException
        at org.alfresco.repo.domain.PropertyValue$ValueType.convert(PropertyValue.java:331)
        at org.alfresco.repo.domain.PropertyValue.getValue(PropertyValue.java:771)
        at org.alfresco.repo.node.AbstractNodeServiceImpl.makeSerializableValue(AbstractNodeServiceImpl.java:689)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getPropertiesImpl(DbNodeServiceImpl.java:917)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.setProperty(DbNodeServiceImpl.java:1053)
        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:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
        at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(TransactionResourceInterceptor.java:138)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
        at $Proxy2.setProperty(Unknown Source)
        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:585)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
        at $Proxy3.setProperty(Unknown Source)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:206)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
        at $Proxy2.setProperty(Unknown Source)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.updateCurrentRepositoryDescriptor(DescriptorServiceImpl.java:260)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.access$300(DescriptorServiceImpl.java:66)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.execute(DescriptorServiceImpl.java:176)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.execute(DescriptorServiceImpl.java:167)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:225)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.onBootstrap(DescriptorServiceImpl.java:182)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)

        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:448)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
        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:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
17:44:28,763 ERROR [[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app
.ContextListener
java.lang.NullPointerException
        at org.alfresco.repo.domain.PropertyValue$ValueType.convert(PropertyValue.java:331)
        at org.alfresco.repo.domain.PropertyValue.getValue(PropertyValue.java:771)
        at org.alfresco.repo.node.AbstractNodeServiceImpl.makeSerializableValue(AbstractNodeServiceImpl.java:689)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getPropertiesImpl(DbNodeServiceImpl.java:917)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.setProperty(DbNodeServiceImpl.java:1053)
        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:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
        at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(TransactionResourceInterceptor.java:138)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
        at $Proxy2.setProperty(Unknown Source)
        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:585)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
        at $Proxy3.setProperty(Unknown Source)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:206)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
        at $Proxy2.setProperty(Unknown Source)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.updateCurrentRepositoryDescriptor(DescriptorServiceImpl.java:260)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.access$300(DescriptorServiceImpl.java:66)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.execute(DescriptorServiceImpl.java:176)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.execute(DescriptorServiceImpl.java:167)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:225)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)
        at org.alfresco.repo.descriptor.DescriptorServiceImpl.onBootstrap(DescriptorServiceImpl.java:182)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)

        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:448)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
        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:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Jan 22, 2009 5:44:28 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Jan 22, 2009 5:44:28 PM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
17:44:28,937 INFO  [[Catalina].[localhost].[/alfresco]] Closing Spring root WebApplicationContext
Jan 22, 2009 5:44:30 PM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-9080
Jan 22, 2009 5:44:30 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Jan 22, 2009 5:44:30 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 148349 ms

Thanks,
Senthil.

[csvalavan]

Hi:

I have identified the root cause for this issue. That is the issue with bit column type. In MSSQL, the column type is tinyint and I am migrating data using the linkedserver method like this:
/*Data for the table alf_node_properties */

insert into alfresco.dbo.alf_node_properties(node_id,actual_type,multi_valued,persisted_type,boolean_value,long_value,float_value,double_value,string_value,attribute_value,serializable_value,qname) SELECT * FROM openquery(MYSQL, 'SELECT * FROM alfresco.alf_node_properties');


This query is screwing up data. It converts "True" for false bit data also. So, the code is looking for serializable properties and it is null.

I also have found that following tables => Columns are bit types. I need to manually analyze and set data properly. Is there any automated way available to convert this data effectively in the database migration?

alf_access_control_entry allowed
`alf_access_control_list` `inherits`
`alf_applied_patch` `was_executed`, `succeeded`
`alf_attributes` `bool_value`
`alf_audit_fact` `filtered`, `fail`
`alf_child_assoc` `is_primary`
`alf_node_properties` `multi_valued`, `boolean_value`,
`avm_node_properties` `multi_valued`, `boolean_value`
`avm_node_properties_new` `multi_valued`, `boolean_value`
`avm_nodes` `is_root`, `primary_indirection`, `opacity`
`avm_store_properties``multi_valued`, `boolean_value`,
`jbpm_action` `ISPROPAGATIONALLOWED_`, `ISASYNC_`,
`jbpm_job` `ISSUSPENDED_`, `ISEXCLUSIVE_`,

`jbpm_node` `ISASYNC_`, `ISASYNCEXCL_`, `CREATETASKS_`, `ENDTASKS_`,
`jbpm_processdefinition` `ISTERMINATIONIMPLICIT_`,

`jbpm_processinstance` `ISSUSPENDED_`,
`jbpm_task` `ISBLOCKING_`, `ISSIGNALLING_`,
`jbpm_taskinstance` `ISCANCELLED_`, `ISSUSPENDED_`, `ISOPEN_`, `ISSIGNALLING_`, `ISBLOCKING_`,

`jbpm_token` `ISABLETOREACTIVATEPARENT_`, `ISTERMINATIONIMPLICIT_`, `ISSUSPENDED_`,


Thanks,
Senthil.