Skip to main content
Question

Syntactical Error in A360 When Using database Insert/Delete Commands

  • August 26, 2024
  • 4 replies
  • 181 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!

 

4 replies

Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+18
  • Most Valuable Pathfinder
  • August 27, 2024

Hi @Winnie 743,

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

Looks you have enabled message box before inserting/deleting data” please display query in message box how the data is display”

Please try below query,

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


Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+18
  • Most Valuable Pathfinder
  • August 27, 2024

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

Please try below query.

 

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

 

Thanks,

Aravindh S

aravindhkumar002@gmail.com


Shreya.Kumar
Pathfinder Community Team
Forum|alt.badge.img+14
  • Pathfinder Community Team
  • January 28, 2025

@Winnie 743 did ​@Aravindh483 ‘s answer help you out?