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

ClearQuest Connector Outgoing Sync Error (CQ "users&quo

Hi Everyone,

I am new to Rational Team Concert and wanted to ask if anyone has any ideas that can solve my configuration problem.

When I create a record in CQ, a new corresponding work item is created in RTC, which is great.

I also have a ClearCase Connector configured which works fine. When I create/modify a file in ClearCase, a file is created in RTC source control and vice versa.

However, when I modify a work item e.g. changing the state of a defect, an outgoing sync to CQ defect record is blocked by another outgoing sync to CQ users record that reports an error.

The error in the synchronization status window says java.net.ConnectException: Connection Refused, and refers me to the synchronization rule for the CQ users record.

I can see in the Current State section of the same synchronization status window that the Item Properties to be synced out (i.e. EmailAddress, Name, UserId) all have values, but the corresponding CQ External Properties do not (i.e. email, fullname, login_name).

My CQ Connection port is set to 8085 in both server.xml and in the External Repository Connection, and I have verified it is running by navigating to the CQ Connector status page at http://localhost:8085/cqconnector/gateway.

I have also ensured that the user associated with the work item is present in CQ User Management and in Jazz Team Server with identical information.

This has been baffling me for some time so any help would be greatly appreciated! If you need a screenshot please let me know and I'll post one up.

Many thanks in advance,
Darren

0 votes



7 answers

Permanent link
Are you using localhost in the external repository connection? That would only work if the CQ gateway and Jazz server are running on the same machine. Otherwise, please use the actual host name of the CQ gateway.

0 votes


Permanent link
Hi Lorelei,

Thanks for the very helpful tip! I used the full hostname with domain and the outgoing sync seems to be doing a bit more now :-) The fields in CQ even show up in the synchronization rules editor where they previously didn't.

However, the sync is not fully working yet as the original error has been replaced by a different one (though I think it is a separate issue). It reads:

CRVSV0134E (property-not-requested): 'display-name' The value for property 'display-name' is not in this proxy; it has not been set by the client not requested from the server

I hope you can help with this new error. And thank you once again for your help so far :-)

Thank you,
Darren

0 votes


Permanent link
Can you provide us the sync rule that has this problem? I'm assuming it's the one you are mapping to the Jazz work item.

0 votes


Permanent link
Hi Lorelei,

I have a suspicion that the error is something to do with the VOBs or views used for the setup, as we have a UCM configuration here between CQ and ClearCase.

Here is the sync rule in XML format as requested:

<xml><syncRule>
<name>com.ibm.rational.clearquest.SIR.CCCQProject</name>
<externalTypeName>com.ibm.rational.clearquest.SIR</externalTypeName>
<syncItemTypeName>WorkItem</syncItemTypeName>
<syncItemTypeNsURI>com.ibm.team.workitem</syncItemTypeNsURI>
<syncItemTypeQualifier>Type:sir</syncItemTypeQualifier>
<itemManager>com.ibm.team.interop.service.managers.workitem.WorkItemManager</itemManager>
<externalManager>com.ibm.team.interop.service.managers.clearquest.CQExternalManager</externalManager>
<maxCycleCount>1</maxCycleCount>
<syncAllItemStates>true</syncAllItemStates>
<propertyMappings>
<propertyMapping>
<externalPropertyName>Headline</externalPropertyName>
<itemPropertyName>Summary</itemPropertyName>
<incoming>true</incoming>
<outgoing>true</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
<propertyMapping>
<externalPropertyName>Dummy</externalPropertyName>
<itemPropertyName>Category</itemPropertyName>
<incoming>true</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
<transformExtension>com.ibm.team.interop.service.managers.workitem.CategoryValueTransformer</transformExtension>
<valueMappings>
<valueMapping>
<externalValue></externalValue>
<itemValue>RTC_TEST2</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
</valueMappings>
</propertyMapping>
<propertyMapping>
<externalPropertyName>record_type</externalPropertyName>
<itemPropertyName>Type</itemPropertyName>
<incoming>true</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
<valueMappings>
<valueMapping>
<externalValue>SIR</externalValue>
<itemValue>sir</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
</valueMappings>
</propertyMapping>
<propertyMapping>
<externalPropertyName>Description</externalPropertyName>
<itemPropertyName>Description</itemPropertyName>
<incoming>true</incoming>
<outgoing>true</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
<propertyMapping>
<externalPropertyName>State</externalPropertyName>
<itemPropertyName>State</itemPropertyName>
<incoming>true</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
<valueMappings>
<valueMapping>
<externalValue>Closed</externalValue>
<itemValue>Closed</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
<valueMapping>
<externalValue>Submitted</externalValue>
<itemValue>New</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
</valueMappings>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>Blocks</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>Children</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>Comments</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>CreationDate</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>Creator</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>DependsOn</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>DueDate</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>JazzWorkFlowAction</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties>
<itemPropertyName>State</itemPropertyName>
</requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
<transformExtension>com.ibm.team.interop.service.managers.workitem.WorkflowActionValueTransformer</transformExtension>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>Related</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>Resolution</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
<valueMappings>
<valueMapping>
<externalValue></externalValue>
<itemValue>Duplicate</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
<valueMapping>
<externalValue></externalValue>
<itemValue>Fixed Upstream</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
<valueMapping>
<externalValue></externalValue>
<itemValue>Fixed</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
<valueMapping>
<externalValue></externalValue>
<itemValue>Works as Designed</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
<valueMapping>
<externalValue></externalValue>
<itemValue>Invalid</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
<valueMapping>
<externalValue></externalValue>
<itemValue>Works for Me</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
<valueMapping>
<externalValue></externalValue>
<itemValue>Unresolved</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
<valueMapping>
<externalValue></externalValue>
<itemValue>Remind</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
<valueMapping>
<externalValue></externalValue>
<itemValue>Later</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
</valueMappings>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>Tags</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>Target</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
<valueMappings>
<valueMapping>
<externalValue></externalValue>
<itemValue>1.0</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
<valueMapping>
<externalValue></externalValue>
<itemValue>M1</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
</valueMappings>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>Version</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
<valueMappings>
<valueMapping>
<externalValue></externalValue>
<itemValue>Test</itemValue>
<defaultExternalValue>false</defaultExternalValue>
<defaultItemValue>false</defaultItemValue>
</valueMapping>
</valueMappings>
</propertyMapping>
<propertyMapping>
<externalPropertyName></externalPropertyName>
<itemPropertyName>Id</itemPropertyName>
<incoming>false</incoming>
<outgoing>false</outgoing>
<itemIdentifier>false</itemIdentifier>
<externalIdentifier>false</externalIdentifier>
<externalModifier>false</externalModifier>
<requiredItemProperties></requiredItemProperties>
<requiredExternalProperties></requiredExternalProperties>
</propertyMapping>
</propertyMappings>
</syncRule>

Thanks for your help,
Darren

0 votes


Permanent link
Could you see if there is any stack trace information in the sync status or in the cqgateway log?

Rich Piazza
CQ Connector team

0 votes


Permanent link
Hi Rich,

Unfortunately, there is nothing in the cqgateway log under the tomcat/logs directory. There is also no exception or error information on the CQ Gateway status page below the Polling Information section. I hope I am looking in the right areas!

Many Thanks,
Darren

0 votes


Permanent link
Hi Rich,

I just wanted to let you know I have managed to solve the issue. The view that the CC connector used did not have the correct permissions for the ccsync user.

Outgoing sync is now working fine and changes in RTC are now reflected in CQ.

Thanks,
Darren

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: Feb 22 '10, 7:06 a.m.

Question was seen: 7,897 times

Last updated: Feb 22 '10, 7:06 a.m.

Confirmation Cancel Confirm