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
- 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.MaxStringLenvalue, 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.
- While adjusting the
-
- 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
-
-
- 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.jsonfile. In this example, we used a limit of 100 characters, but it will correspond to whatever value you have chosen forInsights.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.