Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

ExcelImporter validate the connection to RQM

Hello,

if i validate the Connection of RQMExcelImporter to RQM Server, than i got the following exception
11:40:03,164 DEBUG sqlTxLogger - ConnectionStatWrapper(type 3, 5968988, dirty: true, b(18961896)) sql => select t1.ITEM_ID, t1.STATE_ID from SEQUENCER.SCHEDULED_SEQUENCE t1 where (t1.SCHEDULE_START <11> 1 ms
11:40:03,165 DEBUG sqlTxLogger - result set processing time => 0 ms -- rows processed => 0
11:40:03,165 DEBUG ository.service.internal.RdbRepositoryDataMediator - --> query read took: 1
11:40:03,165 DEBUG ository.service.internal.RdbRepositoryDataMediator - -- end queryData
11:40:03,165 DEBUG ository.service.internal.RdbRepositoryDataMediator - -- end queryData
11:40:03,165 DEBUG repository.service.internal.rdb.RepositoryDatabase - CRJAZ0543I >>TX>> Completing com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$ReadTransaction on: 1435325837
11:40:03,165 DEBUG repository.service.internal.rdb.RepositoryDatabase - >>>>>>>>>>>>>>>>>>REPO ROLLBACK<<<<<<<<<<<<<<<<<<<<<<
11:40:03,166 DEBUG sqlTxLogger - com.ibm.db2.jcc.t4.b@18961896 ROLLBACK
11:40:03,166 INFO com.ibm.team.repository.service.internal.scheduler - CRJAZ0868I Scheduling the task "ScheduledExecutionScanner" contributed by component "com.ibm.rational.test.lm.sequencer" for execution with a fixed delay of 30 seconds.
11:40:03,184 INFO com.ibm.team.repository.service.internal.scheduler - CRJAZ0858I Completing the asynchronous task "com.ibm.rational.test.lm.sequencer.ScheduledExecutionScanner".
11:40:14,610 DEBUG eam.repository.service.internal.ContributorService - ContributorService#fetchContributorItemIdByUserId() returning ItemID: for userId kloekerm
11:40:14,610 DEBUG .ibm.rqm.integration.service.IntegrationServiceURI - invalid URI
java.util.NoSuchElementException
at java.util.StringTokenizer.nextToken(StringTokenizer.java:347)
at com.ibm.rqm.integration.service.IntegrationServiceURI.parse(IntegrationServiceURI.java:167)
at com.ibm.rqm.integration.service.internal.IntegrationService.handleRequest(IntegrationService.java:366)
at com.ibm.rqm.integration.service.internal.IntegrationService.perform_GET(IntegrationService.java:173)
at com.ibm.team.repository.service.TeamRawService.service(TeamRawService.java:82)
at sun.reflect.GeneratedMethodAccessor362.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy455.service(Unknown Source)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doRestService(AbstractTeamServerServlet.java:879)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:1768)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1642)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1555)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:121)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
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:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
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:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873)
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:689)
at java.lang.Thread.run(Thread.java:811)
11:40:14,611 DEBUG com.ibm.rqm.integration.service - class com.ibm.rqm.integration.service.internal.IntegrationService method: handleRequest INVALID_REQUEST_INFO Exception: com.ibm.rqm.integration.common.IntegrationServiceURIException: Internal error
11:40:14,611 DEBUG rqm.rest.performance.log - 73,unknown,IntegrationService.perform_GET,1
11:40:16,092 DEBUG eam.repository.service.internal.ContributorService - ContributorService#fetchContributorItemIdByUserId() returning ItemID: for userId kloekerm
11:40:16,092 DEBUG .ibm.rqm.integration.service.IntegrationServiceURI - invalid URI
java.util.NoSuchElementException
at java.util.StringTokenizer.nextToken(StringTokenizer.java:347)
at com.ibm.rqm.integration.service.IntegrationServiceURI.parse(IntegrationServiceURI.java:167)
at com.ibm.rqm.integration.service.internal.IntegrationService.handleRequest(IntegrationService.java:366)
at com.ibm.rqm.integration.service.internal.IntegrationService.perform_GET(IntegrationService.java:173)
at com.ibm.team.repository.service.TeamRawService.service(TeamRawService.java:82)


What is the reason for this exception?

We use the RQM Version 2.0.1.1 iFix1 and Jazz Server 1.0.0.2 iFix 5.
The apache server runs in a different server environment as the tomcat for RQM.
Apache is running in AGV network and RQM Tomcat is running in MVDI Network. The communication between both server running over port 22 (SSH tunneled) and with AJP protocol. OS is Unix on both server.

Thx and Regards
Magnus

0 votes



One answer

Permanent link
If this is still reproducible, please upgrade RQM (https://jazz.net/downloads/rational-quality-manager/) and RQM Excel/Word Importer (see https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter) and retry this scenario.  If the symptom is still reproducible, please open a PMR (see http://www-01.ibm.com/support/docview.wss?uid=swg21507639).

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Feb 18 '11, 6:40 a.m.

Question was seen: 3,927 times

Last updated: Oct 24 '14, 11:02 a.m.

Confirmation Cancel Confirm