RQM 3.0 Excel Exporter - can't log in to repository
I just re-installed the Excel Exporter Add-on for Excel and it will not connect to my server repository. I have the correct login and host information and it still gives me an error when I attempt to "Validate". Is there something else that needs to be configured?
|
9 answers
I just re-installed the Excel Exporter Add-on for Excel and it will not connect to my server repository. I have the correct login and host information and it still gives me an error when I attempt to "Validate". Is there something else that needs to be configured? Was able to get logged into the repository, now getting errors on the import. Here is the info from the Mso2Rqm_Debug.log file:7/5/2011 10:57:37 AM: SESSION: 7/5/2011 10:57:37 AM 7/5/2011 10:57:37 AM: Getting artifacts from current document Req_test1.xls 7/5/2011 10:57:37 AM: Created 3 artifacts, sending to server 7/5/2011 10:57:37 AM: sending requirement0 named Req_test1_reqs_1.xml.xml 7/5/2011 10:57:37 AM: ERROR: : RQMConnector: PutToServer - Error putting resource: https://omdc-qatest4:9443/qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Taiored%2bProject%2b1%2b%2528Quality%2bManagement%2529/requirement/Req_test1_reqs_1.xml.xml 7/5/2011 10:57:37 AM: EXCEPTION: : The remote server returned an error: (500) Internal Server Error. 7/5/2011 10:57:37 AM: at System.Net.HttpWebRequest.GetResponse() at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data) 7/5/2011 10:57:37 AM: ERROR: : The remote server returned an error: (500) Internal Server Error. 7/5/2011 10:57:37 AM: Error sending to server Req_test1_reqs_1.xml.xml of type requirement 7/5/2011 10:57:37 AM: ERROR: : ExcelExportRepositoryDialog: Error saving to url https://omdc-qatest4:9443/qm of type requirement 7/5/2011 10:57:37 AM: EXCEPTION: : Object reference not set to an instance of an object. 7/5/2011 10:57:37 AM: at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data) at RQMExcelExporter.ExcelExportRepositoryDialog.doExport(IList`1 artifacts) .cfg file: //---Requirements //Start looking for requirements after row 2 requirement.XLSStartRow=2 //requirement.XLSArtifactID=A requirement.dc:title=B requirement.dc:description=C requirement.jzalm:owner=D //requirement.dc:creator=D |
It would be helpful if you indicate what requirements server you have
integrated with RQM 3.0.1. If it's RRC, my guess is that you may not have configured RQM with a user id and password to access the RRC server with. That is done on the advanced properties page of the qm application. See this link about Requirements Composer User Name and password. http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/topic/com.ibm.rational.test.qm.doc/topics/t_manage_reqs_rm.html |
It would be helpful if you indicate what requirements server you have I can add requirements while in QM via the "create Requirements" menu option, but when I attempt to "Export to Repository" using the "Excel Exporter" and associated sample files, (.cfg and .xls) the test cases get imported fine, but it errors on the requirement importing as indicated above. |
|
RQM 3.0.1 no longer has native requirements support. It will always use
an external requirements system. Out-of-box it uses RRC for this. Most likely that's the case for your RQM project area. An easy way to tell is to do the "View Requirements" action on the main menu and that will take you to the View All Artifacts page of the RM application. You'll notice the URL in the browser change from ../server:port/qm to .../server:port/rm. If that's the case then you'll need to go to the admin page for the /rm application and create a user to access the application, then go to the "manage this project area" for the /rm application project area and add this user, including specifying a role that has read/write permissions. Then configure the userid/password on the advanced properties page of your /qm application as mentioned earlier. Then hopefully your post via Excel tool should work. |
I work with the person that started the string. The user is setup to access composer in QM, in fact I tried several users and we are still getting the same error.
The users that we are using have only a Quality Professional License. Are users with that license type unable to add requirements through the excel importer? RQM 3.0.1 no longer has native requirements support. It will always use |
|
I'm not certain about a QM Professional licenses allowing you to do
everything that's needed when using the Excel tool. But it wouldn't hurt to add the RRC - Analyst license for the user for which you have configured in the advance properties qm/admin page. Also, when the error happens see if any additional information has been logged to the qm log file. This will be located under the <RQM301_INSTALL_DIR>\JazzTeamServer\server\logs\ directory and by should be named qm.log. Unless you migrated your server from RQM 2.x, in which case it will be jazz.log |
I'm not certain about a QM Professional licenses allowing you to do There were some additional configuration items that we addressed and it is now working. Thanks for the insights. |
Can you please share what additional configuration you addressed to make it work? thanks.
I'm not certain about a QM Professional licenses allowing you to do There were some additional configuration items that we addressed and it is now working. Thanks for the insights. |
Can you please share what additional configuration you addressed to make it work? thanks. I'm not certain about a QM Professional licenses allowing you to do There were some additional configuration items that we addressed and it is now working. Thanks for the insights. We enabled "Process Sharing" - "Allow other project areas to use this project area's process" option under "Application Administration - Requirements Management" and that seemed clear up the issue. |
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.