It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×10,908
×7,382
×6,076
×4,288

question asked: Jan 09 '16, 7:45 a.m.
question was seen: 2,145 times
last updated: Jan 11 '16, 7:48 a.m.

Related questions

FAQ - How this Forum works

What causes internal error in RQM excelImporter for Test plans with Test Cases with Test Scripts.

0
anup Gaur (139●22●44) | asked Jan 09 '16, 7:45 a.m.
 What causes internal error in RQM excelImporter for Test plans with Test Cases with Test Scripts.
While uploading the artifacts from excelsheet, all test cases and Test scripts get uploaded. The test plan upload fails with internal error.
Server returned code InternalServerError
Error sending to server <Name of Test Plan> of type testplan
Internal Server Error

1) This is not an error with the config file, as using the same config file I'm able to successfully upload some XLS sheets without any error. Only a few excel sheet cause this error. Removing a few test cases seems to remove the error. unable to find the cause of the error.
2) This is the error generated in the logs.

ResultHandler.java:204)","com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)","com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)","com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1783)"],"errorMessage":"Violation of PRIMARY KEY constraint 'VRSNDTSTPLNTSTCSSP'. Cannot insert duplicate key in object 'PLANNING.VERSIONED_TEST_PLAN_TEST_CASES'. The duplicate key value is (_IMv6q7clEeW0hrxLJ0LGOw, _G1ILya0yEeWpVItFWgG0Ig)."},"errorAllData":{"exceptionData":{"-hint-eclass-1":"VersionedTestCaseHandle","uri":"itemOid\/com.ibm.rqm.planning.VersionedTestCase\/_G-PEe60yEeWpVItFWgG0Ig","itemId":"_G-PEe60yEeWpVItFWgG0Ig","-hint-epackage-1":"com.ibm.rqm.planning","com.ibm.team.repository.typeName":"com.ibm.rqm.planning.VersionedTestCase"}},"errorCode":null,"errorTraceMarshall":

Given below is the config file.
//Config for Testplan
testplan.dc:title=B1
testplan.XLSArtifactID=B1
testplan.dc:description=B3
testplan.category term="Test Plan Created By".value=B2
testplan.customAttributes identifier="Test_Plan_Description".name="Test Plan Description".type="MEDIUM_STRING".value=B3
testplan.customAttributes identifier="Planned_Start_Date".name="Planned Start Date".type="TIMESTAMP".value=B4
testplan.customAttributes identifier="Planned_End_Date".name="Planned End Date".type="TIMESTAMP".value=B5
testplan.customAttributes identifier="Actual_Start_Date".name="Actual Start Date".type="TIMESTAMP".value=B6
testplan.customAttributes identifier="Actual_End_Date".name="Actual End Date".type="TIMESTAMP".value=B7
testplan.category term="XXX".value=B8
testplan.category term="YYY".value=B9
testplan.priority=B10

//Config for testscript
testscript.XLSStartRow=13
testscript.XLSArtifactID=C
testscript.dc:title=C
testscript.dc:description=D
testscript.steps.type="execution"
testscript.steps.description=F
testscript.steps.title=F
testscript.steps.name=F
testscript.steps.expectedResult=G
testscript.category term="Test Script Created By".value=B2
testscript.customAttributes identifier="Test_Script_Descriptions".name="Test Script Descriptions".type="MEDIUM_STRING".value=D
testscript.priority=H
testscript.XLSDelimeter=\n

//Config for testcase
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description
testcase.XLSArtifactID=C
testcase.category term="Test Case Created By".value=B2
testcase.customAttributes identifier="Test_Case_Description".name="Test Case Description".type="MEDIUM_STRING".value=D
testcase.category term="XXX".value=A
testcase.category term="YYY".value=B
testcase.priority=H
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition", "RQM-KEY-TC-PRE-COND-TITLE")=E

testplan.XLSLink=testcase

Any ideas will be helpful thank you.
 

Accepted answer

1
permanent link
Donald Nong (14.5k●4●14) | answered Jan 10 '16, 7:58 p.m.
edited Jan 10 '16, 7:59 p.m.
You have already (sort of) found the cause - one (or maybe more) of the test cases are already linked to the test plan. You just need to find out which it is and remove it from the Excel file.

Use this link to find out the affected test plan:
https://clm:9443/qm/oslc_qm/contexts/< Proect Area UUID >/resources/com.ibm.rqm.planning.VersionedTestPlan/_IMv6q7clEeW0hrxLJ0LGOw
(The UUID at the end is the first one highlighted in the error message).

Use this link to find out the affected test case:
https://clm:9443/qm/oslc_qm/contexts/< Proect Area UUID >/resources/com.ibm.rqm.planning.VersionedTestPlan/_G1ILya0yEeWpVItFWgG0Ig
(The UUID at the end is the second one highlighted in the error message).

If you are familiar with OSLC API, you should know how to get the < Project Area UUID > to put into the above URLs. Otherwise, follow these steps.
1. Go to the Manage Project Areas page.
2. Hover the mouse over the affected project area, and you should see the link in the status bar of the browser. Or you can copy the link ("Copy link address" in Chrome, or "Copy Link Location" in Firefox). The link should look like
https://clm:9443/qm/admin#action=com.ibm.team.process.editProjectArea&itemId=_un7MMIPsEeSArJ5EtUYmDQ
The UUID following "itemId=" is the < Project Area UUID > that you need.
anup Gaur selected this answer as the correct answer
Comments
anup Gaur commented Jan 11 '16, 7:48 a.m.

 Thanks Donald..


You saved me a PMR and a ton of time.

I didn't even think of that scenario. The user while creating the excel sheet has created copies of the same test case as new entries. 

By the way once the test plan is created then this error doesn't come with the same excel sheet and the config file.

Thanks again.

Your answer

Register or 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.