Split street, City,state,zipcode from Addresss and load it to the database

Help Activities
, ,
21

Hello @Gautham_Pattabiraman ,

Address it is fetching from site and splitting i am doing in the array inside assign activity.
and type into i am just giving site name “https://”

Load also to database for few seconds lets suppose if Extract data table having 100 records, Its inserting 45 records then throwing below error

Insert: One or more errors occurred. (ORA-03135: Connection lost contact) (ORA-12545: Network Transport: Unable to resolve connect hostname)

22

Hi @jezna_jose ,

I hope below will help you on the 2 issues,

Issue 1 : Type into (URL)

Instead of Type into use a “Use Browser” to set the URL and browser type(edge/chrome)

Manually open a browser which you want to use in your automation and open the url as well.

Drag a Use browser activity and indicate the above setup.

By doing that UiPath will automatically take the URl and while launching browser itself the UiPath will launch in that URl.

Issue 2 : Loading into DB

This will take some considerable time to load n items depending on the number of rows.

My suggestion would be Load the data outside the browser actions if possible.

If it includes some scrapping from the browser and loading which must take place inside, Have a sequence to load data in,

The sequence should be containing all the below 3 steps,

Connect DB
Execute Query/ Execute Non Query( Based on your need)
Disconnect Db

By following the 3 steps (connecting and disconnecting from db for every row insertion)

The db connection will be fresh and this connection issue will not occur.

If you still face connection issue my recommendation would be for you to create a test sequence where you can do the above 3 steps and check where the jssue is occuring ( Insert some dummy data in db some lower region db like dev or test can be used)

Try and let me know on the above pointers.

Thanks,
Gautham.

23

Hi @jezna_jose ,

Let me know if you were able to fix or still facing issues.

Kindly mark the response that helped you find the solution.

Happy automation.!

Thanks,
Gautham

24

Hello @Gautham_Pattabiraman ,

Thank you so much for the support. Its working as expected

25

@jezna_jose ,
My pleasure

26

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.