Question

How to solve "There is a syntactical error in the SQL statement."

  • 31 March 2022
  • 7 replies
  • 238 views

User is able to connect to database, do select queries but all insert queries got the same error.

 

Using Automation Anywhere 360 version an as database Access


7 replies

Userlevel 3
Badge +7

Please double-check the queries, sometimes white space or hidden spaces cause these issues.

Userlevel 5
Badge +8

Hi @Alejandra Bonilla​ ,

 

Few tips for working with SQL Statements, build the Queries using SSMS and try to copy the Query from SSM to A360 and try running the bot. Keep a message box and check the values before DB commands to make sure values are available in the respective variables before hitting the DB commands.

What is the solution for this? What is the correct insert query statement

Hello,

i ran the update query in compiler, but still not working in AA :(

 

UPDATE [Dx_Orders$$] SET "Material issue Date" = '$vPostingDate$' WHERE "Sales Document" = '$vSalesDocMaster$'

 

Getting error as -

 There is a syntactical error in the SQL statement.

- SQL statement got timed out.

 

Can someone help ?

 

Thanks

Badge

Hi,

Same issue, INSERT query was working fine but caused only once and keeps on failing after that.

 

Userlevel 7
Badge +10

Hi @rohit.k1,

 

Could you please share your INSERT query and the output that you are getting from it?

It is a best practice to keep a message box just Infront of the INSERT query through which you can identify the issue with the syntax and ensure the data is populating correctly or not.

 

 

Userlevel 3
Badge +6

Dear @AlejandraBonilla,

 

There could be several reasons why you are experiencing an error when trying to perform insert queries using Automation Anywhere 360 and an Access database. Here are a few things you can try to troubleshoot the issue:

  1. Make sure that you have the necessary permissions to insert data into the database. If you do not have permission to insert data, you will receive an error when trying to perform an insert query.

  2. Make sure that the syntax of your insert query is correct. Access uses a specific syntax for insert queries, and any errors in the syntax could cause the query to fail.

  3. Make sure that the data you are trying to insert is valid. If you are trying to insert data that is not in the correct format or exceeds the maximum length of the field, you may receive an error.

  4. Check the log files for any error messages that may provide more information about the cause of the issue. You can find the log files by going to the "Logs" tab in Automation Anywhere 360 and selecting the appropriate bot from the list.

 

Regards,

Reply