It's all about the answers!

Ask a question

CQ Gateway events being ignored


Terry Krause (101138) | asked Nov 06 '08, 11:59 a.m.
JAZZ DEVELOPER
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



permanent link
Richard Piazza (381) | answered Nov 06 '08, 12:11 p.m.
JAZZ DEVELOPER
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

permanent link
Terry Krause (101138) | answered Nov 06 '08, 3:09 p.m.
JAZZ DEVELOPER
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

permanent link
Richard Piazza (381) | answered Nov 06 '08, 3:44 p.m.
JAZZ DEVELOPER
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??

permanent link
Terry Krause (101138) | answered Nov 06 '08, 5:16 p.m.
JAZZ DEVELOPER
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.

permanent link
Terry Krause (101138) | answered Nov 07 '08, 11:28 a.m.
JAZZ DEVELOPER
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)

permanent link
Terry Krause (101138) | answered Nov 07 '08, 11:30 a.m.
JAZZ DEVELOPER
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>

permanent link
Lorelei Ngooi (1.5k22) | answered Nov 07 '08, 2:35 p.m.
JAZZ DEVELOPER
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

permanent link
Richard Piazza (381) | answered Nov 10 '08, 9:29 a.m.
JAZZ DEVELOPER
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


Register or 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.