Skip to main content
Question

Syntactical Error in A360 When Using database Insert/Delete Commands

  • August 26, 2024
  • 4 replies
  • 103 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+16
  • Most Valuable Pathfinder
  • 3274 replies
  • 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+16
  • Most Valuable Pathfinder
  • 3274 replies
  • August 27, 2024

Forum|alt.badge.img+4
  • Navigator | Tier 3
  • 20 replies
  • 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+9
  • Pathfinder Community Team
  • 95 replies
  • January 28, 2025

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


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