It's all about the answers!

Ask a question

Error while exporting Excel file that contains testscript,testcases and requirements


Brijraj Beriwal (1311217) | asked Sep 18 '12, 7:48 a.m.

I am trying to export a excel file which contains testscript,testcases and requirements which are all linked.....My config files look as follows:-

testscript.XLSWorksheetID="TCER"
testscript.XLSStartRow=8
testscript.dc:title=E
testscript.dc:description=F
testscript.steps.description=H
testscript.steps.title=E
testscript.steps.name=E
testscript.steps.expectedResult=G
testscript.XLSDelimeter=\n

testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description
//testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=H
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseExpectedResults","RQM-KEY-TC-EXP-RESULTS-TITLE")=G
testcase.XLSWorksheetID="TCER"
testcase.requirement=Link(A)

requirement.XLSStartRow=8
requirement.XLSArtifactID=A
requirement.dc:title=A
requirement.dc:description=B
requirement.XLSWorksheetID="REQ"

while exporting it gives the following error

Sending testscript 3 named Book1_TCER_1.xml...

Error sending to server Book1_TCER_1.xml of type testscript

The remote server returned an error: (500) Internal Server Error.

Sending testcase 4 named Book1_TCER_1.xml...

Sending testscript 5 named Book1_TCER_2.xml...

Error sending to server Book1_TCER_2.xml of type testscript

The remote server returned an error: (500) Internal Server Error.

Sending testcase 6 named Book1_TCER_2.xml...

Sending testscript 7 named Book1_TCER_3.xml...

Error sending to server Book1_TCER_3.xml of type testscript

The remote server returned an error: (500) Internal Server Error.

Sending testcase 8 named Book1_TCER_3.xml...

Sending testscript 9 named Book1_TCER_4.xml...

Error sending to server Book1_TCER_4.xml of type testscript

The remote server returned an error: (500) Internal Server Error.

Sending testcase 10 named Book1_TCER_4.xml...

Could  anyone please help in resolving the above error?

3 answers



permanent link
Hao Wan (1.5k35) | answered Sep 18 '12, 8:15 a.m.
JAZZ DEVELOPER
Hi Brijraj,
when create testscript step type must be set,
you can add testscript.steps.type="execution" to have a try again

permanent link
Brijraj Beriwal (1311217) | answered Sep 19 '12, 2:45 a.m.

Hey Hao....i am able to export testcases and testscripts .....but it is giving the following error

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
   at Mso2Rqm_Common.OSLCHelper.getOslcLinkForTestCase(String testCaseUrl)
   at Mso2Rqm_Common.OSLCHelper.fetchAndUpdateTestCase(String testCaseUrl, List`1 reqList)
   at Mso2Rqm_Common.OSLCHelper.linkRequirementsToTestcase(String postUrl)
   at RQMExcelExporter.ExcelExportRepositoryDialog.handleExportToRepository(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
....

....also when i check it is getting linked to 4  same kind of requiremnts and also on clicking on their link it gives

following error

Error 410: Gone

com.ibm.rdm.fronting.server.exception.GoneException (More info found at entry [c9fbc6d398ae69fd] in RRS server log)


Requirements Management/4.0

But the requiremnts are getting exported in the RM....so could u please help in resolving the error.......

Also thanking you for the queries u have resolved in the past....


permanent link
Hao Wan (1.5k35) | answered Sep 20 '12, 12:25 a.m.
JAZZ DEVELOPER
Hi Brijraj,
have you ever try with the sample "TestPlan with TestCases 001 linked to requirement 001" to see if it can run successfully on your environment?

Your answer


Register or to post your answer.