Skip to main content
Question

There is a syntactical error in the SQL statement. - SQL statement got timed out.

  • 26 August 2024
  • 1 reply
  • 32 views

Hello everyone,

I'm encountering a persistent syntactical error in Automation Anywhere A360 when trying to insert data into a database. The error occurs whether I use the `INSERT` or `DELETE` command. Here’s an example of the code I’m using:

```
INSERT INTO RPATest (sCase Id], MRN, Resident_First_Name, Resident_Last_Name)

VALUES (123, '123Test', 'ABC', 'abc');
```


Error message: `There is a syntactical error in the SQL statement. - SQL statement got timed out.`

Interestingly, the same code works perfectly when executed in SQL Server Management Studio (SSMS), so I suspect this issue might be specific to A360.

Has anyone else experienced a similar issue or knows how to resolve it? Any insights would be greatly appreciated!

 

Please try the below query

INSERT INTO RPATest ((Case Id],,MRN],,Resident_First_Name],,Resident_Last_Name]) VALUES (123,'123Test','ABC','abc');

 

Mark as resolved if you find green way.

 

Thanks,

Aravindh S

aravindhkumar002@gmail.com

 

 


Reply