Dispatcher issue

Hi All,

Could you please help me to fix below error?

@MythicGold,

Please help.

Below is the error:

image

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

Hi @Shah
Check this s well

Th@nks
@shwin.S

Hi @AshwinS2,

This is regarding Assignment 2- Generate yearly report.

@Palaniyappan,

Unable to execute write line activity.

may i know what is the datatable name
Cheers @Shah

dt_WorkItems

@Palaniyappan,
It’s dt_WorkItems

@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

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

1 Like

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