It's all about the answers!

Ask a question

ExcelImporter validate the connection to RQM


Magnus Klöker (2622) | asked Feb 18 '11, 6:40 a.m.
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

One answer



permanent link
Paul Slauenwhite (8.4k12) | answered Oct 24 '14, 11:02 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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).

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.