Test Scripts failed to upload while Excel Import

Hi All,

I am trying to upload Test Cases from Excel to RQM 3.0.1.1 but Test Scripts are failing to upload with error -"EXCEPTION: : Object reference not set to an instance of an object.

]" , but all TC are uploaded successfully.

Error details:

sending testscript0 named 13898

ERROR: : RQMConnector: PutToServer - Error putting resource: https://*.com:port/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/LegacyTest/testscript/13898


EXCEPTION: : The remote server returned an error: (400) Bad Request.

at System.Net.HttpWebRequest.GetResponse()
at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)

ERROR: : The remote server returned an error: (400) Bad Request.


Error sending to server 13898 of type testscript

ERROR: : ExcelExportRepositoryDialog: Error saving to url https://*.com:port/jazz of type testscript

EXCEPTION: : Object reference not set to an instance of an object.


at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)
at RQMExcelExporter.ExcelExportRepositoryDialog.doExport(IList`1 artifacts)

Configuration file used is:

testscript.XLSWorksheetID="Sheet2"
testscript.XLSStartRow=2
testscript.XLSArtifactID=F
testscript.dc:title=G
testscript.dc:description=N
testscript.steps.type="execution"
testscript.steps.description=T
testscript.steps.title=S
testscript.steps.name=S
testscript.steps.expectedResult=U
testscript.steps.property name="comment"=R


testscript.XLSDelimeter=\n
testcase.ID=testscript.XLSArtifactID
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description


Please help to resolve the issue,

Thanks

Your best bet here is going to be to open a PMR and provide both the .cfg file and the Excel spreadsheet as attachments. Importer issues are largely case specific and it would be ill-advised to include any of what might be sensitive spreadsheet data on the forum.

@teja32
would you please try to delete the line
testscript.steps.property name="comment"=R
in the config file, I think Excel Importer don't support such config.
if it still don't work, please do as @shengo suggested.

Hi All,

I am trying to upload Test Cases from Excel to RQM 3.0.1.1 but Test Scripts are failing to upload with error -"EXCEPTION: : Object reference not set to an instance of an object.

]" , but all TC are uploaded successfully.

Error details:

sending testscript0 named 13898

ERROR: : RQMConnector: PutToServer - Error putting resource: https://*.com:port/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/LegacyTest/testscript/13898


EXCEPTION: : The remote server returned an error: (400) Bad Request.

at System.Net.HttpWebRequest.GetResponse()
at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)

ERROR: : The remote server returned an error: (400) Bad Request.


Error sending to server 13898 of type testscript

ERROR: : ExcelExportRepositoryDialog: Error saving to url https://*.com:port/jazz of type testscript

EXCEPTION: : Object reference not set to an instance of an object.


at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)
at RQMExcelExporter.ExcelExportRepositoryDialog.doExport(IList`1 artifacts)

Configuration file used is:

testscript.XLSWorksheetID="Sheet2"
testscript.XLSStartRow=2
testscript.XLSArtifactID=F
testscript.dc:title=G
testscript.dc:description=N
testscript.steps.type="execution"
testscript.steps.description=T
testscript.steps.title=S
testscript.steps.name=S
testscript.steps.expectedResult=U
testscript.steps.property name="comment"=R


testscript.XLSDelimeter=\n
testcase.ID=testscript.XLSArtifactID
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description


Please help to resolve the issue,

Thanks

Hi,
There was a bug in the 3.0.1 excel importer tool, downloaded the latest one from site and it worked fine

Thanks

There was bug in the 3.0.1 excel importer tool, downloaded the latest one from ibm site and it worked fine.

Thanks