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 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 |
7 answers
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.
|
|
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: I hope you can help with this new error. And thank you once again for your help so far :-) Thank you, Darren |
|
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.
|
|
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 |
Could you see if there is any stack trace information in the sync status or in the cqgateway log?
Rich Piazza CQ Connector team |
|
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 |
|
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 |
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.