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

RQM Excel Importer Bad Request

Questions
Tags
Users
Badges
d B
(1●1●1) Nov 04 '13, 4:03 p.m.
hello,
i am trying to export some lab resources provided in an excel file via the excel importer. Exporting to xml files works like a charm for me, but uploading data to my jazz.net sandbox ends up in bad requests. I am following the steps described in the excel importer wiki. Exporting with a unchecked box ("link to existing RM requirement") causes the already alluded error code 400.

log file:
11/4/2013 2:27:23 PM: sending labresource12 named DevOpsMgmt_HW_Extract_Sheet1_13.xml

11/4/2013 2:27:24 PM: ERROR: <Unknown Caller Context>: RQMConnector: PutToServer - Error putting resource: https://jazz.net/sandbox01-qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/bortmesd%2527s%2bProject%2b%2528Quality%2bManagement%2529/labresource/XLS/XLS/DevOpsMgmt_HW_Extract_Sheet1_13.xml

May anyone please help me in order to get the exports uploaded.

Dominic

0 votes

Comments
d B
May 12 '14, 7:26 p.m.
hey, thanks for answering, i am using the provided "lab resourecs.xls" with the standard config file.The role "test team member" has been assigned to the account. i can't even export this file: http://bit.ly/174g0T2 btw: the importer recognizes my credentials as valid and detects all project areas properly.

Don Yang
Nov 06 '13, 1:09 a.m.
there are some important info not in the discussions: version of RQM used, version of ExcelImporter used, OS you run and what sample files used and what you want to achieve as the result of export.

d B
Nov 06 '13, 2:30 a.m.
sorry, here is is my system configuration jazz sandbox1: RQM 4.0.5 jazz sandbox2: RQM 4.0.4 Excel Importer: 4.0.4 i am currently running win7 64 bit professional with sp1 my goal is to import approx. 400 lab resources from a excel file into rqm, and test the usabilty of the lab management module in rqm. yesterday a colleague claimed that the excel importer may not be able to handle the jazz.net addresses because of the amount of redirects.. As my log file says: Proxy Error: Host connected but unable to forward request "https://199.246.40.115/sandbox02-qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/..

1 vote

Sunil Kumar R
JAZZ DEVELOPER Nov 06 '13, 4:39 a.m.
Hello! yes I see the same error while using the excel exporter utility and similar behavior as well. I found an alt., mechanism to upload data using RESTClient! But dont think its practical to use the client to create 400 artifacts.. Do you perhaps have an automation tool available - that might help in this activity. Best Regards, Sunil

2 answers
10,021 views
0 votes

2 answers

Permanent link
Sunil Kumar R
JAZZ DEVELOPER (1.1k●1●33●44) Nov 05 '13, 3:07 a.m.
 Hello!

At first glance the error appears to be occuring due to malformed URL used with POST for the XML resource indicated.
But it's hard to figure out what exactly went wrong without the specifics (sheet, config file, logs)

So I would like to propose teh following way to help troubleshoot this issue:-

a. Try using the "Lab Resources" sheet and config file provided in RQM excel exporter samples.
b. Assign the user the "TestTeamMember" role on the project area, after adding the user under "Members" list for the project area

If the above works, please compare your sheet with the sample and see if there is any commonality and anything specific that is specific wrong in the sheet you use? I know its hard to figure out - but if you are stuck at this point, please contact IBM Rational Client Support with all details available to speed up resolution.

Best Regards, Sunil

1 vote

Permanent link
Miles Thompson
(18●2●4) Dec 04 '13, 1:15 p.m.
I have the exact same issue in my thread: https://jazz.net/forum/questions/132735/rqm-404-excel-importer-error-400-bad-request-when-importing-to-sandbox-repository

At first I had solved it by going over http rather than https, but that solution stopped working almost immediately.

0 votes

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,106
× 1,736
× 384

Question asked: Nov 04 '13, 4:03 p.m.

Question was seen: 10,021 times

Last updated: May 12 '14, 7:26 p.m.

Confirmation Cancel Confirm