Getting error "Insert: Incorrect syntax near the keyword 'from'." when using Insert fuction

Help Activities
, , , , ,
1

Hello I have a UiPath flow where I am running a truncate query (see below)
“begin
TRUNCATE TABLE
database…tableA end”

Then I am using database.insert function to insert new rows from a data table variable …
When I run the insert function alone it works perfectly fine
when i run the truncate query before the Insert function it throws this error

Insert: Incorrect syntax near the keyword ‘from’.

please advise

2

Put the whole query on one line, no line breaks.

3

Hello I gave that a try no luck. the query with the truncate statement runs fine its the insert function that throws the error . But if I comment out the query statement then the insert function runs fine …

4

You can’t do them all in one activity. You’ll have to send them each as individual queries.

5

Yes each is in its own Sequence with in the UiPath flow

6

Are you using the Insert activity, or the query activity with a SQL INSERT statement?

Either way, show how you have it configured.

7

Insert activity

I have execute Query activity that is "“begin TRUNCATE TABLE database…tableA end”
Then I have Insert Activity that is inserting a data table .

Both functions work fine individually in the flow but when both are not commented out it errors out on the insert activity with error “Insert: Incorrect syntax near the keyword ‘from’.”

image
image562×540 18.1 KB

8

I would try connect, clear rows, disconnect, connect, insert.

9

Yeah I tried that as well prior didn’t work…

10

It might all be happening too fast, the insert is happening before the truncate completes. Maybe try a delay between the two.

11

yeah tried a 15 sec delay as well before I came here no luck…

12

@tdutcher

Try to use them in tqo differnt workflows and check if that works with different connect and disconnects

cheers

13

Hi @tdutcher ,

Could you let us know if the Error was received again or the resultant was not the correct result ?

Also, was the query checked in SQL Studio itself whether it works properly?

14

Yes independently of each other they work fine but when in same work flow it throws the error

15

The truncate query runs fine on sql and in the UiPath flow it is erroring out in the insert function but when the execute query function is commented out the insert runs fine

16

@tdutcher

I am asking you to keep them in two different workflows and invoke them one after the other…sot hat it looks like a sequencial flow and in invoke workflow activity use isolated option so that it might work

Cheers

17

Ok sounds good will give this a try tomorrow and report back thank you !

1 Like
18

Hello Anil ! this worked perfect ! thank you so much ?

1 Like
19

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.