CQ Connector sync error "The sync rule name is malform

Are you using RTC 1.0.1 M2 or RTC 1.0?

Additionally, was there a stack trace available?

Rich Piazza
Jazz CQ Connector team

Version: 1.0
Build id: I20080618-1642

There was no stack trace that I could find. The error was presented within sync status page.

Synchronization Status: Outgoing error

Blocked By: Not blocked

Last Synchronization Attempt: Outgoing at 9/16/08 4:58:00 PM CDT
Error occurred:
java.lang.RuntimeException: com.ibm.team.interop.service.managers.clearquest.common.InteropException: The sync rule name is malformed

Synchronization Rule: com.ibm.rational.clearquest.DefectTrackingInterop.Project

Can you view the project sync rule and verify that there is a value in the external type field? Also, click the source Tab and tell us what the value is in the <externalTypeName> tag. It should be "com.ibm.rational.clearquest.Project".

Lorelei
Jazz CQ Connector Team

The external type field is blank.

<externalTypeName></externalTypeName>

There is also an exclamation at the top of the sync rule and the error "External type information is not available".

The sync rule must have been modified, then, because "out-of-the-box", all external type name values are set correctly. The external type name must be in the format "prefix.record-type-name" (i.e. must end with the CQ record type name, preceded by a '.' character, with any prefix you like).

By the way, the error message is pretty unhelpful, so I entered a work item to improve it:

https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/61144

John
Jazz ClearQuest Connector Team

Oh, and the "external type information is not available" message indicates that the Jazz server is not communicating with the CQ Gateway. That could be caused by not configuring the URL of the CQ Gateway correctly in your external repository connection, or perhaps having an invalid username or password for the connection, or just not having network connectivity. If you click on the message at the top of the sync rule editor, a dialog will open with additional details, which might indicate the exact nature of the problem.

John
Jazz ClearQuest Connector Team

There does seem to be a problem connecting to the gateway. When I click the link on the sync rule page which says "External Type information is not available", I am giving the follow error in the detail box:

External type information is not available
java.lang.RuntimeException: com.ibm.team.interop.service.managers.clearquest.common.InteropException: Server error on the ClearQuest gateway - status 500

What does this error mean?

A 500 error is a standard http error code for an unexpected error.

Could you turn on debug logging in the gateway - the details are in the documentation, but basically, just edit log4j.properties in the gateway directory and uncomment out where you see level1 and level2.

One idea - are you sure that you have the appropriate RTC license to use the CQ connector, and that the jazz user id that the gateway logs into the Jazz server has the right permissions?

I'm now seeing this in the gateway log when I turn on debugging. I am using a CQ admin ID in the repository connection.


17 Sep 2008 15:57:52,103 DEBUG com.ibm.rational.interop.level1 - Exception handling POST
com.ibm.team.interop.service.managers.clearquest.common.InteropException: com.ibm.rational.connector.cq.teamapi71.InteropWvcmException71: CRVAP0339E (property-retrieval-failed): 'key-fields' The attemp
t to retrieve the value of the property named 'KEY_FIELDS' failed because of an unexpected error.
...CRVAP0339E (property-not-currently-available): 'key-fields' The attempt to retrieve the value of the property named 'KEY_FIELDS' failed because of an unexpected error.
...com.rational.clearquest.cqjni.CQException: Caught a CQException at the JNI Boundary:
../cqsession.cpp: line 1297-Permission denied. This operation can only be performed by a user with SQL editor privileges.
at com.ibm.rational.connector.cq.gateway.servlet.InteropOperationReturn.serializeCqRecordFields(InteropOperationReturn.java:102)
at com.ibm.rational.connector.cq.gateway.servlet.InteropOperationReturn.serializeCqRecordType(InteropOperationReturn.java:116)
at com.ibm.rational.connector.cq.gateway.servlet.InteropOperationReturn.serializeTypeInfo(InteropOperationReturn.java:129)
at com.ibm.rational.connector.cq.gateway.servlet.InteropOperationReturn.serialize(InteropOperationReturn.java:164)
at com.ibm.rational.connector.cq.gateway.servlet.InteropServlet.doPostInteropOperation(InteropServlet.java:80)
at com.ibm.rational.connector.cq.gateway.servlet.InteropServlet.doPost(InteropServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:810)

You need to grant the SQL Editor permission to the CQ user account that you have configured the gateway to log in as. This is mentioned in the 'Creating user accounts' topic in the documentation, i.e.

https://jazz.net/jazzdocs/topic/com.ibm.team.connector.cq.doc/topics/t_creating_user_accounts.html

John
Jazz ClearQuest Connector Team