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

SqlSyntaxErrorException running the repotools-ccm -scmImportComponent command

I get this error trying to import components from another 7.0 ELM server using this command:

repotools-ccm -scmImportComponent adminPassword=********** adminUserId=clmadmin fromFile=C:\media\exportComponents.tar importContributors repositoryURL=https://mytargetserver:9443/ccm

Both servers are Windows 2016 with ELM 7.0 (no iFixes). The original server is DB2 11.1 and the second is DB2 11.5. Does that matter? Does everything have to align 100% the same?

2020-05-29 15:51:40,419 itemId=[UUID _STK0snNMEeqRLbDkSZV0Uw] stateId=[UUID _SVGuZ3NMEeqRLbDkSZV0Uw] nsURI=com.ibm.team.repository typeName=ContributorRecord
com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0314I ステートメント "Select ITEM_UUID From BLACKBOARD.DEFERRED_ITEMS Where ITEM_UUID = ? AND KEY_UUID = ?" のパラメーター番号 1 を設定中にエラーが発生しました
    at com.ibm.team.repository.service.TeamRepositoryExceptionHelper.wrapInternalException(TeamRepositoryExceptionHelper.java:109)
    at com.ibm.team.repository.service.internal.dataaccess.AbstractDocumentMediatorService.prepareQuery(AbstractDocumentMediatorService.java:93)
    at com.ibm.team.repository.migration.internal.blackboard.dataaccess.BlackboardMigrationMediatorService.isPresent(BlackboardMigrationMediatorService.java:636)

And the root cause is an SQL error:
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=BLACKBOARD.DEFERRED_ITEMS, DRIVER=4.26.14


I have tried this many times, but keep getting this error. Is this a defect?

0 votes

Comments

Has anyone used this command successfully in 7.0?


Be the first one to answer this question!

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: May 29 '20, 3:08 a.m.

Question was seen: 1,720 times

Last updated: Jun 01 '20, 1:02 a.m.

Confirmation Cancel Confirm