Insights Custom Variables Are Being Truncated Within Automation Suite

How to increase the character limit of Insights custom variables within Automation Suite?

Issue Description:

The default setting in the Orchestrator limits JSON string fields to 40 characters. This limit causes truncation of strings exceeding this length in Orchestrator's database, leading to incomplete data representation.

Resolution:

Adjust JSON String Length using Orchestrator Configurator

  1. Create a JSON file with the name insights_string_maxlength.json and paste in the code below:
    • {
          "Insights.Etl.Json.MaxStringLen": 100
      }
      • While adjusting the Insights.Etl.Json.MaxStringLen value, tailor it to fit your specific requirements. However, be aware that setting excessively large string lengths can lead to performance issues, particularly in terms of slower data loading times in the dashboard. Choose a balance that meets your data needs without significantly impacting system performance.​​
  2. Ensure ArgoCD is in the system path
    • Prior to running the Orchestrator Configurator tool, it is essential to add ArgoCD to your system's PATH. This step ensures that the necessary commands are accessible during the configuration process. Use the command below, modifying the directory path to point to the 'bin' directory of your ArgoCD installation within the UiPath Automation Suite.

      • #Replace  with the specific version number of your UiPath #Automation Suite installation. 
        

        export PATH=$PATH:/opt/UiPathAutomationSuite//installer/bin

  3. Use the Orchestrator Configurator tool to apply this change. Navigate to the Tools directory within the UiPath Installer and run the following command:
    • #Replace  with the directory location of the json file #created above i.e. /home/root/insights_string_maxlength.json
      

      ./orchestrator_configurator.sh -c /insights_string_maxlength.json

      • Following the update, all new data ingested will reflect the new character limit as set in your insights_string_maxlength.json file. In this example, we used a limit of 100 characters, but it will correspond to whatever value you have chosen for Insights.Etl.Json.MaxStringLen.

Note:
This change will only affect new data entered into the database after the update and won't retroactively alter existing data.