Getting error "assign exception has been thrown by the target of an invocation"

Help
1

Hi All,

I have an error which is always throwing this error
“assign exception has been thrown by the target of an invocation”
As that variable has values it’s throwing errors.

so if there’s a solution please let me know it as soon as possible.

2

Hi
Is this assign used inside any loop
Cheers @SOURAV_KUMAR_DAS

1 Like
3

Hi Palaniyappan Sir,

Yes Sir.

4

That’s the issue
If that assign is used in a for each or for each row loop and if the TO property variable is from that loop then it will show
Like if we are trying to modify a element or delete a element from the variable that the loop is iterating with then we will face this issue
Cheers @SOURAV_KUMAR_DAS

2 Likes
5

Hi Palaniyappan Sir,

So is there any solution Sir.

6

Kindly elaborate the process pls
Cheers @SOURAV_KUMAR_DAS

1 Like
7

Hi Palaniyappan Sir,

Sure Sir,

  1. At first I am scrapping out the data from a website using Data Scrapping, to get the names and URL’s.

  2. And Iterating through the URL want to scrape the extra data’s and write it in Excel sheet.

This goes on for each URL’s and I am getting error in the (2) step.

So is there any solution please let me know Sir.

1 Like
8

Hi Palaniyappan Sir,

Then will it work in flowchart and that flowchart will be in for each loop?

9

Hi All,

If there’s a solution for my above problem let me know it as soon as possible.

10

@SOURAV_KUMAR_DAS
Can you share sample for your code?

1 Like
11

I will send you the screenshot.

12

Ok Share it here please.

13

Let’s take like we have a datatable named dt
Now that dt will be having data in it under a column named url

Now use a For each row activity and inside that use a Open browser activity
Where mention the url as row(“yourcolumnname”).ToString

Cheers @SOURAV_KUMAR_DAS

1 Like
14

Done the process Sir.
Inside For each what I should do to scrape those data’s

15

Hi Sir,

Below is the screenshot for the verification Sir.

image
image1220×744 59.5 KB

image
image1188×747 45.7 KB

image
image1165×741 24.1 KB

image
image1079×747 23.7 KB

image
image1083×749 26 KB

image
image1077×749 27.2 KB

image
image1076×746 23.3 KB

image
image1078×684 15.4 KB

So these are the screen shots Sir.

17

Hi @SOURAV_KUMAR_DAS
Did you find a solution to this? I am facing the same issue.

18

Hi all! Although this reply comes very late, I’m going to leave it here as it may help others who encounter such an issue in the future.

The exception in this message (although it seems vague) shows that the Assign is not the source of the exception. In this case it’s useful to have a look at the exception details; there, you can find the clue as to what happened. image

In my case (and I believe this is also what happened to others) it was this:

Cannot set column ‘XXXX’. The value violates the MaxLength limit of this column.

By default, a DataTable Column of type String has a maximum length of 100 characters. If you try to assign a string value of greater length, this is the exception thrown. The simple fix, for this case, is to increase the MaxLength property of the column to a value that can accommodate the longest string you expect to have.

Cheers,
Alex.

11 Likes
19

hello there…!! actually im facing this error and i increase the maxlength but still i facing that error

and my input value is 99.22

error is:-Assign: Exception has been thrown by the target of an invocation.

20

Hi @swanand_deshmukh!

What is the type defined for the column? And how are you assigning the value to it?

Also, can you please get the Exception details (by clicking on the “Details” button, as shown in my message) and post the entire exception here?

Cheers!

21

i define column as string in build data table
and, i assign value dataRow(“Column_name”)=row(2).tostring

1 Like