UiPath Go ! BalaReva PostgreSQL

Help Marketplace
,
1

Hi Guys,
I have successfully uploaded PostgreSQL in UiPath Go.This package contains the below activities .

  1. Execute DataTable

This brings the information from database even if you use the direct query or stored procedure.

  1. Execute NonQuery

It helps to execute To insert, update and delete statements.

  1. Execute Scalar

Returns the first column of the first row in the result set returned by the query or stored procedure as Object.

https://go.uipath.com/component/balareva-postgresql-activities

Regards
Balamurugan.S

2

Awesome!!! Great work bro!!!

3

Thank you @Lahiru.Fernando

4

Awesome! :slightly_smiling_face:

5

Hello Sir,
I have an error something as picture below. Cloud you please help ?

Capture
Capture733×482 28.3 KB

6

Hi ,
can you attach your project ?

Regards
Balamurugan.S

7

Hello Balamurugan,
Could you please resolve them? :sweat_smile:
POCConnection.xaml (4.5 KB) project.json (1.2 KB)

Best Regards,
Tanakorn P.

8

Hi @Tanakorn_boy,

I have seen your xaml. The connection is ok. But you have to take look in the select query. When we are using the direct select query it may give error. But if try like below .It works well.

SELECT * FROM public.“tblCustomer” limit 1

Ref : Web
https://social.msdn.microsoft.com/Forums/tr-TR/808e59da-5bf1-439d-b5f4-89878797be20/error-42p01-relation-does-not-exist-hatas?forum=csharptr

Regards
Balamurugan.S

9

Hello @balupad14
I have checked them with your guide but see same error. Do u have more solution for advise me or more solution for fix this issue? Thank you in advance

Capture
Capture1672×972 86.9 KB
Capture2
Capture21130×560 46.6 KB

1

Best Regards,
Tanakorn P.

10

Hi @Tanakorn_boy,

I will look on it and get back to you. For me it working well. Please check the port that you have accessing thru Uipath. This weekend send a video about this. we can see. If possible we discuss about it on this weekend. Thank you very much to your feedback.

Thank you
Balamurugan.S

11

Hi,

can you select the query with schema like

Select * from public.tblcustomer

image
image924×556 55.2 KB

Regards
Balamurugan.S

12

Hi Sir,
Sorry to late, I query like that with last comment from you it’s work but when query on uipath it doesn’t work, still same that error.

BestRegard,
Tanakorn P.

13

Hello Balamurugan,

I have the same issue as below. It’s look like that UIPath BR activies could connect postgres ,but could not retrieve the data set by SQL Query. Look forward to your reply.

*RemoteException wrapping System.NullReferenceException: Object reference not set to an instance of an object. *

  • at BalaReva.PostgreSQL.ExecuteDataTable.Execute(CodeActivityContext context)*
  • at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance,*
    ActivityExecutor executor,
    BookmarkManager bookmarkManager)
  • at System.Activities.ActivityInstance.Execute(ActivityExecutor executor,*
    BookmarkManager bookmarkManager)
  • at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor,*
    BookmarkManager bookmarkManager,
    Location resultLocation)
14

Hello Balamurugan,

I have the same issue as below. It’s look like that UIPath BR activies could connect postgres ,but could not retrieve the data set by SQL Query. Look forward to your reply.
RemoteException wrapping System.NullReferenceException: Object reference not set to an instance of an object

15

Hi @sflxc15912123602,

Welcome to UiPath Community !

Can you explain your environment. How and what way you are access database… It would be very helpful to me to test at my side.

Thank you
Balamurugan.S

17

Hi Sir,

1590485524(1)
1590485524(1)1920×1031 101 KB
1590485666(1)
1590485666(1)1920×1031 104 KB

I configured ODBC access, using ‘Database’ can be normal access.

18

Can you share your workflow please…

Thank you
Balamurugan.S

19

Hello Balamurugan,
Could you please resolve them?
Main.xaml (5.6 KB) project.json (1.1 KB) Sequence.xaml (5.3 KB)

20

Sure… @sflxc15912123602

21

same error… Execute DataTable: Object reference not set to an instance of an object.