It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,788

question asked: Mar 26 '09, 8:12 a.m.
question was seen: 4,543 times
last updated: Mar 26 '09, 8:12 a.m.

Related questions

FAQ - How this Forum works

problems connecting to the CQ DB

0
Tushar Parate (36●9●2) | asked Mar 26 '09, 8:12 a.m.
Hi Team,

I have setup the CQ-Jazz Integration.
Setup:
1) M/C- Jazz Server installed
2) M/C 2- Jazz CQ Connector

I have followed all the steps given at the info center.
Both way communication (M/C1 and M/C 2) is fine. This is checked by opening the link at both machines (Link: http://IP_ADDRESS_OF_GATEWAY_MC:8081/InteropGateway)


Message: There were problems connecting to the CQ DB, TEST_ENV/BGTRK.

Need help on this..

Status page:
Welcome to the Jazz ClearQuest Connector Gateway
Gateway started at: 3/26/09 3:48 PM
Uptime: 01:18:56
Gateway Version: I20081024-1335
CQ Database Information:
There were problems connecting to the CQ DB, TEST_ENV/BGTRK
A CQ database was not specified in the cqconnector.properties file, or it was unreachable
Jazz Team Servers:
URI: https://jazzadmin2.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: 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


Thanks & regards,
Tushar.

5 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Elisabeth Carbone (616●10●8) | answered Mar 26 '09, 8:30 a.m.
JAZZ DEVELOPER
Hi Tushar,

on the machine where you have the Jazz CQ Connector installed you must have a CQ installation as well. Do you have a connection TEST_ENV where you have a db called BGTRK ?

Could you share the cqconnector.properties file with us ?

KR,
Elisabeth
0
permanent link
Tushar Parate (36●9●2) | answered Mar 27 '09, 2:39 a.m.
Hi Tushar,

on the machine where you have the Jazz CQ Connector installed you must have a CQ installation as well. Do you have a connection TEST_ENV where you have a db called BGTRK?

Could you share the cqconnector.properties file with us ?

KR,
Elisabeth


Hi Elisabeth,
Yes, I have installed the CQ Installation too on the same machine.
We have a connection TEST_ENV and BGTRK Db.

Here is the cqconnector.properties:
com.ibm.rational.interop.pollingPeriod=60
cq.dbSetDbName=TEST_ENV/BGTRK
cq.userid=tuparate@in.ibm.com
cq.password=<password>
com.ibm.team.uris=https://tuparate%40in.ibm.com:<password>@9.124.36.118:9443/jazz
cq.queryTreeRoot=Public Queries/JazzConnector
0
permanent link
Richard Piazza (381) | answered Mar 27 '09, 9:25 a.m.
JAZZ DEVELOPER
Hi Tushar,

Can you send the gateway log?

Rich Piazza
Jazz CQ Connector team
0
permanent link
Tushar Parate (36●9●2) | answered Mar 30 '09, 5:09 a.m.
Hi Tushar,

Can you send the gateway log?

Rich Piazza
Jazz CQ Connector team



Hi Rich,
Here is the gateway log:

Log:
26 Mar 2009 15:46:54,062 INFO com.ibm.rational.interop.level2 - temp dir is: C:\IBM\JazzCQConnector\gateway\tomcat\temp\interop
26 Mar 2009 15:46:54,375 DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: jazzadmin2.in.ibm.com(9443)
26 Mar 2009 15:46:54,390 DEBUG com.ibm.rational.interop.level1 - Logging in as tuparate@in.ibm.com
26 Mar 2009 15:46:58,250 DEBUG com.ibm.rational.interop.level2 - Got connection at 0 for CQ Interop Polling
26 Mar 2009 15:46:59,234 DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: BALTIC_MR1.D070529
26 Mar 2009 15:46:59,234 DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 701
26 Mar 2009 15:46:59,234 DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
26 Mar 2009 15:46:59,234 DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
26 Mar 2009 15:46:59,281 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for TEST_ENV/BGTRK login: tuparate@in.ibm.com
26 Mar 2009 15:47:12,609 DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for TEST_ENV/BGTRK thread name: CQ Interop Polling
26 Mar 2009 15:47:12,609 DEBUG com.ibm.rational.interop.level2 - Allocating CQ Interop handler at 0
26 Mar 2009 15:47:12,609 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-TEST_ENV/BGTRK-CQ Interop Polling
26 Mar 2009 15:47:20,046 DEBUG com.ibm.rational.interop.level2 - Number of record types: 24
26 Mar 2009 15:47:20,203 DEBUG com.ibm.rational.interop.level2 - Processed (1) JazzConnectorProperties
26 Mar 2009 15:47:20,281 DEBUG com.ibm.rational.interop.level2 - Processed (2) UCM_Project
26 Mar 2009 15:47:20,968 DEBUG com.ibm.rational.interop.level2 - Processed (3) users
26 Mar 2009 15:47:21,015 DEBUG com.ibm.rational.interop.level2 - Processed (4) DepDrop
26 Mar 2009 15:47:21,062 DEBUG com.ibm.rational.interop.level2 - Processed (5) groups
26 Mar 2009 15:47:21,140 DEBUG com.ibm.rational.interop.level2 - Processed (6) JazzConnectorChangeEvents
26 Mar 2009 15:47:21,203 DEBUG com.ibm.rational.interop.level2 - Processed (7) MastershipRoutingRule
26 Mar 2009 15:47:21,328 DEBUG com.ibm.rational.interop.level2 - modify order is: []
26 Mar 2009 15:47:21,343 DEBUG com.ibm.rational.interop.level2 - submit order is: []
26 Mar 2009 15:47:21,468 DEBUG com.ibm.rational.interop.level2 - Processed (8) part
26 Mar 2009 15:47:21,515 DEBUG com.ibm.rational.interop.level2 - Processed (9) BaseCMActivity
26 Mar 2009 15:47:21,625 DEBUG com.ibm.rational.interop.level2 - Processed (10) attachments
26 Mar 2009 15:47:21,671 DEBUG com.ibm.rational.interop.level2 - Processed (11) UCMUtilityActivity
26 Mar 2009 15:47:21,703 DEBUG com.ibm.rational.interop.level2 - Processed (12) JazzConnectorSyncHistory
26 Mar 2009 15:47:21,734 DEBUG com.ibm.rational.interop.level2 - Processed (13) JazzConnectorQueryInfo
26 Mar 2009 15:47:21,765 DEBUG com.ibm.rational.interop.level2 - Processed (14) ratl_replicas
26 Mar 2009 15:47:21,781 DEBUG com.ibm.rational.interop.level2 - Processed (15) _ratl_data_code_page
26 Mar 2009 15:47:21,812 DEBUG com.ibm.rational.interop.level2 - Processed (16) Template
26 Mar 2009 15:47:21,921 DEBUG com.ibm.rational.interop.level2 - Processed (17) PTF
26 Mar 2009 15:47:22,062 DEBUG com.ibm.rational.interop.level2 - Processed (18) APAR
26 Mar 2009 15:47:22,156 DEBUG com.ibm.rational.interop.level2 - Processed (19) Locales
26 Mar 2009 15:48:23,828 DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: jazzadmin2.in.ibm.com(9443)
26 Mar 2009 15:48:23,828 DEBUG com.ibm.rational.interop.level1 - Logging in as tuparate@in.ibm.com
26 Mar 2009 15:48:23,843 INFO com.ibm.rational.interop.level2 - temp dir is: C:\IBM\JazzCQConnector\gateway\tomcat\temp\interop
26 Mar 2009 15:48:25,218 DEBUG com.ibm.rational.interop.level2 - Got connection at 0 for CQ Interop Polling
26 Mar 2009 15:48:25,546 DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: BALTIC_MR1.D070529
26 Mar 2009 15:48:25,546 DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 701
26 Mar 2009 15:48:25,546 DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
26 Mar 2009 15:48:25,546 DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
26 Mar 2009 15:48:25,593 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for TEST_ENV/BGTRK login: tuparate@in.ibm.com
26 Mar 2009 15:48:31,109 DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for TEST_ENV/BGTRK thread name: CQ Interop Polling
26 Mar 2009 15:48:31,109 DEBUG com.ibm.rational.interop.level2 - Allocating CQ Interop handler at 0
26 Mar 2009 15:48:31,109 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-TEST_ENV/BGTRK-CQ Interop Polling
26 Mar 2009 15:48:37,640 DEBUG com.ibm.rational.interop.level2 - Number of record types: 24
26 Mar 2009 15:48:37,718 DEBUG com.ibm.rational.interop.level2 - Processed (1) JazzConnectorProperties
26 Mar 2009 15:48:37,796 DEBUG com.ibm.rational.interop.level2 - Processed (2) UCM_Project
26 Mar 2009 15:48:38,453 DEBUG com.ibm.rational.interop.level2 - Processed (3) users
26 Mar 2009 15:48:38,562 DEBUG com.ibm.rational.interop.level2 - Processed (4) DepDrop
26 Mar 2009 15:48:38,593 DEBUG com.ibm.rational.interop.level2 - Processed (5) groups
26 Mar 2009 15:48:38,656 DEBUG com.ibm.rational.interop.level2 - Processed (6) JazzConnectorChangeEvents
26 Mar 2009 15:48:38,781 DEBUG com.ibm.rational.interop.level2 - Processed (7) MastershipRoutingRule
26 Mar 2009 15:48:38,890 DEBUG com.ibm.rational.interop.level2 - modify order is: []
26 Mar 2009 15:48:38,906 DEBUG com.ibm.rational.interop.level2 - submit order is: []
26 Mar 2009 15:48:39,015 DEBUG com.ibm.rational.interop.level2 - Processed (8) part
26 Mar 2009 15:48:39,062 DEBUG com.ibm.rational.interop.level2 - Processed (9) BaseCMActivity
26 Mar 2009 15:48:39,171 DEBUG com.ibm.rational.interop.level2 - Processed (10) attachments
26 Mar 2009 15:48:39,234 DEBUG com.ibm.rational.interop.level2 - Processed (11) UCMUtilityActivity
26 Mar 2009 15:48:39,281 DEBUG com.ibm.rational.interop.level2 - Processed (12) JazzConnectorSyncHistory
26 Mar 2009 15:48:39,375 DEBUG com.ibm.rational.interop.level2 - Processed (13) JazzConnectorQueryInfo
26 Mar 2009 15:48:39,406 DEBUG com.ibm.rational.interop.level2 - Processed (14) ratl_replicas
26 Mar 2009 15:48:39,421 DEBUG com.ibm.rational.interop.level2 - Processed (15) _ratl_data_code_page
26 Mar 2009 15:48:39,453 DEBUG com.ibm.rational.interop.level2 - Processed (16) Template
26 Mar 2009 15:48:39,500 DEBUG com.ibm.rational.interop.level2 - Processed (17) PTF
26 Mar 2009 15:48:39,718 DEBUG com.ibm.rational.interop.level2 - Processed (18) APAR
26 Mar 2009 15:48:39,750 DEBUG com.ibm.rational.interop.level2 - Processed (19) Locales
26 Mar 2009 17:16:17,531 INFO com.ibm.rational.interop.level1 - Stopping CQ Interop Polling Thread
26 Mar 2009 17:16:43,703 INFO com.ibm.rational.interop.level2 - temp dir is: C:\IBM\JazzCQConnector\gateway\tomcat\temp\interop
26 Mar 2009 17:16:43,750 DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: 9.124.36.118(9443)
26 Mar 2009 17:16:43,750 DEBUG com.ibm.rational.interop.level1 - Logging in as tuparate@in.ibm.com
26 Mar 2009 17:16:45,078 DEBUG com.ibm.rational.interop.level2 - Got connection at 0 for CQ Interop Polling
26 Mar 2009 17:16:45,484 DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: BALTIC_MR1.D070529
26 Mar 2009 17:16:45,484 DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 701
26 Mar 2009 17:16:45,484 DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
26 Mar 2009 17:16:45,500 DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
26 Mar 2009 17:16:45,562 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for TEST_ENV/BGTRK login: tuparate@in.ibm.com
26 Mar 2009 17:16:52,984 DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for TEST_ENV/BGTRK thread name: CQ Interop Polling
26 Mar 2009 17:16:52,984 DEBUG com.ibm.rational.interop.level2 - Allocating CQ Interop handler at 0
26 Mar 2009 17:16:52,984 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-TEST_ENV/BGTRK-CQ Interop Polling
26 Mar 2009 17:16:59,625 DEBUG com.ibm.rational.interop.level2 - Number of record types: 24
26 Mar 2009 17:16:59,687 DEBUG com.ibm.rational.interop.level2 - Processed (1) JazzConnectorProperties
26 Mar 2009 17:16:59,828 DEBUG com.ibm.rational.interop.level2 - Processed (2) UCM_Project
26 Mar 2009 17:17:00,468 DEBUG com.ibm.rational.interop.level2 - Processed (3) users
26 Mar 2009 17:17:00,515 DEBUG com.ibm.rational.interop.level2 - Processed (4) DepDrop
26 Mar 2009 17:17:00,546 DEBUG com.ibm.rational.interop.level2 - Processed (5) groups
26 Mar 2009 17:17:00,578 DEBUG com.ibm.rational.interop.level2 - Processed (6) JazzConnectorChangeEvents
26 Mar 2009 17:17:00,734 DEBUG com.ibm.rational.interop.level2 - Processed (7) MastershipRoutingRule
26 Mar 2009 17:17:00,828 DEBUG com.ibm.rational.interop.level2 - modify order is: []
26 Mar 2009 17:17:00,843 DEBUG com.ibm.rational.interop.level2 - submit order is: []
26 Mar 2009 17:17:00,937 DEBUG com.ibm.rational.interop.level2 - Processed (8) part
26 Mar 2009 17:17:00,968 DEBUG com.ibm.rational.interop.level2 - Processed (9) BaseCMActivity
26 Mar 2009 17:17:01,093 DEBUG com.ibm.rational.interop.level2 - Processed (10) attachments
26 Mar 2009 17:17:01,125 DEBUG com.ibm.rational.interop.level2 - Processed (11) UCMUtilityActivity
26 Mar 2009 17:17:01,218 DEBUG com.ibm.rational.interop.level2 - Processed (12) JazzConnectorSyncHistory
26 Mar 2009 17:17:01,250 DEBUG com.ibm.rational.interop.level2 - Processed (13) JazzConnectorQueryInfo
26 Mar 2009 17:17:01,328 DEBUG com.ibm.rational.interop.level2 - Processed (14) ratl_replicas
26 Mar 2009 17:17:01,359 DEBUG com.ibm.rational.interop.level2 - Processed (15) _ratl_data_code_page
26 Mar 2009 17:17:01,375 DEBUG com.ibm.rational.interop.level2 - Processed (16) Template
26 Mar 2009 17:17:01,484 DEBUG com.ibm.rational.interop.level2 - Processed (17) PTF
26 Mar 2009 17:17:01,671 DEBUG com.ibm.rational.interop.level2 - Processed (18) APAR
26 Mar 2009 17:17:01,703 DEBUG com.ibm.rational.interop.level2 - Processed (19) Locales
0
permanent link
Richard Piazza (381) | answered Mar 30 '09, 1:14 p.m.
JAZZ DEVELOPER
Tushar,

From the log it appears that you have encountered an issue described in work item 65195. I say that because the log indicates that there are 24 record types in the schema, but the gateway never processes any after the 19th.

The cause of this is due to "web dependent fields". Because hooks in your schema can cause ordering issues when specifying fields values on a CQ form, you can specify (using the CQ designer - look in the forms view) the order in which the fields must be assigned values.

If you specify the order in a circular fashion, e.g., a depends upon b, but b depends upon a, the CQ connector will not be able to process the record type.

Check the record types that would have been processed after the 19th one. In other words, there is no issue in 19 of 24 of your record types, so check the other 5.

There is additional information in the work item.

Rich
Jazz CQ Connector team

Your answer

Register or to post 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.