import test cases with test scripts using RQM excel import tool
Hi, I'm trying to import a testcase with testscripts using "Testsuite with testcases that have testscripts" config file.
Am able to upload 1 or 2 testcases, scripts successfully but when I try to import multiple around 50 testcases , it is throwing some errors.
My cfg file look like this:
testscript.XLSStartRow=5
// use the data in the first row of a found script's column B
testscript.XLSArtifactID=B
testscript.dc:title=B
testscript.dc:description=G
// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type="execution"
testscript.steps.title=C
testscript.steps.name=C
testscript.steps.description=D
testscript.steps.expectedResult=E
testcase.category term="Priority".value=F
testcase.category term="TestType".value=H
testcase.category term="Project".value=J
testcase.category term="Test Phase".value=K
testcase.category term="Release".value=L
// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
// we want to use the data we got for each test script to create a test case
testcase.ID=testscript.XLSArtifactID
// by refering to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description
testcase.alm:owner=I
testsuite.dc:title=B1
testsuite.dc:description=B2
testsuite.XLSLink=testcase
I am getting Internal error (500). The log file AppData\Roaming\Mso2Rqm is displaying below message:
sending testscript4 named Opt_in_winback_for_SME_user_registered_at_CTN_level__Negative_Testing
Server returned code OK
sending testscript5 named Login_to_My_account_and_Verify_winback_is_editable_for_SPT_user_registered_at_BAN_level
Server returned code OK
sending testscript6 named Login_to_My_account_and_Verify_winback_is_not_editable_for__SME_user_registered_at_CTN_level
Server returned code OK
sending testscript7 named Login_to_My_account_and_Verify_winback_is_editable_for__SME_user_registered_at_BAN_level
Server returned code OK
sending executionworkitem8 named Login_to_My_account_and_Verify_winback_is_editable_for__SME_user_registered_at_BAN_level
Server returned code InternalServerError
Error sending to server Login_to_My_account_and_Verify_winback_is_editable_for__SME_user_registered_at_BAN_level of type executionworkitem
Internal Server Error
sending executionworkitem9 named Login_to_My_account_and_Verify_winback_is_not_editable_for__SME_user_registered_at_CTN_level
Server returned code InternalServerError
Error sending to server Login_to_My_account_and_Verify_winback_is_not_editable_for__SME_user_registered_at_CTN_level of type executionworkitem
Internal Server Error
sending executionworkitem10 named Login_to_My_account_and_Verify_winback_is_editable_for_SPT_user_registered_at_BAN_level
Server returned code InternalServerError
Error sending to server Login_to_My_account_and_Verify_winback_is_editable_for_SPT_user_registered_at_BAN_level of type executionworkitem
Internal Server Error
sending executionworkitem11 named Login_to_My_account_and_Verify_winback_is_not_editable_for__SPT_user_registered_at_CTN_level
Server returned code InternalServerError
I have posted part of log message. Is the way I specified the test case, test script is wrong? why it has worked for few TCs but not working for others. Would anybody please help me on this. Thanks in Advance.
Am able to upload 1 or 2 testcases, scripts successfully but when I try to import multiple around 50 testcases , it is throwing some errors.
My cfg file look like this:
testscript.XLSStartRow=5
// use the data in the first row of a found script's column B
testscript.XLSArtifactID=B
testscript.dc:title=B
testscript.dc:description=G
// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type="execution"
testscript.steps.title=C
testscript.steps.name=C
testscript.steps.description=D
testscript.steps.expectedResult=E
testcase.category term="Priority".value=F
testcase.category term="TestType".value=H
testcase.category term="Project".value=J
testcase.category term="Test Phase".value=K
testcase.category term="Release".value=L
// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
// we want to use the data we got for each test script to create a test case
testcase.ID=testscript.XLSArtifactID
// by refering to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description
testcase.alm:owner=I
testsuite.dc:title=B1
testsuite.dc:description=B2
testsuite.XLSLink=testcase
I am getting Internal error (500). The log file AppData\Roaming\Mso2Rqm is displaying below message:
sending testscript4 named Opt_in_winback_for_SME_user_registered_at_CTN_level__Negative_Testing
Server returned code OK
sending testscript5 named Login_to_My_account_and_Verify_winback_is_editable_for_SPT_user_registered_at_BAN_level
Server returned code OK
sending testscript6 named Login_to_My_account_and_Verify_winback_is_not_editable_for__SME_user_registered_at_CTN_level
Server returned code OK
sending testscript7 named Login_to_My_account_and_Verify_winback_is_editable_for__SME_user_registered_at_BAN_level
Server returned code OK
sending executionworkitem8 named Login_to_My_account_and_Verify_winback_is_editable_for__SME_user_registered_at_BAN_level
Server returned code InternalServerError
Error sending to server Login_to_My_account_and_Verify_winback_is_editable_for__SME_user_registered_at_BAN_level of type executionworkitem
Internal Server Error
sending executionworkitem9 named Login_to_My_account_and_Verify_winback_is_not_editable_for__SME_user_registered_at_CTN_level
Server returned code InternalServerError
Error sending to server Login_to_My_account_and_Verify_winback_is_not_editable_for__SME_user_registered_at_CTN_level of type executionworkitem
Internal Server Error
sending executionworkitem10 named Login_to_My_account_and_Verify_winback_is_editable_for_SPT_user_registered_at_BAN_level
Server returned code InternalServerError
Error sending to server Login_to_My_account_and_Verify_winback_is_editable_for_SPT_user_registered_at_BAN_level of type executionworkitem
Internal Server Error
sending executionworkitem11 named Login_to_My_account_and_Verify_winback_is_not_editable_for__SPT_user_registered_at_CTN_level
Server returned code InternalServerError
I have posted part of log message. Is the way I specified the test case, test script is wrong? why it has worked for few TCs but not working for others. Would anybody please help me on this. Thanks in Advance.
One answer
Hi Sirisha,
Can you please send your excel file and .cfg file to me? So I can look at this issue.
My email: dxfdiao@cn.ibm.com
Can you please send your excel file and .cfg file to me? So I can look at this issue.
My email: dxfdiao@cn.ibm.com