It's all about the answers!

Ask a question

CQ Gateway starts but not syncing


Mark Parry (31121711) | asked Apr 04 '08, 4:33 p.m.
I'm trying to use the CQ Connector gateway on linux using M5a. The files
were unzipped using the '-a' option as I saw previous posts(or workitem
recommending this). My CQ Schema is the out of the box sample schema
supplied with the connector. Both the schema database (SCHEMADB) and the
user database (USERDB1) are co-located with the CQ Connector gateway.
ClearQuest has been installed on this host and a dbset registered by the
name CQ_CONN. I can use CQ to connect to the database set and create
defects from this host. When I create the defect I do see the name of
the project record I created. Does this need to match anything on the
jazz server?(Project area or team area?) The hostname (as reported by
the hostname command) for this machine is jazztest.rchland.ibm.com.

When the gateway starts I'm seeing the following in the catalina.out log
file.

Apr 3, 2008 2:40:33 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in productio n environments was not found on the java.library.path: /opt/ibm/jazz/connectors/gate way/linux/ibm-java2-i386-50/jre/bin:/opt/ibm/jazz/connectors/gateway/linux/ibm-java2 -i386-50/jre/bin:/opt/ibm/jazz/connectors/gateway/linux/ibm-java2-i386-50/jre/bin/cl assic:/opt/ibm/jazz/connectors/gateway/linux/ibm-java2-i386-50/jre/bin:/opt/rational /c
learquest/linux_x86/shlib:/opt/rational/clearquest/linux_x86/odbc/lib:/usr/lib:/us r/lib
Apr 3, 2008 2:40:33 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8081
Apr 3, 2008 2:40:34 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8444
Apr 3, 2008 2:40:34 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1822 ms
Apr 3, 2008 2:40:34 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 3, 2008 2:40:34 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.20
Apr 3, 2008 2:40:34 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Apr 3, 2008 2:40:35 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive InteropGateway.war
java.net.UnknownHostException: .
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:215)
at java.net.Socket.connect(Socket.java:541)
at java.net.Socket.connect(Socket.java:491)
at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
at sun.net.NetworkClient.openServer(NetworkClient.java:141)
at sun.net.ftp.FtpClient.openServer(FtpClient.java:503)
at sun.net.ftp.FtpClient.openServer(FtpClient.java:490)
at sun.net.www.protocol.ftp.FtpURLConnection.connect(FtpURLConnection.java:2 87)
at sun.net.www.protocol.ftp.FtpURLConnection.getInputStream(FtpURLConnection .java:369)
at java.net.URL.openStream(URL.java:1041)
at com.ibm.rational.connector.cq.teamapi.common.internal.InteropProperties.r eadPropertyFile(InteropProperties.java:37)
at com.ibm.rational.connector.cq.gateway.polling.TimerStartupServlet.init(Ti merStartupServlet.java:48)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java :1105)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.ja va:3951)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4225)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.jav a:759)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310 )
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSup port.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java :64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI mpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)

I'm not sure whats causing it to report the UnkownHostException, usually
this exception lists the host its looking for but this seems to be
listing dot?

My cqconnector.properties file is as follows with passwords obviously
x'd out.

# CQ Connector polling period
com.ibm.rational.interop.pollingPeriod=60

# CQ repository configuration
cq.dbSetDbName=CQ_CONN/usrdb
cq.userid=cqconn
cq.password=XXXXXXXX

# Every CQ record type that will be synched or replicated
# needs to have a cq.query.<recordType> entry whose value
# can be empty which means synch all records of that type
# or the full query path such as Public Queries/My Query
# which will sync records that satisfy the query.
cq.query.Defect=
cq.query.Project=
cq.query.users=

# Uri should be in the following format: http://@]hostname
com.ibm.team.uris=http://cqconn:XXXXXXXX@localhost:9080/jazz

The Gateway appears to start as if I goto test page I do see the
"Welcome to the Jazz CQ Connector Gateway!" message.

I did import the sync rules to my jazz repo and created a external repo
connection point to the host that has the cq gateway on it. To verify
I've copy/pasted the url from the external repo definition into a
browser and I do see the "Welcome to the Jazz CQ Connector Gateway!"
message. I also enabled the outgoing sync capabilites on the Jazz server
via the admin web interface. For safe measures I also restarted the jazz
server following that.

I've also double/triple checked that the User Record in CQ maps
correctly to the user in jazz for the connector. Meaning that the CQ
Login, Name, and E-mail fields are exactly the same as the Jazz User Id,
Name, and email fields.

At this point I'm not sure where to look for additional debug
information. Any additional insight?

--Mark

7 answers



permanent link
Richard Piazza (381) | answered Apr 07 '08, 9:11 a.m.
JAZZ DEVELOPER
Hi Mark,

Can you look at the server.startup file to see how
the cqconnector.properties file is being specified.

Did you change it? I ask because I see that it is trying
to use the ftp protocol. This may be a "red-herring",
but the gateway can't work without reading the properties
file.

Here is a snippet from the stack trace you included:

at sun.net.ftp.FtpClient.openServer(FtpClient.java:490)
at sun.net.www.protocol.ftp.FtpURLConnection.connect(FtpURLConnection.java:2 87)
at sun.net.www.protocol.ftp.FtpURLConnection.getInputStream(FtpURLConnection .java:369)
at java.net.URL.openStream(URL.java:1041)
at com.ibm.rational.connector.cq.teamapi.common.internal.InteropProperties.r eadPropertyFile(InteropProperties.java:37)

Rich Piazza
Jazz CQ Connector Team

permanent link
Mark Parry (31121711) | answered Apr 07 '08, 10:50 a.m.
rpiazza wrote:
Hi Mark,

Can you look at the server.startup file to see how
the cqconnector.properties file is being specified.

Did you change it? I ask because I see that it is trying
to use the ftp protocol. This may be a "red-herring",
but the gateway can't work without reading the properties
file.

Here is a snippet from the stack trace you included:

at sun.net.ftp.FtpClient.openServer(FtpClient.java:490)
at
sun.net.www.protocol.ftp.FtpURLConnection.connect(FtpURLConnection.java:2
87)
at
sun.net.www.protocol.ftp.FtpURLConnection.getInputStream(FtpURLConnection
java:369)
at java.net.URL.openStream(URL.java:1041)
at
com.ibm.rational.connector.cq.teamapi.common.internal.InteropProperties.r
eadPropertyFile(InteropProperties.java:37)

Rich Piazza
Jazz CQ Connector Team


Hey Rich,
Yeah, In M5 there didn't appear to linux startup scripts ( I see they
might be with M6) so I wrote my own based on the windows version. Looks
like I had a type-o on the export for cqconnector.properties version.
Now I'm seeing the following in the log...

INFO: Deploying web application archive InteropGateway.war
09:55:53,688 ERROR com.ibm.rational.interop.level1
- Couldn't start interop polling:
com.ibm.team.interop.service.managers.clearquest.common.InteropException: Couldn
't get CQ DB info
at com.ibm.rational.connector.cq.common.cqgateway.CQRepository.initializ
eRepoInfo(CQRepository.java:97)
at com.ibm.rational.connector.cq.common.cqgateway.CQRepository.<init>(CQ
Repository.java:33)
at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.connectToRep
ositoryLocal(CQGateway.java:80)
at com.ibm.rational.connector.cq.gateway.CQInteropPollingManager.addCQRe
pository(CQInteropPollingManager.java:670)
at com.ibm.rational.connector.cq.gateway.CQInteropPollingManager.initial
ize(CQInteropPollingManager.java:772)
at com.ibm.rational.connector.cq.gateway.polling.PollingThread.pollingIn
coming(PollingThread.java:44)
at com.ibm.rational.connector.cq.gateway.polling.PollingThread.run(Polli
ngThread.java:31)
Caused by:
com.ibm.team.interop.service.managers.clearquest.common.InteropException: Couldn
't get CQ version
at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.getCQV
ersionInfo(CqObjectFactory.java:99)
at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.getImp
lementation(CqObjectFactory.java:106)
at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.create
CqProvider(CqObjectFactory.java:286)
at com.ibm.rational.connector.cq.common.cqgateway.CQInteropEventHandler.
connect(CQInteropEventHandler.java:68)
at com.ibm.rational.connector.cq.common.cqgateway.CQInteropEventHandler.
init>(CQInteropEventHandler.java:51)
at com.ibm.rational.connector.cq.common.cqgateway.CQRepository.getHandle
r(CQRepository.java:140)
at com.ibm.rational.connector.cq.common.cqgateway.CQRepository.initializ
eRepoInfo(CQRepository.java:90)
... 6 more
Caused by:
com.ibm.team.interop.service.managers.clearquest.common.InteropException: Illega
l version combination: cqprovider version 7011-IFIX01; cm api version 701
at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.determ
ineGatewayVersion(CqObjectFactory.java:59)
at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.getCQV
ersionInfo(CqObjectFactory.java:91)
... 12 more

Which seems to indicate a problem with the CQ install itself?

--Mark

permanent link
Richard Piazza (381) | answered Apr 07 '08, 11:11 a.m.
JAZZ DEVELOPER
Hi Mark,

First, no big deal, but please use the forum so others can take advantage of our discussion :-)

What version of the Connector are you using? M6 should handle any version of CQ (after 7.0.1), and Linux! Additionally, the gateway startup script does some environment preparation, so you should use the one in the zip file (Starting in M6 the cq core jar file used by the gateway is the one installed the machine where the gateway runs)

Rich Piazza
Jazz CQ Connector Team

---------------------------------------------------------
From Mark via email:

Hey Rich,
Yeah, In M5 there didn't appear to linux startup scripts ( I see they
might be with M6) so I wrote my own based on the windows version. Looks
like I had a type-o on the export for cqconnector.properties version.
Now I'm seeing the following in the log...

> INFO: Deploying web application archive InteropGateway.war
> 09:55:53,688 ERROR com.ibm.rational.interop.level1
> - Couldn't start interop polling:
> com.ibm.team.interop.service.managers.clearquest.common.InteropException: Couldn
> 't get CQ DB info
> at com.ibm.rational.connector.cq.common.cqgateway.CQRepository.initializ
> eRepoInfo(CQRepository.java:97)
> at com.ibm.rational.connector.cq.common.cqgateway.CQRepository.<init>(CQ
> Repository.java:33)
> at com.ibm.rational.connector.cq.common.cqgateway.CQGateway.connectToRep
> ositoryLocal(CQGateway.java:80)
> at com.ibm.rational.connector.cq.gateway.CQInteropPollingManager.addCQRe
> pository(CQInteropPollingManager.java:670)
> at com.ibm.rational.connector.cq.gateway.CQInteropPollingManager.initial
> ize(CQInteropPollingManager.java:772)
> at com.ibm.rational.connector.cq.gateway.polling.PollingThread.pollingIn
> coming(PollingThread.java:44)
> at com.ibm.rational.connector.cq.gateway.polling.PollingThread.run(Polli
> ngThread.java:31)
> Caused by:
> com.ibm.team.interop.service.managers.clearquest.common.InteropException: Couldn
> 't get CQ version
> at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.getCQV
> ersionInfo(CqObjectFactory.java:99)
> at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.getImp
> lementation(CqObjectFactory.java:106)
> at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.create
> CqProvider(CqObjectFactory.java:286)
> at com.ibm.rational.connector.cq.common.cqgateway.CQInteropEventHandler.
> connect(CQInteropEventHandler.java:68)
> at com.ibm.rational.connector.cq.common.cqgateway.CQInteropEventHandler.
> <init>(CQInteropEventHandler.java:51)
> at com.ibm.rational.connector.cq.common.cqgateway.CQRepository.getHandle
> r(CQRepository.java:140)
> at com.ibm.rational.connector.cq.common.cqgateway.CQRepository.initializ
> eRepoInfo(CQRepository.java:90)
> ... 6 more
> Caused by:
> com.ibm.team.interop.service.managers.clearquest.common.InteropException: Illega
> l version combination: cqprovider version 7011-IFIX01; cm api version 701
> at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.determ
> ineGatewayVersion(CqObjectFactory.java:59)
> at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.getCQV
> ersionInfo(CqObjectFactory.java:91)
> ... 12 more

Which seems to indicate a problem with the CQ install itself? :D :) :)

permanent link
Mark Parry (31121711) | answered Apr 07 '08, 12:43 p.m.
rpiazza wrote:
Hi Mark,

First, no big deal, but please use the forum so others can take
advantage of our discussion :-)

What version of the Connector are you using? M6 should handle any
version of CQ (after 7.0.1), and Linux! Additionally, the gateway
startup script does some environment preparation, so you should use
the one in the zip file (Starting in M6 the cq core jar file used by
the gateway is the one installed the machine where the gateway runs)

Rich Piazza
Jazz CQ Connector Team

---------------------------------------------------------
From Mark via email:

Hey Rich,
Yeah, In M5 there didn't appear to linux startup scripts ( I see
they
might be with M6) so I wrote my own based on the windows version.
Looks
like I had a type-o on the export for cqconnector.properties version.

Now I'm seeing the following in the log...

INFO: Deploying web application archive InteropGateway.war
09:55:53,688 ERROR
com.ibm.rational.interop.level1
- Couldn't start interop polling:

com.ibm.team.interop.service.managers.clearquest.common.InteropException:
Couldn
't get CQ DB info
at
com.ibm.rational.connector.cq.common.cqgateway.CQRepository.initializ
eRepoInfo(CQRepository.java:97)
at
com.ibm.rational.connector.cq.common.cqgateway.CQRepository.<init>(CQ
Repository.java:33)
at
com.ibm.rational.connector.cq.common.cqgateway.CQGateway.connectToRep
ositoryLocal(CQGateway.java:80)
at
com.ibm.rational.connector.cq.gateway.CQInteropPollingManager.addCQRe
pository(CQInteropPollingManager.java:670)
at
com.ibm.rational.connector.cq.gateway.CQInteropPollingManager.initial
ize(CQInteropPollingManager.java:772)
at
com.ibm.rational.connector.cq.gateway.polling.PollingThread.pollingIn
coming(PollingThread.java:44)
at
com.ibm.rational.connector.cq.gateway.polling.PollingThread.run(Polli
ngThread.java:31)
Caused by:

com.ibm.team.interop.service.managers.clearquest.common.InteropException:
Couldn
't get CQ version
at
com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.getCQV
ersionInfo(CqObjectFactory.java:99)
at
com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.getImp
lementation(CqObjectFactory.java:106)
at
com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.create
CqProvider(CqObjectFactory.java:286)
at
com.ibm.rational.connector.cq.common.cqgateway.CQInteropEventHandler.
connect(CQInteropEventHandler.java:68)
at
com.ibm.rational.connector.cq.common.cqgateway.CQInteropEventHandler.
init>(CQInteropEventHandler.java:51)
at
com.ibm.rational.connector.cq.common.cqgateway.CQRepository.getHandle
r(CQRepository.java:140)
at
com.ibm.rational.connector.cq.common.cqgateway.CQRepository.initializ
eRepoInfo(CQRepository.java:90)
... 6 more
Caused by:

com.ibm.team.interop.service.managers.clearquest.common.InteropException:
Illega
l version combination: cqprovider version 7011-IFIX01; cm api
version 701
at
com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.determ
ineGatewayVersion(CqObjectFactory.java:59)
at
com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.getCQV
ersionInfo(CqObjectFactory.java:91)
... 12 more

Which seems to indicate a problem with the CQ install itself? :D :)
:)


I took a peek at the M6 startup script, the only difference I could see
was the copying of the cqjni.jar to the tomcat shared library directory
and the setting of the LD_LIBRARY_PATH. So I modified my startup script
for M5a to set the LD_LIBRARY_PATH and then copyied that file manually.
I then restarted the server, but I'm still seeing the following in the
log files:

com.ibm.team.interop.service.managers.clearquest.common.InteropException: Illegal version combination: cqprovider version
7011-IFIX01; cm api version 701
at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.determineGatewayVersion(CqObjectFactory.java:59)
at com.ibm.rational.connector.cq.common.cqgateway.CqObjectFactory.getCQVersionInfo(CqObjectFactory.java:91)
... 12 more

Unfortunately I can't upgrade the environment to M6 until middle of next
week. Just in case I did miss something here is the script that I wrote.
#!/bin/bash
export TZ=CST6CDT
export CQ_HOME=/opt/rational/clearquest
. $CQ_HOME/cq_setup.sh
export LD_LIBRARY_PATH=$CQ_HOME/linux_x86/shlib:$CQ_HOME/linux_x86/odbc/lib
export JRE_HOME=./linux/ibm-java2-i386-50/jre
export CATALINA_HOME=./tomcat
export CATALINA_OPTS="-Dlog4j.configuration=./log4j.properties -Dcom.ibm.rational.interop.gateway.configURL="file:///opt/IBM/jazz/connectors/gateway/cqconnector.properties""
export JAVA_OPTS=-Xmx700M
env
$CATALINA_HOME/bin/startup.sh

permanent link
Richard Piazza (381) | answered Apr 07 '08, 2:27 p.m.
JAZZ DEVELOPER
M6 additionally has a fix to the code that compares the versions. Those two versions are compatible, but M5a can't determine it

:-(

permanent link
Mark Parry (31121711) | answered Apr 07 '08, 2:34 p.m.
rpiazza wrote:
M6 additionally has a fix to the code that compares the versions.
Those two versions are compatible, but M5a can't determine it

:-(


I'm guessing given the frown, that the M6 connector prolly shouldn't be
used with a M5a repo?

--Mark

permanent link
Richard Piazza (381) | answered Apr 07 '08, 2:50 p.m.
JAZZ DEVELOPER
As a rule, it is a bad idea to use a jazz repo from one version in a different version. On the other hand, you can make use of the repotools to upgrade your jazz repo from M5a to M6.

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.