topic SQL 2000 working SQL 2005 not working in Alfresco Archive

SQL 2000 working SQL 2005 not working

pepperking — Wed, 21 Nov 2007 21:53:55 GMT

Has anyone sucessfully got alfresco running on SQL 2005. We have it running on SQL 2000 fine.It stops on Deploying Web application archive alfresco.war for longer than it normally would and then comes up with a heap of alfresco errors.

Re: SQL 2000 working SQL 2005 not working

steve — Thu, 22 Nov 2007 13:12:27 GMT

Hi,

can you post the first few errors?

Steve

Re: SQL 2000 working SQL 2005 not working

pepperking — Fri, 23 Nov 2007 03:10:23 GMT

Hi Steve,

See below alfersco errors.

15:04:43,109 WARN [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
15:04:45,093 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.alfresco.error.AlfrescoRuntimeException: Failure during rollback: org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@a50a00
Caused by:
org.alfresco.error.AlfrescoRuntimeException: Failure during rollback: org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@a50a00
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:281)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)
   at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepositoryBootstrap.java:134)
   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)

I think it just cannot connect to the databae for some reason. Yet i have setup all exactly the same as the SQl 2000 environment.

Re: SQL 2000 working SQL 2005 not working

janv — Fri, 23 Nov 2007 10:25:45 GMT

Are you running 2.1 Community ? If so, then the exception(s) are masking the underlying DB exception. Refer to:
http://forums.alfresco.com/viewtopic.php?t=8877

Please double-check the DB connection from your Alfresco server and all DB settings.

We fixed the 'exception masking' issue in 2.1 Enterprise and in the HEAD code. If you try with a nightly build then you'll see the real exception, at least.

Thanks,
Jan