Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Derby db export will not import into DB2 db

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)

0 votes



2 answers

Permanent link
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)

0 votes


Permanent link
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)

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Aug 20 '08, 4:17 p.m.

Question was seen: 4,022 times

Last updated: Aug 20 '08, 4:17 p.m.

Confirmation Cancel Confirm