java.lang.RuntimeException: A CQ database was not specified
Hi Team,
I am getting the following exception while connecting the Jazz-CQ:
java.lang.RuntimeException: A CQ database was not specified in the cqconnector.properties file, or it was unreachable
Setup:
1) machine 1: CQ Server installed, Jazz-CQ Gateway
2) Machine 2: Jazz Server (under BSO)
I am able to establish the connection between two machine. I checked the link from both machine.
http://gateway_machine_IP:8081/InteropGateway
Could you please help me to resolve the error.
cqgateway.log;
01 Apr 2009 12:50:44,640 DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: 9.124.36.118(9443)
01 Apr 2009 12:50:44,640 DEBUG com.ibm.rational.interop.level1 - Logging in as tuparate@in.ibm.com
01 Apr 2009 12:50:44,781 INFO com.ibm.rational.interop.level2 - temp dir is: C:\IBM\JazzCQConnector\gateway\tomcat\temp\interop
01 Apr 2009 12:50:45,078 ERROR com.ibm.rational.interop.level1 - Unrecognized SSL message, plaintext connection?
01 Apr 2009 12:50:45,109 DEBUG com.ibm.rational.interop.level2 - Got connection at 0 for CQ Interop Polling
01 Apr 2009 12:50:45,250 DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: BALTIC_MR1.D070529
01 Apr 2009 12:50:45,265 DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 701
01 Apr 2009 12:50:45,265 DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
01 Apr 2009 12:50:45,265 DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
01 Apr 2009 12:50:45,296 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for TEST_ENV/BGTRK login: tuparate@in.ibm.com
01 Apr 2009 12:50:51,281 DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for TEST_ENV/BGTRK thread name: CQ Interop Polling
01 Apr 2009 12:50:51,281 DEBUG com.ibm.rational.interop.level2 - Allocating CQ Interop handler at 0
01 Apr 2009 12:50:51,281 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-TEST_ENV/BGTRK-CQ Interop Polling
01 Apr 2009 12:50:57,859 DEBUG com.ibm.rational.interop.level2 - Number of record types: 24
01 Apr 2009 12:50:57,984 DEBUG com.ibm.rational.interop.level2 - Processed (1) JazzConnectorProperties
01 Apr 2009 12:50:58,093 DEBUG com.ibm.rational.interop.level2 - Processed (2) UCM_Project
01 Apr 2009 12:50:59,078 DEBUG com.ibm.rational.interop.level2 - Processed (3) users
01 Apr 2009 12:50:59,203 DEBUG com.ibm.rational.interop.level2 - Processed (4) DepDrop
01 Apr 2009 12:50:59,234 DEBUG com.ibm.rational.interop.level2 - Processed (5) groups
01 Apr 2009 12:50:59,312 DEBUG com.ibm.rational.interop.level2 - Processed (6) JazzConnectorChangeEvents
01 Apr 2009 12:50:59,406 DEBUG com.ibm.rational.interop.level2 - Processed (7) MastershipRoutingRule
01 Apr 2009 12:50:59,671 DEBUG com.ibm.rational.interop.level2 - modify order is: []
01 Apr 2009 12:50:59,703 DEBUG com.ibm.rational.interop.level2 - submit order is: []
01 Apr 2009 12:50:59,781 DEBUG com.ibm.rational.interop.level2 - Processed (8) part
01 Apr 2009 12:50:59,906 DEBUG com.ibm.rational.interop.level2 - Processed (9) BaseCMActivity
01 Apr 2009 12:51:00,015 DEBUG com.ibm.rational.interop.level2 - Processed (10) attachments
01 Apr 2009 12:51:00,078 DEBUG com.ibm.rational.interop.level2 - Processed (11) UCMUtilityActivity
01 Apr 2009 12:51:00,140 DEBUG com.ibm.rational.interop.level2 - Processed (12) JazzConnectorSyncHistory
01 Apr 2009 12:51:00,250 DEBUG com.ibm.rational.interop.level2 - Processed (13) JazzConnectorQueryInfo
01 Apr 2009 12:51:00,312 DEBUG com.ibm.rational.interop.level2 - Processed (14) ratl_replicas
01 Apr 2009 12:51:00,328 DEBUG com.ibm.rational.interop.level2 - Processed (15) _ratl_data_code_page
01 Apr 2009 12:51:00,359 DEBUG com.ibm.rational.interop.level2 - Processed (16) Template
01 Apr 2009 12:51:00,453 DEBUG com.ibm.rational.interop.level2 - Processed (17) PTF
01 Apr 2009 12:51:00,718 DEBUG com.ibm.rational.interop.level2 - Processed (18) APAR
01 Apr 2009 12:51:00,765 DEBUG com.ibm.rational.interop.level2 - Processed (19) Locales
01 Apr 2009 12:51:30,750 DEBUG com.ibm.rational.interop.level1 - An unexpected exception occurred
java.lang.RuntimeException: A CQ database was not specified in the cqconnector.properties file, or it was unreachable
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getDefaultRepository(CQGateway.java:550)
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getRepoForURL(CQGateway.java:565)
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getSupportedTypeInfo(CQGateway.java:181)
at com.ibm.rational.connector.cq.gateway.servlet.InteropOperationInvoker.invoke(InteropOperationInvoker.java:92)
at com.ibm.rational.connector.cq.gateway.servlet.InteropServlet.doPostInteropOperation(InteropServlet.java:57)
at com.ibm.rational.connector.cq.gateway.servlet.InteropServlet.doPost(InteropServlet.java:251)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:810)
01 Apr 2009 12:51:44,359 DEBUG com.ibm.rational.interop.level1 - An unexpected exception occurred
java.lang.RuntimeException: A CQ database was not specified in the cqconnector.properties file, or it was unreachable
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getDefaultRepository(CQGateway.java:550)
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getRepoForURL(CQGateway.java:565)
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getSupportedTypeInfo(CQGateway.java:181)
at com.ibm.rational.connector.cq.gateway.servlet.InteropOperationInvoker.invoke(InteropOperationInvoker.java:92)
at com.ibm.rational.connector.cq.gateway.servlet.InteropServlet.doPostInteropOperation(InteropServlet.java:57)
at com.ibm.rational.connector.cq.gateway.servlet.InteropServlet.doPost(InteropServlet.java:251)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:810)
I am getting the following exception while connecting the Jazz-CQ:
java.lang.RuntimeException: A CQ database was not specified in the cqconnector.properties file, or it was unreachable
Setup:
1) machine 1: CQ Server installed, Jazz-CQ Gateway
2) Machine 2: Jazz Server (under BSO)
I am able to establish the connection between two machine. I checked the link from both machine.
http://gateway_machine_IP:8081/InteropGateway
Could you please help me to resolve the error.
cqgateway.log;
01 Apr 2009 12:50:44,640 DEBUG com.ibm.rational.interop.level1 - Jazz Interop server is: 9.124.36.118(9443)
01 Apr 2009 12:50:44,640 DEBUG com.ibm.rational.interop.level1 - Logging in as tuparate@in.ibm.com
01 Apr 2009 12:50:44,781 INFO com.ibm.rational.interop.level2 - temp dir is: C:\IBM\JazzCQConnector\gateway\tomcat\temp\interop
01 Apr 2009 12:50:45,078 ERROR com.ibm.rational.interop.level1 - Unrecognized SSL message, plaintext connection?
01 Apr 2009 12:50:45,109 DEBUG com.ibm.rational.interop.level2 - Got connection at 0 for CQ Interop Polling
01 Apr 2009 12:50:45,250 DEBUG com.ibm.rational.interop.level2 - Stage label of CQ: BALTIC_MR1.D070529
01 Apr 2009 12:50:45,265 DEBUG com.ibm.rational.interop.level2 - CQ Provider (JNI) Version is: 701
01 Apr 2009 12:50:45,265 DEBUG com.ibm.rational.interop.level2 - CM API Version is: 71
01 Apr 2009 12:50:45,265 DEBUG com.ibm.rational.interop.level2 - CQ Version Info is: 71
01 Apr 2009 12:50:45,296 DEBUG com.ibm.rational.interop.level2 - Getting Team Provider for TEST_ENV/BGTRK login: tuparate@in.ibm.com
01 Apr 2009 12:50:51,281 DEBUG com.ibm.rational.interop.level2 - Allocating an admin session for TEST_ENV/BGTRK thread name: CQ Interop Polling
01 Apr 2009 12:50:51,281 DEBUG com.ibm.rational.interop.level2 - Allocating CQ Interop handler at 0
01 Apr 2009 12:50:51,281 DEBUG com.ibm.rational.interop.level2 - Using CQInteropEventHandler-TEST_ENV/BGTRK-CQ Interop Polling
01 Apr 2009 12:50:57,859 DEBUG com.ibm.rational.interop.level2 - Number of record types: 24
01 Apr 2009 12:50:57,984 DEBUG com.ibm.rational.interop.level2 - Processed (1) JazzConnectorProperties
01 Apr 2009 12:50:58,093 DEBUG com.ibm.rational.interop.level2 - Processed (2) UCM_Project
01 Apr 2009 12:50:59,078 DEBUG com.ibm.rational.interop.level2 - Processed (3) users
01 Apr 2009 12:50:59,203 DEBUG com.ibm.rational.interop.level2 - Processed (4) DepDrop
01 Apr 2009 12:50:59,234 DEBUG com.ibm.rational.interop.level2 - Processed (5) groups
01 Apr 2009 12:50:59,312 DEBUG com.ibm.rational.interop.level2 - Processed (6) JazzConnectorChangeEvents
01 Apr 2009 12:50:59,406 DEBUG com.ibm.rational.interop.level2 - Processed (7) MastershipRoutingRule
01 Apr 2009 12:50:59,671 DEBUG com.ibm.rational.interop.level2 - modify order is: []
01 Apr 2009 12:50:59,703 DEBUG com.ibm.rational.interop.level2 - submit order is: []
01 Apr 2009 12:50:59,781 DEBUG com.ibm.rational.interop.level2 - Processed (8) part
01 Apr 2009 12:50:59,906 DEBUG com.ibm.rational.interop.level2 - Processed (9) BaseCMActivity
01 Apr 2009 12:51:00,015 DEBUG com.ibm.rational.interop.level2 - Processed (10) attachments
01 Apr 2009 12:51:00,078 DEBUG com.ibm.rational.interop.level2 - Processed (11) UCMUtilityActivity
01 Apr 2009 12:51:00,140 DEBUG com.ibm.rational.interop.level2 - Processed (12) JazzConnectorSyncHistory
01 Apr 2009 12:51:00,250 DEBUG com.ibm.rational.interop.level2 - Processed (13) JazzConnectorQueryInfo
01 Apr 2009 12:51:00,312 DEBUG com.ibm.rational.interop.level2 - Processed (14) ratl_replicas
01 Apr 2009 12:51:00,328 DEBUG com.ibm.rational.interop.level2 - Processed (15) _ratl_data_code_page
01 Apr 2009 12:51:00,359 DEBUG com.ibm.rational.interop.level2 - Processed (16) Template
01 Apr 2009 12:51:00,453 DEBUG com.ibm.rational.interop.level2 - Processed (17) PTF
01 Apr 2009 12:51:00,718 DEBUG com.ibm.rational.interop.level2 - Processed (18) APAR
01 Apr 2009 12:51:00,765 DEBUG com.ibm.rational.interop.level2 - Processed (19) Locales
01 Apr 2009 12:51:30,750 DEBUG com.ibm.rational.interop.level1 - An unexpected exception occurred
java.lang.RuntimeException: A CQ database was not specified in the cqconnector.properties file, or it was unreachable
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getDefaultRepository(CQGateway.java:550)
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getRepoForURL(CQGateway.java:565)
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getSupportedTypeInfo(CQGateway.java:181)
at com.ibm.rational.connector.cq.gateway.servlet.InteropOperationInvoker.invoke(InteropOperationInvoker.java:92)
at com.ibm.rational.connector.cq.gateway.servlet.InteropServlet.doPostInteropOperation(InteropServlet.java:57)
at com.ibm.rational.connector.cq.gateway.servlet.InteropServlet.doPost(InteropServlet.java:251)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:810)
01 Apr 2009 12:51:44,359 DEBUG com.ibm.rational.interop.level1 - An unexpected exception occurred
java.lang.RuntimeException: A CQ database was not specified in the cqconnector.properties file, or it was unreachable
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getDefaultRepository(CQGateway.java:550)
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getRepoForURL(CQGateway.java:565)
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.getSupportedTypeInfo(CQGateway.java:181)
at com.ibm.rational.connector.cq.gateway.servlet.InteropOperationInvoker.invoke(InteropOperationInvoker.java:92)
at com.ibm.rational.connector.cq.gateway.servlet.InteropServlet.doPostInteropOperation(InteropServlet.java:57)
at com.ibm.rational.connector.cq.gateway.servlet.InteropServlet.doPost(InteropServlet.java:251)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:810)
5 answers
Hello tuparate,
please refer to this tech note:
https://jazz.net/learn/LearnItem.jsp?href=content/tech-notes/rational-team-concert-1_0-cc-and-cq-connectors-deployment-guide/index.html
I tried to put my experiences into https://w3.tap.ibm.com/com.ibm.ram/assetDetail/generalDetails.faces?guid=%7bEBA32389-399C-B16A-F45F-3B19F1D8E1CC%7d&v=1.1
There is a section that talks about what we did and where we bumped into
it is however IBM internal.
There are various things one can do wrong setting up the connector. First
of all the cqconnector.properties file needs to be adjusted according to
your setup. This includes the cq database connection and public queries that
need to be available in CQ in order for the connector to work.
Test your setup with: URL http://YOURSERVERNAME:8081/InteropGateway and be
sure to carefully read all the messages I have seen everything appearing
fine but closer investigation showing issues such as licensing etc.
Ralph
please refer to this tech note:
https://jazz.net/learn/LearnItem.jsp?href=content/tech-notes/rational-team-concert-1_0-cc-and-cq-connectors-deployment-guide/index.html
I tried to put my experiences into https://w3.tap.ibm.com/com.ibm.ram/assetDetail/generalDetails.faces?guid=%7bEBA32389-399C-B16A-F45F-3B19F1D8E1CC%7d&v=1.1
There is a section that talks about what we did and where we bumped into
it is however IBM internal.
There are various things one can do wrong setting up the connector. First
of all the cqconnector.properties file needs to be adjusted according to
your setup. This includes the cq database connection and public queries that
need to be available in CQ in order for the connector to work.
Test your setup with: URL http://YOURSERVERNAME:8081/InteropGateway and be
sure to carefully read all the messages I have seen everything appearing
fine but closer investigation showing issues such as licensing etc.
Ralph
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://9.124.36.118: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
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://9.124.36.118: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
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://9.124.36.118: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
Not sure why this error mesg in log:
01 Apr 2009 12:50:45,078 ERROR com.ibm.rational.interop.level1 - Unrecognized SSL message, plaintext connection?
That would indicate that port 9443 of your Jazz server is not configured as an SSL port. Could you have changed your Jazz server configuration?