It's all about the answers!

Ask a question

RQM 4.0.4 Excel Importer Error 400: Bad Request when importing to Sandbox repository


Miles Thompson (1814) | asked Nov 01 '13, 4:23 p.m.
I'm evaluating RQM for a project and am currently using the 4.0.4 sandbox environment.  I was using the 4.0.4 Excel Importer tool and generated many test scripts and cases to file correctly.  I was able to upload these scripts and cases to my project in the sandbox.

If I instead attempt to post the scripts and cases to the sandbox directly with the Excel Import to Repository ability, my credentials are validated, I choose my project, then all 4 artifacts fail due to Error 400: Bad Request.  Any idea what I'm doing wrong?  Can the sandbox environment receive import requests?

Comments
Miles Thompson commented Nov 01 '13, 6:10 p.m.

If someone else would like to try exporting to this project, the server is https://jazz.net/sandbox02-qm.  Use your Jazz.net credentials to gain access. 


Chenyue Gao commented Nov 11 '13, 11:28 a.m.
JAZZ DEVELOPER

can you access to RQM server and manually create the test scripts and test cases with the username/password used in the RQM excel importer? Thanks


Miles Thompson commented Nov 11 '13, 11:59 a.m.

Hi Chenyue,

I can access the RQM server and manually create test scripts and test cases with the same login I am using with the RQM excel importer.  My login is validated.  I can also import XML test scripts and test cases that are generated through the RQM excel importer, but only manually and one at a time.


Miles Thompson commented Nov 20 '13, 4:04 p.m.

All, have another update:


I ran a test case in offline mode and opened the .rqms file with the Excel Importer.  I filled in the StepResult for each step and attempted to export it back to the repository.  I received the Error 400 Bad Request again.  This means that my configuration file is not the problem as this export used the .rqms config. 

Accepted answer


permanent link
Joao Carusi (26314) | answered Apr 22 '16, 9:13 a.m.
 Not sure whether you're still working on this one. I finally got time to set it all up again and could get the exact same error message as you did. Only then I realized I overlooked the message that you original posted: 
Proxy Error: Host connected but unable to forward request "https://199.246.40.123/sandbox02-qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/jcarusi%2527s%2bProject%2b%2528Quality%2bManagement%2529/testscript/WOW_Test_Cases_Test_Cycle_2_3_16.xml", please retry, errno: 32
The debug log shows a bit more details and indicates that this message is thrown by the Edge Components Caching Proxy. So far, I can only conclude that the jazz.net reverse proxy is configured in a way that does not allow us to use the RQM Excel Importer. 
Miles Thompson selected this answer as the correct answer

4 other answers



permanent link
Antoinette Iacobo (650612) | answered Nov 11 '13, 5:39 p.m.
 Miles,
Can you show some screen shots of the steps you are taking in Excel to run the tool and also post what you see in the Excel Import logs.  In searching for "400 Bad Request" errors, the only hits I find are for OSLC integration issues where the clocks are out of sync and that doesn't match with this use case.


Comments
Miles Thompson commented Nov 20 '13, 4:00 p.m.

Hi Antoinette,


I tried uploading some screen captures, but my reputation isn't above 60.

Sorry.


Joao Carusi commented Mar 11 '16, 5:11 p.m.

 


permanent link
ma chi (3111) | answered Nov 19 '13, 10:15 p.m.
   hi miles, i think there's something wrong with your config file.can you download a RQM application, and deploy on your local environment.Please let me know if you still have this problem.

Comments
Miles Thompson commented Nov 20 '13, 4:03 p.m.

Hi Ma Chi,


I cannot install the RQM application at my local environment at the moment.  I'm trying to see if RQM can help my team with our project testing, but we can't install it without approval (which comes after I tell IT that we need this product).

I do have an update, though. I ran a test case in offline mode and opened the .rqms file with the Excel Importer.  I filled in the StepResult for each step and attempted to export it back to the repository.  I received the Error 400 Bad Request again.  This means that my configuration file is not the problem as this export used the rqms config.

- Miles


ma chi commented Nov 20 '13, 9:46 p.m.

 hi Miles ,


       Can you send some screen captures to my email machibj@cn.ibm.com. Please send me the config file and the excel file if you are convenient.


permanent link
Miles Thompson (1814) | answered Dec 03 '13, 12:02 p.m.
Solved!

When connecting to https://jazz.net/sandbox02-qm was using HTTPS which apparently isn't supported by Excel Importer.  I changed the address to HTTP http://jazz.net/sandbox02-qm and no longer receive a 400 Bad Request.

Hope this helps everyone!

Comments
Miles Thompson commented Dec 04 '13, 1:17 p.m.

Never mind.  It only worked once, then was unable to get my project information to auto-populate.  Still looking for a solution.


permanent link
Joao Carusi (26314) | answered Mar 11 '16, 5:20 p.m.
It worked just fine in my local QM 601 environment, but I'm facing the same issue when I use my QM jazz.net sandbox.

URL: 
https://jazz.net/sandbox02-qm

QM 6.0.1 iFix002a

RQMExcellImporter Version 6.0.121691

Sample:
WOW Test Cases

Error message:
Getting artifacts from document - "WOW Test Cases.xls".....
Sending artifacts to https://jazz.net/sandbox02-qm.....
Sending testscript 0 named WOW_Test_Cases_Test_Cycle_2_3_16.xml...
Error sending to server WOW_Test_Cases_Test_Cycle_2_3_16.xml of type testscript
The remote server returned an error: (400) Bad Request.


Log:


3/11/2016 1:45:24 PM: 
--------------------------------------------------------------------------------
3/11/2016 1:45:24 PM: 
SESSION: 3/11/2016 1:45:24 PM

3/11/2016 1:45:24 PM: Getting artifacts from current document WOW Test Cases.xls
3/11/2016 1:45:24 PM: Created 54 artifacts, sending to server
3/11/2016 1:45:24 PM: sending testscript0 named WOW_Test_Cases_Test_Cycle_2_3_16.xml
3/11/2016 1:45:25 PM: Server returned code BadRequest
3/11/2016 1:45:25 PM: Error sending to server WOW_Test_Cases_Test_Cycle_2_3_16.xml of type testscript
3/11/2016 1:45:25 PM: Proxy Error: Host connected but unable to forward request "https://199.246.40.123/sandbox02-qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/jcarusi%2527s%2bProject%2b%2528Quality%2bManagement%2529/testscript/WOW_Test_Cases_Test_Cycle_2_3_16.xml", please retry, errno: 32
3/11/2016 1:45:25 PM: sending testscript1 named WOW_Test_Cases_Test_Cycle_2_3_15.xml
3/11/2016 1:45:26 PM: Server returned code BadRequest


I will post a new question about that... 
https://jazz.net/forum/questions/218181/is-it-possible-to-import-data-to-rqm-jazznet-sandbox-using-rqm-excel-importer-tool


Your answer


Register or to post your answer.