hi i tried run my project this morning but the bot ended without any error , it used to be running fine for the past few days . i tried uninstall / update UiPath but nothing works . please help will greatly appreciate it
VDM (1).xaml (33.5 KB)
instead of running project u have debugged the file. if u r using studio from design tab click the dropdown and select Run option. so entire project will be executed
Hi,
For now, can you try to turn on “LogActivities” on ribbon menu then debug run? We can get detailed log and it may help to solve the problem.
Regards,
i tried the log activities and it seem to run all my workflow activities , what could be the issue ?
Hi,
Is there any mail to process in Mailbox? If not, it seems no problem. (as your machine is fast)
It may be good to check raw log file from “OpenLog” button. There is mill second order time information.
Regards,
yes there mail in the mailbox for it to process, what else could be the reason ?
Hi,
Is there possibility the filter expression is not correct?
To isolate cause, what if filter condition is empty?
Regards,
1 Like
if the filter is empty is remove there an error . This project file was running perfectly the past few days , it was just today i run it i face this issue
Hi,
It seems filter expression matter.
To isolate which condition causes problem, can you try the following 2 conditions separately?
"@SQL=(""urn:schemas:httpmail:datereceived"" >= '" +now.AddDays(-1).ToShortDateString+ "')"
"@SQL=(""urn:schemas:httpmail:subject"" LIKE '%VDM%')"
Then check there is any mail which exists in both result?
Regards,
This error is getting because you set max length for Column MailSubject in Build Datatable activity and you are trying to assign bigger than max length string to the column.
Change Max length to higher one and this will be resolved.
Thanks,
Ashok 
hi i also think it the filter issue , i tried doing separately and there two mail that exist in both result. What can i do if i wan both condition to be in the filter ?
Hi,
I just modified the expression a little. Can you try this?
"@SQL=urn:schemas:httpmail:datereceived >= '" +Today.AddDays(-1).ToString("'yyyy/MM/dd HH:mm'")+ "' AND urn:schemas:httpmail:subject LIKE '%VDM%'"
Or as another workaround, filter mails by date only in GetOutlookMailMessages, then filter subject using the following expression.
MailMessages.Where(Function(m) m.Subject.ToUpper.Contains("VDM")).ToList()
Please note that it may be necessary to set larger value at top property in GetOutlookMailMessages.
Regards,
it works thank you so much
What if i want to filter email received today or ystd but with the subject condition how should i write the expression ?
Hi,
it works thank you so much
Which approach works?
What if i want to filter email received today or ystd but with the subject condition how should i write the expression ?
If the above expression doesn’t work as you expect, it might be timezone matter. Can you try the following expression?
"@SQL=urn:schemas:httpmail:datereceived >= '" +Today.AddDays(-1).ToUniversalTime.ToString("'yyyy/MM/dd HH:mm'")+ "' AND urn:schemas:httpmail:subject LIKE '%VDM%'"
Regards,
Pls, check your event logs and the memory used by the bot. We got the same kind of issue where my team running the bot but its stops during the run. so we checked the we have 8 GB Ram and it was used during the data massaging. We increased RAM and it got solved
@xiangyun.koh Hope it solves your issue.
“@SQL=urn:schemas:httpmail:datereceived >= '” +Today.AddDays(-1).ToString(“‘yyyy/MM/dd HH:mm’”)+ “’ AND urn:schemas:httpmail:subject LIKE ‘%VDM%’”
i tried this and this works
Hi,
The above expression will filter mails which is received Yesterday or after and has subject contains “VDM”. Isn’t it same with your second requirement :“What if i want to filter email received today or ystd but with the subject condition how should i write the expression” ?
Regards,
Currently it filtering out email received yesterday but not received today
HI,
How about the following expression? It filters emails by date as UTC base.
"@SQL=urn:schemas:httpmail:datereceived >= '" +Today.AddDays(-1).ToUniversalTime.ToString("'yyyy/MM/dd HH:mm'")+ "' AND urn:schemas:httpmail:subject LIKE '%VDM%'"
Regards,