Friday, July 29, 2022

RPA Support Check list;

 

When you notice that there are Queue items, also verify if they have been there for a long time without being processed ?

 

  • The time of those entries made
  • If they have been processed within 12 or 24 hours since the Queue item creation
  • If they have not been processed, verify if the trigger for that is enabled or disabled.
  • If trigger is disabled, find out why it is disabled – there may / may not be a reason for that
  • If enabled, verify if the jobs associated with that trigger have run or about to run
  • If about to run, verify when it’s time kicks in
  • If already scheduled to run, but not running – Verify if any previous job is struck making this go to pending status
  • If yes, see if the Jobs that are keeping this pending are genuinely running and processing the transactions associated with it’s Queue.
  • If yes, look at the volume and estimated time to finish the volume
  • If no, see why it is struck – verify logs . Try to figure out the root cause. If unknown, please reach out.
  • After the potential root cause is identified – log a defect and create a backlog item
  • Verify if the stuck job can be killed without any impact
  • Ensure the actual scheduled job is running as expected and verify if the transactions are being processed
  • During the transactions processing, verify if there are mixture of Success, Fail and Application Exceptions.
  • If exceptions counts are noticeably high, verify if they are valid reasons.
  • IF more application exceptions or invalid reasons for exceptions – reach out or create backlog item.

Notes to Self:


  1. Have the right to run the jobs if number of pending jobs in Queue are high. – Should monitor if queue items go in successfully if not stop the job.
  2. Check if all triggers are enabled. If not, send an email out.
  3. Check if jobs are faulted. If not let team know if Queue items are pending to be processed.
  4. If Application Exceptions keep occurring to a bot stop the bot and let the team know. If Any authentication with Salesforce or SimpliGov or ABBYY fails.
  5. Wish Disable trigger has some notes feature on Orchestrator. Also, Any info. on historical (on and off) as well as some SSO ID helpful for tracking.
  6. If bot is not processing transactions right, restarting might help.
  7. App Robot Number - X; Get to know the robot names.

Thursday, July 28, 2022

Extract key value from json array; UiPath RPA;

 
for each item in CType(jrez2("records"),JArray)
















Send Document to Salesforce using API; Postman; UiPath RPA

Postman Collection


PO Environment:






HTTP Request POST
OAUTH:

https://app.sandbox.my.salesforce.com //instance url

//Add below Parameters to HTTP Request

username

password

grant_type

client_id

client_secret


Get Response content to json file. Deserialize to get access_token


ADD FILE: HTTP Request POST

//Convert the document to Bytes[] bytes

https://app.sandbox.my.salesforce.com/services/data/v53.0/sobjects/ContentVersion

//Add below json to body of HTTP Request

{"PathOnClient": "C:\Users\Public\Documents\test.pdf",

  "Title": "0.jpg", //docName

  "VersionData":Convert.ToBase64String(bytes)

}


Get Access Token:






Pass Header: Authorization String access_token






Http Request GET

GET ContentDocumentId

https://app.sandbox.my.salesforce.com/services/data/v53.0/query/?q=SELECT ContentDocumentId FROM ContentVersion where Title = '+"0.jpg"+'

Pass Header: Authorization String access_token



HTTP Request POST

Assign the File to Case:

https://app.sandbox.my.salesforce.com/services/data/v53.0/sobjects/ContentDocumentLink

Pass below in body


{ "ContentDocumentId":"The ID from GET function",

"LinkedEntityId":"CASE ID",

"ShareType":"V"

}

Pass Header: Authorization String access_token



Helpful video:

https://youtu.be/ONpe-O2eMIM






Tuesday, July 26, 2022

UiPath Custom Library; Naming convention; RPA

 Company.ProjectName.Process


Example: FM.DocuSign.Activities





Similar to out to box libraries:



Thursday, July 21, 2022

Apache Load balancer for WebLogic Managed servers;

 http://weblogicexpert.weebly.com/configuring-apache-web-server-with-weblogic.html



Wednesday, July 20, 2022

Add Queue Items from Orchestrator; Manual upload; UiPath RPA;

 1. Create an Excel with Queue Items to be added. 



2. Upload the Excel to Orchestrator queue. 





3.                                                                                                                     
4.                                                                                                           
                                                                                                                 






Tuesday, July 19, 2022

Invoke Method; Add values to Dictionary; UiPath RPA;

 



Enable to read Outlook emails/attachments; UiPath RPA;

 Knowledge: "Get Outlook Mail Messages" Activity Does Not Retrieve Mail Body And From Address (force.com)

https://drive.google.com/file/d/1BpCbEp5TH-Crd-svKmyCM80LhAdsJQ69/view?usp=sharing

Issue: Unable to read outlook attachments.

 

Description: Get Outlook activity fails to read emails from inbox.

 

Activities: UiPath.Mail.Activities (1.15.2)

Studio Version: 22.4

 

Screenshot:



Updates to Outlook Group policies might be required.

Monday, July 18, 2022

UiPath Code Review template;

https://docs.google.com/spreadsheets/d/1c-q5pqQZENblAGWqnrmxhmiPt1obcI4-/edit?usp=sharing&ouid=108428966501894711148&rtpof=true&sd=true 



Action Center; UiPath RPA ; Embed image

 <embed src={{data.image_storage}} width="1000px" height="600px"> </embed>

OR

 <img src={{data.image_storage}} width="1000px" height="600px"> </img>

image_storage is the parameter passed on from Form Collection. 

*storage is the key word to let the activity know that the document is from storage bucket.

Friday, July 15, 2022

Connect Action Center installed on a different server to the Orchestrator; UiPath

 Orchestrator.dll on windows server where Orchestrator is installed can be configured to add the server where Action Center is installed.

Wednesday, July 6, 2022

Get Category Id after adding custom Categories and Sub-Categories in Automation Hub; RPA

 

Inspect element on chrome browser can be used to get the category id to be able to add the user to Automation Hub.



Tuesday, July 5, 2022

Short-cut to get to log file (Ctrl+L) ; UiPath Studio; RPA

 






Everyday these files get generated. (Whenever you use Studio and run projects)