If spent the afteernoon trying to upgrade to 5.0 and SQL Server as database. As I was unable to get it working, I've upgraded to version 4.5 and switched from file to using SQL Server 2005 and that seems to be working fine.
Trying to upgrade further from the working 4.5 to 5.0 still fails. I can not get TeamCity to start up. I get the following error in the teamcity-server.log:
[2009-12-21 16:22:23,210] INFO - rverSide.db.TeamCityDataSource - Using the following database settings:
database type: MSSQL2005
database driver: net.sourceforge.jtds.jdbc.Driver
login as: sa
[2009-12-21 16:22:23,522] INFO - jetbrains.buildServer.SERVER - TeamCity configuration version is 343
[2009-12-21 16:22:23,569] INFO - jetbrains.buildServer.SERVER - Configuration version: 280, Database version: 0
[2009-12-21 16:22:24,053] INFO - jetbrains.buildServer.SERVER - Closing database connections.
[2009-12-21 16:22:24,116] ERROR - er.spring.WebDispatcherServlet - Context initialization failed
org.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Failed to import bean definitions from URL location [classpath*:/META-INF/plugin-model-shared-spring.xml]
Offending resource: URL [jar:file:/C:/TeamCity/webapps/ROOT/WEB-INF/lib/server.jar!/META-INF/buildServerPluginsSupport.xml]; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Unexpected exception parsing XML document from URL [jar:file:/C:/TeamCity/webapps/ROOT/WEB-INF/lib/common-impl.jar!/META-INF/plugin-model-shared-spring.xml]; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader]: Constructor threw exception; nested exception is java.lang.NullPointerException
......... (see teamcity-server.log)
I can't find any way to upgrade the database and no instructions on how to do this, only to migrate from one database to another. I've tried to migrate from one database to another on sql server, but the TeamCity says the 4.5-database is corrupt or empy ( I think thta was the message). The user running the installation and the service has db_owner access to the database. Found other posts on upgrading problem referring to a db_version table but there is none in my database so I suspect the database is too old and for some reason TeamCitty is unable to upgrade the database.
How can I upgrade from 4.5 to 5.0 when I'm using SQL Server 2005?
Attaching some of the logs.