Issue with DB update query

[MayurGangrade]

There is an strange issue during database update query run. I am trying to update DB table data using update query and it's throwing an exception saying "Internal : Could not execute code stage because exception thrown by code stage: Cannot find table 0." Though values are updated in background. Issue is happening with MS Access as well as Oracle DB.  Is there any way to avoid this exception and making sure query executed successfully.  Thanks.

[TomCirone]

have you tried running the query outside of blueprism (i.e. in SQL Developer).  If the same error comes there it's an issue with your query, not BluePrism.

[AmiBarrett]

This may have less to do with the raw query, and more to do with the actual code you're using to interact with the server. Are you using a default action that shipped with Blue Prism, or is this one you wrote? If the former, which action are you using? If the latter, are you able to provide a sanitized copy of the code?