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.
Please sign in to leave a comment.
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.
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.
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.
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.