Error using Insert activity within database workflow

Help Studio
1

Hi, everyone.
Can someone assist me I encounter problem on using insert activity to insert database into database. I tried using run command activity and run manual syntax command and it does not have any issue but when im using insert activity its come out with error as below. I try simplified my data to just one row just to test to push data successfully but it just does not work. Below is my sample of activity flow, excel data ,the error and my database. My database first column and last column is auto increment each time i push data in.

IMG-4860
IMG-48601920×2560 1.13 MB

IMG-4861
IMG-48611920×1440 645 KB

IMG-4862
IMG-48621920×1440 601 KB

IMG-4863
IMG-48631920×1440 654 KB

IMG-4864
IMG-48641920×2560 1000 KB

Would be a great help if anyone have any advice for me.
Thank You,
Best Regards,

2

Hi @Paankhand

I see that the Number of columns are different in your SQL DB and DataTable.
Can you please add all the columns in your DataTable and then try runnning the workflow.

Your Ops_Queue_monitoring_id is a primary key which is not even present in you dataTable.

3

Hi @adiijaiin,

Thank you for the advice but I have add all the columns in my Datatable matched my database but still I receive the same error as before.

4

@Paankhand Did you built connection in ODBC through Tns.ora?

5

Can you display the query and run the same directly into My SQL, see if you are able to execute that ?

6

I’m not sure Tns.ora but yes I built connection using ODBC.

7

I have try using Run Command activity using this syntax i attached below and UiPath able to execute it successfully into database.

1DB591DE-8BA6-4E47-94F8-BB309F569EB4
1DB591DE-8BA6-4E47-94F8-BB309F569EB41920×1080 308 KB

8

@Paankhand was connection successful?