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

CQ Connector - Outgoing CQ Record Creation Not Working

Hi,

I have successfully enabled incoming sync between our current production CQ database and Jazz (RTC)....everything is fine as long as CQ record is first created and then sync'ed into RTC - incoming/outgoing synchronization is fine as long as this is the case.

However, when I create a Work Item in RTC and expect that Work Item to be created as a Record in CQ, I am running into problems, specifically that RTC is not selecting the correct Record ID in CQ during the outgoing sync attempt. Each time I create a new Work Item, RTC simply attempts to modify an existing CQ record (e.g 'Work Item #40' is attempting to edit 'CQ Record DBNAME000040' instead of creating the next logical CQ record number) and I end up with a conflict between the new data and the original data in the existing (and different) CQ record.

In my property mapping for my work item sync rule, I have Id (item type) mapped to id (external type), with the external identifier flag set. In/Out is also selected.

Could somebody please point me in the direction of where I'm going wrong? Is this even possible? The help documentation says "The creation and modification changes also flow from work items to ClearQuest records. " so I presume it is.............I had intended to somewhat integrate our testing and development function using RQM and RTC based on this premise and now I'm at a loss.

Any help/suggestions would be much obliged and appreciated.

Peter............

0 votes



3 answers

Permanent link
Never mind........looked at the sample........maybe if it wasn't 3am I might have thought of that sooner :D

0 votes


Permanent link
Hi Peter,

I spent some hours on this topic. The CQ_Connector package is provided with some sample sync rules you can import from the sync rule view as an example.
Don't map ID on ID !
You need to create a cqid attribute in the jazz schema and jazzid attribute in the cq schema. And map the CQ primary key (you must specify it in the rule) on jazzid and jazz primary key on cqid. The sample rule defect does it.
The sync status view is helpful to analyze issues.
Hope this help
Good luck
Bernard

Hi,

I have successfully enabled incoming sync between our current production CQ database and Jazz (RTC)....everything is fine as long as CQ record is first created and then sync'ed into RTC - incoming/outgoing synchronization is fine as long as this is the case.

However, when I create a Work Item in RTC and expect that Work Item to be created as a Record in CQ, I am running into problems, specifically that RTC is not selecting the correct Record ID in CQ during the outgoing sync attempt. Each time I create a new Work Item, RTC simply attempts to modify an existing CQ record (e.g 'Work Item #40' is attempting to edit 'CQ Record DBNAME000040' instead of creating the next logical CQ record number) and I end up with a conflict between the new data and the original data in the existing (and different) CQ record.

In my property mapping for my work item sync rule, I have Id (item type) mapped to id (external type), with the external identifier flag set. In/Out is also selected.

Could somebody please point me in the direction of where I'm going wrong? Is this even possible? The help documentation says "The creation and modification changes also flow from work items to ClearQuest records. " so I presume it is.............I had intended to somewhat integrate our testing and development function using RQM and RTC based on this premise and now I'm at a loss.

Any help/suggestions would be much obliged and appreciated.

Peter............

0 votes


Permanent link
OK, forget my reply. It's too late . Bernard.
Hi,

I have successfully enabled incoming sync between our current production CQ database and Jazz (RTC)....everything is fine as long as CQ record is first created and then sync'ed into RTC - incoming/outgoing synchronization is fine as long as this is the case.

However, when I create a Work Item in RTC and expect that Work Item to be created as a Record in CQ, I am running into problems, specifically that RTC is not selecting the correct Record ID in CQ during the outgoing sync attempt. Each time I create a new Work Item, RTC simply attempts to modify an existing CQ record (e.g 'Work Item #40' is attempting to edit 'CQ Record DBNAME000040' instead of creating the next logical CQ record number) and I end up with a conflict between the new data and the original data in the existing (and different) CQ record.

In my property mapping for my work item sync rule, I have Id (item type) mapped to id (external type), with the external identifier flag set. In/Out is also selected.

Could somebody please point me in the direction of where I'm going wrong? Is this even possible? The help documentation says "The creation and modification changes also flow from work items to ClearQuest records. " so I presume it is.............I had intended to somewhat integrate our testing and development function using RQM and RTC based on this premise and now I'm at a loss.

Any help/suggestions would be much obliged and appreciated.

Peter............

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: Nov 26 '08, 9:40 p.m.

Question was seen: 4,391 times

Last updated: Nov 26 '08, 9:40 p.m.

Confirmation Cancel Confirm