Is it possible to import data to RQM jazz.net sandbox using RQM Excel Importer tool ?
I'm trying to import data from Excel to my QM jazz.net sandbox.
URL:
https://jazz.net/sandbox02-qm
QM 6.0.1 iFix002a
RQMExcelImporter 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
It worked just fine in my local QM 601 environment
similar issue: https://jazz.net/forum/questions/132735/rqm-404-excel-importer-error-400-bad-request-when-importing-to-sandbox-repository
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.
One other answer
You should be able to. Note that the jazz.net sandbox is TLSv1.2 enabled, so you need to install the Excel Importer accordingly for it to work properly. Similar discussion took place in the past.
https://jazz.net/forum/questions/212620/rqm-excel-importer-protocol-configuration
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter
https://jazz.net/forum/questions/212620/rqm-excel-importer-protocol-configuration
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter
Comments
Hi Donald,
My Excel is 32 bit and I used RQMExcelImporterSetup.
I have added your jazz user as member of my project (jcarusi) in https://jazz.net/sandbox02-qm
If you have a moment, could you please try importing data using your environment?
Thank you
I haven't got time to set up the environment yet (the previous one was undeployed). But based on what you said, you have not installed the plugin correctly, as you should install Excel 2013, .NET 4.5 and use the installer "RQMExcelImporterSetupForDotNET45".