Unable to excute query uipath

Help Activities
,
1

Hi Team,

Connection ro database is successful
but unable to delete, insert or select query for the same and also no error thrown

Kindly please help

Regards

2

Hi @Supriya_Yenaganti

Check Query Syntax : Ensure that the SQL queries you are trying to execute are valid and have the correct syntax. Any errors in the SQL syntax can cause queries to fail silently.

Try the same query in the SQL and try if it is working then let me know.

Hope it helps!!

3

Hi @Supriya_Yenaganti

  • Make sure that the database is up and running.
  • Make sure that the database is not in read-only mode.
  • Make sure that the query is syntactically correct.
  • Make sure that the query is using the correct database schema.
  • Make sure that the user account that you are using has the correct permissions to run queries.

Hope it helps!!

4

Check syntax of query and given values

5

same query is working in sql

6

Provide a screenshot or log for further review.

7

@Supriya_Yenaganti
Are you using Non query execute activity?

8

@Supriya_Yenaganti

What activities are you using …for connection did you teat the connection and check?

Cheers