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) |
5 answers
Ralph Schoon (63.1k●3●36●45)
| answered Apr 06 '09, 3:24 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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 CQ Database Information: |
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 |
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? |
Not sure why this error mesg in log: 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? |
Tushar,
Two things: 1. Can you you open up a work item for the ssl error, and attach the whole log file. 2. Is the ssl issue related to the gateway initialization issue? Rich Jazz CQ 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.