SQL 2000 working SQL 2005 not working

[pepperking]

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.

[steve]

Hi,

can you post the first few errors?

Steve

[pepperking]

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.

[janv]

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