RQM Excel Importer: The remote server returned an error: (403) Forbidden.
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
2 answers
Comments
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
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
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.
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?