It's all about the answers!

Ask a question

Derby db export will not import into DB2 db


Tim Feeney (30745745) | asked Aug 20 '08, 4:17 p.m.
JAZZ DEVELOPER
I have an export of a Derby db that I'm trying to import into a DB2 db. The import is failing with verification errors on some Build Result records because they reference a Build Definition that does not exist. From the client I can only see results for definitions that exist. How can I remove these old results?

Here's one instance of the failure flagged in the log:

2008-08-20 14:08:57,656 Verifying items present in the "com.ibm.team.build" component.
2008-08-20 14:08:57,859 CRJAZ1150I ** ERROR ** "com.ibm.team.build" component verification failed.
2008-08-20 14:08:57,875 CRJAZ1150I ** ERROR ** CRRTC3004E: BuildResult(_0cvwkhSyEdyNtYtqZakbiw) failed verification.
com.ibm.team.build.common.TeamBuildValidationException: BuildResult(_0cvwkhSyEdyNtYtqZakbiw) references BuildDefinition(_1Y-mwBSbEdyxLcmAEAfVcg) which does not exist.
at com.ibm.team.build.internal.service.AbstractTeamBuildService.validateRequiredExists(AbstractTeamBuildService.java:974)
at com.ibm.team.build.internal.service.AbstractTeamBuildService.doValidate(AbstractTeamBuildService.java:894)
at com.ibm.team.build.internal.service.AbstractTeamBuildService.validate(AbstractTeamBuildService.java:877)
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 $Proxy289.validate(Unknown Source)
at com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verifyPage(BuildMigrationVerifier.java:125)
at com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verifyItems(BuildMigrationVerifier.java:103)
at com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verifyComponent(BuildMigrationVerifier.java:81)
at com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verify(BuildMigrationVerifier.java:60)
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 $Proxy350.verify(Unknown Source)
at com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verifyComponent(RepositoryVerificationService.java:96)
at com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verify(RepositoryVerificationService.java:78)
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 $Proxy8.verify(Unknown Source)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.verifyRepository(AbstractMigrationService.java:1015)
at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerify(AbstractMigrationService.java:649)
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)

2 answers



permanent link
Don Weinand (7851) | answered Aug 20 '08, 4:50 p.m.
JAZZ DEVELOPER
Unfortunately there is no current way to eliminate them. Even at the API
level we require the build definition so that we can find the team area the
build is associated with so process permissions can be computed to determine
if the delete is allowed. Looks like you are missing the build definition
for some reason. We need to determine if these build results had been
orphaned long ago in which case it has no impact on you system or were they
orphaned as a result of the migration. I'll contact you directly so we can
try to assess that.

Don Weinand
Jazz Team Build


"tfeeney" <tfeeney> wrote in message
news:g8hu5k$27e$1@localhost.localdomain...
I have an export of a Derby db that I'm trying to import into a DB2
db. The import is failing with verification errors on some Build
Result records because they reference a Build Definition that does
not exist. From the client I can only see results for definitions
that exist. How can I remove these old results?

Here's one instance of the failure flagged in the log:

2008-08-20 14:08:57,656 Verifying items present in the
"com.ibm.team.build" component.
2008-08-20 14:08:57,859 CRJAZ1150I ** ERROR **
"com.ibm.team.build" component verification failed.
2008-08-20 14:08:57,875 CRJAZ1150I ** ERROR ** CRRTC3004E:
BuildResult(_0cvwkhSyEdyNtYtqZakbiw) failed verification.
com.ibm.team.build.common.TeamBuildValidationException:
BuildResult(_0cvwkhSyEdyNtYtqZakbiw) references
BuildDefinition(_1Y-mwBSbEdyxLcmAEAfVcg) which does not exist.
at
com.ibm.team.build.internal.service.AbstractTeamBuildService.validateRequiredExists(AbstractTeamBuildService.java:974)
at
com.ibm.team.build.internal.service.AbstractTeamBuildService.doValidate(AbstractTeamBuildService.java:894)
at
com.ibm.team.build.internal.service.AbstractTeamBuildService.validate(AbstractTeamBuildService.java:877)
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 $Proxy289.validate(Unknown Source)
at
com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verifyPage(BuildMigrationVerifier.java:125)
at
com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verifyItems(BuildMigrationVerifier.java:103)
at
com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verifyComponent(BuildMigrationVerifier.java:81)
at
com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verify(BuildMigrationVerifier.java:60)
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 $Proxy350.verify(Unknown Source)
at
com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verifyComponent(RepositoryVerificationService.java:96)
at
com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verify(RepositoryVerificationService.java:78)
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 $Proxy8.verify(Unknown Source)
at
com.ibm.team.repository.migration.internal.service.AbstractMigrationService.verifyRepository(AbstractMigrationService.java:1015)
at
com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerify(AbstractMigrationService.java:649)
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)

permanent link
Don Weinand (7851) | answered Aug 20 '08, 5:24 p.m.
JAZZ DEVELOPER
I created workitem 60055 for this and added you as a subscriber. Can you
please attach your export and import log to that defect for me?

Don Weinand
Jazz Team Build

"tfeeney" <tfeeney> wrote in message
news:g8hu5k$27e$1@localhost.localdomain...
I have an export of a Derby db that I'm trying to import into a DB2
db. The import is failing with verification errors on some Build
Result records because they reference a Build Definition that does
not exist. From the client I can only see results for definitions
that exist. How can I remove these old results?

Here's one instance of the failure flagged in the log:

2008-08-20 14:08:57,656 Verifying items present in the
"com.ibm.team.build" component.
2008-08-20 14:08:57,859 CRJAZ1150I ** ERROR **
"com.ibm.team.build" component verification failed.
2008-08-20 14:08:57,875 CRJAZ1150I ** ERROR ** CRRTC3004E:
BuildResult(_0cvwkhSyEdyNtYtqZakbiw) failed verification.
com.ibm.team.build.common.TeamBuildValidationException:
BuildResult(_0cvwkhSyEdyNtYtqZakbiw) references
BuildDefinition(_1Y-mwBSbEdyxLcmAEAfVcg) which does not exist.
at
com.ibm.team.build.internal.service.AbstractTeamBuildService.validateRequiredExists(AbstractTeamBuildService.java:974)
at
com.ibm.team.build.internal.service.AbstractTeamBuildService.doValidate(AbstractTeamBuildService.java:894)
at
com.ibm.team.build.internal.service.AbstractTeamBuildService.validate(AbstractTeamBuildService.java:877)
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 $Proxy289.validate(Unknown Source)
at
com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verifyPage(BuildMigrationVerifier.java:125)
at
com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verifyItems(BuildMigrationVerifier.java:103)
at
com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verifyComponent(BuildMigrationVerifier.java:81)
at
com.ibm.team.build.internal.service.migration.BuildMigrationVerifier.verify(BuildMigrationVerifier.java:60)
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 $Proxy350.verify(Unknown Source)
at
com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verifyComponent(RepositoryVerificationService.java:96)
at
com.ibm.team.repository.service.internal.verifiers.RepositoryVerificationService.verify(RepositoryVerificationService.java:78)
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 $Proxy8.verify(Unknown Source)
at
com.ibm.team.repository.migration.internal.service.AbstractMigrationService.verifyRepository(AbstractMigrationService.java:1015)
at
com.ibm.team.repository.migration.internal.service.AbstractMigrationService.importRepositoryOptionalVerify(AbstractMigrationService.java:649)
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)

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.