topic RE: Cannot find table 0 in Product Forum

Cannot find table 0

Vikram.R — Mon, 22 May 2023 13:29:00 GMT

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
------------------------------

RE: Cannot find table 0

ewilson — Mon, 22 May 2023 15:25:00 GMT

@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
------------------------------

RE: Cannot find table 0

Vikram.R — Tue, 23 May 2023 04:10:00 GMT

@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
------------------------------

RE: Cannot find table 0

AtyantSrivastav — Tue, 23 May 2023 12:49:00 GMT

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
------------------------------