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.

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)

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.