Problems connecting to the CQ DB
Hi Jazz Team,
I am facing challenges to connect the Jazz CQ DB.
Both way communication from the jazz client and jazz server is fine. I have checked with the help of ink: http://localhost:8081/InteropGateway.
And its working on the both the machine and getting the following result. Need your help on this.
Thanks & regards,
Tushar Parate
http://localhost:8081/InteropGateway
------------------------------------------------>
Welcome to the Jazz ClearQuest Connector Gateway
Gateway started at: 4/24/09 11:58 AM
Uptime: 00:00:57
Gateway Version: I20081024-1335
CQ Database Information:
There were problems connecting to the CQ DB, JAZZ_TEST/BGTRK
A CQ database was not specified in the cqconnector.properties file, or it was unreachable
Jazz Team Servers:
URI: https://jazzaadmin2.in.ibm.com:9443/jazz
Status: OK
Project Area: WebSphere Adapters Project Area
No records will be synced to this project area because it does not appear as a folder in the CQ workspace under the Public Queries/JazzConnector folder
Project Area: CQJazzIntegration
No records will be synced to this project area because it does not appear as a folder in the CQ workspace under the Public Queries/JazzConnector folder
Project Area: WebSphere Adapters Project Area 2009
No records will be synced to this project area because it does not appear as a folder in the CQ workspace under the Public Queries/JazzConnector folder
Polling Information:
Polling enabled: false
Tomcat Console:
---------------------->
Apr 24, 2009 11:58:42 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: E:\IBM\CQ_Connector\gateway\win32
Apr 24, 2009 11:58:42 AM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8081
Apr 24, 2009 11:58:43 AM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8444
Apr 24, 2009 11:58:43 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1375 ms
Apr 24, 2009 11:58:43 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 24, 2009 11:58:43 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Apr 24, 2009 11:58:43 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Apr 24, 2009 11:58:43 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.Digester.sax).
log4j:WARN Please initialize the log4j system properly.
log4j:ERROR Could not find value for key log4j.appender.synctool
log4j:ERROR Could not instantiate appender named "synctool".
24 Apr 2009 11:58:43,625 INFO com.ibm.rational.interop.level2 - temp dir is: E:\IBM\CQ_Connector\gateway\tomcat\temp\interop
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: jazzaadmin2.in.ibm.com(9443)
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Logging in as tuparate@in.ibm.com
Apr 24, 2009 11:58:43 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8081
Apr 24, 2009 11:58:43 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8444
Apr 24, 2009 11:58:43 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8010
Apr 24, 2009 11:58:43 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/16 config=null
Apr 24, 2009 11:58:43 AM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Apr 24, 2009 11:58:43 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 625 ms
24 Apr 2009 11:58:44,109 DEBUG com.ibm.rational.interop.level2 - Got connection at 0 for CQ Interop Polling
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: BALTIC_MR1.D070529
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 701
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
24 Apr 2009 11:58:44,187 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for JAZZ_TEST/BGTRK login: tuparate@in.ibm.c
CRVSV0977I Not launching task to watch for logging properties changes since this CM API-based code is running inside a servlet or within the CM Server.
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for JAZZ_TEST/BGTRK thread name: CQ In
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating CQ Interop handler at 0
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-JAZZ_TEST/BGTRK-CQ Interop Polling
24 Apr 2009 11:58:50,296 DEBUG com.ibm.rational.interop.level2 - Number of record types: 24
24 Apr 2009 11:58:50,312 DEBUG com.ibm.rational.interop.level2 - Processed (1) JazzConnectorProperties
24 Apr 2009 11:58:50,328 DEBUG com.ibm.rational.interop.level2 - Processed (2) UCM_Project
24 Apr 2009 11:58:50,500 DEBUG com.ibm.rational.interop.level2 - Processed (3) users
24 Apr 2009 11:58:50,531 DEBUG com.ibm.rational.interop.level2 - Processed (4) DepDrop
24 Apr 2009 11:58:50,546 DEBUG com.ibm.rational.interop.level2 - Processed (5) groups
24 Apr 2009 11:58:50,562 DEBUG com.ibm.rational.interop.level2 - Processed (6) JazzConnectorChangeEvents
24 Apr 2009 11:58:50,593 DEBUG com.ibm.rational.interop.level2 - Processed (7) MastershipRoutingRule
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - modify order is: []
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - submit order is: []
24 Apr 2009 11:58:50,625 DEBUG com.ibm.rational.interop.level2 - Processed (8) part
24 Apr 2009 11:58:50,656 DEBUG com.ibm.rational.interop.level2 - Processed (9) BaseCMActivity
24 Apr 2009 11:58:50,671 DEBUG com.ibm.rational.interop.level2 - Processed (10) attachments
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (11) UCMUtilityActivity
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (12) JazzConnectorSyncHistory
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (13) JazzConnectorQueryInfo
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (14) ratl_replicas
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (15) _ratl_data_code_page
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (16) Template
24 Apr 2009 11:58:50,781 DEBUG com.ibm.rational.interop.level2 - Processed (17) PTF
24 Apr 2009 11:58:50,828 DEBUG com.ibm.rational.interop.level2 - Processed (18) APAR
24 Apr 2009 11:58:50,843 DEBUG com.ibm.rational.interop.level2 - Processed (19) Locales
cqgateway log:
--------------------->
24 Apr 2009 11:58:43,625 INFO com.ibm.rational.interop.level2 - temp dir is: E:\IBM\CQ_Connector\gateway\tomcat\temp\interop
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: jazzaadmin2.in.ibm.com(9443)
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Logging in as tuparate@in.ibm.com
24 Apr 2009 11:58:44,109 DEBUG com.ibm.rational.interop.level2 - Got connection at 0 for CQ Interop Polling
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: BALTIC_MR1.D070529
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 701
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
24 Apr 2009 11:58:44,187 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for JAZZ_TEST/BGTRK login: tuparate@in.ibm.com
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for JAZZ_TEST/BGTRK thread name: CQ Interop Polling
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating CQ Interop handler at 0
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-JAZZ_TEST/BGTRK-CQ Interop Polling
24 Apr 2009 11:58:50,296 DEBUG com.ibm.rational.interop.level2 - Number of record types: 24
24 Apr 2009 11:58:50,312 DEBUG com.ibm.rational.interop.level2 - Processed (1) JazzConnectorProperties
24 Apr 2009 11:58:50,328 DEBUG com.ibm.rational.interop.level2 - Processed (2) UCM_Project
24 Apr 2009 11:58:50,500 DEBUG com.ibm.rational.interop.level2 - Processed (3) users
24 Apr 2009 11:58:50,531 DEBUG com.ibm.rational.interop.level2 - Processed (4) DepDrop
24 Apr 2009 11:58:50,546 DEBUG com.ibm.rational.interop.level2 - Processed (5) groups
24 Apr 2009 11:58:50,562 DEBUG com.ibm.rational.interop.level2 - Processed (6) JazzConnectorChangeEvents
24 Apr 2009 11:58:50,593 DEBUG com.ibm.rational.interop.level2 - Processed (7) MastershipRoutingRule
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - modify order is: []
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - submit order is: []
24 Apr 2009 11:58:50,625 DEBUG com.ibm.rational.interop.level2 - Processed (8) part
24 Apr 2009 11:58:50,656 DEBUG com.ibm.rational.interop.level2 - Processed (9) BaseCMActivity
24 Apr 2009 11:58:50,671 DEBUG com.ibm.rational.interop.level2 - Processed (10) attachments
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (11) UCMUtilityActivity
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (12) JazzConnectorSyncHistory
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (13) JazzConnectorQueryInfo
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (14) ratl_replicas
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (15) _ratl_data_code_page
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (16) Template
24 Apr 2009 11:58:50,781 DEBUG com.ibm.rational.interop.level2 - Processed (17) PTF
24 Apr 2009 11:58:50,828 DEBUG com.ibm.rational.interop.level2 - Processed (18) APAR
24 Apr 2009 11:58:50,843 DEBUG com.ibm.rational.interop.level2 - Processed (19) Locales
I am facing challenges to connect the Jazz CQ DB.
Both way communication from the jazz client and jazz server is fine. I have checked with the help of ink: http://localhost:8081/InteropGateway.
And its working on the both the machine and getting the following result. Need your help on this.
Thanks & regards,
Tushar Parate
http://localhost:8081/InteropGateway
------------------------------------------------>
Welcome to the Jazz ClearQuest Connector Gateway
Gateway started at: 4/24/09 11:58 AM
Uptime: 00:00:57
Gateway Version: I20081024-1335
CQ Database Information:
There were problems connecting to the CQ DB, JAZZ_TEST/BGTRK
A CQ database was not specified in the cqconnector.properties file, or it was unreachable
Jazz Team Servers:
URI: https://jazzaadmin2.in.ibm.com:9443/jazz
Status: OK
Project Area: WebSphere Adapters Project Area
No records will be synced to this project area because it does not appear as a folder in the CQ workspace under the Public Queries/JazzConnector folder
Project Area: CQJazzIntegration
No records will be synced to this project area because it does not appear as a folder in the CQ workspace under the Public Queries/JazzConnector folder
Project Area: WebSphere Adapters Project Area 2009
No records will be synced to this project area because it does not appear as a folder in the CQ workspace under the Public Queries/JazzConnector folder
Polling Information:
Polling enabled: false
Tomcat Console:
---------------------->
Apr 24, 2009 11:58:42 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: E:\IBM\CQ_Connector\gateway\win32
Apr 24, 2009 11:58:42 AM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8081
Apr 24, 2009 11:58:43 AM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8444
Apr 24, 2009 11:58:43 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1375 ms
Apr 24, 2009 11:58:43 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 24, 2009 11:58:43 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Apr 24, 2009 11:58:43 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Apr 24, 2009 11:58:43 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.Digester.sax).
log4j:WARN Please initialize the log4j system properly.
log4j:ERROR Could not find value for key log4j.appender.synctool
log4j:ERROR Could not instantiate appender named "synctool".
24 Apr 2009 11:58:43,625 INFO com.ibm.rational.interop.level2 - temp dir is: E:\IBM\CQ_Connector\gateway\tomcat\temp\interop
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: jazzaadmin2.in.ibm.com(9443)
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Logging in as tuparate@in.ibm.com
Apr 24, 2009 11:58:43 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8081
Apr 24, 2009 11:58:43 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8444
Apr 24, 2009 11:58:43 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8010
Apr 24, 2009 11:58:43 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/16 config=null
Apr 24, 2009 11:58:43 AM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Apr 24, 2009 11:58:43 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 625 ms
24 Apr 2009 11:58:44,109 DEBUG com.ibm.rational.interop.level2 - Got connection at 0 for CQ Interop Polling
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: BALTIC_MR1.D070529
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 701
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
24 Apr 2009 11:58:44,187 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for JAZZ_TEST/BGTRK login: tuparate@in.ibm.c
CRVSV0977I Not launching task to watch for logging properties changes since this CM API-based code is running inside a servlet or within the CM Server.
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for JAZZ_TEST/BGTRK thread name: CQ In
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating CQ Interop handler at 0
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-JAZZ_TEST/BGTRK-CQ Interop Polling
24 Apr 2009 11:58:50,296 DEBUG com.ibm.rational.interop.level2 - Number of record types: 24
24 Apr 2009 11:58:50,312 DEBUG com.ibm.rational.interop.level2 - Processed (1) JazzConnectorProperties
24 Apr 2009 11:58:50,328 DEBUG com.ibm.rational.interop.level2 - Processed (2) UCM_Project
24 Apr 2009 11:58:50,500 DEBUG com.ibm.rational.interop.level2 - Processed (3) users
24 Apr 2009 11:58:50,531 DEBUG com.ibm.rational.interop.level2 - Processed (4) DepDrop
24 Apr 2009 11:58:50,546 DEBUG com.ibm.rational.interop.level2 - Processed (5) groups
24 Apr 2009 11:58:50,562 DEBUG com.ibm.rational.interop.level2 - Processed (6) JazzConnectorChangeEvents
24 Apr 2009 11:58:50,593 DEBUG com.ibm.rational.interop.level2 - Processed (7) MastershipRoutingRule
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - modify order is: []
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - submit order is: []
24 Apr 2009 11:58:50,625 DEBUG com.ibm.rational.interop.level2 - Processed (8) part
24 Apr 2009 11:58:50,656 DEBUG com.ibm.rational.interop.level2 - Processed (9) BaseCMActivity
24 Apr 2009 11:58:50,671 DEBUG com.ibm.rational.interop.level2 - Processed (10) attachments
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (11) UCMUtilityActivity
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (12) JazzConnectorSyncHistory
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (13) JazzConnectorQueryInfo
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (14) ratl_replicas
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (15) _ratl_data_code_page
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (16) Template
24 Apr 2009 11:58:50,781 DEBUG com.ibm.rational.interop.level2 - Processed (17) PTF
24 Apr 2009 11:58:50,828 DEBUG com.ibm.rational.interop.level2 - Processed (18) APAR
24 Apr 2009 11:58:50,843 DEBUG com.ibm.rational.interop.level2 - Processed (19) Locales
cqgateway log:
--------------------->
24 Apr 2009 11:58:43,625 INFO com.ibm.rational.interop.level2 - temp dir is: E:\IBM\CQ_Connector\gateway\tomcat\temp\interop
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: jazzaadmin2.in.ibm.com(9443)
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Logging in as tuparate@in.ibm.com
24 Apr 2009 11:58:44,109 DEBUG com.ibm.rational.interop.level2 - Got connection at 0 for CQ Interop Polling
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: BALTIC_MR1.D070529
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 701
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
24 Apr 2009 11:58:44,187 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for JAZZ_TEST/BGTRK login: tuparate@in.ibm.com
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for JAZZ_TEST/BGTRK thread name: CQ Interop Polling
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating CQ Interop handler at 0
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-JAZZ_TEST/BGTRK-CQ Interop Polling
24 Apr 2009 11:58:50,296 DEBUG com.ibm.rational.interop.level2 - Number of record types: 24
24 Apr 2009 11:58:50,312 DEBUG com.ibm.rational.interop.level2 - Processed (1) JazzConnectorProperties
24 Apr 2009 11:58:50,328 DEBUG com.ibm.rational.interop.level2 - Processed (2) UCM_Project
24 Apr 2009 11:58:50,500 DEBUG com.ibm.rational.interop.level2 - Processed (3) users
24 Apr 2009 11:58:50,531 DEBUG com.ibm.rational.interop.level2 - Processed (4) DepDrop
24 Apr 2009 11:58:50,546 DEBUG com.ibm.rational.interop.level2 - Processed (5) groups
24 Apr 2009 11:58:50,562 DEBUG com.ibm.rational.interop.level2 - Processed (6) JazzConnectorChangeEvents
24 Apr 2009 11:58:50,593 DEBUG com.ibm.rational.interop.level2 - Processed (7) MastershipRoutingRule
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - modify order is: []
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - submit order is: []
24 Apr 2009 11:58:50,625 DEBUG com.ibm.rational.interop.level2 - Processed (8) part
24 Apr 2009 11:58:50,656 DEBUG com.ibm.rational.interop.level2 - Processed (9) BaseCMActivity
24 Apr 2009 11:58:50,671 DEBUG com.ibm.rational.interop.level2 - Processed (10) attachments
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (11) UCMUtilityActivity
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (12) JazzConnectorSyncHistory
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (13) JazzConnectorQueryInfo
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (14) ratl_replicas
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (15) _ratl_data_code_page
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (16) Template
24 Apr 2009 11:58:50,781 DEBUG com.ibm.rational.interop.level2 - Processed (17) PTF
24 Apr 2009 11:58:50,828 DEBUG com.ibm.rational.interop.level2 - Processed (18) APAR
24 Apr 2009 11:58:50,843 DEBUG com.ibm.rational.interop.level2 - Processed (19) Locales
2 answers
Hi Jazz Team,
I am facing challenges to connect the Jazz CQ DB.
Both way communication from the jazz client and jazz server is fine. I have checked with the help of ink: http://localhost:8081/InteropGateway.
And its working on the both the machine and getting the following result. Need your help on this.
Thanks & regards,
Tushar Parate
http://localhost:8081/InteropGateway
------------------------------------------------>
Welcome to the Jazz ClearQuest Connector Gateway
Gateway started at: 4/24/09 11:58 AM
Uptime: 00:00:57
Gateway Version: I20081024-1335
CQ Database Information:
There were problems connecting to the CQ DB, JAZZ_TEST/BGTRK
A CQ database was not specified in the cqconnector.properties file, or it was unreachable
Jazz Team Servers:
URI: https://jazzaadmin2.in.ibm.com:9443/jazz
Status: OK
Project Area: WebSphere Adapters Project Area
No records will be synced to this project area because it does not appear as a folder in the CQ workspace under the Public Queries/JazzConnector folder
Project Area: CQJazzIntegration
No records will be synced to this project area because it does not appear as a folder in the CQ workspace under the Public Queries/JazzConnector folder
Project Area: WebSphere Adapters Project Area 2009
No records will be synced to this project area because it does not appear as a folder in the CQ workspace under the Public Queries/JazzConnector folder
Polling Information:
Polling enabled: false
Tomcat Console:
---------------------->
Apr 24, 2009 11:58:42 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: E:\IBM\CQ_Connector\gateway\win32
Apr 24, 2009 11:58:42 AM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8081
Apr 24, 2009 11:58:43 AM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8444
Apr 24, 2009 11:58:43 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1375 ms
Apr 24, 2009 11:58:43 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 24, 2009 11:58:43 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Apr 24, 2009 11:58:43 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Apr 24, 2009 11:58:43 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.Digester.sax).
log4j:WARN Please initialize the log4j system properly.
log4j:ERROR Could not find value for key log4j.appender.synctool
log4j:ERROR Could not instantiate appender named "synctool".
24 Apr 2009 11:58:43,625 INFO com.ibm.rational.interop.level2 - temp dir is: E:\IBM\CQ_Connector\gateway\tomcat\temp\interop
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: jazzaadmin2.in.ibm.com(9443)
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Logging in as tuparate@in.ibm.com
Apr 24, 2009 11:58:43 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8081
Apr 24, 2009 11:58:43 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8444
Apr 24, 2009 11:58:43 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8010
Apr 24, 2009 11:58:43 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/16 config=null
Apr 24, 2009 11:58:43 AM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Apr 24, 2009 11:58:43 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 625 ms
24 Apr 2009 11:58:44,109 DEBUG com.ibm.rational.interop.level2 - Got connection at 0 for CQ Interop Polling
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: BALTIC_MR1.D070529
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 701
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
24 Apr 2009 11:58:44,187 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for JAZZ_TEST/BGTRK login: tuparate@in.ibm.c
CRVSV0977I Not launching task to watch for logging properties changes since this CM API-based code is running inside a servlet or within the CM Server.
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for JAZZ_TEST/BGTRK thread name: CQ In
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating CQ Interop handler at 0
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-JAZZ_TEST/BGTRK-CQ Interop Polling
24 Apr 2009 11:58:50,296 DEBUG com.ibm.rational.interop.level2 - Number of record types: 24
24 Apr 2009 11:58:50,312 DEBUG com.ibm.rational.interop.level2 - Processed (1) JazzConnectorProperties
24 Apr 2009 11:58:50,328 DEBUG com.ibm.rational.interop.level2 - Processed (2) UCM_Project
24 Apr 2009 11:58:50,500 DEBUG com.ibm.rational.interop.level2 - Processed (3) users
24 Apr 2009 11:58:50,531 DEBUG com.ibm.rational.interop.level2 - Processed (4) DepDrop
24 Apr 2009 11:58:50,546 DEBUG com.ibm.rational.interop.level2 - Processed (5) groups
24 Apr 2009 11:58:50,562 DEBUG com.ibm.rational.interop.level2 - Processed (6) JazzConnectorChangeEvents
24 Apr 2009 11:58:50,593 DEBUG com.ibm.rational.interop.level2 - Processed (7) MastershipRoutingRule
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - modify order is: []
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - submit order is: []
24 Apr 2009 11:58:50,625 DEBUG com.ibm.rational.interop.level2 - Processed (8) part
24 Apr 2009 11:58:50,656 DEBUG com.ibm.rational.interop.level2 - Processed (9) BaseCMActivity
24 Apr 2009 11:58:50,671 DEBUG com.ibm.rational.interop.level2 - Processed (10) attachments
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (11) UCMUtilityActivity
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (12) JazzConnectorSyncHistory
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (13) JazzConnectorQueryInfo
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (14) ratl_replicas
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (15) _ratl_data_code_page
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (16) Template
24 Apr 2009 11:58:50,781 DEBUG com.ibm.rational.interop.level2 - Processed (17) PTF
24 Apr 2009 11:58:50,828 DEBUG com.ibm.rational.interop.level2 - Processed (18) APAR
24 Apr 2009 11:58:50,843 DEBUG com.ibm.rational.interop.level2 - Processed (19) Locales
cqgateway log:
--------------------->
24 Apr 2009 11:58:43,625 INFO com.ibm.rational.interop.level2 - temp dir is: E:\IBM\CQ_Connector\gateway\tomcat\temp\interop
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: jazzaadmin2.in.ibm.com(9443)
24 Apr 2009 11:58:43,640 DEBUG com.ibm.rational.interop.level1 - Logging in as tuparate@in.ibm.com
24 Apr 2009 11:58:44,109 DEBUG com.ibm.rational.interop.level2 - Got connection at 0 for CQ Interop Polling
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: BALTIC_MR1.D070529
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 701
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
24 Apr 2009 11:58:44,171 DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
24 Apr 2009 11:58:44,187 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for JAZZ_TEST/BGTRK login: tuparate@in.ibm.com
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for JAZZ_TEST/BGTRK thread name: CQ Interop Polling
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Allocating CQ Interop handler at 0
24 Apr 2009 11:58:46,765 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-JAZZ_TEST/BGTRK-CQ Interop Polling
24 Apr 2009 11:58:50,296 DEBUG com.ibm.rational.interop.level2 - Number of record types: 24
24 Apr 2009 11:58:50,312 DEBUG com.ibm.rational.interop.level2 - Processed (1) JazzConnectorProperties
24 Apr 2009 11:58:50,328 DEBUG com.ibm.rational.interop.level2 - Processed (2) UCM_Project
24 Apr 2009 11:58:50,500 DEBUG com.ibm.rational.interop.level2 - Processed (3) users
24 Apr 2009 11:58:50,531 DEBUG com.ibm.rational.interop.level2 - Processed (4) DepDrop
24 Apr 2009 11:58:50,546 DEBUG com.ibm.rational.interop.level2 - Processed (5) groups
24 Apr 2009 11:58:50,562 DEBUG com.ibm.rational.interop.level2 - Processed (6) JazzConnectorChangeEvents
24 Apr 2009 11:58:50,593 DEBUG com.ibm.rational.interop.level2 - Processed (7) MastershipRoutingRule
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - modify order is: []
24 Apr 2009 11:58:50,609 DEBUG com.ibm.rational.interop.level2 - submit order is: []
24 Apr 2009 11:58:50,625 DEBUG com.ibm.rational.interop.level2 - Processed (8) part
24 Apr 2009 11:58:50,656 DEBUG com.ibm.rational.interop.level2 - Processed (9) BaseCMActivity
24 Apr 2009 11:58:50,671 DEBUG com.ibm.rational.interop.level2 - Processed (10) attachments
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (11) UCMUtilityActivity
24 Apr 2009 11:58:50,703 DEBUG com.ibm.rational.interop.level2 - Processed (12) JazzConnectorSyncHistory
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (13) JazzConnectorQueryInfo
24 Apr 2009 11:58:50,718 DEBUG com.ibm.rational.interop.level2 - Processed (14) ratl_replicas
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (15) _ratl_data_code_page
24 Apr 2009 11:58:50,734 DEBUG com.ibm.rational.interop.level2 - Processed (16) Template
24 Apr 2009 11:58:50,781 DEBUG com.ibm.rational.interop.level2 - Processed (17) PTF
24 Apr 2009 11:58:50,828 DEBUG com.ibm.rational.interop.level2 - Processed (18) APAR
24 Apr 2009 11:58:50,843 DEBUG com.ibm.rational.interop.level2 - Processed (19) Locales
Hello,
Looks like you have not created any qurey folder from your CQ database? According to the documentation, whether you use one project area or multiple project areas in RTC, you must create a hierarchy of query folders in the Public Queries or Personal Queries folder from CQ. In the cqconnector.properties file, you set the value of the cq.queryTreeRoot parameter to the root query folder. Within this root folder, create folders for each project area to which you want to connect the CQ user database. The names of the folders must match exactly the names of the project areas. For each record type, create no more than one query per project area.
I include a the following link below with configuration checklist for CQ connector. Check out item #6
http://publib.boulder.ibm.com/infocenter/rtc/v1r0m1/index.jsp?topic=/com.ibm.team.connector.cq.doc/topics/c_configuration_checklist.html
Susan
Jazz/RTC Support
This seems to be a repost of your post on March 30 in
https://jazz.net/forums/viewtopic.php?t=3998
where Rich responded that this is due to a problem in your CQ schema. There is a work item you can reference for more information. Have you looked into that? (Note, this has nothing to do with your query configuration, as Susan surmised.)
https://jazz.net/forums/viewtopic.php?t=3998
where Rich responded that this is due to a problem in your CQ schema. There is a work item you can reference for more information. Have you looked into that? (Note, this has nothing to do with your query configuration, as Susan surmised.)