Process Discovery

FORUM POSTS AND DISCUSSIONS

  • 227 Topics
  • 255 Replies

227 Topics

A
Ayelet_Gazit
posted in Process Discovery

www.sqlnethub.com

How did we solve "RPA DB failed to populate" issue in BGL with 19.5.1Knowledge share by Oren Configuration: Single machine, user password, SQL express 2017 was installed manually on the same machine, no TLS.The symptom:Installation completes, RPA DB is empty, Authentication DB is populated correctly.Digging into logs, found the following error: SqlSearch: Executing SQL query 'SELECT CAST(HAS_PERMS_BY_NAME(QUOTENAME('Keycloak'), 'DATABASE', 'ANY') AS VARCHAR)'. Server='PEG-RPAAPPDEV02', Instance='SQLEXPRESS', Database='', User='sa'. Will place results in property 'ab_sql_db_exists'SqlSearch: Error 0x80004005: Failed to initialize connection to Server='PEG-RPAAPPDEV02SQLEXPRESS', Database='', User='sa'. SSL Security error.SqlSearch: Error 0x80004005: Failed connecting to databaseCustomAction SqlSearch returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox) As we were totally not familiar with this error, we tried to google it.The first

0
A
4 years ago
N
Nitzan_Koren
posted in Process Discovery

Kyron Helps Long Term Care Group Make Huge Automation Savings

Justin Kruse, RPA Lead at LTCG: “We recognize the huge value that Kryon ProcessDiscovery™ delivers in conjunction with RPA, and we’re certain that our working relationship with Kryon will help us to boost our digital efficiency quickly and easily.” Read the full story here: http://bit.ly/370vsFN

0
N
4 years ago
N
Nitzan_Koren
posted in Process Discovery

www.mydomain.org

Keycloak / AerobaseKnowledge shared by Aviad KeycloackKeycloak is an open source Identity and Access Management solution aimed at modern applications and services. It makes it easy to secure applications and services with little to no code.Keycloak supports login with (SSO). Keycloak also supports login with username/password In order to integrate Keycloak with Windows Active Directory we need to (In Kryon case):Integrate with LDAP, which means that user accounts will be provisioned from LDAP server. Add service principal for "HTTP" service (with Keytab File). For example if your Keycloak server will be running on www.mydomain.org you may need to add principal HTTP/www.mydomain.org@MYDOMAIN.ORG assuming that MYDOMAIN.ORG will be your Kerberos realm.More about Keycloack: https://www.keycloak.org/about.html AerobaseAerobase is a wrapper on top of Keycloack that make it easier to config and deploy on windows environment (Keycloack is insdie Aerobase msi package).Aerobase benefits over bar

0
N
4 years ago
A
Ayelet_Gazit
posted in Process Discovery

R&D Training - Aerobase (by Aviad)

See here training content added by Aviad to confluence. Aviad is updating it all the time, so follow it.https://kryonsystems.atlassian.net/wiki/spaces/RndKB/pages/880607994/Aerobase+-+DraftLogin with Kryon domain user

0
A
4 years ago
A
Artur_Martirosy
posted in Process Discovery

A customer asked how can we save the email messages locally?

Except using visual recognition which is opening the outlook then visually selecting the specific email, copying and pasting it to the respective folder, the following basic Vb-script can be used with the "Run Script" advanced command to save the messages as well as carry out more actions in a faster and smooth way. The .txt file of the code is attached. <<< ***Set outlook = createobject("outlook.application")Set session = outlook.getnamespace("mapi")session.logon 'optional to useolMSG = 3Set objMailbox = session.Folders("Insert your email address here")Set objFolder = objMailbox.Folders("Inbox").Folders("Important") 'this reperesents Inbox/Important folder For Each m In objFolder.itemsIf m.unread Thenm.SaveAs "C:UsersKryonDesktopEmailSource.msg", olMSGend ifNext session.logoff 'optional to use Set outlook = NothingSet CaseTitle = NothingSet session = Nothing WScript.Quit***>>>

0
A
4 years ago
M
Moran_Talbi
posted in Process Discovery

Issues with fail/stuck Jenkins job

If you encountered issues with fail/stuck Jenkins job, during VM deployment/start/termination and etc. Follow next steps (Deploy VM example):Find your own run:Click on build number (see: Jenkins1) Browse to Parameters: (see: Jenkins2) Here you may find all the information about parameters that triggered the job: (see: Jenkins3) Browse to Console Output for logs: ((see: Jenkins4) In the logs you have several milestones:                                                             i.     VM creation (not in Domain): (see: Jenkins5)                                                            ii.     Add VM to DNS: (see: Jenkins6)                                                           iii.     Prerequisites tool installations: (see: Jenkins7)                                                           iv.     Chrome installation: (see: Jenkins8)                                                             v.     .Net Framework installation: (see: Jenkins9)                                    

0
M
4 years ago
N
Nitzan_Koren
posted in Process Discovery

localhost

How did I investigate Admin and Seq are not working?Knowledge shared by Oren Wanted to share with you an issue I had with 19.5.1 installation, how I investigated, and what was the solution. So we installed today Wyndham server.Hosted on our AWS (separate network), outside domain, user password authentication, local DB.DNS name is defined as a global DNS record: WyndhamAWS1.KryonSystems.com . All Services are up and running.First symptom: Admin shows error on launch (same error like the Aerobase service is down).Second symptom: SEQ it not accessible through http:///Seq but it is accessible through http://localhost:5341 (internal port).So it feels like something is wrong with nginx, which is the front line for both SEQ and Aerobase. If nginx is down, Admin will behave like Aerobase is down.Checking: Nginx service is up and running.I tried to stop the nginx service, and run the nginx.exe manually, hopefully to get some exception information. Nothing. All is working.I get out from the serv

0
N
4 years ago
N
Nitzan_Koren
posted in Process Discovery

kryonsystems.com

Hi team, Check out this link: http://kryonsystems.com/kryonpedia/ All the marketing materials that you're looking for- in here! Please don't share with anyone- this is an internal link. 

0
N
4 years ago
Lyubomir
LyubomirNintex Employee
posted in Process Discovery

Error: The Admin Tool could not start. Check logs for more information.

Error: The Admin Tool could not start. Check logs for more information.Knowledge shared by Oren In case you get the following error in Admin after reboot: The Admin Tool could not start. Check logs for more information. The reason is that the Kryon Services, mostly the Aerobase Services, are not started yet. All services are configured to "Delayed Automatic start" so you need to wait 2-3 minutes after reboot before you can use any Client, including Admin.

0
Lyubomir
4 years ago
Lyubomir
LyubomirNintex Employee
posted in Process Discovery

How to solve the "Authentication service is paused" issue

 Knowledge shared by Oren Run the following command and then reboot:reg add "HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpip6Parameters" /v DisabledComponents /t REG_DWORD /d 32 /f Explanation:We need to configure Windows to prefer resolving of server DNS name by IPv4 and not IPv6 . We currently suspect something has changed a few days in the AWS image or some Windows update that caused this configuration.

0
Lyubomir
4 years ago
N
Nitzan_Koren
posted in Process Discovery

Generated MSI kits for Robot/Studio

 Knowledge shared by Oren The MSI files that are generated from the 19.5 RPA server installation process are not signed with Kryon Certificate .(why? Signing them during the installation will require embedding our certificate private key together with the installation kit…). That means that customers that has IT policy that prevents running non signed MSI files – will not be able to use these MSI as they are.Such customers will have several options:Sign these MSI files with customer certificate (this is not a SSL/TLS certificate type, it is a Code Sign certificate). Use the original EXE setup kits as usual, with the relevant CLI. Send Kryon the generated MSI files and we will sign them and return them back. 

0
N
4 years ago
N
Nitzan_Koren
posted in Process Discovery

How to analyze "Authentication Gateway" service issues

 Knowledge shared by Oren If you happen to experience the “Authentication Gateway service” failed to start, first you need to understand this is the nginx service.  To analyze the issue, simple run the nginx from Command window:C:KryonIDPAerobaseDataNginx ginx.exe  In the above example it seems that the port 80 is not available. The command line:Netstat -aonWill show you the immediate suspect.If it is process ID 4, that means the system process, which is more difficult to understand which “Windows feature” is to blame, usually it is the IIS.

0
N
4 years ago
N
Nitzan_Koren
posted in Process Discovery

How to analyze "Authentication Service cannot start" issue

 Knowledge shared by Oren If you encounter with an issue that the Authentication Service cannot start, one way to find the root cause is running it in “Console mode” so you will see the error of the root cause and get a hint what is wrong. I will use some screenshots from Clinton’s issue report (part of testing 19.5.1), but it is the same for any future issue with Authentication Service. (Comment: “Authentication Service” is not the Aerobase service. It was developed by Kryon). In the example below it helped us understand that a wrong version of .net core is installed. Run the command:Dotnet Kryon.Infra.Authentication.Server.dll >> error.log

0
N
4 years ago
N
Nitzan_Koren
posted in Process Discovery

How to get Aerobase logs

 Knowledge shared by Oren You can to a case installation completed, but Aerobase service failed to start.to analyze – you need to get the Aerobase logs.Aerobase does NOT write to SEQ.It has its own textual files. They are located here:C:KryonIDPAerobaseLogsaerobase-serverlogs How to read them?I really don’t know ?It is an open source solution.What I am doing when I need to find a root cause in these logs is just using my common sense, opening the logs files, trying to look for some errors that will give me a hint.90% of the cases till today – some kind of “failed to connect to the DB”.In 19.5.1 we put a lot of effort to try and minimize the cases that the Aerobase’s DB connection “explodes” after the installation, and in v19.5.1 we “stop” it on the Installers UI phase.

0
N
4 years ago
A
Artur_Martirosy
posted in Process Discovery

The wizard could not be downloaded from the server due to a network problem. Please click either 'do It' or 'Guide Me' to try again?

Special such as “Bell” or "●" and ASCII characters cause issues to run the process from the Robot. As we know in every software or programming language the special and ASCII characters can be stored in different mechanisms/ways, which can cause issues to run the wizard from Robot or even from Kryon Studio.therefore the bellow example is another way to work with scripts and make the wizard more stable and readable. If you ever encounter the bellow issue:  Then take into consideration Archivierung your scripts locally in the following way:   Then use Read text file AC to get the VBS.txt code and then use replace function to insert your variables inside the content:  Then your Run Script AC should look like this:    

0
A
4 years ago
N
Nitzan_Koren
posted in Process Discovery

Meet the Kryoner!

Hi there, community members! This week we start a new tradition - Meet the Kryoner! Every two weeks, we will tell you about one of our own, so you will know more about the great employees that are part of the Kryon family! This week we introduce you to- @Dudi Grinstin​ ! Dudi has been with us for two years, and he is a Senior Technical Support Engineer. Here are some things you didn't know about Dudi: He is from Rehovot, Israel, joined Kryon in July 2017, and the first version he ever installed was…5.4.1! Wow! His favorite Advanced command is the Analyze PDF command. He told me that he used it once to translate a document he had in German, and that's the only thing that helped him read it! His favorite feature is API, who doesn't love using the API feature? And the thing he likes the most about RPA are the people; he says that the best people work in the field of RPA. Dudi is an Attended Automation expert, and his favorite academy course is, of course: Kryon Attended Automation Develop

0
N
4 years ago
Lyubomir
LyubomirNintex Employee
posted in Process Discovery

How to reduce SEQ Memory Consumption

Hello Everyone, Lyubomir from the Kryon Support Team here, we would like to point out that recently we have received multiple queries in regards with Seq and how there are memory usage spikes. Here is how we were able to remedy this issue: 1. C:Installation FolderSeqDataSeq.json you should find: { "cache": {   "systemRamTarget": 0.9 }, 2. Changing the 0.9 to lets say, 0.2 or 0.3 will cause Seq to start dropping cache as soon as overall utilization on the machine passes 20 or 30%. 3. You'll need to restart the Seq Windows service to pick up the change. Hope that this will prevent any inconveniences in the future. Best regards,Lyubomir and the whole CS Team

0
Lyubomir
4 years ago
Z
Ziv_Ilan
posted in Process Discovery

To use the PD robot when traveling for business / with users who also work offline

The PD robot has configuration which you can adapt to the users' way of working - for users who travel a lot or for those who might work when they are offline, you can increase the number of actions it stores locally before sending it to the server or you can move the user's PD robot to a stand-alone mode

0
Z
4 years ago
Z
Ziv_Ilan
posted in Process Discovery

To dynamically use your PD robot licenses

You can install more PD robots than your license allows you - for example if your license is for 10 PD robots, you can install it in all the departments users' machines and use the Discovery Robots tab in the Orchestrator to dynamically enable and disable the PD robots and decide which 10 PD robots you want to record at any given time

0
Z
4 years ago
A
Artur_Martirosy
posted in Process Discovery

Getting word file content and cleaning the text from ASCII characters, unwanted linebreaks and Bells

The bellow code can be used to extract the content of any Word document, will clean it from ASCII characters and line breaks and will output the value in Kryon, as well ass will write the output in text file.Simply insert the code inside the Advanced command "Run Script" in Kryon. 'Funtion to remove the ASCII charachtersPrivate Function GetStrippedText(DocContent)Dim regExSet regEx = CreateObject("vbscript.regexp")regEx.Pattern = "[^u0000-u007F]"GetStrippedText = regEx.Replace(DocContent, "")End Function 'Opening the word file in not visible mode and getting the contentDim WordDim WordDocSet Word = CreateObject("Word.Application")Word.Visible = false'Open the DocumentSet WordDoc = Word.Documents.open("WordDocumentPath",,True)WScript.Sleep 500DocContent = WordDoc.Content 'Close WordWord.Quit'Release the object variablesSet WordDoc = NothingSet Word = Nothing 'Calling the function to clean the text from ASCII charachtersDocContent1 = DocContentDocContent = GetStrippedText(DocContent) whi

0
A
4 years ago
C
Clinton_Tay
posted in Process Discovery

Finding Which User / Robot previously ran a process via either [Add Automation Task to Queue] or just normal runs.

To determine what process was ran and who/which robot had triggered the process, it is entirely possible to query the information out from the Kryon Database.  Refer to the script as follows: select       ls.Title AS "WizardName (First Embedded Wizard)"      ,lrh.RunTime      ,lu.UserName from LeoRunHistory lrh       inner join LeoScripts ls on ls.ScriptID = lrh.RealScriptID      inner join LeoUsers lu on lu.UserID = lrh.UserIDwhere CONVERT(varchar(10),lrh.RunTime,104) = '12.11.2019' --system date format (query first before setting)Order By RunTime Desc By running the above SQL query in your Leo DB, you will receive the following sorted information:Wizard Name RunTime UserName This will help you and your team to drill down on the timeline each process was ran. All the best!

0
C
4 years ago
N
Nitzan_Koren
posted in Process Discovery

Welcome to the Process Discovery forum!

Hi there! This is a forum for Kryon Process Discovery users, and we invite you to ask questions, and share ideas from experiences working with the Kryon Process Discovery platform and its components- Process Discovery Console, Process Discovery Orchestrator, Discovery Robot and Process Discovery Server & Database.We also invite you to share more about process analysis that is done in your organization or from your personal experience. Post, share, and respond to others! We can't wait to learn more about your experiences! 

0
N
4 years ago
N
Nitzan_Koren
posted in Process Discovery

How to add the an application in Kryon Free Trial version?

Open the application on your computer and then click "Add Application" in Kryon Studio homepage.You should see a pop up window with the list of applications that are currently open on your computer to select from.Check the application you want to white-list and click "Add Application".Reload the Studio and open the wizard that you have created (close and re-open the wizard if it wasn't closed earlier prior to adding the application).Record! This applies to all desktop applications. If you want to add a web application, simply type the URL and click the Plus sign to add it. Make sure to reload Kryon Studio prior to the recording.

0
N
4 years ago
N
Nitzan_Koren
posted in Process Discovery

Academy Course - Using Advanced Commands

In the Advanced Commands course you can learn how to add advanced commands to the flow of your automation with a drag-and-drop visual interface.Kryon Studio offers over 200 commands allowing you to create loops and conditions, run programs, execute script and database queries, manipulate Excel files, send and receive emails and much more. Type: OnlinePrerequisite: RPA Developer Introduction courseAudience: available for all registered traineesDuration: Self-paced. Allow 1 hours for completionComponents: Online modulesNumber of attendees: No limitPricing: Free of chargeCertification: Course completion certificate Course Content1. Variable commandsDemo 1- Calculates price raise Commands used: Set value & Mathematics commands. Demo 2- Separate between First & Last Names Commands used: Split and Set value commands.2. Flow commandsDemo 1- Wizard that checks how customers grade the service and display a message to alert for unsatisfied customers. Used commands: If Else, set value and

0
N
4 years ago
T
Theo_Schmidt
posted in Process Discovery

Considerations if you are experiencing "wrongly formatted" dates when working with Excel and Kryon RPA

When working with "dates" in Excel in the context of Kryon RPA you may run into the problem that the date format is not correctly interpreted. Example: Kryon RPA retrieves the value "mm/dd/yyyy" as opposed to what you see when you open the .xlsx file manually, for example, "dd/mm/yyyy". To address this, it is important to first understand how dates actually "work" (in Excel) and how they tie to your (system) regional settings. Please review the following article: https://www.excelcampus.com/functions/how-dates-work-in-excel/ As such, when working with dates (coming from Excel files) in Kryon RPA, consider the following if you are indeed experiencing the above-mentioned format(ting) issues: You can (re-) format the date in Kryon RPA using Advanced Commands, such as the "Format date" command (if date formats are "reliably wrong" in the same fashion all the time) or a combination of the "Split" and "Set value" commands If this proves too unreliable, you can make sure (if applicable) you a

0
T
4 years ago

View our Community Site Map

Nintex Community Sitemap

Badges

Show all badges
Terms & ConditionsCookie settings