Skip to main content
hirushiharant0001
hirushiharant0001
November 3, 2023
Question

Error in RPA Get table values

  • November 3, 2023
  • 4 replies
  • 0 views

Hi,

I am trying to get all the values from a table using Appian RPA Get table values action. But I am getting an error.

This is the table I am trying to get.

Transaction Date #Ref Description Contact Deposit Charges Payment Balance Action



This is the table action configuration.

This is the error I am getting.


[STAT] 2023-11-03 04:37:36 01m 06s (0h) -  - Start action 'browser->get-table-values' - 'Get table values' // dur: - - avg: - etc:
[INFO] 2023-11-03 04:37:36 01m 06s (0h) - Target table has no footer section
[WARN] 2023-11-03 04:37:37 01m 06s (0h) - Method manageException invoked
[ERROR] 2023-11-03 04:37:37 01m 07s (0h) - java.lang.reflect.InvocationTargetException
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:568)
    at com.novayre.jidoka.client.RobotClientExecutor.invokeMethod(RobotClientExecutor.java:1559)
    at com.novayre.jidoka.client.RobotClientExecutor.onManageExceptionMethodCall(RobotClientExecutor.java:776)
    at com.novayre.jidoka.client.WorkflowProcessor.invokeManageExceptionMethod(WorkflowProcessor.java:221)
    at com.novayre.jidoka.client.WorkflowProcessor.manageException(WorkflowProcessor.java:255)
    at com.novayre.jidoka.client.WorkflowProcessor.start(WorkflowProcessor.java:169)
    at com.novayre.jidoka.client.RobotClientExecutor.workflow(RobotClientExecutor.java:732)
    at com.novayre.jidoka.client.RobotClientExecutor.runJavaTechnologyRobot(RobotClientExecutor.java:638)
    at com.novayre.jidoka.client.ETechnologyClient.runJava(ETechnologyClient.java:241)
    at com.novayre.jidoka.client.ETechnologyClient.lambda$static$1(ETechnologyClient.java:37)
    at com.novayre.jidoka.client.ETechnologyClient.run(ETechnologyClient.java:96)
    at com.novayre.jidoka.client.RobotClientExecutor.tryExecute(RobotClientExecutor.java:412)
    at com.novayre.jidoka.client.RobotClientExecutor.execute(RobotClientExecutor.java:213)
    at com.novayre.jidoka.client.ResponseHandler.execute(ResponseHandler.java:324)
    at com.novayre.jidoka.client.ResponseHandler.robotDeclaredResponse(ResponseHandler.java:274)
    at com.novayre.jidoka.client.ResponseHandler.onMessage(ResponseHandler.java:149)
    at com.novayre.jidoka.client.ClientManager.processResponse(ClientManager.java:1715)
    at com.novayre.jidoka.client.ClientManager.internalSendCommandRetry(ClientManager.java:1417)
    at com.novayre.jidoka.client.ClientManager.internalSendCommand(ClientManager.java:1283)
    at com.novayre.jidoka.client.ClientManager.sendCommand(ClientManager.java:1064)
    at com.novayre.jidoka.client.ClientManager.sendCommand(ClientManager.java:1053)
    at com.novayre.jidoka.client.ClientManager.loop(ClientManager.java:1044)
    at com.novayre.jidoka.client.ClientManager.realConnectToServer(ClientManager.java:926)
    at com.novayre.jidoka.client.ClientManager.connectToServer(ClientManager.java:884)
    at com.novayre.jidoka.client.JidokaClient.connect(JidokaClient.java:976)
    at com.novayre.jidoka.client.JidokaClient.mainLoop(JidokaClient.java:578)
    at com.novayre.jidoka.client.JidokaClient.run(JidokaClient.java:564)
    at com.novayre.jidoka.client.JidokaClient.main(JidokaClient.java:403)
Caused by: com.novayre.jidoka.client.api.exceptions.JidokaException: Error invoking method 'browser->get-table-values'
    at com.novayre.jidoka.client.RobotClientExecutor.invokeMethod(RobotClientExecutor.java:1316)
    at com.novayre.jidoka.client.RobotClientExecutor.internalCallAction(RobotClientExecutor.java:908)
    at com.novayre.jidoka.client.RobotClientExecutor.onMethodCall(RobotClientExecutor.java:764)
    at com.novayre.jidoka.client.WorkflowProcessor.start(WorkflowProcessor.java:158)
    ... 22 more
Caused by: java.lang.reflect.InvocationTargetException
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:568)
    at com.novayre.jidoka.client.SDKInvoker.invoke(SDKInvoker.java:56)
    at com.novayre.jidoka.client.RobotClientExecutor.internalInvokeMethod(RobotClientExecutor.java:1345)
    at com.novayre.jidoka.client.RobotClientExecutor.invokeMethod(RobotClientExecutor.java:1299)
    ... 25 more
Caused by: java.lang.IndexOutOfBoundsException: Index 11 out of bounds for length 11
    at java.base/jdk.internal.util.Preconditions.outOfBounds(Preconditions.java:64)
    at java.base/jdk.internal.util.Preconditions.outOfBoundsCheckIndex(Preconditions.java:70)
    at java.base/jdk.internal.util.Preconditions.checkIndex(Preconditions.java:266)
    at java.base/java.util.Objects.checkIndex(Objects.java:359)
    at java.base/java.util.ArrayList.get(ArrayList.java:427)
    at java.base/java.util.stream.Collectors.lambda$toMap$68(Collectors.java:1673)
    at java.base/java.util.stream.ReduceOps$3ReducingSink.accept(ReduceOps.java:169)
    at java.base/java.util.stream.IntPipeline$1$1.accept(IntPipeline.java:180)
    at java.base/java.util.stream.Streams$RangeIntSpliterator.forEachRemaining(Streams.java:104)
    at java.base/java.util.Spliterator$OfInt.forEachRemaining(Spliterator.java:711)
    at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
    at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
    at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921)
    at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
    at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682)
    at com.novayre.jidoka.browser.impl.WebBrowserSupportV3.lambda$extractTableData$4(WebBrowserSupportV3.java:247)
    at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
    at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179)
    at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1625)
    at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
    at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
    at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
    at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
    at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
    at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596)
    at com.novayre.jidoka.browser.impl.WebBrowserSupportV3.extractTableData(WebBrowserSupportV3.java:245)
    at com.novayre.jidoka.browser.impl.WebBrowserSupportV3.getTableValues(WebBrowserSupportV3.java:165)
    ... 32 more


Anyone help on these error please?

4 replies

A
anjalim918645
November 3, 2023

Hello hirushiharant0001,

Error is showing that there is no footer section.
Can you please provide the Site link of this table, so that I can spy the element to get the table values?

hirushiharant0001
hirushiharant0001Author
November 3, 2023

Hi Anjali,

Thanks for the reply. Sorry, I can't share the site details, it is confidential.


What should I provide in the footer section of the table configuration?

Thanks

miguelangel.carnero
miguelangel.carnero
November 9, 2023

 [mention:c313b468f82b40aabe4c80d90a89b0d5:e9ed411860ed4f2ba0265705b8793d05:label=Hirushiharan]  It should work even if the table doesn't have footer. Can you provide us a table with the same structure for us to have a look? If it is a private site, we don't need the site link, but we need the same structure (elements, ID, etc) to see how the table is built. Thanks.

miguelangel.carnero
miguelangel.carnero
November 9, 2023

 [mention:c313b468f82b40aabe4c80d90a89b0d5:e9ed411860ed4f2ba0265705b8793d05:label=Hirushiharan] Could you check if the number of cells in the header is the same as the number of cells in the columns? This log trace "Index 11 out of bounds for length 11" could show they are different and this would make the action to fail.

Terms & ConditionsAccessibility statement