It's all about the answers!

Ask a question

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


Jochen Staack (551120) | asked 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

Comments
Jochen Staack commented 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 commented Jul 08 '15, 4:23 p.m. | edited Aug 30 '15, 6:52 p.m.

Bumping this issue.  I have the same problem.   Any ideas?

2 answers



permanent link
Ara Masrof (3.2k15) | answered Feb 09 '15, 9:43 p.m.
JAZZ DEVELOPER
 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 

Comments
Jochen Staack commented Feb 10 '15, 3:13 a.m. | edited 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.7k21114139) | answered 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

Comments
Steven Bonsall commented Jul 13 '15, 1:34 p.m. | edited 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 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.