Automation failing on VM

Help Studio
, ,
1

hI ,

i have developed a automation where in i am fetching data from api then saving data on sharepoint excel and the reading the file and filtering data as per requirement its is working fine on local machine
tried with remote debugging that is also working

but when i executing the process from Orchestrator / assistant after some time it fails with reason that can not find column name [Col Name]

how to resolve this as checked the file column name is there in file

2

@mint

May be there is an extra space or so in the column name…just to be sure…print all the column names in log message and check

String.Join(",",dt.Columns.Cast(Of DataColumn).Select(Function(x)x.ColumnName).ToArray)

Cheers

1 Like
3

@Anil_G thanks will check on local its working fine can that happen when running from assistant ?

4

@mint

We never know…so it is good to print the headers then we can know the root cause

Cheers

1 Like
5

it worked by providing some delay