RQM Excel Importer unable to import requirements
Hi,
in a project we tried to to import testcases and requirements with RQM EXCEL IMPORTER. The testcases worked without problems. The requirements are not. Then we tried this in a test enviroment. Same result. After that I tried to import the sample "Requirements 001 using document properties.xls" from the installation into test. Doesn't work. Then I did a download of the CLM 3.0.1.3, installed it local on my laptop, did the configuration. Here I also was unable to import the sample. I thought this should work. Any idea ? Versions CLM 30.0.1.3 Excel 2003 (11.8346.8341) SP3 OS Windows XP SP3 RQMExcelImporter 1.0.4465.14983 Logfile 10/25/2012 11:24:13 AM: Getting artifacts from C:\Program Files\IBM\RQMExcelImporter\Samples\Requirements 001 using document properties.xls 10/25/2012 11:24:13 AM: Created 5 artifacts, sending to server 10/25/2012 11:24:13 AM: sending requirement0 named ID.01 10/25/2012 11:24:13 AM: Error sending to server ID.01 of type requirement 10/25/2012 11:24:13 AM: sending requirement1 named ID.02 10/25/2012 11:24:14 AM: Error sending to server ID.02 of type requirement 10/25/2012 11:24:14 AM: sending requirement2 named ID.03 10/25/2012 11:24:14 AM: Error sending to server ID.03 of type requirement 10/25/2012 11:24:14 AM: sending requirement3 named ID.04 10/25/2012 11:24:14 AM: Error sending to server ID.04 of type requirement 10/25/2012 11:24:14 AM: sending requirement4 named ID.05 10/25/2012 11:24:15 AM: Error sending to server ID.05 of type requirement 10/25/2012 11:24:15 AM: finished writing artifacts |
7 answers
|
Hi Hao,
thanx for your answer. With you hint I found also the document RQMAndRRCIntegrationSetUp [ Main [ TWiki.pdf. With this document I did some configuration. In my local installation I installed the JKE Banking sample project. I checked that my user had full licenses for all 3 tools (RTC, RQM, RRC). The user is JazzAdmin and JazzUser. This user I inserted into RQM -> Advanced Properties -> Requirement. I added the Artefact types Requirement and "Test Plan Collection" to the RRC project. I checked the permissions for "Save Comment", "Save Resource", "Save Type" for role Administrator. Was OK. The user is memeber of the projects (RQM and RRC) and has all roles. No hint in the logfile or import message. So I have no idea about my mistake. Importing "Testsuite with testcases that have testscripts.xls" (I know, no requirements) worked. So user and PW are correct. |
Hi Torsten,
how many RM project areas are associated with the QM project area that used to export the test artifacts? and the following is copied from https://jazz.net/wiki/bin/view/Main/RqmApi When Rational Quality Manager requirements reference resources in Rational Requirements Composer, the following configuration is required:
|
|
Hi Hao,
what I did: 1) Download CLM3.0.1.3 from jazz.net 2) Installed this on my local laptop 3) Did the configuration 4) Created the sample project JKE Banking via .../admin 5) Did the configuration like descripted in RQMAndRRCIntegrationSetUp [ Main [ TWiki.pdf 6) Checked that
com.ibm.rqm.requirement.service.internal.RequirementService
contains my user and PW.
7) Only the sample project is installed. 8) The PA's are connected like installed. For me this seems OK. RM provides requirements for QM. 9) I reinstalled RQMExcelImporter to avoid wrong version. Same Version like before. 10) My user has all roles (JazzAdmin, JazzDWAdmin, JazzProjectManager, JazzUser, JazzGuest) 11) Executing sample "Scripts that create testcases with comments" worked fine 12) Executing sample "Requirements 001" failed. Output from TOMCAT logs 2012-10-29 13:26:30,220 [ http-9443-Processor42] WARN .rqm.requirement.service.rmproxy.util.RMRepository - Das Attribut Priority wurde nicht zum Anforderungstyp in RM hinzugefügt. Die Attributinformationen gehen verloren. 2012-10-29 13:26:30,236 [ http-9443-Processor42] WARN .rqm.requirement.service.rmproxy.util.RMRepository - Die Definition für das Attribut Launch URL wurde nicht in RM gefunden. Die Attributinformationen gehen verloren. 2012-10-29 13:26:30,236 [ http-9443-Processor42] WARN .rqm.requirement.service.rmproxy.util.RMRepository - Die Definition für das Attribut Requirement Type wurde nicht in RM gefunden. Die Attributinformationen gehen verloren. 2012-10-29 13:26:30,252 [ http-9443-Processor42] WARN .rqm.requirement.service.rmproxy.util.RMRepository - Die Definition für das Attribut Package Info wurde nicht in RM gefunden. Die Attributinformationen gehen verloren. 2012-10-29 13:26:30,252 [ http-9443-Processor42] WARN .rqm.requirement.service.rmproxy.util.RMRepository - Die Definition für das Attribut Severity wurde nicht in RM gefunden. Die Attributinformationen gehen verloren. 2012-10-29 13:26:30,252 [ http-9443-Processor42] WARN .rqm.requirement.service.rmproxy.util.RMRepository - Die Definition für das Attribut QM Creation Time wurde nicht in RM gefunden. Die Attributinformationen gehen verloren. 2012-10-29 13:26:30,314 [ http-9443-Processor42] ERROR com.ibm.rqm.oslc.service - Interner Serverfehler com.ibm.team.repository.common.TeamRepositoryException: Das RM-Artefakt kann nicht erstellt werden. at com.ibm.rqm.requirement.service.rmproxy.RmProxyFacade$PrivateRmApiArtifactCreator.create(RmProxyFacade.java:809) at com.ibm.rqm.requirement.service.rmproxy.RmProxyFacade.createRequirement(RmProxyFacade.java:121) at com.ibm.rqm.transactional.handlers.RequirementPutHandler.unmarshalCalmRequirement(RequirementPutHandler.java:342) at com.ibm.rqm.transactional.handlers.RequirementPutHandler.unmarshal(RequirementPutHandler.java:146) at com.ibm.rqm.transactional.handlers.RequirementPutHandler.unmarshal(RequirementPutHandler.java:1) at com.ibm.rqm.integration.handler.AbstractPutHandler.handle(AbstractPutHandler.java:116) at com.ibm.rqm.integration.handler.AbstractPostHandler.handle(AbstractPostHandler.java:48) at com.ibm.rqm.transactional.handlers.RequirementPutHandler.handle(RequirementPutHandler.java:505) at sun.reflect.GeneratedMethodAccessor750.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 $Proxy1702.handle(Unknown Source) at com.ibm.rqm.integration.service.internal.IntegrationService.handleRequest(IntegrationService.java:489) at com.ibm.rqm.integration.service.internal.IntegrationService.perform_PUT(IntegrationService.java:187) at com.ibm.team.repository.service.TeamRawService.service(TeamRawService.java:94) at sun.reflect.GeneratedMethodAccessor745.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 $Proxy1630.service(Unknown Source) at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doRestService(AbstractTeamServerServlet.java:823) at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:1866) at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1725) at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1634) 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:120) at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:76) 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:563) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:420) 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:879) 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) Caused by: java.lang.NullPointerException at org.apache.commons.httpclient.HttpMethodBase.setURI(HttpMethodBase.java:279) at com.ibm.rqm.requirement.service.rmproxy.util.RRCRestClient.createConnection(RRCRestClient.java:184) at com.ibm.rqm.requirement.service.rmproxy.util.RRCRestClient.performPost(RRCRestClient.java:218) at com.ibm.rqm.requirement.service.rmproxy.RmProxyFacade$PrivateRmApiArtifactCreator.create(RmProxyFacade.java:791) ... 53 more Did I miss something ? Is there any possibility to get some more debug output ? Comments Hi Torsten, would you try to create another QM project and RM project (with base template) and linked to each other and have a try again?
|
When trying to import from excel, does the excel importer give you an additional option to select the RM project area?
If not, you may want to uninstall the utility and install the below excel importer and give a try: https://jazz.net/downloads/rational-quality-manager/releases/4.0/RQM-Extras-RQMExcelWordImporter-4.0.zip Hope this helps!! Best Regards Rajat |
|
Hi,
I tried to install RQMExcelImporter 4.0 and 4.0.0.1. Excel did not start the application from the menu. Back to 3.0.1.3 I was able to launch the application. Next I created 2 new projects (RM and QM). Linked them. I was able to create a requirement from RM AND! QM. So that worked. |
|
Excuse me. I was able to create requierements by hand. But the import of requierements is not working.
I am not even able to import the sample requirements that are installed by the importer. |
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.