Can anyone help me in connecting to Document DB through UiPath. I have tried installing DocumentDB driver and connecting through Database activities but update and insert commands are not working.
Thanks in advance.
Welcome to the community
can you please show what you tried? and what activities are you using and how did you confirm only these are not working
I have downloaded Amazon document DB driver and connected in ODBC data source. I have used this connection in UiPath database “connect” activity and the connection is successful. I am able to fetch data through select query but when I am trying to update or insert I am getting error.
RemoteException wrapping System.Data.Odbc.OdbcException: ERROR [HYC00] ****
ERROR [HY000] ****
Server stack trace:
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 UiPath.Database.DatabaseConnection.Execute(String sql, Dictionary`2 parameters, Int32 commandTimeout, CommandType commandType)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object args, Object server, Object& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
Exception rethrown at :
at UiPath.Database.Activities.ExecuteNonQuery.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
I hope you are not using the same activity for updatw and insert also?
Update and insert needs to be used with execute non query activity
And do you have permissions to update on that db?
Yes Anil, I am using execute non query activity for update. I am able to update manually through mongo query, but when using SQL update query we are getting error.