Archive: RPA Knowledge Articles

Discover how to make your wizards more interactive with text and input fields in Nintex RPA. Learn to customize bubble content with formatted text, images, hyperlinks, and dynamic variables. Plus, see how to set up input fields to collect essential user data, with options like text, dropdowns, checkboxes, and more! 👉 Watch Now:   

Kindly check with TE (Senior team) for the latest HF links.  

Check out our latest tutorial on the Split dynamic advanced command in Nintex RPA!Learn how to perform calculations on variables using constants or other variable values to enhance your wizards. What You Will Learn:How to use the Split Dynamic Advanced Command. Practical examples of variable splitting. Best practices for effective automation with this command.For more information on advanced commands check out our help center Join the Discussion:Share your thoughts and questions below!

TopicWizard related queries. Instructions Query DescriptionSQL QueryExtract wizards that are created/ imported/ duplicated in the last X daysDECLARE @num_Duration bigint;SET @num_Duration = 30; (Change the duration (days) here as necessary)SELECT A.ChangeID, A.ScriptID, B.Title AS WizardName, A.ChangeDate, A.UserName,A.Title, A.DescriptionFROM LeoScriptChangesHistory A,LeoScripts BWHERE A.ScriptID = B.ScriptIDAND A.Title IN ('Wizard created','Wizard insert (during import)','Wizard duplicated')AND ChangeDate >= DATEADD(DD,-@num_Duration,GETDATE());Extract wizard changes in the last X daysDECLARE @num_Duration bigint;SET @num_Duration = 30; (Change the duration (days) here as necessary)SELECT A.ScriptID, A.Title AS WizardName, C.Name AS CatalogName, D.Name AS LibraryName, B.ChangeDate, B.UserName, B.StudioVersion, B.Title, B.DescriptionFROM LeoScripts A,LeoScriptChangesHistory B,LeoLibrariesCategoriesTree C,LeoScriptsLibraries DWHERE A.ScriptID = B.ScriptIDAND A.CategoryID = C.Categor

TopicRPA version - 22.9.3When sending an email in Nintex RPA, using a stand alone wizard, the email will send successfully.When another wizard that calls the first wizard is being used (aka embedded wizard), RPA fails to send email.Instructions Use below hotfix to avoid the issue - https://public.kryon.io/RPA-Versions/22.9/22.9%20Archive/22.9.3/HotFixes/RPA-17030%20-%20OAuth%20mail%20data%20not%20fetched%20from%20embedded%20wizard%20-%2022.9.3.5.zip

TopicIf you need MSI kits please follow the instructions below.Instructions Below are the instructions:Navigate to <Drive>:\Nintex\Support Tools\MSI Wrapper.Run pgplwiz.exe. An application window will open.Click the "Browse" button and select the respective Robot or Studio Executable.In the "Command Line Parameters," set the respective config parameters, that are valid for the customer's server like: Main Server Name, Http/NetTcp/HTTPS/Nginx ports, robot/assistant mode, etc.Example: LeoServer=myappServer.com /s ALLUSERS=TRUE NetComPort=8082.Note, for these parameters apply the same rules as for regular cmd parameters.More parameters can be found in additional information section below.For "Group Policy Display Name" set Nintex Robot/Studio.Once the parameters are set, click "Save As" and select the name and location of the Output MSI files.Click "OK" and wait for the file to be generated. Another option, instead of using the Installer's MSI wrapper, is to download Orca and use to

TopicSolution of issue : Sequelize Connection error in SEQ  Instructions Issue - During RPA server installation, there are times you could encounter an error withSequelize Connection Error (Server requires encryption, set ‘encrypt’ config to true)as below:To resolve this, in the config.prod.properties.json file the MSSQL_ENCRYPT line should be set to true as shown below:For the changes to be applied you need to run configureAll.ps1 script, this can be done with the following powershell command from the folder:configureAll.ps1 -h “<InstalledDrive>:\Nintex”However, there are times when the Powershell script doesn’t run due to issues, e.g. server execution policies that cannot be overridden, or the Powershell windows closes on its own when running configureAll.ps1.Cause :Possible Powershell restrictions at GP level or organization level.Solution :Use StopAll.bat with administrator privileges to stop all RPA services. This can be found under <Installed Drive>:\Nintex(e.g. E:\Ni

TopicThis article describes how to use DELETE queries to reduce DB size and how to obtain Console Summary Tab results using SQL queris Instructions IMPORTANT NOTE : Always perform a full DB backup before making any changes to the DB. Query DescriptionSQL Query  Delete tasks from tasks history to reduce database size(Only applicable from 21.4)Clear redis and restart unattended-ui-svc thereafter to update the console.DECLARE @date date;SET @date = '<cutoff date in yyyy-mm-dd format>'DELETE FROM [history].[tasks_history] WHERE created_at < @dateDELETE FROM [history].[tasks_summary] WHERE created_at < @dateDELETE FROM [tasks].[tasks_task_data] WHERE task_allocation_time < @dateDELETE FROM [queues].[queues_task_data] WHERE task_create_time < @dateDELETE FROM LeoLogInHistory WHERE LogInTime < @dateDELETE FROM LeoStatistics WHERE Time < @dateDELETE FROM [history].[user_runtime_action_history] WHERE created_at < @dateConsole Summary Tab result from DB on monthly basi

TopicThis article related to the cases when service/client throws a Could not load file or assembly error:Instructions IMPORTANT: Be very careful when updating the registry keys and if possible create a machine's backup before performing changesEnable Fusion logs by adding the following values to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion in the registry:DWORD ForceLog set value to 1 DWORD LogFailures set value to 1 DWORD LogResourceBinds set value to 1 DWORD EnableLog set value to 1 String LogPath set value to folder for logs (e.g. C:\FusionLog\)Make sure you include the backslash after the folder name and that the Folder exists.      Alternatively, use the following commands:md C:\FusionLog REG ADD HKLM\Software\Microsoft\Fusion /v ForceLog /t REG_DWORD /d 1 /f REG ADD HKLM\Software\Microsoft\Fusion /v LogFailures /t REG_DWORD /d 1 /f REG ADD HKLM\Software\Microsoft\Fusion /v LogResourceBinds /t REG_DWORD /d 1 /f REG ADD HKLM\Software\Microsoft\Fusion /v EnableLog /t REG_DWORD /d 1

TopicWhile migrating wizard, receive .NET plugin error message: "Done with error." This can happen with multiple wizards with .NET plugin embedded in them. Instructions Update Leo.Plugin.Library in existing developed plugin, e.g. if you upgraded to RPA 21.10.2 then latest File version is 2020.12.1.0Edit and add Leo.Plugin.Library assembly in the LeoScriptMigrationtool.exe.config file:    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">        <dependentAssembly>        <assemblyIdentity name="Kryon.Leo.Infrastructure.Shared.Helpers.PowerCollections" publicKeyToken="1E94CC96D0565216" culture="neutral" />        <bindingRedirect oldVersion="0.0.0.0-5.0.0.0" newVersion="2020.12.1.0" />      </dependentAssembly>    </assemblyBinding> Start Migration tool from:C:\Kryon\Services\Migration Tool 64bit\LeoScriptsMigrationTool.exe and try to migrate now.Note: To login, use your Studio credentials    

TopicA problem has been noticed on 21.10 and 22.9 with HA and external load balancer used. User synchronization in admin fails:Troubleshooting:Users are synchronized correctly to the aerobase from AD, in SEQ one can see the following errors:FetchUsersFromIdp: Request to fetch users request failed, statusCode:NotFoundThe problem is that UserSync service is trying to access keycloak on the local server directly instead of routing requests through the load balancer and keycloak is accepting requests coming to LB URL only. Instructions IMPORTANT NOTE: Please back up configuration files before making changesOn 21.10:Open \Kryon\Services\Kryon Server - Users Synchronization Server 64bit\UsersSyncService\Kryon.Console.Services.UsersSyncWindowsService.exe.configOn 22.9:Open \Nintex\Services\Nintex Server - Users Synchronization Server 64bit\UsersSyncService\Kryon.Console.Services.UsersSyncWindowsService.exe.configChange URL in IdpMiddlewareApi so it will point to external URL (via load balance

TopicThis article contains information on how to Upgrade the Redis Server.Issue:How to upgrade the Redis Server version post installation of RPA.Cause:If it becomes corrupted or a patch available due to a vulnerability. Instructions Stop all the Nintex Services, this will automatically shut down currently running Redis-Server.1. Download latest version from the below link:Redis-Server >> Redis-x64-5.0.14 (zip)PS: not source code2. Extract the zip file content. 3. Go to the following directory and make a backup of it in another temp directory.4. Copy the content from step 2 in runtime directory.{Installation Drive}:\Nintex\Services\Kryon.Cache\runtime5. Restart Nintex Services.6. Go to details tab, under task manager, and right click on running Redis-Server and check it’s properties.   

TopicThe instructions in this article show all the steps necessary to upgrade and create a New Nintex Database using the DbUp Command Line Interface Tool.This is only required in cases where your Nintex database failed to create successfully during installation.Before executing it on a customer’s environment, first validate the script in a test environment to familiarize yourself with it.Before any upgrade is conducted on a customer’s database, please perform a back-up of their existing databases in case there is need to do a roll-back. Instructions The circumstances below should be used to determine if there is need to create the Nintex DB table manually via the DbUp Command Line Interface ToolWhen the Nintex DB was not created successfully via the installer. There is a missing table in the Nintex Database.Usually, the above happens when you see the following error during installation:Failed executing SQL scriptSSL Security errorConnectionOpen (SECCreateCredentials0)To upgrade an exis

TopicIf below error is found in SEQ : “Responded 401 to /robots-manager/graphql”Related to Nintex Robots manager service application.Task created manually or started by trigger will remain stuck in queue. If a task is opened that was initiated by any trigger, it will show that Robot is not available:Inside console Robots will show as available and idle:Instructions To resolve above issue, open Robot config file to check Graphql endpoints for Robot manger and task manager:URL to check the same is as below:{FQDN}/unattended/task/isAlive Resulted in error{FQDN}/unattended/robot/isAlive{FQDN}/unattended/queue/isAliveWas giving is alive notificationOpen the file:{Install directory}\Kryon\WatchDog\appsettings.Production.jsonLook for the port used for Task management SVCTry to open:{FQDN}:50002/tasks-manger/isAliveIf it shows "is alive" notification:Check if there is a port mismatch under Kryon-upstreams.import under nginx directory as shown in below image:Port Key looks correct:  Replace 127

TopicThis article describes how to configure SAML for HA-deployment.   Instructions 1. Define Authentication flow as shown below:2. Create two identity providersAlias - has to be identical in Keycloak and on the customer side Redirect URI - generated automatically according to the current server name Display Name – the FQDN of the current server First Login Broker – select from the combo-box the name created in step 1 Single Sign-On Service URL – to be provided by the customer Single Logout Service URL – to be provided by the customer Other settings – configured in accordance to the customer’s IT requirements 3. Create mappers for each created identity provider as shown below (User Attribute Value is in camelcase format)   4. Mark all the federations as WRITABLE5. Modify "\Kryon\IDP\Aerobase\Data\aerobase-server\themes\kryon\login\login.ftl" file as shown below (line 64)6. Modify "\Kryon\IDP\Aerobase\Data\aerobase-server\themes\kryon\login\template.ftl" file as shown below (line 58)   

TopicWhen you need an additional level of logging of Chrome that can help you debug issues with the Nintex Connector extension or, for example, with clientless host. Instructions Run Chrome in the following manner from cmd:cd C:\Program Files\Google\Chrome\Applicationchrome --enable-logging --v=1This will open additional stderr windows which may contain helpful information 

TopicIn Studio versions prior to 22.9.3 we may face an issue with saving a specific wizard with a blank value:The root cause can be seen in the SEQ Logs: Exception saving #xx (Scripts) data by user Exception saving script #xx dynamic commands dataWe can verify it in the database using: select * from LeoScriptDynamicCommandsData or select * from LeoScriptDynamicCommandsData where DefinitionID='00000000-0000-0000-0000-000000000000'  00000000-0000-0000-0000-000000000000 is an invalid value and we need to give it a new unique one. Instructions Before we proceed to resolve the issue, we would want to make a BACKUP of the database To resolve it, we need to execute:update LeoScriptDynamicCommandsData set DefinitionID=NEWID() where ScriptID=XX and CommandName='XXXXX'(In our scenario the query is update LeoScriptDynamicCommandsData set DefinitionID=NEWID() where ScriptID=34 and CommandName='RunMacro') The expected return is:Once again run the select query to verify that we no longer have that i

TopicDuring server installation, RabbitMQ failed to install leading to the server installation failing with fatal error 1603 and rollback.Instructions Cause:Possibly script execution rights or lack of permissions for the logged in user. Solution:To resolve the issue, do the following.Open registry editor. Locate registry key Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Ericsson\Erlang Delete the registry key. Save and close Registry Editor. Reattempt the server installation.If installation was successful but RabbitMQ service not seen in Services or RabbitMQ admin not accessible, do the following:Open PowerShell. Navigate to C:\Nintex\installer-assets\config\prod\scripts Run command ./configureAll.ps1 -h “<installed directory>:\Nintex” After execution completed, verify that RabbitMQ service is seen in Services Restart Nintex services.  

TopicCustomer has reported that Rabbit MQ password stopped working and was prompting the message:Not management userInstructions Cause:Missing permissions/rights.Solution:In order to resolve the issue and grant the user with the required rights:Run the following two commands in CMD from C:\Nintex\RabbitMQ\rabbitmq_server-3.8.1\sbin.\rabbitmqctl.bat set_permissions -p / admin ".*" ".*" ".*".\rabbitmqctl.bat set_user_tags admin administrator   

TopicPlease find information on all 3rd party components being installed on the Nintex RPA Server and Client machines version 21.10, 22.3, 22.9, 23.11  Instructions        

TopicOne or more of the Nintex Services is not starting or is stuck/paused. The example below shows that there is a missing .NET framework.  Instructions Solution.net serviceCheck the type of serviceOpen Services Console (services.msc). Find the service you want to start manually and double-click on it. The word NSSM in “Path to executable” indicates the service is NSSM hosted; otherwise, it is self-hosted. Self-hosted Windows Services:Open Services Console (services.msc). Find the service you want to start manually and double-click on it. Open the command prompt as administrator (cmd). Navigate to the folder defined in “Path to executable” (see illustration below). Run the executable. See the output. NSSM hosted services:Open the Services Console (services.msc). Find the service you want to start manually and double-click on it. Open the command prompt as administrator (cmd). Navigate to the folder defined in “Path to executable” (see illustration above). Run command nssm edit “<se

TopicIf you need MSI kits please follow the instructions below. Instructions Below are the instructions:Navigate to <Drive>:\Nintex\Support Tools\MSI Wrapper.Run pgplwiz.exe. An application window will open.Click the "Browse" button and select the respective Robot or Studio Executable.In the "Command Line Parameters," set the respective config parameters, that are valid for the customer's server like: Main Server Name, Http/NetTcp/HTTPS/Nginx ports, robot/assistant mode, etc.Example: LeoServer=myappServer.com /s ALLUSERS=TRUE NetComPort=8082.Note, for these parameters apply the same rules as for regular cmd parameters.More parameters can be found in additional information section below.For "Group Policy Display Name" set Nintex Robot/Studio.Once the parameters are set, click "Save As" and select the name and location of the Output MSI files.Click "OK" and wait for the file to be generated. Another option, instead of using the Installer's MSI wrapper, is to download Orca and use t

TopicDuring the installation of the RPA Robot, the following error is seen in the installation logs:Failed setting JsonJpath ‘$.MonitoredApplicationSettings.Data[?(@.AppName == 'Kryon Robot’)].UpdateSettings.UpdateServerPathsThe issue is arising from a conflicting registry key for RPA Robot.Instructions To resolve the issue, perform the following.Open registry editor. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Kryon Delete the entire Kryon folder. Save and exit the registry editor. Install Kryon Robot.NOTE: Show extra caution to ensure you are deleting the correct registry key so as not to create unwanted issues thereafter.

New How-To VideoMathematics dynamic advanced command Hey everyone!We've just released a new how-to video on the Mathematics dynamic advanced command in Nintex RPA.This video covers how to perform calculations on variables using constants or other variable values, enhancing your automation workflows.See the Video What it covers:Using the Mathematics Dynamic Advanced Command. Practical examples of variable calculations. Best practices  with for the command.  Be sure to check it out and join the discussion in the comments! 

Topic NotificationsYou can receive email notifications to stay informed about important events, such as when a robot is: Added to Console Plus Stopped Becomes disconnected or unresponsive.More details can be found on the official documentation: Nintex Help: Notifications. If you followed all the steps and are still not receiving any notifications, you may want to look for a specific entry in the Seq logs. To identify if this is the cause, please refer to the steps below: Instructions Navigate to the Seq online tool. For additional information, go to this link: Nintex Community: Gather Logs - Seq Once you have gained access, you can see what is happening on the backend. In the top search bar, you can enter the following to filter out which services are visible:Application = ‘kryon-notifications-svc’ In this case, you will be looking for the following entries:   If you have these entries, it is likely that there is an issue with the certificate , and we advise you to check and verify