Skip to main content
Question

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

  • August 26, 2024
  • 1 reply
  • 121 views

Forum|alt.badge.img+1

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 ([Case 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!

 

1 reply

Forum|alt.badge.img+4
  • Navigator | Tier 3
  • 20 replies
  • August 28, 2024

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

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings