Skip to main content
Kofax

Error produced when trying to remove multiple columns in a robot.

Article # 3011705 - Page views: 463

3011705

Question / Problem: 

Robots error when trying to remove multiple columns from Excel. 

This is seen in webkit robots. The stack trace produced follows:

Stack trace:
com.kapowtech.lang.ApplicationError: Internal error during robot execution.
at kapow.robot.robomaker.engine.instruction.ExecuteNonIteratorTransitionInstruction.handleThrowable(ExecuteNonIteratorTransitionInstruction.java:192)
at kapow.robot.robomaker.engine.instruction.ExecuteNonIteratorTransitionInstruction.execute(ExecuteNonIteratorTransitionInstruction.java:159)
at kapow.robot.robomaker.engine.stackengine.StackEngine.execute(StackEngine.java:68)
at kapow.robot.robomaker.engine.StudioRobotExecutionEngine.lambda$startBackgroundExecution$190(StudioRobotExecutionEngine.java:272)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.IllegalStateException: Only applicable to named ranges
at org.apache.poi.hssf.usermodel.HSSFName.getRefersToFormula(HSSFName.java:233)
at com.kapowtech.connector.platform.studio.models.excel.ExcelSpreadsheetDocument.getNameFormulaMap(ExcelSpreadsheetDocument.java:1937)
at com.kapowtech.connector.platform.studio.models.excel.ExcelSpreadsheetDocument.removeColumns(ExcelSpreadsheetDocument.java:2293)
at kapow.robot.plugin.common.stepaction.excel.modify.RemoveColumnsStepAction.execute(RemoveColumnsStepAction.java:64)
at kapow.robot.plugin.common.stepaction.excel.ExcelNonIteratorStepAction.execute(ExcelNonIteratorStepAction.java:53)
at kapow.robot.robomaker.stateprocessor.noniterator.NonIteratorStepAction.execute(NonIteratorStepAction.java:335)
at kapow.robot.robomaker.stateprocessor.noniterator.NonIteratorStepAction.executeWithDirectModeCaching(NonIteratorStepAction.java:266)
at kapow.robot.robomaker.stateprocessor.noniterator.NonIteratorStepAction.execute(NonIteratorStepAction.java:156)
at kapow.robot.robomaker.stateprocessor.StepAction.execute(StepAction.java:672)
at kapow.robot.robomaker.robot.Transition.executeStepAction(Transition.java:770)
at kapow.robot.robomaker.engine.instruction.ExecuteNonIteratorTransitionInstruction.executeStepAction(ExecuteNonIteratorTransitionInstruction.java:232)
at kapow.robot.robomaker.engine.instruction.ExecuteNonIteratorTransitionInstruction.execute(ExecuteNonIteratorTransitionInstruction.java:67)
... 3 more
 

Answer / Solution: 

TFS 1298659 is currently opened against this problem and is in engineering backlog.

There is no workaround.

 

Applies to:  

Product Version Category
Kofax RPA All Troubleshooting