Migration Error

We have had TeamCity setup with the default file system based database for evaluation and are now interested in using SQL 2008 as the backend.  

I keep getting a critical error part of the way through the migration.  It's getting an index out of bounds exception.  I have no idea how to proceed.

This is using TeamCity 4.5. Here is what I've got.  Any ideas?

Migration Properties

targetDriver=net.sourceforge.jtds.jdbc.Driver
targetURL=jdbc:jtds:sqlserver://serverName:1433/TeamCity
targetUser=teamcity
targetPassword=teamcity
forceClean=true



Partial Log

[2009-08-31 15:24:08,263]   INFO [           main] -     jetbrains.buildServer.dbmt - Exporting table: default_build_parameters, rows number: 0
[2009-08-31 15:24:08,263]   INFO [           main] -     jetbrains.buildServer.dbmt - Exporting table: deleted_build_types, rows number: 0
[2009-08-31 15:24:08,279]   INFO [           main] -     jetbrains.buildServer.dbmt - Exporting table: downloaded_artifacts, rows number: 0
[2009-08-31 15:24:08,279]   INFO [           main] -     jetbrains.buildServer.dbmt - Exporting table: failed_tests_output, rows number: 0
[2009-08-31 15:24:08,295]  ERROR [           main] -     jetbrains.buildServer.dbmt - Failed to export source database

[2009-08-31 15:24:08,310]  DEBUG [           main] -     jetbrains.buildServer.dbmt - org.dbunit.dataset.DataSetException: java.sql.SQLException: S1000 General error java.lang.ArrayIndexOutOfBoundsException: 5
org.dbunit.dataset.DataSetException: java.sql.SQLException: S1000 General error java.lang.ArrayIndexOutOfBoundsException: 5
 at org.dbunit.database.DatabaseDataSet.getTable(DatabaseDataSet.java:316)
 at org.dbunit.database.DatabaseTableIterator.getTable(DatabaseTableIterator.java:89)
 at org.dbunit.dataset.filter.AbstractTableFilter$FilterIterator.getTable(AbstractTableFilter.java:141)
 at org.dbunit.dataset.stream.DataSetProducerAdapter.produce(DataSetProducerAdapter.java:83)
 at org.dbunit.dataset.csv.CsvDataSetWriter.write(CsvDataSetWriter.java:87)
 at jetbrains.buildServer.serverSide.DBMTool.exportSourceDatabase(DBMTool.java:283)
 at jetbrains.buildServer.serverSide.DBMTool.main(DBMTool.java:154)
Caused by: java.sql.SQLException: S1000 General error java.lang.ArrayIndexOutOfBoundsException: 5
 at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
 at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
 at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
 at org.dbunit.database.AbstractResultSetTable.<init>(AbstractResultSetTable.java:110)
 at org.dbunit.database.ForwardOnlyResultSetTable.<init>(ForwardOnlyResultSetTable.java:59)
 at org.dbunit.database.ForwardOnlyResultSetTableFactory.createTable(ForwardOnlyResultSetTableFactory.java:62)
 at org.dbunit.database.DatabaseDataSet.getTable(DatabaseDataSet.java:312)
 ... 6 more
[2009-08-31 15:24:08,310]   INFO [           main] -     jetbrains.buildServer.dbmt - Closing source database connection...
[2009-08-31 15:24:08,310]   INFO [           main] -     jetbrains.buildServer.dbmt - Closing connection...
[2009-08-31 15:24:08,685]   INFO [           main] -     jetbrains.buildServer.dbmt - Closing target database connection...
[2009-08-31 15:24:08,701]   INFO [           main] -     jetbrains.buildServer.dbmt - Done.

4 comments
Comment actions Permalink

Jesse,

TeamCity 4.5 doesn't support MS SQL 2008.
There is an issue TW-6482 (http://www.jetbrains.net/tracker/issue/TW-6482) to support this DBMS, you can watch/vote for it.

0
Comment actions Permalink

Hi!

FYI, even if TeamCity 4.5 doesn't support MS SQL 2008, I've installed it and I noticed no problem yet.

Regards,

Olivier.

0
Comment actions Permalink

Oliver,

Did you migrate from the internal database?  If so, did you do anything special?  I don't doubt TeamCity will work on SQL2008, I just can't get it to migrate from the internal storage.

0
Comment actions Permalink

Just after TeamCity was installed on the internal database I've switched to SQL Server 2008.
It's note really a migration as there were neither projects nor build configuration set.

Olivier.

0

Please sign in to leave a comment.