Skip to main content
santhalv
santhalv
March 9, 2023
Solved

Appian RPA trying to upload an excel file from my PC to Appian (PC as resource)

  • March 9, 2023
  • 2 replies
  • 0 views

Hi ,

I am trying to upload an excel file from my local desktop to Appian folder. 

I am using upload document action from Appian RPA. I am able to locate the file and get file properties but facing null pointer issue when trying to upload the file to Appian folder. Please refer to the execution log below. Any insights on this would be helpful. 

[WARN] 2023-03-09 19:19:40 - - Method manageException invoked
[ERROR] 2023-03-09 19:19:40 - - java.lang.reflect.InvocationTargetException
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:119)
    at java.base/java.lang.reflect.Method.invoke(Method.java:577)
    at com.novayre.jidoka.client.RobotClientExecutor.invokeMethod(RobotClientExecutor.java:1546)
    at com.novayre.jidoka.client.RobotClientExecutor.onManageExceptionMethodCall(RobotClientExecutor.java:778)
    at com.novayre.jidoka.client.WorkflowProcessor.invokeManageExceptionMethod(WorkflowProcessor.java:202)
    at com.novayre.jidoka.client.WorkflowProcessor.manageException(WorkflowProcessor.java:239)
    at com.novayre.jidoka.client.WorkflowProcessor.start(WorkflowProcessor.java:150)
    at com.novayre.jidoka.client.RobotClientExecutor.workflow(RobotClientExecutor.java:734)
    at com.novayre.jidoka.client.RobotClientExecutor.runJavaTechnologyRobot(RobotClientExecutor.java:640)
    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:414)
    at com.novayre.jidoka.client.RobotClientExecutor.execute(RobotClientExecutor.java:214)
    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 'appian->uploadDocument'
    at com.novayre.jidoka.client.RobotClientExecutor.invokeMethod(RobotClientExecutor.java:1303)
    at com.novayre.jidoka.client.RobotClientExecutor.internalCallAction(RobotClientExecutor.java:911)
    at com.novayre.jidoka.client.RobotClientExecutor.onMethodCall(RobotClientExecutor.java:766)
    at com.novayre.jidoka.client.WorkflowProcessor.start(WorkflowProcessor.java:139)
    ... 22 more
Caused by: java.lang.reflect.InvocationTargetException
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:116)
    at java.base/java.lang.reflect.Method.invoke(Method.java:577)
    at com.novayre.jidoka.client.SDKInvoker.invoke(SDKInvoker.java:56)
    at com.novayre.jidoka.client.RobotClientExecutor.internalInvokeMethod(RobotClientExecutor.java:1332)
    at com.novayre.jidoka.client.RobotClientExecutor.invokeMethod(RobotClientExecutor.java:1286)
    ... 25 more
Caused by: java.lang.NullPointerException
    at java.base/java.io.File.<init>(File.java:278)
    at com.novayre.jidoka.client.impl.appian.Appian.uploadDocument(Appian.java:289)
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
    ... 29 more

Best answer by david.catalan

Hi:

That error happens when the parameter "File Path" is empty.

Are you sure you have filled in this field correctly? Did you test to type the full path of the file there?

2 replies

D
david.catalanAnswer
March 10, 2023

Hi:

That error happens when the parameter "File Path" is empty.

Are you sure you have filled in this field correctly? Did you test to type the full path of the file there?

    santhalv
    santhalvAuthor
    March 10, 2023

    Thank you David. After typing the file path of the file, it worked perfectly. 

    I am getting file properties from 'List the contents of a folder' action and when I pass file path from the properties, facing the error. Thank you. 

    Terms & ConditionsAccessibility statement