Extracting Data table working in a independent workflow but not when Invoked in the Init State of the Main workflow

Help
1

When Running the System1_ExtractWorkItemDataTable independently it completes by writing in an excel file, but when invoking it in the Init State of the Main workflow it will cancel the execution and it wont run the data extraction. Please find attached the workflows.InitAllApplications.xaml (5.4 KB)
InitAllSettings.xaml (18.6 KB)
KillAllProcesses.xaml (4.3 KB)Main.xaml (53.1 KB)InitAllApplications.xaml (5.4 KB)ACME_Login.xaml (12.5 KB)
System1_Close.xaml (6.0 KB)
System1_ExtractWorkItemDataTable.xaml (8.3 KB)

2

refere this

thanks

3

Changing the out_ExtractedDT from DataTable to DataRow will return the conversion error:
Cannot assign from type ‘System.Data.DataRow’ to type ‘System.Data.DataRow’ in Assign activity ‘Assign’. (workflow: System1_ExtractWorkItemDataTable)
How have you solved it?

4

use
dt_WIs.Select(“Type=‘WI4’ AND status=‘Open’”).CopyToDataTable()

CopyToDataTable

5

it returns again the conversion error.

Extract2
Extract21078×498 45 KB

6

out_ExtractDT is DataTable Variable??

7

why you change from DataTable to data row?

8

It is a Datarow. I changed it on your suggestion. Extract3

9

make array of datarow
then do need to use CopyToDatatable

image
image967×235 7.48 KB

10

I changed the out_ExtractedDT into an Array of DataRow, but
If I add the CopyToDataTable function, it will return again a conversion error.
Removing CopyToDataTable would remove the conversion error.

Extract4
Extract41153×523 55 KB

11

after made array of datarow
then do need to use CopyToDatatable

1 Like
12

I do not think it needs the CopytoDataTable . DataTable.Select() would be enough to convert the Datatable type into a Array of Datarow, don’t you think?

13

sorry .,you are right

then don’t need to use CopyToDatatable

its typo mistake

1 Like
14

It still stops execution throwing ‘Execution is cancelled’. Every workflow working fine independently, the problem is faced just when run from Init or from Main. Can you please have a look at the InitAllApplications workflow, that is the one that is causing the termination of the business workflow.Main.xaml (55.1 KB)
GetTransactionData.xaml (9.8 KB)
System1_ExtractClientInformation.xaml (8.8 KB)InitAllApplications.xaml (5.6 KB)

15

hello @Vilma
I go through your workflow. its like you don`t follow walkthrough that give in academy

1)image
you put this sequence under If first run - read Config file

  1. image

Again invoke login workflow under initApplication
why SHA1Online workflow invoke there.

i suggest read walkthrough that provides in the academy

Thnaks

1 Like
16

@Vilma
one more thing

image
image987×453 23.7 KB

WIList should me Variable, not an argument where Out_ExtractedDT value store

for you reference i add sample projectClientSecurityHash1.zip (1.7 MB)

Hope its helps
Thnaks

3 Likes
17

Thank you @sandeep13. I will have a look and come back to you.

1 Like