Cannot find table 0

[Vikram.R]

In SQL SSMS if I execute the query i am not getting any error but when I execute through blueprism I am getting issue

Regards
Vikram

------------------------------
Vikram Ramesh
------------------------------

[ewilson]

@Vikram.R 

You're going to have to provide more details. How are you executing the query via Blue Prism? Are you using the Data - SQL Server VBO, UI automation, etc. Can you share screenshots of your Action stage?

Cheers, 

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[Vikram.R]

@ewilson I am executing SQL Insert Query using Data - SQL Server VBO but I am getting "Cannot find Table 0" in message variable but if I evaluate the query and execute directly in SSMS its working.

------------------------------
Vikram Ramesh
------------------------------

[AtyantSrivastav]

What Schema your table reside in. Is it [dbo].[yourtable]? If the query is something like this "Insert into [dbo].[yourtable]" then remove [dbo]. And put only the table name and check.

------------------------------
Atyant Srivastava Deputy General Manager
Deputy General manager
Personal
Asia/Kolkata
------------------------------