It's all about the answers!

Ask a question

Importing Testcases/Scripts with Excel Importer Gives Internal Server Error 500


Corey Jacobs (641835) | asked Aug 21 '13, 6:42 p.m.
retagged Aug 27 '13, 2:55 p.m. by Ralph Earle (25738)
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.



Comments
Corey Jacobs commented Aug 21 '13, 6:44 p.m.

Accepted answer


permanent link
Hao Wan (1.5k35) | answered Aug 21 '13, 10:32 p.m.
JAZZ DEVELOPER
edited Aug 21 '13, 10:33 p.m.
 Hi Corey,
when exporting RFT script the type should be "com.ibm.rqm.adapter.rft"
remotescript.type="com.ibm.rqm.adapter.rft"

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
Corey Jacobs commented Aug 22 '13, 4:55 p.m.

Thanks Hao.  That fixed the Internal Sever Error Message.  I will look at those samples for reference.

Your answer


Register or to post your answer.