Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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.


0 votes

Comments


Accepted answer

Permanent link
 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

0 votes

Comments

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

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,014
× 343

Question asked: Aug 21 '13, 6:42 p.m.

Question was seen: 5,937 times

Last updated: Aug 27 '13, 2:55 p.m.

Confirmation Cancel Confirm