Run Query scalar variable error

Help Activities
, ,
1

image
Hi everyone, can I please get assistance on this error here.

Here is how I declared the variable currentDate:

The image shows a query parameter configuration screen containing rows specifying input details such as name, direction, type, and value. (Captioned by AI)
The image shows a query parameter configuration screen containing rows specifying input details such as name, direction, type, and value. (Captioned by AI)807×286 13 KB

The image displays a SQL query snippet for inserting data into a table named Respond.ComplaintCases_2 with specific column names and values. (Captioned by AI)
The image displays a SQL query snippet for inserting data into a table named Respond.ComplaintCases_2 with specific column names and values. (Captioned by AI)921×183 8.16 KB

Forum Engagement Daily Reports
2

looks like SQL query is incorrect.
In your subquery table name is missing

3

Hi @adi.mehare , the table name is Respond.ComplaintCases_2

4

You are using select keywork in your query,

The image shows a SQL query for inserting data into a database table named 'Respond.ComplaintCases_2' using selected values from variable parameters. (Captioned by AI)
The image shows a SQL query for inserting data into a database table named 'Respond.ComplaintCases_2' using selected values from variable parameters. (Captioned by AI)1844×362 74.1 KB

if you do not wish to select values from another table to insert into Respond.ComplaintCases_2, use below syntax.

INSERT INTO table_name (column1 , column2 , column3 , …)
VALUES (value1 , value2 , value3 , …);

5

@Anelisa_Bolosha1,

Try this approach:
Remove @ from the parameters and keep only the string like PartnerAdminRef

6

Hi @ashokkarale

This image displays a tabular interface listing parameters with their names, directions, types, and corresponding values. (Captioned by AI)
This image displays a tabular interface listing parameters with their names, directions, types, and corresponding values. (Captioned by AI)797×245 11.2 KB

I tried and got

The image depicts a runtime execution error message in UiPath indicating invalid column names in a SQL query. (Captioned by AI)
The image depicts a runtime execution error message in UiPath indicating invalid column names in a SQL query. (Captioned by AI)467×230 5.63 KB

7

@Anelisa_Bolosha1,

Which database are you using? Try prefixing : to parameters. I read it somewhere. Worth trying.

8

I’m using the
image
image

I want to insert to:

image
image896×109 2.83 KB

The image shows an SQL query being edited, involving an INSERT INTO statement with selected parameters. (Captioned by AI)
The image shows an SQL query being edited, involving an INSERT INTO statement with selected parameters. (Captioned by AI)903×194 8.3 KB

The image shows a parameter table containing details with columns for Name, Direction, Type, and Value with corresponding string data. (Captioned by AI)
The image shows a parameter table containing details with columns for Name, Direction, Type, and Value with corresponding string data. (Captioned by AI)764×276 11.3 KB

9

@Anelisa_Bolosha1

in the first screenshot that you provided in first question the only error is you need to use @RespondCapture_Date instead of @Currentdate

left side name is what you need to use

cheers

10

Hi @Anil_G yes I am using the left side name…the right side is the variable with the value

11

@Anelisa_Bolosha1

please check the last line you have used right side variable name instead of leftside argument name

Screenshot 2025-07-14 at 7.01.43 PM
Screenshot 2025-07-14 at 7.01.43 PM456×102 12.5 KB

cheers

12

Oh thank you, changed it but I now got this:

The image displays an error message about a SQL exception where string or binary data would be truncated in a database operation. (Captioned by AI)
The image displays an error message about a SQL exception where string or binary data would be truncated in a database operation. (Captioned by AI)667×198 6.11 KB

13

What type of data is PartnerAdminRef set to? varchar(20), int, etc?
The error message indicates that the field is not big enough to hold the data.
If it’s characters you could try to set PartnerAdminRef to varchar(max) instead of what you have now.

14

@Anelisa_Bolosha1

as per error the data you are sending in and the data that is required for tables are not matching or to be precise there is a size limitation

prticularly partneradminref

cheers

15

I saw on my select * query on the where- I did not put a value there

16

Thanks Anil This solved it

1 Like
17

Hi @pierre.aberg the data type is varchar(25) and the value of PartnerRef is always 18 characters, it was not the data type issue

18

Thank you all so much for your assistance :beating_heart:

19

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.