Data Table ambiguity issues with modern excel activities

Help Studio
,
1

Unexpected error has occurred during the library compilation process:
The assembly compilation returned the following errors from ‘Main.xaml’:

  • (1925) : error BC30560: ‘DataTable3’ is ambiguous in the namespace ‘System.Data’.
  • (1929) : error BC30560: ‘DataTable3’ is ambiguous in the namespace ‘System.Data’.
  • (1935) : error BC30560: ‘DataTable3’ is ambiguous in the namespace ‘System.Data’.
  • (1939) : error BC30560: ‘DataTable3’ is ambiguous in the namespace ‘System.Data’.
  • (350) : error BC30560: ‘DataTable3’ is ambiguous in the namespace ‘System.Data’.
  • (350) : error BC31143: Method ‘Public Function ValueType___Expr30Get() As System.Data.DataTable3’ does not have a signature compatible with delegate ‘Delegate Function Func(Of System.Data.DataTable3)() As System.Data.DataTable3’.
  • (350) : error BC31143: Method ‘Public Sub ValueType___Expr30Set(value As System.Data.DataTable3)’ does not have a signature compatible with delegate ‘Delegate Sub Action(Of System.Data.DataTable3)(obj As System.Data.DataTable3)’.
  • (657) : error BC30560: ‘DataTable3’ is ambiguous in the namespace ‘System.Data’.
  • (657) : error BC31143: Method ‘Public Function ValueType___Expr30Get() As System.Data.DataTable3’ does not have a signature compatible with delegate ‘Delegate Function Func(Of System.Data.DataTable3)() As System.Data.DataTable3’.
  • (657) : error BC31143: Method ‘Public Sub ValueType___Expr30Set(value As System.Data.DataTable3)’ does not have a signature compatible with delegate ‘Delegate Sub Action(Of System.Data.DataTable3)(obj As System.Data.DataTable3)’.
  • (967) : error BC30560: ‘DataTable3’ is ambiguous in the namespace ‘System.Data’.
  • (1920) : error BC30560: ‘DataTable3’ is ambiguous in the namespace ‘System.Data’.

I keep getting these types of errors when I try to debug my current workflow. I have had this issue before and was able to delete some things within the json that fixed it but that is not working this time. Is there a way to prevent this from occurring? Every time I try to debug that number increases by 1.

2

@stike21

Do you have DataTable3 as a variable declared in your code? if yes, can you rename it to something else and try?

One more possible solution is, delete the datatable variable and now declare it from the property you are trying to assign it using Ctrl+K

Reference thread for similar issue:

3

@stike21

Go to arguments or variables panel and wherever you see datatable3 or datatable2 etc..click on the variable type and change it to datatable

This should solve the issue

Cheers

4

OK, you can add import below namespace

  1. “System.Data”
  2. “System.Data.DataTable”

image
image308×394 8.61 KB

5

All of the above options do not work… I do not have a variable with that name. I have set it back to System.Data.Datatable multiple times. I have tried creating the data table in the variables panel as well as in the activity itself with ctrl+k. Nothing seems to work.

6

@stike21

Try upgrading the project packages to the latest possible version.