Importing Testcases/Scripts with Excel Importer Gives Internal Server Error 500
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.
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
Comments
Corey Jacobs
Aug 21 '13, 6:44 p.m.