Skip to main content

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!

 

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

 

 


That’s an interesting question, Winnie 743 !

I think the following community members may be able to help 

@ChanduMohammad 

@Tamil Arasu10 

@Olatidoye 

@KhaledMostafaMe 

@Theertha K S 


You can try 

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


 


Hi ​@Winnie 743 ,

 

You missed to mention the sheet name inside the square bracket along with $$ hence the syntactical error.

 

Please reframe your Insert query as below. It will work.

 

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