ODBC driver can't execute the Update Query in the Power Automate desktop

MongoDB ODBC Driver Update Query…Issue

Hello Team,

Requriment,

Need to connect the Mongo Database with Power Automate Desktop.

I have established the database connection with PowerAutomate Desktop and can execute the Select Query in the Power Automate SQL statement.

But can’t able to execute the Update Query in the Power Automate SQL statement.

Thanks!!

Exact Erro is :slight_smile:
Correlation Id: a8392f27-b45b-4d07-b145-41ba3450c120

ERROR [42000] [MySQL][ODBC 1.4(w) Driver][mysqld-5.7.12 mongosqld v2.14.5]parse sql ‘UPDATE powerAutomatePosts SET instaPostId = ‘123455ry4t667’ WHERE _id = ‘646d9c2a9ad6287f1ccfa760’’ error: unexpected UPDATE at position 8 near UPDATE: Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Error in SQL statement ERROR [42000] [MySQL][ODBC 1.4(w) Driver][mysqld-5.7.12 mongosqld v2.14.5]parse sql ‘UPDATE powerAutomatePosts SET instaPostId = ‘123455ry4t667’ WHERE _id = ‘646d9c2a9ad6287f1ccfa760’’ error: unexpected UPDATE at position 8 near UPDATE —> System.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 1.4(w) Driver][mysqld-5.7.12 mongosqld v2.14.5]parse sql ‘UPDATE powerAutomatePosts SET instaPostId = ‘123455ry4t667’ WHERE _id = ‘646d9c2a9ad6287f1ccfa760’’ error: unexpected UPDATE at position 8 near UPDATE
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.DatabaseActions.ExecuteSQLStatement(Variant connectionString, Variant sqlConnectionVariable, Variant sqlCommand, Variant& result, Int32 timeout, Int32 getConnection)
— End of inner exception stack trace —
at Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.ExecuteSqlStatement.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary2 inputArguments, Dictionary2 outputArguments)