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

Error delivering a change set [RM]

Hi everyone, when deploying a change set, I get the following error. As additional information, I have run the module analyzer on both source modules and target modules and no one has errors.


ID CRRRW7780E  An error occurred during the operation. The following message might include more information about the problem.
Propagated exception; original message [BadRequestException: Propagated exception; original message [BadRequestException: SQL usage to push change set to stream ->{ insert into REPOSITORY.VERSION select distinct V.ITEM_ID, V.STATE_ID, ?, V.IS_CURRENT, ?, V.PREV_CONFIG_ID, V.CHANGE_SET_ID, ?, V.CURRENT_UUID, V.IGNORED, V.INTERNAL, V.ITEM_TYPE_DBID from REPOSITORY.VERSION V where V.CONFIG_ID=? and ( ( V.IS_CURRENT=1 and not exists ( select 1 from REPOSITORY.VERSION W where W.CONFIG_ID=? and W.ITEM_ID=V.ITEM_ID and W.ITEM_TYPE_DBID=V.ITEM_TYPE_DBID and W.IS_CURRENT=1 ) ) or ( exists ( select 1 from REPOSITORY.VERSION U where U.CONFIG_ID=? and U.CURRENT_UUID=? and U.ITEM_ID=V.ITEM_ID and U.ITEM_TYPE_DBID=V.ITEM_TYPE_DBID and ( ( V.IS_CURRENT=1 and U.STATE_ID!=V.STATE_ID ) or ( V.IS_CURRENT=2 and V.CREATED = ( select max( X.CREATED ) from REPOSITORY.VERSION X where (X.CONFIG_ID=? and X.ITEM_ID=V.ITEM_ID and X.ITEM_TYPE_DBID=V.ITEM_TYPE_DBID and X.IS_CURRENT=2) ) ) ) ) ) ) }

0 votes


Accepted answer

Permanent link

Please open a case with support.

Eduardo Pérez Soto selected this answer as the correct answer

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: Jan 12 '22, 2:34 a.m.

Question was seen: 778 times

Last updated: Jan 12 '22, 2:38 a.m.

Related questions
Confirmation Cancel Confirm