RQM 4.0.4 Excel Importer Error 400: Bad Request when importing to Sandbox repository
![]()
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?
|
Accepted answer
![]()
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: 32The 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
![]()
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 Never mind. It only worked once, then was unable to get my project information to auto-populate. Still looking for a solution. |
![]()
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
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.
Comments
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.
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
Hi Chenyue,
All, have another update: