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