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

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

0 votes



7 answers

Permanent link
Hi Torsten,
have you set the correct RM username and password in RQM admin page - > advance properties

0 votes

Comments

that is
Requirements Composer User Name
and
Requirements Composer User Password


Permanent link
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.

0 votes


Permanent link
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:

  1. The Quality Management project area in Rational Quality Manager must have a "uses and requirements" association to a Requirements Management project area in Rational Requirements Composer. Note, multiple Quality Management project areas can be associated with a single Requirements Management project area.
  2. Set the following Requirement ( com.ibm.rqm.requirement.service.internal.RequirementService ) advanced server configuration properties (see Configuring advanced properties in the Collaborative Lifecycle Management Online Help):

  • Requirements Composer User Name
  • Requirements Composer User Password

0 votes


Permanent link
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 ?

0 votes

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?
and in RQM Excel Importer 3.x, it used REST API to create requirment,
you can also try with the RQM excel Importer 4.0, which use OSLC API to create requirement artifact.


Permanent link
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

0 votes


Permanent link
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. 
 

0 votes

Comments

Hi Torsten,
you can accept the answer if you feel it works for you , thank you.


Permanent link
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.


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: Oct 25 '12, 5:39 a.m.

Question was seen: 6,479 times

Last updated: Nov 05 '12, 7:47 a.m.

Confirmation Cancel Confirm