topic Re: Installation Errors w/ SQL Server in Alfresco Archive

Installation Errors w/ SQL Server

doug — Wed, 01 Mar 2006 05:32:50 GMT

Hi, I'm hoping someone can help me…I verify that it connects and creates the tables on the database, but it won't start the Alfresco service.Here's my hibernate-cfg.properties:[size=75]## Hibernate configuration#hibernate.jdbc.use_streams_for_binary=truehibernate.dialect=org.hibernate.dialect.SQLSer

Re: Installation Errors w/ SQL Server

gavinc — Wed, 01 Mar 2006 09:15:08 GMT

I noticed the followling line in the stack trace:

Caused by: org.alfresco.repo.search.SearcherException: More than one root node in index: 2

This usually indicates that you have more than one set of index files or they are not in sync with the database.

The best thing to do is point the alf_data directory outside the bundle (rather than the relative path it has by default).

In your repository.properties file you should also have something like:

dir.root=c:\alf_data

See the repository configuration wiki page for more info: http://www.alfresco.org/mediawiki/index.php/Repository_Configuration

Re: Installation Errors w/ SQL Server

doug — Thu, 02 Mar 2006 01:57:24 GMT

Thanks gavinc, that did it! I was working on migrating from mysql to mssql. In fact, I've even got this to work with sql 2005 now. Only with the jDTS driver. The ms jdbc driver for 2005 doesn't work, I think it has to do with hibernate support.

Thanks for the rapid response and a correct response that provided the resolution!!!