Skip to main content
Question

Syntactical Error in A360 When Using database Insert/Delete Commands

  • 26 August 2024
  • 3 replies
  • 28 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!

 

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');
 

If the above query doesn’t helps please check out the link https://apeople.automationanywhere.com/s/article/There-is-a-syntactical-error-in-the-SQL-statement-SQL-statement-got-timed-out

 

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

Reply


Terms & ConditionsCookie settings