Problem to execute my script

Help Studio
, , , ,
1

Hi Guys

I am currently experiencing an issue while running my script that sends daily newsletters to my clients. At the end of each repetition, the script stores the current contact in an asset so that on the following day, the script can continue from where it left off. I am using UiPath Studio for this automation.

However, I am encountering a problem where the script is not able to retrieve the contact stored in the asset on the next day. I have checked and verified that the asset is being stored correctly at the end of each repetition, but the script is not able to retrieve it.

I have tried to troubleshoot the issue by checking the variable types and data formats, but I have not been able to identify the root cause of the problem. I suspect that there might be an issue with how the asset is being retrieved or how the data is being passed between different parts of the script.

I would appreciate any guidance or suggestions on how to resolve this issue and ensure that the script is able to retrieve the correct contact from the asset and continue the automation from the correct point each day.

The problem is:
image
And this is my sequence:

image
image762×419 16.4 KB

image
image
image
im using this to jump to the next contact in this case:
dbAssociadosAtivos.AsEnumerable().Skip(index + 1).CopyToDataTable

This is my file:
Main.xaml (55.1 KB)

2

@Matheus_Antunes

Try giving the extension of the csv…

And could you please show the detailed error you get in the output panel

Cheers

3

What do you mean with give the extension of the csv? Use the full path file in the activity “Read CSV”?

The problem: An unexpected error occurred during the library compilation process:
Assembly compilation generated the following errors:

  • Syntax error.

And in the log file have this:

13:48:42.7891 => [WARN] [UiPath.Studio] [1] GetCompilableWorkflows: allWfCount = 2, normalizedDistinctWfCount = 1 13:48:47.8824 => [ERROR] [UiPath.Studio.App.Logging.OutputLogger] [51] An unexpected error occurred during the library compilation process: Assembly compilation returned the following errors:

  • Syntax error. 13:48:47.8830 => [ERROR] [UiPath.Studio] [51] An unexpected error occurred during the library compilation process: Assembly compilation returned the following errors:
  • Syntax error.
4

@Matheus_Antunes

  1. In read cav give the xtension as well…i see only file name…

  2. And in get assets try removing the folder path…if studio is connected to same folder then no folder path is needed

  3. If lastprocessedrow is string then please remove .ToString from there

One of the activities you are using is having some character which is not supposed to be there…that is the reason compilation is failing

Cheers

5

Ok.
Now i’m having another problem.
I put the extension of CSV and i removed the folder path of assets

  1. If lastprocessedrow is string then please remove .ToString from there → You are talking about of CellValue of Output of LookUp Data Table activity?

Inside in the activity LookUp Data Table in Output CellValue i have this problem:
Option Strict On disallows implict conversions from “String” to “Double”.

image
image816×412 33.4 KB

6

@Matheus_Antunes

I see in output you assigned a string…ideally you should be giving a variable there…can you please remove the value and then click ctrl+k and create a variable for the output please

cheers