repotools export/import

I have recently attempted to migrate a repository from one server to another via repo tools, and received the error below.

This was done via repotools -export and then -import. Should I be using copy? I created a new blank DB2 DB for the import

2008-11-03 14:07:41,147 repotools -import fromFIle=C:\software\Project backup\13082008.tar
2008-11-03 14:07:41,147 Repo Tools, Version 1.0 - I20080618-1642
2008-11-03 14:07:41,147 Provisioning using "C:\Program Files\IBM\ProjectJazzTeamServer\server\\provision_profiles".
2008-11-03 14:07:53,491 Rational Jazz Team Server - Standard (60 day trial)
2008-11-03 14:07:53,491 Loading configuration from "file:teamserver.properties".
2008-11-03 14:07:55,210 Fulltext Index Location: workitemindex\fulltext_index\
2008-11-03 14:07:56,726 Initial database connection successful
Db Product Name: DB2/NT
Db Product Version: SQL09051
Db Name/Location: //localhost:50000/JAZZALN:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;
2008-11-03 14:08:09,367 Creating the tables for the database "//localhost:50000/JAZZALN:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;" without indices.
2008-11-03 14:08:37,901 The database tables were created successfully.
2008-11-03 14:08:37,979 The user "ADMIN" has logged in to the database "//localhost:50000/JAZZALN:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;".
2008-11-03 14:08:37,979 Importing the data from the file "C:\software\Project backup\13082008.tar" into the database "//localhost:50000/JAZZALN:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;".
2008-11-03 14:08:37,995
Reading the TAR file C:\software\Project backup\13082008.tar...
2008-11-03 14:08:38,448 Finished reading the TAR file "C:\software\Project backup\13082008.tar" in 453 ms.
2008-11-03 14:08:38,448 Importing contents from C:\software\Project backup\13082008.tar into the repository.
2008-11-03 14:08:39,073
Imported 0 items, 0 item states in 625 ms. 0 item states skipped. Error importing 0 elements.
2008-11-03 14:08:39,073
2008-11-03 14:08:39,073
2008-11-03 14:08:39,073 ##############################################################################################
2008-11-03 14:08:39,073 ****** Migration Errors ******
2008-11-03 14:08:39,073 CRJAZ0656I **ERROR** Migration completed with errors. The imported database is in an inconsistent state and should not be used without further analysis.
Check the migration log "C:\Program Files\IBM\ProjectJazzTeamServer\server\repotools_import.log" for details.
2008-11-03 14:08:39,089 ##############################################################################################
2008-11-03 14:08:39,089 The user "ADMIN" has logged out of the database "//localhost:50000/JAZZALN:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;".
2008-11-03 14:08:39,089 java.lang.NullPointerException
java.lang.RuntimeException: java.lang.NullPointerException
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerify(AbstractMigrationService.java:664)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy317.importRepositoryOptionalVerify(Unknown Source)
at com.ibm.team.repotools.rcp.internal.command.ImportCommand.importData(ImportCommand.java:130)
at com.ibm.team.repotools.rcp.internal.command.ImportCommand.execute(ImportCommand.java:97)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:167)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:616)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:673)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
at org.eclipse.equinox.launcher.Main.run(Main.java:1173)
at org.eclipse.equinox.launcher.Main.main(Main.java:1148)
Caused by:
java.lang.NullPointerException
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.isItemCreatedDuringDBInitialization(AbstractMigrationService.java:949)
at com.ibm.team.repository.migration.internal.service.MigrationService.importItem(MigrationService.java:678)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importData(AbstractMigrationService.java:747)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerify(AbstractMigrationService.java:628)
... 26 more

What version of the server were you running previously. What version of repotools did you use to export the data in the database ?

It looks like the tar file is not well formed. Were you using a very old version of repotools to export the data.

--- Balaji
Jazz Server Team

Both versions of the server and repotools are 1.0 related.

What version of the server were you running previously. What version of repotools did you use to export the data in the database ?

It looks like the tar file is not well formed. Were you using a very old version of repotools to export the data.

--- Balaji
Jazz Server Team

This is a DB2 to DB2 migration on version 1.0.0.

The migration is being done via a Windows machine, below is an output of some of the contents of the tar:

11/03/2008 10:55 AM <DIR> .
11/03/2008 10:55 AM <DIR> ..
06/25/2008 06:28 AM 36 ftp-script.cmd
11/03/2008 10:58 AM <DIR> repository-backup
08/13/2008 04:50 PM 195,297,792 repository-backup.tar
11/03/2008 10:52 AM <DIR> repotools
06/18/2008 10:43 AM 306 RTC-backup.cmd
06/25/2008 06:39 AM 1,909 RTC-file-backup.cmd
11/03/2008 10:52 AM <DIR> server
07/22/2008 04:35 AM 55 upload.scr
5 File(s) 195,300,098 bytes
5 Dir(s) 33,988,820,992 bytes free

The tar file generated by repotools -export should be used as an input to the repotools -import command.

Here, you are using a tar file that contains your script, backup tar etc. Use the tar generated by export to import the data into the new DB2 database.

--- Balaji
Jazz Server Team