Dispatcher issue

Help
1

Hi All,

Could you please help me to fix below error?

image
image1898×827 70.3 KB

2

@MythicGold,

Please help.

3

Below is the error:

image
image1553×399 16.8 KB

4

Fine
kindly check once with the variable datatable passed to the FOR EACH ROW activity whether it has any rows in it or not
to validate that we can use a WRITE LINE ACTIVITY and mention like this
yourdatatablename.Rows.Count.ToString
which will give us the count of rows

place this writeline activity before to the for each row loop and check with output panel so that we would come to know the issue

Cheers @Shah

1 Like
5

Hi @Shah
Check this s well

Th@nks
@shwin.S

6

Hi @AshwinS2,

This is regarding Assignment 2- Generate yearly report.

7

@Palaniyappan,

Unable to execute write line activity.

image
image1864×865 65 KB

8

may i know what is the datatable name
Cheers @Shah

9

dt_WorkItems

10

@Palaniyappan,
It’s dt_WorkItems

11

@Shah, looking at the PNG it is clear that dt_Workitems is NULL. So any .Rows.Count will fail.
Copy or move the Write Line box to immediately after the place in the code where you expect the dt_WorkItems to receive data (right after the call, look-up or whatever gives you the data).
If it fails there aswell (is NULL/NOTHING) then your call is not returning data. Check the query in the source system and try again.

BR
/Klaus

12

check your invoke for this activity, check ur extract datatable invoke and check your extract datatable activity.

1 Like
13

AND IVE BEEN ASKING FOR THIS FOR I DON’T KNOW HOW LONG