Error using Get Row(Next)

issues

#1

Hi,

I am trying to read row from excel sheet using Get Row(Next) functionality but getting error :

Build info: version: '2.53.0', revision: '35ae25b1534ae328c771e0856c93e187490ca824', time: '2016-03-15 10:43:46'
System info: host: 'vC01-D001-VSTS', ip: '172.16.2.90', os.name: 'Windows Server 2008 R2', os.arch: 'amd64', os.version: '6.1', java.version: '1.8.0_121'
Driver info: com.freedomoss.crowdcontrol.webharvest.selenium.wrapper.RemoteDriverWrapper
Capabilities [{sikuliThreshold=0.8, webdriver.remote.sessionid=2360fdf7-10a0-44f5-92a9-223ae7b34b35, browserName=universal, takesScreenshot=true, javascriptEnabled=true, SEARCH_ALL_WINDOWS=true, platform=WINDOWS}]
Session ID: 2360fdf7-10a0-44f5-92a9-223ae7b34b35
  org.openqa.selenium.WebDriverException: Build info: version: '2.53.0', revision: '35ae25b1534ae328c771e0856c93e187490ca824', time: '2016-03-15 10:43:46'
System info: host: 'vC01-D001-VSTS', ip: '172.16.2.90', os.name: 'Windows Server 2008 R2', os.arch: 'amd64', os.version: '6.1', java.version: '1.8.0_121'
Driver info: com.freedomoss.crowdcontrol.webharvest.selenium.wrapper.RemoteDriverWrapper
Capabilities [{sikuliThreshold=0.8, webdriver.remote.sessionid=2360fdf7-10a0-44f5-92a9-223ae7b34b35, browserName=universal, takesScreenshot=true, javascriptEnabled=true, SEARCH_ALL_WINDOWS=true, platform=WINDOWS}]
Session ID: 2360fdf7-10a0-44f5-92a9-223ae7b34b35
  	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  	at org.openqa.selenium.remote.ErrorHandler.createThrowable(ErrorHandler.java:206)
  	at org.openqa.selenium.remote.ErrorHandler.throwIfResponseFailed(ErrorHandler.java:158)
  	at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:646)
  	at org.openqa.selenium.remote.RemoteWebDriver.executeScript(RemoteWebDriver.java:545)
  	at com.workfusion.rpa.helpers.RPA.executeScript(RPA.java:745)
  	at com.workfusion.rpa.helpers.RPA.executeGroovyScript(RPA.java:844)
  	at com.workfusion.rpa.helpers.Excel.getRow(Excel.java:202)
  	at com.workfusion.studio.rpa.recorder.model.action.excel.GetRowAction.executeAction(GetRowAction.java:35)
  	at com.workfusion.studio.rpa.recorder.model.action.ActionWithDelay.execute(ActionWithDelay.java:27)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.execute(ActionFlowPlayer.java:278)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.processAction(ActionFlowPlayer.java:217)
  	at com.workfusion.studio.rpa.recorder.model.action.excel.OpenSpreadsheetAction.executeAction(OpenSpreadsheetAction.java:42)
  	at com.workfusion.studio.rpa.recorder.model.action.ActionWithDelay.execute(ActionWithDelay.java:27)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.execute(ActionFlowPlayer.java:278)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.processAction(ActionFlowPlayer.java:217)
  	at com.workfusion.studio.rpa.recorder.model.action.RepeatAction.executeAction(RepeatAction.java:36)
  	at com.workfusion.studio.rpa.recorder.model.action.ActionWithDelay.execute(ActionWithDelay.java:27)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.execute(ActionFlowPlayer.java:278)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.processAction(ActionFlowPlayer.java:217)
  	at com.workfusion.studio.rpa.recorder.model.action.BaseNestedAction.executeAction(BaseNestedAction.java:22)
  	at com.workfusion.studio.rpa.recorder.model.action.ActionWithDelay.execute(ActionWithDelay.java:27)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.execute(ActionFlowPlayer.java:278)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.processAction(ActionFlowPlayer.java:217)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.lambda$1(ActionFlowPlayer.java:104)
  	at java.util.ArrayList.forEach(ArrayList.java:1249)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.lambda$0(ActionFlowPlayer.java:104)
  	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  	at java.lang.Thread.run(Thread.java:745)

Please help.


#2

Hi, @RSingh_EXL_Service2,
Could you provide to us this full log file? and log of node (RPA_FOLDER/logs/*)?
Given stack trace does not contain the necessary information.

Best Regards
Kanstantsin Sheleh


#3

Hi ksheleg,

Please find logs in attachment.rpa-node0-2017-05-03.0.log (38.9 KB)

Regards,


#4

Hi, @RSingh_EXL_Service2,
Yes, it is issue in RPA, we will fixing it in next release.
as workaround for your task, you can open this file in excel, change something and save it.

Best Regards
Kanstantsin Sheleh


#5

Can you provide an estimate of when the release containing this functionality will be available? Iterating through rows in Excel is critical functionality for the processes we want to automate.

Thanks!