Selector Highlighting slow with SQL based software

Help
1

I’m working with a client on a tool that is connected to an SQL database. In this case, I am finding that trying to indicate selectors using Studio or UiExplorer is extremely slow… as in 20+ mins to return the selector. The whole system hangs while waiting for this to complete It is especially bad once a database is loaded in the target software.

I am not trying to access the database with UiPath, but once the tool is opened the latency issue comes into effect in UiPath for ANY element, within the entire windows 10 environment. This is having an enormous productivity impact - does anyone have an idea what could be causing it? Could it be an SQL server config issue?

Thanks,

1 Like
2

Hi @pduffy

May i know the version of UiPath Studio and the software where you need to load the data into db

Thanks
Ashwin S

4

Hi @pduffy
Share the screenshot of the application need to check whether it is terminal or SAP

Thanks
Ashwin S

5

I cannot share a screenshot from the client, but you can see one on the software vendors website here:

953×543 102 KB

6

Hi @pduffy

Have you tried installed Java Extension or enable sap gui scripting

Thanks
Ashwin S

7

Sorry for the delay with my replies, as mentioned my system hangs when trying to test solutions so I have to wait. I need to get IT here to install the Java extension to test and will get back to you.

Why did you suggest enabling sap gui scripting?

(FYI The payroll software is configured to use SQL rather than default MS Access, and the database is managed via MS SQL Server Management Studio)

8

Hi @pduffy

I thought even it might be a SAP Application

Thanks
Ashwin S

9

Ah, ok. Problem persists. Still trying to find a solution if anyone has experienced this…

10

Hi @pduffy
Have you tried using Element exists or try to reinstall UiPath Studio and check

Thanks
Ashwin S

11

Hi,

Yes the elements definitely exist. Actually the slow down occurs as soon as the payroll app is loaded. It gets much worse when the app actually opens a database. It’s not an issue with elements existing it slows down before even selecting one. Everything starts freezing before even clicking an element. It will (eventually) return a selector for the element, but there are extremely long lags. It takes ages just to highlight the desired element, and then after clicking a lag (up to 20 mins) to process and return a selector. Trying to build a robot with this issue is impacting productivity and progress severely. I need to find a solution…

12

Hi @pduffy

Have you tried using delay activity in between the activities to check

Thanks
Ashwin S

13

Hi, it’s not a run time problem. Delays won’t make a difference. The problem is in the selector creation process (e.g. using UiExplorer)