Importing Testcases/Scripts with Excel Importer Gives Internal Server Error 500
Corey Jacobs (64●25●39)
| asked Aug 21 '13, 6:42 p.m.
retagged Aug 27 '13, 2:55 p.m. by Ralph Earle (257●3●9)
I'm working with Excel Importer Tool to import test cases along with their associated test scripts. Within this spreadsheet/worksheet, I would put the testcase details along with the script details. These scripts are of Rational Functional Tester and my Adapter is up and running. When exporting to Repository, I'm running into 500 Internal Server Error.
Here's my error message from Mso2Rqm Log 8/21/2013 3:29:52 PM: -------------------------------------------------------------------------------- 8/21/2013 3:29:52 PM: SESSION: 8/21/2013 3:29:52 PM 8/21/2013 3:29:52 PM: Getting artifacts from current document Sample Spreadsheet with Testcases and Testscripts.xls 8/21/2013 3:29:52 PM: Created 3 artifacts, sending to server 8/21/2013 3:29:52 PM: sending remotescript0 named Sample_Spreadsheet_with_Testcases_and_Testscripts_Sheet1_1.xml 8/21/2013 3:29:52 PM: Server returned code InternalServerError 8/21/2013 3:29:52 PM: Error sending to server Sample_Spreadsheet_with_Testcases_and_Testscripts_Sheet1_1.xml of type remotescript 8/21/2013 3:29:52 PM: Internal Server Error 8/21/2013 3:29:52 PM: sending remotescript1 named Sample_Spreadsheet_with_Testcases_and_Testscripts_Sheet1_2.xml 8/21/2013 3:29:52 PM: Server returned code InternalServerError 8/21/2013 3:29:52 PM: Error sending to server Sample_Spreadsheet_with_Testcases_and_Testscripts_Sheet1_2.xml of type remotescript 8/21/2013 3:29:52 PM: Internal Server Error 8/21/2013 3:29:52 PM: sending remotescript2 named Sample_Spreadsheet_with_Testcases_and_Testscripts_Sheet1_3.xml 8/21/2013 3:29:52 PM: Server returned code InternalServerError 8/21/2013 3:29:52 PM: Error sending to server Sample_Spreadsheet_with_Testcases_and_Testscripts_Sheet1_3.xml of type remotescript 8/21/2013 3:29:52 PM: Internal Server Error 8/21/2013 3:29:52 PM: finished writing artifacts Config File Used //configuration file for sample migration for admin testcase.XLSStartRow=6 testcase.alm:owner=A testcase.dc:title=B testcase.dc:description=C //testcase.category term="Test Purpose".value=C testcase.category term="Product".value=E testcase.category term="Product Version".value=F testcase.category term="Test Team".value=G testcase.category term="CM Enabled".value=H testcase.category term="CM ID Level".value=I testcase.category term="Component Tested".value=J testcase.category term="DB2 Level".value=K testcase.category term="MVS Level".value=L testcase.category term="Should this scenario be automated".value=M testcase.Section("myns:com.ibm.rqm.planning.editor.section.caseTestDescription", "RQM-KEY-TC-TEST-DESCRIPTION-TITLE")=N // testcase.XLSLink=remotescript remotescript.alm:owner=A remotescript.type="Rational Functional Tester" remotescript.adapterid="8" remotescript.manageadapter="true" remotescript.fullpath=O remotescript.dc:title=P Any Clues to as to what went wrong? Here's my excel file used as well. 
|
Accepted answer
Hi Corey,
when exporting RFT script the type should be "com.ibm.rqm.adapter.rft"
remotescript.type="com.ibm.rqm.adapter.rft"
you can refer to https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter
and search for
Supported Attributes and Configuration Syntax
and refer to the sample Testcase with Remote Scripts 001.xls
Corey Jacobs selected this answer as the correct answer
Comments Thanks Hao. That fixed the Internal Sever Error Message. I will look at those samples for reference.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments