CQ Connector Gateway reporting error on startup

In the documentation it states that to use the Jazz CQ Connector on a schema, the JazzInterop package must be applied to it. Assuming that you did that, you might have forgotten to upgrade your user database?

Rich Piazza
Jazz CQ Connector Team

Hi, the package was applied and database upgraded. I have checked the schema properties and it states that the package has been applied to all the record types that I specified.

If the gateway cannot find the JazzConnectorQueryInfo table, but you feel that the package was applied correctly and the db upgrades, perhaps the cqconnector.properties file has a property that is pointed to a different user db?

Please verify that you using the CQ database that you applied the package to.

Also, got to a browser, and type in the gateway's url (the url you used in the external repository connection in RTC). This will display a status page about the gateway. It might indicate what the problem is.

Is that functionality in M6a? When I goto http:<hostname>/InteropGateway/InteropServlet (which is what I used in my external connection config, all I see is the welcome page with no other info.

Unfortunately, this cool feature is not available until RC2, which will be available early next week.


Lorelei

Hi

The schema has been applied apparently successfully to the CQ defect record type, database has been checked in and upgraded. External repository created within RTC and sync rule for RTC to CQ defect record created. cqconnector.properties file is;

###############################################################################
# Licensed Materials - Property of IBM
# (c) Copyright IBM Corporation 2008. All Rights Reserved.
#
# Note to U.S. Government Users Restricted Rights:
# Use, duplication or disclosure restricted by GSA ADP Schedule
# Contract with IBM Corp.
###############################################################################

# Properties file for configuring ClearQuest Connector parameters

# CQ Connector polling period (in seconds)
com.ibm.rational.interop.pollingPeriod=60

# CQ repository configuration
#cq.dbSetDbName=sample_schema_repo/SAMPL
#cq.userid=admin
#cq.password=
cq.dbSetDbName=7.0.0/CQPOC
cq.userid=cqsync
cq.password=Welcome1

# Every CQ record type that will be synched or replicated
# needs to have a cq.query.<recordType> entry whose value
# can be empty which means synch all records of that type
# or the full query path such as Public Queries/My Query
# which will sync records that satisfy the query.
cq.query.Defect=Public Queries/AllDefects
cq.query.Project=Public Queries/AllProjects
cq.query.users=Public Queries/AllUsers

# Uri should be in the following format: http://@]hostname;...
com.ibm.team.uris=https://cqsync:cqsync@Dundatapp13:9443/jazz

# The cq.queryTreeRoot property is part of the new facility to specify the filters that determine
# what records are synced from CQ. It is used instead of the now depricated properties
# cq.query.*. In fact, it is illegal to specify both cq.query.* parameters and the
# cq.queryTreeRoot parameters in the same properties file.

# If you use this property, there should exist a query tree in the CQ workspace, rooted at the specified folder,
# that contains the filter queries corresponding to each Jazz project area involved in synchronization.
# The root folder must be under the Personal Queries or Public Queries folder. For simplicity it should
# be immediately under one of those existing folder, but it can be at any sub-level.

# The skeleton of the necessary query tree is as follows:

#<exisiting>
# <leaf>
# <name>
# <query>
# <query>
# <name>
# <query>
# <query>
# <query>
# .
# .
# .
# <name>
# <query>
# <query>

# The names of the queries are arbitrary, but best practices indicate it should be related to the record
# type name. If there is no query for a particular record type in a particular project area, then all
# records of that type will be synchronized. In other words, there is no filter for that record type
#in that project area

#cq.queryTreeRoot=Public Queries/JazzConnector




When the sync rule is run the CQConnector reports the following including an error that indicates a strange unknown record type; JazzConnectorQueryInfo


09-May-2008 17:59:02 org.apache.catalina.core.AprLifecycleListener lifecycleEvent INFO: The Apache Tomcat Native library which allows optimal performance in produ
ction environments was not found on the java.library.path: C:\CQConnector\jazz\connectors\gateway\win32\ibm-java2-i386-50\jre\bin;.;C:\Program Files\VERITAS\Net
Backup\bin\;C:\Program Files\Support Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\HP OpenView\Installed Packages\{790c06b4-84
4e-11d2-972b-080009ef8c2a}\bin;C:\Program Files\HP OpenView\Installed Packages\{790c06b4-844e-11d2-972b-080009ef8c2a}\bin\OpC;C:\Program Files\HP OpenView\bin;C:\Program Files\HP OpenView\bin\;C:\Program Files\HP OpenView\lib\;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;C:\Program Files\Rational\common;C:\Program Files\Rational\ClearCase\bin
09-May-2008 17:59:02 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8082
09-May-2008 17:59:04 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8444
09-May-2008 17:59:04 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3047 ms
09-May-2008 17:59:04 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
09-May-2008 17:59:04 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.20
09-May-2008 17:59:04 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
09-May-2008 17:59:05 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive InteropGateway.war
log4j:WARN No appenders could be found for logger (org.apache.commons.digester.D
igester.sax).
log4j:WARN Please initialize the log4j system properly.
09-May-2008 17:59:07 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8082
09-May-2008 17:59:08 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8444
09-May-2008 17:59:08 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8010
09-May-2008 17:59:08 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/172 config=null
09-May-2008 17:59:08 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
09-May-2008 17:59:08 org.apache.catalina.startup.Catalina start
INFO: Server startup in 4391 ms
17:59:13,742 ERROR com.ibm.rational.interop.level1
- Problem saving properties to CQ
17:59:13,757 ERROR com.ibm.rational.interop.level1
- CRRTC4540E: Couldn't start event polling:
com.ibm.team.interop.service.managers.clearquest.common.InteropException: No record type with name JazzConnectorQueryInfo
at com.ibm.rational.connector.cq.common.cqgateway.CQRepository.getCqRecordTypeInfo(CQRepository.java:66)
at com.ibm.rational.connector.cq.common.cqgateway.CQRepository.insertQueryInfo(CQRepository.java:157)
at com.ibm.rational.connector.cq.gateway.CQInteropPollingManager.addCQRepository(CQInteropPollingManager.java:721)
at com.ibm.rational.connector.cq.gateway.CQInteropPollingManager.initialize(CQInteropPollingManager.java:839)
at com.ibm.rational.connector.cq.gateway.polling.PollingThread.pollingIncoming(PollingThread.java:44)
at com.ibm.rational.connector.cq.gateway.polling.PollingThread.run(PollingThread.java:31)

The JazzConnectorQueryInfo is one of the CQ Connector custom tables that store information that we need for synchronization. To verify that your user db is CQ Connector-enabled,go to CQ, connect to your user db, try to create a query and if in the list of record types you don't see JazzConnectorQueryInfo as an option, then the user database has not been upgraded.

Lorelei

Hi

The user database has been upgraded in so much that the following CQConnector tables have been created;
- Change_History
- RecordsSynced
- JazzConnectorProperties

But not the JazzConnectorQueryInfo table which is not documented in the RTC help documentation as existing or being part of the user DB upgrade. Can you confirm whether this table is part of the 1.0m6 build? The database server being used for CQ is DB2 Enterprise v9.1

OK, having looked into the CQPackage contents it would seem that users should now use version 1.05 of the JazzInterop package instead of the documented 1.03.

Can you confirm?

N.B. I have raised this in Work Item 55505.

Yes, you should always install the latest version of the package. The documentation tries to indicate that, but perhaps it could be clearer:

"If this is the first time you are applying the JazzInterop package to the schema, use the latest version, which is the one with the highest number. If you previously applied an earlier version of the package to your schema, upgrade incrementally. For example, to upgrade from 1.0 to 1.03, perform the following tasks..."

John
Jazz ClearQuest Connector Team