It's all about the answers!

Ask a question

java.lang.RuntimeException: A CQ database was not specified


Tushar Parate (3692) | asked Apr 06 '09, 3:24 a.m.
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



permanent link
Ralph Schoon (63.1k33645) | 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:
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

permanent link
Tushar Parate (3692) | answered Apr 06 '09, 3:25 a.m.
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

permanent link
Tushar Parate (3692) | answered Apr 06 '09, 5:02 a.m.
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?

permanent link
John Vasta (2.6k15) | answered Apr 07 '09, 10:45 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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?

permanent link
Richard Piazza (381) | answered Apr 07 '09, 10:47 a.m.
JAZZ DEVELOPER
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


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.