"Insert: Failed to convert parameter value from a String to a Single."

Help Studio
1

I need to copy data from an Excel table that has null columns and paste it into SQL Server, but it’s not allowing it because it’s giving this error “Insert: Failed to convert parameter value from a String to a Single.” How can I write null data from the table in the Bank?

2

Hi Thiago,

Please check if the table columns in SQL DB are configured to allow Null values. Only when there is a NULL constraint on any of the columns , you will not be able to insert null values else there is no restriction from Uipath side. Also verify once if datatable and SQL table column data types are matching. Only in that case you get this type of error.

Hope this helps.

Regards,
Sruthi YNM

3

Hey,
Check if your table in the database has the column data types same as that of the columns present in the datatable.

4

Yes, all columns are allowed Null values. When I use the insert activity, I get this error at the end. This image here is from the BD

image
image357×511 5.75 KB

image

5

Hi.
my guess is that de “Ano” field is a string in uipath, therefore when you try to add it to sql this error occur.

You can make sure that the “Ano” is realy a integer in uipath ?

6

The problem is here! the fact that the lines are empty is giving this error, when I fill it with “0” it runs normally! Only I need to get Null.

image
image1654×266 12.9 KB

7

use “” instead of “0”.

8

But it won’t be Null in the database .

9

how can i fix this? I’ve tried several different ways and I haven’t been able to.

10

May be some unexpected syntax or values being passed. Can you try to capture what values are being passed in the insert query from Uipath to the SQL database using SQL profiler. Once we get that , we can try to execute it manually and troubleshoot. May be some unexpected syntax issue or values being passed.

Regards,
Sruthi YNM

1 Like