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
|
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: