Error in inserting the excel data from uipath into sql server

[srinivas_pradeep]

Hi Team,
Hope you are well.
I am getting error while inserting the data into sql query.
Can you please help? @Anil_G

Thanks,
Sri

[Anil_G (Anil Gorthi)]

@srinivas_pradeep

Can you please show your datatable?

Few cautions

1. Column names and datatypes should exactly match…
2. Try using select * and then use the same table to check

Cheers

[srinivas_pradeep]

Thank you @Anil_G .

Sure will look into this.

Few things

1. The excel which i am trying to insert into sql server is the information extracted from invoices. Not sure how to check this datatype.

2. I have created table in sql server Audit_ui. This i am unable to check the datatype.

[Anil_G (Anil Gorthi)]

@srinivas_pradeep

When you read the data and run the bot in debug mode …and pause the bot after reading…then you can go to locals panel and check the datatable for their column datatypes

And for sql …click in the table from the menu…and you shpuld be able to see the datatypes there as well…

To know the exact types…use a run query and use a select* from audit_ai and check the locals pane again to see the datatype that it is getting when you do a retreival from database and make sure you give the same datatype…

Cheers

[srinivas_pradeep]

great thank you @Anil_G .
one thing please when i click on the debug mode how can i see the datatype here?

[Anil_G (Anil Gorthi)]

@srinivas_pradeep

Please use this expression in log message and it will print all the column types in the datatable

String.Join(“,”,dt.Columns.Cast(of DataColumn).Select(Function(d) d.Columnname.tostring+ ": " +dt.Columns(cint(d.ordinal)).DataType.ToString).toarray)

dt is the table

Cheers

[srinivas_pradeep]

Great thank you @Anil_G . Please find below i am getting.

its showing all as systemobject. does it means character? thanks

[Anil_G (Anil Gorthi)]

@srinivas_pradeep

So all the columns are objects…try checking the same types when you do select * …ideally column types shpuld be same as what you get when you fo select *

Cheers

[srinivas_pradeep]

Thank you @Anil_G . When i query i am not getting the datatype in sql server.

[Anil_G (Anil Gorthi)]

@srinivas_pradeep

I mean to do the select in your run query activity in your UiPath studio and then check the output column types

Cheers

[srinivas_pradeep]

Thank you @Anil_G . Really appreciate your time and help. It worked. But i am not sure i ran the same query didnt change anything. confused how UiPath works.

[Anil_G (Anil Gorthi)]

@srinivas_pradeep

Same query ?

What do you mean by that

Cheers

[srinivas_pradeep]

I didnt change anything in the workflow or in sql. Please find attached. Except the one you add me to check the datatype.