Error migrating HSQLDB to Oracle

I'm attempting to migrate my HSQLDB internal database over to an external Oracle database.  I'm using TeamCity Server 4.0.1 and Oracle 10.  The problem I'm having seems to be importing the data into Oracle.  Creating of tables in the new Oracle database seems to work.  The export from HSQLDB seems to work too.  Attached is the migration log.   In addition, I set the debug property in dbMigration.properties to true so the following call stack shows up on the console:


Error processing data
Caused by: null
Exception in thread "main" java.lang.NullPointerException
        at jetbrains.buildServer.serverSide.DBMTool.reportCriticalError(DBMTool.java:195)
        at jetbrains.buildServer.serverSide.DBMTool.main(DBMTool.java:117)
Critical error has occurred during migration.
Done.



 


Any ideas why the import is failing?  I have CREATE_TABLE rights to the Oracle database.



Attachment(s):
migration Mon Jun 22 15.22.48 EDT 2009.log
2 comments
Comment actions Permalink

Hi!

You may have something special in your "agent" table...

Did you have a look to? Maybe try to empty it after having made a dump by your own.

Regards,

Olivier.

0
Comment actions Permalink

I couldn't figure out why the import was failing, so I manually imported the .CSV files (all 52 of 'em, some empty) into the Oracle db.   That seemed to work, but I was disappointed that the migration scripts didn't work properly.

0

Please sign in to leave a comment.