Failed to import requirements with RQMExcelImporter
I'm using the RQMExcelImporter tool to import a list of requirements. When trying to import, I get following error in Mso2Rqm_Debug.log:
10/7/2011 9:54:04 AM: EXCEPTION: : Object reference not set to an instance of an object. 10/7/2011 9:54:04 AM: at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data) at RQMExcelExporter.ExcelExportRepositoryDialog.doExport(IList`1 artifacts) The errors I resolved so far are: - update the admin/admin user/pw in RQM that points to RC to an existing user. If I export the requirements to file, the exported requirement looks fine: (with .txt extension) http://dl.dropbox.com/u/7202246/RQMExcelImporter/ReqID_001.txt Can you give any ideas/suggestions to resolve this issue? Please find below my config file and excel sheet. Config file: //---Requirements All other lines are commented out Excel sheet with requirements: |
20 answers
It appears you created an invalid Test Plan Collection type in RRC. I would suggest looking at the RRC Base Template to see how it's defined. Please continue the discussion on the work-around in defect 58607. Thanks, the import works after adding following 2 requirement types: Requirement Test Plan Collection The problem was that I defined 'Test Plan Collection' as text instead of a collection |
It appears you created an invalid Test Plan Collection type in RRC. I would suggest looking at the RRC Base Template to see how it's defined. Please continue the discussion on the work-around in defect 58607.
|
It appears you are experiencing https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/58607. Thanks for having investigated and raised the defect! I manually added following 2 requirement types: Requirement Test Plan Collection Now, I don't have an error about the 'requirement' type anymore, instead I have an error on the 'Test Plan Collection' type, that I added myself. Here is the log: 2011-11-22 09:29:37,129 [ http-9443-Processor538] WARN .rqm.requirement.service.rmproxy.util.RMRepository - Attribute Source Tag definition not found in RM, the attribute info will lost. Do you have any ideas? Thanks in advance |
It appears you are experiencing https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/58607.
|
The second projectAreas URI in the root services document: I don't have this second URI in the root services document. But when I GET above url with my username and password and the specified headers I get a 401 Unauthorized message <body>Oauth authentication is required... 1) Have you got any idea why this URI is not in the list of root services response? 2) Why do I get the 401 message? Thanks in advance, |
The second projectAreas URI in the root services document:
https://server:port/rm/processProxy?uri=https://server:port/jts/process/project-areas |
There appears to be incomplete data coming from your RM server. 2) Use Poster (https://jazz.net/wiki/bin/view/Main/RQMUsingPoster) to GET the project areas (see projectAreas URI in the root services document). Headers: OSLC-Core-Version = 2.0 Accept = application/rdf+xml Here I get a nullpointer exception if I do a GET on: https:// This is the error: Error 500 3) Use Poster to GET the RM types (https://<RM>:<RM>/<RM>/types?resourceContext=<encoded>) Headers: OSLC-Core-Version = 2.0 Accept = application/rdf+xml DoorsRP-Request-Type = private 4) Post the response RDF/XML. |
There appears to be incomplete data coming from your RM server.
Can you try: 1) Open the root services document in your web browser (https://<RM>:<RM>/<RM>/rootservices). 2) Use Poster (https://jazz.net/wiki/bin/view/Main/RQMUsingPoster) to GET the project areas (see projectAreas URI in the root services document). Headers: OSLC-Core-Version = 2.0 Accept = application/rdf+xml 3) Use Poster to GET the RM types (https://<RM>:<RM>/<RM>/types?resourceContext=<encoded>) Headers: OSLC-Core-Version = 2.0 Accept = application/rdf+xml DoorsRP-Request-Type = private 4) Post the response RDF/XML. |
I was missing the identifier tag. This is my new configuration file:
requirement.XLSStartRow=2 The new error is: 2011-11-03 08:54:07,237 [ http-9443-Processor1150] WARN org.apache.commons.httpclient.HttpMethodDirector - Unable to respond to any of these challenges: {oauth=OAuth realm="Jazz"} What requirement type should I foresee in RM for the imported requirements. Can I specify a requirement type in the import configuration file that maps to an existing requirement type defined in RM? Thanks in advance. A couple of points: |
A couple of points:
-You can confirm RRC username/password by logging into RRC. -You can only set the following properties on requirements using the RQM Excel/Word Importer: https://jazz.net/projects/rational-quality-manager/api-doc-3.0/api-files/schemas/qm_xsd/elements/requirement_2.html -What is the new error message? |
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.