For each activity error in dispatcher

Help
1

Hi All,

Could you please help me out to fix below error:

image
image1873Ɨ834 62.1 KB

2

Can we have the complete exception details that could help us
Cheers @Shah

3

Hi @Palaniyappan,

Below are the details:

image
image1869Ɨ729 63.9 KB

4

This implies that the datatable has no records in it
Make sure that the datatable has some data in it
For that use a writeline activity and mention like this
dt_workitems.Rows.Count.ToString
Which will give us the rows count and if that is greater than zero then we need to check with the scope of the datatable variable in the variable panel like it is with whole sequence or not under the column scope in variable panel
Or if that is equal to zero then we need to check the source of the datatable
Cheers @Shah

1 Like
5

Hi @Palaniyappan

Where do I keep the write line activity?

6

before to the for each row activity
@Shah

1 Like
7

Hello,
Have you try to use also the Build datatable activity to create your data table structure?

8

@Palaniyappan I did that but still facing execution issue.

image
image1865Ɨ734 54.5 KB

9

Hi @ Shah,

is your for each inside de same sequence that your DataTable see in variables panel, And why is your DT Value set to ā†’ NULL

1 Like
10

Is the datatable dt_workitems variable is kept with global scope in the variable panel
kindly check that once in the variable panel under column SCOPE and is with the global sequence or not
Cheers @Shah

11

Hi @vmariejeanne Iā€™m using data scrapping. Could you please check my project file? Process.xaml (14.0 KB)

12

Fine
got it
remove the writeline activity and we need to mention this datatable in the for each row loop
image

Cheers @Shah

13

@Palaniyappan, scope is ProcessTransaction:

image
image1857Ɨ820 71.9 KB

14

Just like i say :slight_smile:

test
test1920Ɨ1080 161 KB

15

Try this and let know pls
@Shah

1 Like
16

@Luis261980 what do I need to do now?

17

we are almost done buddy
we have mentioned a new datatable variable and we need to mention the ExtractDatatable variable in for each row loop and not the new datatable we created
Make sure that ExtractDatatable is with global scope in the variable panel
@Shah

1 Like
18

@Palaniyappan, in for each loop, it is dt_WorkItems:

Should I modify it to ExtractDataTable?

image
image1880Ɨ842 61.2 KB

19

yes exactly
@Shah

20

@Palaniyappan, observing compilation error:

image
image1920Ɨ1080 229 KB