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

RQM Excel Importer: The remote server returned an error: (403) Forbidden.

Questions
Tags
Users
Badges
Jochen Staack
(55●11●20) Feb 09 '15, 10:33 a.m.
Hi,

I am using the RQM Excel Importer (V 5.0.1.188) with RQM 5.0.1 Build I20140807_0536.
Excel version is 2007. The installation file used in the RQMWordExcelImporter repository is RQMExcelImporterSetup.msi (as the .NET versions are not working for me).

Running the follwing line the cfg file:
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign", "RQM-KEY-TC-DESIGN-TITLE")=E

is resulting in this error while sending the data to RQM:
Error sending to server Excel_TestSpec_Vehicle_Tabelle1_2.xml of type testcase
The remote server returned an error: (403) Forbidden.

The value in the E column is a simple string, like "Test Case Design 1".

What am I doing wrong?

Regards
Jochen

0 votes

Comments
Jochen Staack
Feb 09 '15, 10:34 a.m.
I am having access to the server, basivally creating a testcase, changing its attributes and so on is working perfectly for me.

Steven Bonsall
Aug 30 '15, 6:52 p.m.
Bumping this issue.  I have the same problem.   Any ideas?

2 answers
8,414 views
0 votes

2 answers

Permanent link
Ara Masrof
JAZZ DEVELOPER (3.2k●1●5) Feb 09 '15, 9:43 p.m.
 You may not have the Quality Management/XML Import/Post permission enabled

Admin -> Manage This Project Area -> Permissions: Be sure the role assigned to the user performing the import has XML import permissions enabled 

0 votes

Comments
Jochen Staack
Aug 30 '15, 6:53 p.m.
I have the necessary rights. Here is the cfg content. The bold line is leading to the error, everything else is working! testcase.XLSStartRow=3 testcase.dc:title=C testcase.jzalm:owner=B testcase.estimate=O testcase.weight=P testcase.priority="literal.priority.120" //literal.priority.110 : Low //literal.priority.120 : Medium //literal.priority.130 : High //literal.priority.101 : Unassigned // categories testcase.category term="test responsible".value=J testcase.category term="test platform".value=K testcase.category term="test level".value=L testcase.category term="component".value=M testcase.category term="integration level".value=N testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign", "RQM-KEY-TC-DESIGN-TITLE")=E

Permanent link
Don Yang
(7.7k●21●114●139) Jul 08 '15, 9:28 p.m.
Hi, Steven

Are you using the same version of RQMExcelImporter(5.0.1 or 5.0.2) or not?
If you try included sample: Scripts that create testcases with TCER.xls/Scripts that create testcases with TCER.cfg
(you can comment out Execution workitem and execution result and even test script part to focus on test case export if you want), do you see the same problem or not?

"The remote server returned an error: (403) Forbidden." error usually is related to permissions.
you may check
1) add "Data Migration Administrator" role to the user for export
2) if that does not work, try to add all permissions to Everyone role and see if it works(you can lift them after exporting)
Thanks

0 votes

Comments
Steven Bonsall
Aug 30 '15, 6:53 p.m.
Don Yang, Thanks for your response. I have version 5.02 of the Importer. I tried "Scripts that Create Testcases with TCER".  Does not work as is, but does work if I comment out this line: testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=C That is my general problem; lines as above cause the 403 error. I added Full Control to Everyone.  No change to export results (same problem as before) Where is the "Data Migration Administrator" role? Thanks again.

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.

Ask a question
Guidelines
FAQ
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
× 11,109

Question asked: Feb 09 '15, 10:33 a.m.

Question was seen: 8,414 times

Last updated: Aug 30 '15, 6:53 p.m.

Confirmation Cancel Confirm