Getting Error while staging the test case which has datasheet and unable to open test case from Devtest workstation

Document ID : KB000009010
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

We are getting an error while staging the test case

(java.lang.NoSuchMethodError: org.apache.poi.ss.formula.WorkbookEvaluator).

 And we see same error when we try to open test case from workstation

Error loading Test Case document: org.apache.poi.ss.formula.WorkbookEvaluator.<init>(Lorg/apache/poi/ss/formula/EvaluationWorkbook;Lorg/apache/poi/ss/formula/IStabilityClassifier;Lorg/apache/poi/hssf/record/formula/udf/UDFF 

 

Environment:
Not specific to environment
Cause:

    If a test case has excel file as a datasheet and reading data from the excel sheet, we notice this kind of error. Because, the excel might have some colors defined in sheets or formulas defined in sheet due to which devtest is not loading those details.

 

Resolution:

     Since we are not able to load the test case through workstation, just open the test case (.tst) file in any editor (like notepad, notepad++, etc) and search the datasheet defined in test case and comment out the datasheet section or remove the excel file defined in test and save it.

     Now, you can open the test case through workstation. Use the excel file which has no formulas or no colors defined in it. So that, we will not get an error and use the test case to stage it.