Can’t insert to mysql connected using ODBC

Help Activities
1

I’m trying to insert to my data table on mysql using a run command activity but i get an error UiPath can’t read. The connection to mysql works and i’m able to read but i just can’t insert to it. I first had issues with name parameters but i switched it to positional and tried but still it does not work

2

Hi @User_Selvam

Could you please share more details like the query you are using to insert row, screenshot of your workflow. Error screenshot

3

Im using the run command activity with this query;
“INSERT Into invoices (provider_name, po_id, invoice_number, invoice_date, subtotal, tax, total, due_date) VALUES (?, ?, ?, ?, ?, ?, ?, ?)”

These are the parameters passed

image
image713×517 45.1 KB

I tried to wrap it in try catch and specifically get error message out and this is all i got

ODBC error while query to sql for invoice: System.Data.Odbc.OdbcException (0x80131937)\r\n at UiPath.Database.Activities.ExecuteNonQuery.HandleException(Exception ex, Boolean continueOnError)\r\n at UiPath.Database.Activities.ExecuteNonQuery.ExecuteInternalAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)\r\n at UiPath.Database.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)\r\n at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager