New issue in Alfresco 3.2 Enterprise ?

[rtan]

Hi there
I am using the new Alfresco 3.2 Enterprise. My environment includes JBoss 5.0.1GA going against SQL Server 2005. My sever log shows that the bootstrap process works until I run into Ibatis XML related exceptions. This is exactly as reported at:
https://issues.alfresco.com/jira/browse/ETHREEOH-3818?page=com.atlassian.jira.plugin.system.issuetab...

I tried the patch in changing 3.2.0 Enterprise /alfresco/patch/patch-services-context.xml as indicated but still seeing the same exceptiopns.  I am unsure of the build I am using but the file is alfresco-enterprise-war-3.2.0.zip.

Can someone help out ASAP?
Thanks

2010-01-07 11:34:18,984 INFO  [STDOUT] (main) 11:34:18,984  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
2010-01-07 11:44:43,953 INFO  [STDOUT] (main) 11:44:43,921  ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 00070040 Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:367)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:724)
   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:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4393)
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:312)
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:144)
   at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
   at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
   at org.jboss.web.deployers.WebModule.start(WebModule.java:97)
   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:597)
   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
   at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
   at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
   at $Proxy36.start(Unknown Source)
   at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
   at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
   at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
   at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
   at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
   at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
   at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
   at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
   at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
   at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
   at org.jboss.system.ServiceController.start(ServiceController.java:460)
   at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
   at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
   at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
   at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
   at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
   at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
   at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
   at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
   at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
   at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)
   at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)
   at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)
   at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)
   at org.jboss.Main.boot(Main.java:209)
   at org.jboss.Main$1.run(Main.java:547)
   at java.lang.Thread.run(Thread.java:619)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to import package at line 24; column 19 due to error: 00070039 Failed to set content property on stream closure:
   node: system://system/c85d9dbd-25b2-4dfa-9776-f996c9e357a9
   property: {http://www.alfresco.org/model/system/1.0}versionProperties
   writer: ContentAccessor[ contentUrl=store://2010/1/7/11/44/b8cec478-8671-4cfc-af74-4a4ccd8739b0.bin, mimetype=text/plain, size=259, encoding=UTF8, locale=en_US]
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1093]; error code [0];  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:196)
   at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.ja
2010-01-07 11:44:43,984 INFO  [STDOUT] (main) va:359)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:223)
   at org.alfresco.repo.importer.ImporterBootstrap.doImport(ImporterBootstrap.java:481)
   at org.alfresco.repo.importer.ImporterBootstrap.access$000(ImporterBootstrap.java:76)
   at org.alfresco.repo.importer.ImporterBootstrap$1$1.execute(ImporterBootstrap.java:356)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
   at org.alfresco.repo.importer.ImporterBootstrap$1.doWork(ImporterBootstrap.java:360)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:514)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:363)
   … 70 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 00070039 Failed to set content property on stream closure:
   node: system://system/c85d9dbd-25b2-4dfa-9776-f996c9e357a9
   property: {http://www.alfresco.org/model/system/1.0}versionProperties
   writer: ContentAccessor[ contentUrl=store://2010/1/7/11/44/b8cec478-8671-4cfc-af74-4a4ccd8739b0.bin, mimetype=text/plain, size=259, encoding=UTF8, locale=en_US]
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1093]; error code [0];  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at org.alfresco.repo.content.ContentServiceImpl$WriteStreamListener.contentStreamClosed(ContentServiceImpl.java:658)
   at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel$1.execute(AbstractContentAccessor.java:359)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:253)
   at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel.fireChannelClosed(AbstractContentAccessor.java:369)
   at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel.implCloseChannel(AbstractContentAccessor.java:338)
   at java.nio.channels.spi.AbstractInterruptibleChannel.close(AbstractInterruptibleChannel.java:97)
   at java.nio.channels.Channels$1.close(Channels.java:138)
   at java.io.FilterOutputStream.close(FilterOutputStream.java:143)
   at org.springframework.util.FileCopyUtils.copy(FileCopyUtils.java:132)
   at org.alfresco.repo.content.AbstractContentWriter.putContent(AbstractContentWriter.java:423)
   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.importContent(ImporterComponent.java:674)
   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.importNode(ImporterComponent.java:577)
   at org.alfresco.repo.importer.view.ViewParser.importNode(ViewParser.java:914)
   at org.alfresco.repo.importer.view.ViewParser.processEndType(ViewParser.java:878)
   at org.alfresco.repo.importer.view.ViewParser.processEndElement(ViewParser.java:858)
   at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:188)
   … 79 more
Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1093]; error code [0];  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120)
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:197)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:368)
   at org.alfresco.repo.domain.contentdata.ibatis.ContentDataDAOImpl.createContentUrlEntity(ContentDataDAOImpl.java:74)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.getOrCreateContentUrlEntity(AbstractContentDataDAOImpl.java:418)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.createContentDataEntity(AbstractContentDataDAOImpl.java:309)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.access$100(AbstractContentDataDAOImpl.java:61)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl$ContentDataCallbackDAO.createValue(AbstractContentDataDAOImpl.java:227)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl$ContentDataCallbackDAO.createValue(AbstractContentDataDAOImpl.java:223)
   at org.alfresco.repo.cache.lookup.EntityLookupCache.getOrCreateByValue(EntityLookupCache.java:438)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.createContentData(AbstractContentDataDAOImpl.java:162)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addValueToPersistedProperties(HibernateNodeDaoServiceImpl.java:4975)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addNodePropertyImpl(HibernateNodeDaoServiceImpl.java:1474)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addNodeProperty(HibernateNodeDaoServiceImpl.java:1513)
   at sun.reflect.GeneratedMethodAccessor546.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:419)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy163.addNodeProperty(Unknown Source)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.setPropertyImpl(DbNodeServiceImpl.java:1455)
   at org.alfresco.repo.node.db.DbNodeServiceImpl
2010-01-07 11:44:44,000 INFO  [STDOUT] (main) .setProperty(DbNodeServiceImpl.java:1419)
   at sun.reflect.GeneratedMethodAccessor510.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy165.setProperty(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor510.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy166.setProperty(Unknown Source)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:255)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:266)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:266)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy165.setProperty(Unknown Source)
   at org.alfresco.repo.content.ContentServiceImpl$WriteStreamListener.contentStreamClosed(ContentServiceImpl.java:638)
   … 95 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)
   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:393)
   at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
   at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:370)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194)
   … 148 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerResultSet.findColumn(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getObject(Unknown Source)
   at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:116)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)
   … 152 more
2010-01-07 11:44:44,031 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/alfresco]] (main) Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: 00070040 Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:367)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:724)
   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:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4393)
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:312)
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:144)
   at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
   at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
   at org.jboss.web.deployers.WebModule.start(WebModule.java:97)
   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:597)
   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
   at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
   at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
   at $Proxy36.start(Unknown Source)
   at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
   at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
   at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
   at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
   at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
   at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
   at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
   at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
   at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
   at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
   at org.jboss.system.ServiceController.start(ServiceController.java:460)
   at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
   at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
   at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
   at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
   at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
   at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
   at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
   at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
   at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
   at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)
   at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)
   at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)
   at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)
   at org.jboss.Main.boot(Main.java:209)
   at org.jboss.Main$1.run(Main.java:547)
   at java.lang.Thread.run(Thread.java:619)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to import package at line 24; column 19 due to error: 00070039 Failed to set content property on stream closure:
   node: system://system/c85d9dbd-25b2-4dfa-9776-f996c9e357a9
   property: {http://www.alfresco.org/model/system/1.0}versionProperties
   writer: ContentAccessor[ contentUrl=store://2010/1/7/11/44/b8cec478-8671-4cfc-af74-4a4ccd8739b0.bin, mimetype=text/plain, size=259, encoding=UTF8, locale=en_US]
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1093]; error code [0];  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:196)
   at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:359)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:223)
   at org.alfresco.repo.importer.ImporterBootstrap.doImport(ImporterBootstrap.java:481)
   at org.alfresco.repo.importer.ImporterBootstrap.access$000(ImporterBootstrap.java:76)
   at org.alfresco.repo.importer.ImporterBootstrap$1$1.execute(ImporterBootstrap.java:356)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
   at org.alfresco.repo.importer.ImporterBootstrap$1.doWork(ImporterBootstrap.java:360)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:514)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:363)
   … 70 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 00070039 Failed to set content property on stream closure:
   node: system://system/c85d9dbd-25b2-4dfa-9776-f996c9e357a9
   property: {http://www.alfresco.org/model/system/1.0}versionProperties
   writer: ContentAccessor[ contentUrl=store://2010/1/7/11/44/b8cec478-8671-4cfc-af74-4a4ccd8739b0.bin, mimetype=text/plain, size=259, encoding=UTF8, locale=en_US]
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1093]; error code [0];  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at org.alfresco.repo.content.ContentServiceImpl$WriteStreamListener.contentStreamClosed(ContentServiceImpl.java:658)
   at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel$1.execute(AbstractContentAccessor.java:359)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:253)
   at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel.fireChannelClosed(AbstractContentAccessor.java:369)
   at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel.implCloseChannel(AbstractContentAccessor.java:338)
   at java.nio.channels.spi.AbstractInterruptibleChannel.close(AbstractInterruptibleChannel.java:97)
   at java.nio.channels.Channels$1.close(Channels.java:138)
   at java.io.FilterOutputStream.close(FilterOutputStream.java:143)
   at org.springframework.util.FileCopyUtils.copy(FileCopyUtils.java:132)
   at org.alfresco.repo.content.AbstractContentWriter.putContent(AbstractContentWriter.java:423)
   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.importContent(ImporterComponent.java:674)
   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.importNode(ImporterComponent.java:577)
   at org.alfresco.repo.importer.view.ViewParser.importNode(ViewParser.java:914)
   at org.alfresco.repo.importer.view.ViewParser.processEndType(ViewParser.java:878)
   at org.alfresco.repo.importer.view.ViewParser.processEndElement(ViewParser.java:858)
   at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:188)
   … 79 more
Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1093]; error code [0];  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120)
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:197)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:368)
   at org.alfresco.repo.domain.contentdata.ibatis.ContentDataDAOImpl.createContentUrlEntity(ContentDataDAOImpl.java:74)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.getOrCreateContentUrlEntity(AbstractContentDataDAOImpl.java:418)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.createContentDataEntity(AbstractContentDataDAOImpl.java:309)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.access$100(AbstractContentDataDAOImpl.java:61)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl$ContentDataCallbackDAO.createValue(AbstractContentDataDAOImpl.java:227)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl$ContentDataCallbackDAO.createValue(AbstractContentDataDAOImpl.java:223)
   at org.alfresco.repo.cache.lookup.EntityLookupCache.getOrCreateByValue(EntityLookupCache.java:438)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.createContentData(AbstractContentDataDAOImpl.java:162)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addValueToPersistedProperties(HibernateNodeDaoServiceImpl.java:4975)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addNodePropertyImpl(HibernateNodeDaoServiceImpl.java:1474)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addNodeProperty(HibernateNodeDaoServiceImpl.java:1513)
   at sun.reflect.GeneratedMethodAccessor546.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:419)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy163.addNodeProperty(Unknown Source)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.setPropertyImpl(DbNodeServiceImpl.java:1455)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.setProperty(DbNodeServiceImpl.java:1419)
   at sun.reflect.GeneratedMethodAccessor510.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy165.setProperty(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor510.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy166.setProperty(Unknown Source)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:255)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:266)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:266)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy165.setProperty(Unknown Source)
   at org.alfresco.repo.content.ContentServiceImpl$WriteStreamListener.contentStreamClosed(ContentServiceImpl.java:638)
   … 95 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)
   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:393)
   at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
   at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:370)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194)
   … 148 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerResultSet.findColumn(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getObject(Unknown Source)
   at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:116)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)
   … 152 more
2010-01-07 11:44:44,125 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/alfresco]] (main) Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: 00070040 Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:367)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:724)
   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:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4393)
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:312)
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:144)
   at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
   at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
   at org.jboss.web.deployers.WebModule.start(WebModule.java:97)
   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:597)
   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
   at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
   at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
   at $Proxy36.start(Unknown Source)
   at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
   at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
   at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
   at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
   at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
   at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
   at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
   at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
   at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
   at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
   at org.jboss.system.ServiceController.start(ServiceController.java:460)
   at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
   at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
   at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
   at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
   at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
   at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
   at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
   at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
   at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
   at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)
   at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)
   at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)
   at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)
   at org.jboss.Main.boot(Main.java:209)
   at org.jboss.Main$1.run(Main.java:547)
   at java.lang.Thread.run(Thread.java:619)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to import package at line 24; column 19 due to error: 00070039 Failed to set content property on stream closure:
   node: system://system/c85d9dbd-25b2-4dfa-9776-f996c9e357a9
   property: {http://www.alfresco.org/model/system/1.0}versionProperties
   writer: ContentAccessor[ contentUrl=store://2010/1/7/11/44/b8cec478-8671-4cfc-af74-4a4ccd8739b0.bin, mimetype=text/plain, size=259, encoding=UTF8, locale=en_US]
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1093]; error code [0];  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:196)
   at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:359)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:223)
   at org.alfresco.repo.importer.ImporterBootstrap.doImport(ImporterBootstrap.java:481)
   at org.alfresco.repo.importer.ImporterBootstrap.access$000(ImporterBootstrap.java:76)
   at org.alfresco.repo.importer.ImporterBootstrap$1$1.execute(ImporterBootstrap.java:356)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
   at org.alfresco.repo.importer.ImporterBootstrap$1.doWork(ImporterBootstrap.java:360)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:514)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:363)
   … 70 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 00070039 Failed to set content property on stream closure:
   node: system://system/c85d9dbd-25b2-4dfa-9776-f996c9e357a9
   property: {http://www.alfresco.org/model/system/1.0}versionProperties
   writer: ContentAccessor[ contentUrl=store://2010/1/7/11/44/b8cec478-8671-4cfc-af74-4a4ccd8739b0.bin, mimetype=text/plain, size=259, encoding=UTF8, locale=en_US]
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1093]; error code [0];  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at org.alfresco.repo.content.ContentServiceImpl$WriteStreamListener.contentStreamClosed(ContentServiceImpl.java:658)
   at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel$1.execute(AbstractContentAccessor.java:359)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:253)
   at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel.fireChannelClosed(AbstractContentAccessor.java:369)
   at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel.implCloseChannel(AbstractContentAccessor.java:338)
   at java.nio.channels.spi.AbstractInterruptibleChannel.close(AbstractInterruptibleChannel.java:97)
   at java.nio.channels.Channels$1.close(Channels.java:138)
   at java.io.FilterOutputStream.close(FilterOutputStream.java:143)
   at org.springframework.util.FileCopyUtils.copy(FileCopyUtils.java:132)
   at org.alfresco.repo.content.AbstractContentWriter.putContent(AbstractContentWriter.java:423)
   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.importContent(ImporterComponent.java:674)
   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.importNode(ImporterComponent.java:577)
   at org.alfresco.repo.importer.view.ViewParser.importNode(ViewParser.java:914)
   at org.alfresco.repo.importer.view.ViewParser.processEndType(ViewParser.java:878)
   at org.alfresco.repo.importer.view.ViewParser.processEndElement(ViewParser.java:858)
   at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:188)
   … 79 more
Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1093]; error code [0];  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120)
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:197)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:368)
   at org.alfresco.repo.domain.contentdata.ibatis.ContentDataDAOImpl.createContentUrlEntity(ContentDataDAOImpl.java:74)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.getOrCreateContentUrlEntity(AbstractContentDataDAOImpl.java:418)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.createContentDataEntity(AbstractContentDataDAOImpl.java:309)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.access$100(AbstractContentDataDAOImpl.java:61)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl$ContentDataCallbackDAO.createValue(AbstractContentDataDAOImpl.java:227)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl$ContentDataCallbackDAO.createValue(AbstractContentDataDAOImpl.java:223)
   at org.alfresco.repo.cache.lookup.EntityLookupCache.getOrCreateByValue(EntityLookupCache.java:438)
   at org.alfresco.repo.domain.contentdata.AbstractContentDataDAOImpl.createContentData(AbstractContentDataDAOImpl.java:162)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addValueToPersistedProperties(HibernateNodeDaoServiceImpl.java:4975)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addNodePropertyImpl(HibernateNodeDaoServiceImpl.java:1474)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.addNodeProperty(HibernateNodeDaoServiceImpl.java:1513)
   at sun.reflect.GeneratedMethodAccessor546.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:419)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy163.addNodeProperty(Unknown Source)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.setPropertyImpl(DbNodeServiceImpl.java:1455)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.setProperty(DbNodeServiceImpl.java:1419)
   at sun.reflect.GeneratedMethodAccessor510.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy165.setProperty(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor510.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy166.setProperty(Unknown Source)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:255)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:266)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:266)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy165.setProperty(Unknown Source)
   at org.alfresco.repo.content.ContentServiceImpl$WriteStreamListener.contentStreamClosed(ContentServiceImpl.java:638)
   … 95 more
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:  
— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed). 
— Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)
   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:393)
   at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
   at org.springframework.orm.ibatis.SqlMapClientTemplate$9.doInSqlMapClient(SqlMapClientTemplate.java:370)
   at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194)
   … 148 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The column name id is not valid.
   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerResultSet.findColumn(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getObject(Unknown Source)
   at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:116)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)
   at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)
   … 152 more
2010-01-07 11:44:44,187 ERROR [org.apache.catalina.core.StandardContext] (main) Error listenerStart
2010-01-07 11:44:44,187 ERROR [org.apache.catalina.core.StandardContext] (main) Context [/alfresco] startup failed due to previous errors
2010-01-07 11:44:44,265 INFO  [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/alfresco]] (main) Closing Spring root WebApplicationContext
2010-01-07 11:44:44,265 INFO  [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/alfresco]] (main) Shutting down Log4J
2010-01-07 11:44:44,281 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.web.deployment:war=/alfresco state=Create mode=Manual requiredState=Installed
org.jboss.deployers.spi.DeploymentException: URL file:/C:/jboss/jboss-5.0.1.GA/server/default/deploy/alfresco.war/ deployment failed
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:333)
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:144)
   at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
   at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
   at org.jboss.web.deployers.WebModule.start(WebModule.java:97)
   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:597)
   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
   at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
   at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
   at $Proxy36.start(Unknown Source)
   at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
   at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
   at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
   at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
   at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
   at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
   at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
   at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
   at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
   at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
   at org.jboss.system.ServiceController.start(ServiceController.java:460)
   at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
   at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
   at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
   at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
   at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
   at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
   at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
   at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
   at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
   at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)
   at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)
   at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)
   at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)
   at org.jboss.Main.boot(Main.java:209)
   at org.jboss.Main$1.run(Main.java:547)
   at java.lang.Thread.run(Thread.java:619)
2010-01-07 11:44:44,296 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Real: name=vfsfile:/C:/jboss/jboss-5.0.1.GA/server/default/deploy/alfresco.war/ state=PreReal mode=Manual requiredState=Real
org.jboss.deployers.spi.DeploymentException: URL file:/C:/jboss/jboss-5.0.1.GA/server/default/deploy/alfresco.war/ deployment failed
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:333)
   at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:144)
   at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
   at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
   at org.jboss.web.deployers.WebModule.start(WebModule.java:97)
   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:597)
   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
   at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
   at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
   at $Proxy36.start(Unknown Source)
   at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
   at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
   at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
   at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
   at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
   at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
   at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
   at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
   at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
   at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
   at org.jboss.system.ServiceController.start(ServiceController.java:460)
   at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
   at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
   at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
   at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
   at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
   at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
   at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
   at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
   at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
   at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
   at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
   at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
   at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)
   at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)
   at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)
   at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)
   at org.jboss.Main.boot(Main.java:209)
   at org.jboss.Main$1.run(Main.java:547)
   at java.lang.Thread.run(Thread.java:619)
2010-01-07 11:44:44,734 INFO  [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/jmx-console
2010-01-07 11:44:45,031 ERROR [org.jboss.system.server.profileservice.ProfileServiceBootstrap] (main) Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

DEPLOYMENTS IN ERROR:
  Deployment "vfsfile:/C:/jboss/jboss-5.0.1.GA/server/default/deploy/alfresco.war/" is in error due to the following reason(s): org.jboss.deployers.spi.DeploymentException: URL file:/C:/jboss/jboss-5.0.1.GA/server/default/deploy/alfresco.war/ deployment failed

[mrogers]

You need to contact Alfresco support.    I suspect the first thing they will do is to check exactly which version you have, since you probably have some sort of pre-release.

[homeshoolin]

I am getting the exact same error.  Trying to set up Alfresco 3.2 Enterprise Edition on Windows server 2003 with Tomcat and MS SQL Server 2005.  Alfresco was downloaded with the license this week, so I do not believe it is a prerelease or anything.

I think that this snippet may be key:

— The error occurred in alfresco/ibatis/#resource.dialect#/content-common-SqlMap.xml. 
— The error occurred while applying a parameter map. 
— Check the alfresco.content.parameter_ContentUrl. 
— Check the statement (update failed)

and am looking to see what can be wrong with this section of content-common-SqlMap.xml:

<parameterMap id="parameter_ContentUrl" class="ContentUrl">
        <parameter property="contentUrl" jdbcType="VARCHAR" javaType="java.lang.String"/>
        <parameter property="contentUrlShort" jdbcType="VARCHAR" javaType="java.lang.String"/>
        <parameter property="contentUrlCrc" jdbcType="BIGINT" javaType="java.lang.Long"/>
        <parameter property="size" jdbcType="BIGINT" javaType="java.lang.Long"/>
        <parameter property="orphanTime" jdbcType="BIGINT" javaType="java.lang.Long"/>
    </parameterMap>

any thoughts?

[bramthielemans]

I also had this problem, but got an Alfresco running on a MS SQL Server 2005 database today by using the jtds driver instead of sqljdbc4. Download it from http://jtds.sourceforge.net/

Then change your db.driver and db.url properties:

db.driver=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sqlserver://${db.host}:${db.port}/${db.name}

[homeshoolin]

Thanks for the reply!

I tried the driver you mentioned but had the same result.  Were there any other things that you changed or did you just add the jar file to the lib dir and update the alfresco-global.properties file?

[bramthielemans]

Does the log still mention the com.microsoft driver? If so, remove sqljdbc4.jar from tomcat/lib. You can also try to disable the db.txn.isolation property.

Some JIRA links:
http://issues.alfresco.com/jira/browse/ETHREEOH-3252
https://issues.alfresco.com/jira/browse/ETHREEOH-3992

[sibe]

HAVE YOU FOUND THE SOLUTION FOR THIS PROBLEM ?
i have the same problem

THANK

[dward]

The error suggests a column is missing that should be there. This suggests an upgrade error.

Were you upgrading your database from a previous version? If so what version?

What do you see for version.build in $TOMCAT_HOME/webapps/alfresco/WEB-INF/classes/alfresco/version.properties?

And if you are an enterprise customer, why haven't you logged this with Alfresco support?

[sibe]

There is the version.properties file  in TOMCAT_HOME\webapps\classes\alfresco

#
# Alfresco version information
#

# Version label

version.major=3
version.minor=2
version.revision=0
version.label=

# Edition label

version.edition=Enterprise

# Build number

version.build=304

# Schema number

version.schema=3400‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Sorry I have not seen that I was logged as support.
I have found the solution of this problem

thank

[sibe]

Please have you a problem for this problem.
Alfesco enterprise 3.2 run with mysql but not with sql server 2005