It's all about the answers!

Ask a question

Command Line test script unable to be executed when added via RQMExcelImporter, RQM 2.0.1.1 iFix 3


Brad Woodvine (1113) | asked Apr 18 '13, 2:38 a.m.
edited Apr 18 '13, 2:40 a.m.

I am importing Test Cases and Test Scripts (Commandline) via the RQM Excel Import Utility. All the Data imports correctly and visual verfication show everything is there.  When I run the test case the result is an error generated in the test results.  The error is

Cannot run program ""null"": CreateProcess error=2, The system cannot find the file specified”

I have found if I change absolutely anything in the test script through RQM webclient so the save button is activated and save the script runs perfectly. The only explaination I have is that RQM does something in the background when a user saves through the GUI which is not happening when you import a test script.

Example. 

1. Import test case and test script

2. Go to the Test Script Section of the Test Case and click on the Run Test button.

3. Test run starts and result in the error specified. Multiple re-executions have the same result.

4. Open up the Test Script and edit anything.  eg. Add a full stop to the description. 

5. This enables the Discard changes and Save button.  Press Save.

6. Go to the Test Script Section of the Test Case and click on the Run Test button.

7. Test run starts and completes without an error

Anyone understand why this is so and how to fix it.  If there is no solution I have to manually open every test script and do something to cause a save which is crazy.

3 answers



permanent link
Hao Wan (1.5k35) | answered May 07 '13, 10:02 p.m.
JAZZ DEVELOPER
Hi Brad,
we need more info regarding to your problem.
1. when exporting from Excel, does the config file you contains the "executionworkitem" ?
2. if the answer is #1 is not, did you use XLSArtifactID keyword? would you try to change these IDs and have another try?
3. if XLSArtifactID is not used, then would you try to change the file name of the excel and have a try again?

Comments
Brad Woodvine commented Jun 10 '14, 10:08 p.m.

Hi Hao,

I had forgotten all about this question.

Answers

1. No

3. Yes



permanent link
Brad Woodvine (1113) | answered Jun 10 '14, 10:08 p.m.

This is my config. I still have the issue on 4.0.3 version of RQM and new version of import Utility

// This is a configuration file created specifically for loading Test Cases from Excel for NBN
// This configuration file creates a test case with each remote test script and links them.
// The linking is accomplished by self referential data

// Sheet name in spredsheet
testscript.XLSWorksheetID="Test Cases Automated"

// Start looking for scripts after line 2
remotescript.XLSStartRow=2

// VERY IMPORTANT: Allows update of artifacts (Test Case or Test Script) if they already exists.
// If not set you could overwrite a completely different test with new data or create duplicate
// data. If you don't assign an artifactID the system automatically assign one based on the xls
// file name and sheet name. The artifactID is not viewable from the UI.
// Example 1. If you add 3 test cases using a excel file named ABC.xls and import it into RQM
// then use the same excel file named ABC.xls and add another 2 tests and import it into RQM
// you will overwrite the first 2 test in first import with the 2 new tests.
// Example 2. If you add 3 test case using a excel file named ABC.xls and import it into RQM then
// use another excel file named DEF.xls and add the same 3 tests and import them you will create
// a total of 6 tests, 3 which are duplicates .
// Use the Test Name as the artifact as there should never be 2 tests cases or script with the same name.
remotescript.XLSArtifactID=V

// Where to find remote script details in spreadsheet
remotescript.dc:title=V
remotescript.owner=W
remotescript.state=X
remotescript.dc:description=Y
remotescript.type="RQM-KEY-CMD-APTR-TYPE-NAME"
remotescript.command=Z
remotescript.arguments=AA

// True as we want to use test resources that are local to a test machine
remotescript.manageadapter="true"

// a new script starts when we encounter an empty row
remotescript.XLSDelimeter=\n

// Create 1-1 link between testscript and testcase
testcase.TestID=remotescript.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.XLSStartRow=2
testcase.XLSDelimeter=\n
testcase.dc:title=A
testcase.weight=M
testcase.dc:description=P
testcase.dc:creator=T
testcase.alm:state=U

// Categories are defined in a special way
testcase.category term="AAA".value=B
testcase.category term="BBB".value=C
testcase.category term="CCC".value=D
testcase.category term="DDD".value=E
testcase.category term="EEEE".value=F
testcase.category term="Technology".value=G
testcase.category term="Test Case Origin".value=H
testcase.category term="Test Phase".value=I
testcase.category term="Test Type".value=J
testcase.category term="Test Window".value=K
testcase.category term="Work Package".value=L

// Test Case Pre-conditions and Post-Conditions, Expected Results and Test Case Design
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=Q
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=R
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=S
testcase.Section("Requirement_Ref","Requirements Reference")=N


permanent link
Brad Woodvine (1113) | answered Jun 15 '14, 10:09 p.m.
edited Jun 15 '14, 10:12 p.m.

Solution found. Not sure which on these three lines in the configuration file that fixed it but I made these changes and now the problem has gone


remotescript.type="RQM-KEY-CMD-APTR-TYPE-NAME" (Changed to remotescript.type="com.ibm.rqm.adapter.commandline")
remotescript.command=Z (Changed to remotescript.rs:command=Z) 
remotescript.arguments=AA (Changed to remotescript.rs:arguments=AA)

 

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.