CQ Connector Gateway reporting error on startup
Hi
Just attempted to configure the CQ connector against the Defect record type that comes with the Enterprise schema (but with the JazzInterop package installed). The RTC external repository and sync rules seem to be ok as does the cqconnectors.properties file contents. However when I start the gateway the following messages are displayed (sync does not happen). May 8, 2008 7:09:58 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\CQConnector\jazz\c onnectors\gateway\win32\ibm-java2-i386-50\jre\bin;.;C:\Program Files\Mail Enable\BIN;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;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 May 8, 2008 7:09:58 AM org.apache.coyote.http11.Http11BaseProtocol init INFO: Initializing Coyote HTTP/1.1 on http-8081 May 8, 2008 7:09:59 AM org.apache.coyote.http11.Http11BaseProtocol init INFO: Initializing Coyote HTTP/1.1 on http-8444 May 8, 2008 7:09:59 AM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 2156 ms May 8, 2008 7:10:00 AM org.apache.catalina.core.StandardService start INFO: Starting service Catalina May 8, 2008 7:10:00 AM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/5.5.20 May 8, 2008 7:10:00 AM org.apache.catalina.core.StandardHost start INFO: XML validation disabled May 8, 2008 7:10:00 AM 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. May 8, 2008 7:10:01 AM org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-8081 May 8, 2008 7:10:01 AM org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-8444 May 8, 2008 7:10:01 AM org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8010 May 8, 2008 7:10:01 AM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/31 config=null May 8, 2008 7:10:01 AM org.apache.catalina.storeconfig.StoreLoader load INFO: Find registry server-registry.xml at classpath resource May 8, 2008 7:10:01 AM org.apache.catalina.startup.Catalina start INFO: Server startup in 1672 ms 07:10:06,639 ERROR com.ibm.rational.interop.level1 - Problem saving properties to CQ 07:10:06,639 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) Somewhat confusingly it mentions a record type named JazzConnectorQueryInfo, this record type does not exist within my CQ schema. Where abouts would the gateway be picking up this value from? |
10 answers
In the documentation it states that to use the Jazz CQ Connector on a schema, the JazzInterop package must be
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, John Jazz ClearQuest 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.