CQ Gateway events being ignored
I am using the CQ Connector to sync defects from CQ to RTC. Each time I open a defect in CQ, the gateway acknowledges the event and then ignores it. I have the gateway log set to debug but the only error I see is the following: CRRTC4500W: Warning - unable to determine if JazzConnector tables are present in the CQ user database
This configuration has worked previously but now seems to be ignoring all events. The defects do not show up in RTC as incoming syncs. Gateway log: 06 Nov 2008 10:26:50,063 INFO com.ibm.rational.interop.level1 - CRRTC4500W: Warning - unable to determine if JazzConnector tables are present in the CQ user database 06 Nov 2008 10:26:50,064 DEBUG com.ibm.rational.interop.level2 - Releasing CQInteropEventHandler-7.0.0/dSTGC-CQ Interop Polling 06 Nov 2008 10:26:50,064 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-7.0.0/dSTGC-CQ Interop Polling 06 Nov 2008 10:26:56,306 DEBUG com.ibm.rational.interop.level2 - Releasing CQInteropEventHandler-7.0.0/dSTGC-CQ Interop Polling 06 Nov 2008 10:26:56,310 INFO com.ibm.rational.interop.level1 - CRRTC4541I: CQ Event Polling has been started 06 Nov 2008 10:26:56,310 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-7.0.0/dSTGC-CQ Interop Polling 06 Nov 2008 10:26:56,350 DEBUG com.ibm.rational.interop.level2 - Releasing CQInteropEventHandler-7.0.0/dSTGC-CQ Interop Polling 06 Nov 2008 10:26:56,351 DEBUG com.ibm.rational.interop.level2 - Number of change history records read: 1 06 Nov 2008 10:26:56,365 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for 7.0.0/dSTGC login: cqcon 06 Nov 2008 10:26:57,190 DEBUG com.ibm.rational.interop.level1 - Retrieving users with login_name = cqcon using TeamAPI 06 Nov 2008 10:26:58,559 DEBUG com.ibm.rational.interop.level1 - Retrieved CQ:cq.repo.cq-record:users/33870075@7.0.0/dSTGC using TeamAPI 06 Nov 2008 10:26:58,559 DEBUG com.ibm.rational.interop.level2 - Releasing CQInteropEventHandler-7.0.0/dSTGC-new 06 Nov 2008 10:26:58,835 INFO com.ibm.rational.interop.level1 - CQ CREATE OCCURRED - dbid: 33566444 version: 1 type Defect 06 Nov 2008 10:26:58,835 DEBUG com.ibm.rational.interop.level2 - Number of change records to process: 1 06 Nov 2008 10:26:58,867 DEBUG com.ibm.rational.interop.level2 - wait for process finishing 1 06 Nov 2008 10:26:58,869 DEBUG com.ibm.rational.interop.level1 - Creating Defect using Jazz Interop Client 06 Nov 2008 10:26:58,933 DEBUG com.ibm.rational.interop.level2 - Processor finished 06 Nov 2008 10:26:58,934 DEBUG com.ibm.rational.interop.level2 - Number of change history records read: 1 06 Nov 2008 10:26:58,934 DEBUG com.ibm.rational.interop.level2 - Number of records processed:0 06 Nov 2008 10:26:58,934 DEBUG com.ibm.rational.interop.level2 - Number of records generation errors:0 06 Nov 2008 10:26:58,934 DEBUG com.ibm.rational.interop.level2 - Number of records ignored:0 06 Nov 2008 10:26:58,934 DEBUG com.ibm.rational.interop.level2 - Number of records suppressed:0 06 Nov 2008 10:26:58,935 DEBUG com.ibm.rational.interop.level2 - Number of records deleted:0 06 Nov 2008 10:26:58,935 DEBUG com.ibm.rational.interop.level2 - Total Number of records not processed:1 Any suggestions would be helpful. Terry |
8 answers
Hi,
This message sequence in the log seems to indicate that there was some problem on the jazz server, since there is no "Created" message. Can you include a jazz server log? 06 Nov 2008 10:26:58,869 DEBUG com.ibm.rational.interop.level1 - Creating Defect using Jazz Interop Client 06 Nov 2008 10:26:58,933 DEBUG com.ibm.rational.interop.level2 - Processor finished Rich Piazza Jazz CQ Connector team |
|
I opened a new defect to be synced. Again the event was acknowledged but was ignored. The following info is all that was in the jazz.log after I opened the defect. Nothing appears to relate to "incoming" sync.
13:50:47,450 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Found 8 sync rules for outgoing synchronization 13:50:47,453 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule dSTGC Sync 13:50:47,453 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for WorkItem items that may need outgoing sync 13:50:47,456 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 2ms 13:50:47,645 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule Basic dSTGC Sync 13:50:47,645 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for WorkItem items that may need outgoing sync 13:50:47,648 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 2ms 13:50:48,016 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule com.ibm.rational.clearquest.DefectTrackingInterop.Defect 13:50:48,016 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for WorkItem items that may need outgoing sync 13:50:48,020 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 2ms 13:50:48,320 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule com.ibm.rational.clearquest.DefectTrackingInterop.Attachment 13:50:48,320 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for Attachment items that may need outgoing sync 13:50:48,323 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 2ms 13:50:48,544 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule com.ibm.rational.clearquest.DefectTrackingInterop.Project 13:50:48,544 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for Category items that may need outgoing sync 13:50:48,548 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 3ms 13:50:48,825 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule com.ibm.rational.clearquest.DefectTrackingInterop.users 13:50:48,825 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for Contributor items that may need outgoing sync 13:50:48,828 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 2ms 13:50:49,095 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule dSTGC 13:50:49,095 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for WorkItem items that may need outgoing sync 13:50:49,100 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 3ms 13:50:49,344 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule com.ibm.rational.clearquest.DefectTrackingInterop.Defect1 13:50:49,345 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for WorkItem items that may need outgoing sync 13:50:49,349 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 3ms 13:55:49,746 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Found 8 sync rules for outgoing synchronization 13:55:49,748 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule dSTGC Sync 13:55:49,748 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for WorkItem items that may need outgoing sync 13:55:49,752 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 3ms 13:55:49,769 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule Basic dSTGC Sync 13:55:49,769 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for WorkItem items that may need outgoing sync 13:55:49,772 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 2ms 13:55:49,786 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule com.ibm.rational.clearquest.DefectTrackingInterop.Defect 13:55:49,787 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for WorkItem items that may need outgoing sync 13:55:49,792 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 4ms 13:55:49,811 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule com.ibm.rational.clearquest.DefectTrackingInterop.Attachment 13:55:49,811 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for Attachment items that may need outgoing sync 13:55:49,815 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 2ms 13:55:49,826 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule com.ibm.rational.clearquest.DefectTrackingInterop.Project 13:55:49,826 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for Category items that may need outgoing sync 13:55:49,829 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 2ms 13:55:49,847 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule com.ibm.rational.clearquest.DefectTrackingInterop.users 13:55:49,847 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for Contributor items that may need outgoing sync 13:55:49,851 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 3ms 13:55:49,866 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule dSTGC 13:55:49,867 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for WorkItem items that may need outgoing sync 13:55:49,870 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 3ms 13:55:49,889 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Synchronizing items for sync rule com.ibm.rational.clearquest.DefectTrackingInterop.Defect1 13:55:49,889 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Searching for WorkItem items that may need outgoing sync 13:55:49,893 DEBUG com.ibm.team.interop.service.outgoingSyncJob - Query for modified items returned 0 result(s) in 2ms 13:56:40,399 DEBUG com.ibm.team.interop - ExternalProxy : Deleting proxy |
|
Maybe we should try to clear up the problem mentioned in the warning message.
Usually, that indicates that there was some problem with the JazzInterop package. You said this worked previously - I assume you are using version 1.06 of JazzInterop? This message appears in two cases. - finding an appropriate class, which depends upon the version of CQ you are using - are you using 7.0.1? - there was an exception trying to determine the version of the package being used. Can you provide the version number info?? |
|
Current versions are:
CQ 7.0.1 JazzInterop 1.05 I can upgrade JazzInterop to 1.06 if that may fix the problem. I know it has worked so I'm not convinced it will but without other suggestions, I can do that. |
|
I have managed to resolve the issue of the gateway ignoring requests. I cannot say how it was resolved since I didn't change anything.
Now that items are coming into RTC from CQ, I am receiving the follow sync error. I assume this error means that a value is trying to be mapped to a reference field with an incorrect value. However, the error below does not state which field is causing the problem. Do you know how to determine which field is causing the invalid UUID exception? Incoming at 11/7/08 10:24:32 AM CST Error occurred: java.lang.IllegalArgumentException: invalid UUID at com.ibm.team.repository.common.UUID.valueOf(UUID.java:72) at com.ibm.team.interop.service.AbstractInteropItemManager.decodeReference(AbstractInteropItemManager.java:121) at com.ibm.team.interop.service.managers.workitem.InteropWorkItemManager.setProperty(InteropWorkItemManager.java:1120) at com.ibm.team.interop.service.managers.workitem.InteropWorkItemManager.saveState(InteropWorkItemManager.java:399) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55) at $Proxy199.saveState(Unknown Source) at com.ibm.team.interop.service.internal.ItemManagerProxy.saveState(ItemManagerProxy.java:115) at com.ibm.team.interop.service.internal.InteropService.doSynchronizeIncoming(InteropService.java:3351) at com.ibm.team.interop.service.internal.InteropService.processIncoming(InteropService.java:1977) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55) at $Proxy119.processIncoming(Unknown Source) at com.ibm.team.interop.service.internal.ProxySyncTask.processRequestQueue(ProxySyncTask.java:322) at com.ibm.team.interop.service.internal.ProxySyncTask.transactionSucceeded(ProxySyncTask.java:216) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55) at $Proxy121.transactionSucceeded(Unknown Source) at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$2.transactionSucceeded(AsynchronousTaskSchedulerService.java:559) at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$2.executeTask(AsynchronousTaskSchedulerService.java:567) at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:118) at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:92) at java.lang.Thread.run(Thread.java:810) |
|
For reference, this is the sync rule I'm using.
<xml> <syncRule> <name>dSTGC Sync v1</name> <externalTypeName>com.ibm.rational.clearquest.Defect</externalTypeName> <syncItemTypeName>WorkItem</syncItemTypeName> <syncItemTypeNsURI>com.ibm.team.workitem</syncItemTypeNsURI> <syncItemTypeQualifier>Type:defect</syncItemTypeQualifier> <itemManager>com.ibm.team.interop.service.managers.workitem.WorkItemManager</itemManager> <externalManager>com.ibm.team.interop.service.managers.clearquest.CQExternalManager</externalManager> <maxCycleCount>0</maxCycleCount> <syncAllItemStates>false</syncAllItemStates> <propertyMappings> <propertyMapping> <externalPropertyName>Subtier</externalPropertyName> <itemPropertyName>attribute:string:tier</itemPropertyName> <incoming>true</incoming> <outgoing>true</outgoing> <itemIdentifier>false</itemIdentifier> <externalIdentifier>false</externalIdentifier> <externalModifier>false</externalModifier> <requiredItemProperties> <requiredExternalProperties> </propertyMapping> <propertyMapping> <externalPropertyName>Component_Name</externalPropertyName> <itemPropertyName>attribute:smallString:component</itemPropertyName> <incoming>true</incoming> <outgoing>true</outgoing> <itemIdentifier>false</itemIdentifier> <externalIdentifier>false</externalIdentifier> <externalModifier>false</externalModifier> <requiredItemProperties> <requiredExternalProperties> </propertyMapping> <propertyMapping> <externalPropertyName>Headline</externalPropertyName> <itemPropertyName>Summary</itemPropertyName> <incoming>true</incoming> <outgoing>true</outgoing> <itemIdentifier>false</itemIdentifier> <externalIdentifier>false</externalIdentifier> <externalModifier>false</externalModifier> <requiredItemProperties> <requiredExternalProperties> </propertyMapping> <propertyMapping> <externalPropertyName>Reported_Release_Name</externalPropertyName> <itemPropertyName>Category</itemPropertyName> <incoming>true</incoming> <outgoing>true</outgoing> <itemIdentifier>false</itemIdentifier> <externalIdentifier>false</externalIdentifier> <externalModifier>false</externalModifier> <requiredItemProperties> <requiredExternalProperties> <transformExtension>com.ibm.team.interop.service.managers.workitem.CategoryValueTransformer</transformExtension> <valueMappings> <valueMapping> <externalValue>Ongoing</externalValue> <itemValue>Test Category</itemValue> <defaultExternalValue>false</defaultExternalValue> <defaultItemValue>false</defaultItemValue> </valueMapping> </valueMappings> </propertyMapping> <propertyMapping> <externalPropertyName> <itemPropertyName>Type</itemPropertyName> <incoming>true</incoming> <outgoing>false</outgoing> <itemIdentifier>false</itemIdentifier> <externalIdentifier>false</externalIdentifier> <externalModifier>false</externalModifier> <requiredItemProperties> <requiredExternalProperties> <valueMappings> <valueMapping> <externalValue> <itemValue>defect</itemValue> <defaultExternalValue>false</defaultExternalValue> <defaultItemValue>false</defaultItemValue> </valueMapping> </valueMappings> </propertyMapping> <propertyMapping> <externalPropertyName>Notes_Log</externalPropertyName> <itemPropertyName>Comments</itemPropertyName> <incoming>true</incoming> <outgoing>true</outgoing> <itemIdentifier>false</itemIdentifier> <externalIdentifier>false</externalIdentifier> <externalModifier>false</externalModifier> <requiredItemProperties> <requiredExternalProperties> </propertyMapping> <propertyMapping> <externalPropertyName>Subsystem_Name</externalPropertyName> <itemPropertyName>attribute:string:subsystem</itemPropertyName> <incoming>true</incoming> <outgoing>true</outgoing> <itemIdentifier>false</itemIdentifier> <externalIdentifier>false</externalIdentifier> <externalModifier>false</externalModifier> <requiredItemProperties> <requiredExternalProperties> </propertyMapping> </propertyMappings> </syncRule> |
Looking at your sync rule, there are two property mappings that look suspicious - comments and category. Comments needs to have the notes transformer and a reference to a user sync rule. Here's an example of what that should look like:
<propertyMapping> <externalPropertyName>Notes_Log</externalPropertyName> <itemPropertyName>Comments</itemPropertyName> <incoming>true</incoming> <outgoing>true</outgoing> <itemIdentifier>false</itemIdentifier> <externalIdentifier>false</externalIdentifier> <requiredItemProperties></requiredItemProperties> <requiredExternalProperties></requiredExternalProperties> <transformExtension>com.ibm.team.interop.service.managers.clearquest.WorkItemNotesValueTransformer</transformExtension> <referenceSyncRule>com.ibm.rational.clearquest.DefectTrackingInterop.users</referenceSyncRule> </propertyMapping> Regarding category, the combination of a category transformer and value mapping is currently not supported. The value in the report_release_name has to be the name of the category. I suspect this is causing the problem. Lorelei Jazz CQ Connector team |
|
Additionally, you should be using JazzInterop package version 1.06.
I assume you are using at least RTC 1.0. If so, I don't see how the connector will work at all with the previous package version. Rich Jazz CQ Connector team |
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.