Pyx
March 21, 2023, 7:34am
1
hi, what does this error mean
Pyx
March 21, 2023, 7:41am
3
here is the type argument as datatable
Jithesh_R
(Jithesh Karkera)
March 21, 2023, 7:41am
4
Hii @Pyx ,
Instead of Parallel for each can’t you use For each Activity and provide dataset.Tables by keeping the type argument as System.DataTable?
Regards,
Pyx
March 21, 2023, 7:48am
6
hi i cnt seem to find typearguement to change
Hi @Pyx
Check property panel. Change type argument to DataTable.
ushu
(Usha kiranmai)
March 21, 2023, 7:51am
8
Hi @Pyx Can you remove append range and reconfigure again
Jithesh_R
(Jithesh Karkera)
March 21, 2023, 7:52am
9
@Pyx ,
Can you please double check
Its working for me
Regards,
Pyx
March 21, 2023, 7:57am
10
hi my properties panel completely doesnt show, could it be due to the update?
Pyx
March 21, 2023, 7:59am
11
it works now, thanks! but i have another error
could it be due to the placement of the activity?
Jithesh_R
(Jithesh Karkera)
March 21, 2023, 8:00am
12
@Pyx ,
Yes in the latest version there is no option to change the argument. This might be a bug not sure.
Bt inorder to use dataset.tables you need to convert the type argument to DataTable.
Pyx
March 21, 2023, 8:01am
13
i used parallel for each with the others suggestion and now my script has another issue,
@Pyx , can you debug and verify which activity is throwing this error and if data exists in dataset?
Pyx
March 21, 2023, 8:23am
15
i disabled that activity, instead appending has issues
this shows that the excel is being usedbut i dont have it open or used…
ushu
(Usha kiranmai)
March 21, 2023, 8:25am
16
@Pyx The error is giving at Present Validation Station . It looks like there is an issue Document Object Model. Can you please check you are giving the right value
ushu
(Usha kiranmai)
March 21, 2023, 8:26am
17
@Pyx Can you use Kill Process activity to kill excel before excel scope
@Pyx
Before Append Range, keep Kill Process and in properties Process Name as EXCEL
So, if there is any instance opened that will be killed before the Append Range
Pyx
March 21, 2023, 8:43am
19
stated that excel doesnt exist
Pyx
March 21, 2023, 8:45am
21
tried a different one and issue is with classtype