Error thrown while accessing data from existing table

Avatar

Avatar
Validate 1
Level 2
varunb19240133
Level 2

Likes

3 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
varunb19240133
Level 2

Likes

3 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
varunb19240133
Level 2

24-03-2019

Hi,

I have tried accesing data from a schema in remote database(pgsql) using the Select the Access data from an existing table or an SQL view option.

1718305_pastedImage_0.png

The schema/view got successfully generated in adobe campaign console. But while trying to view data by clicking on the data tab of the schema, an error message pops up. PFB the screenshot.

1718312_pastedImage_1.png

The user i have logged in is an admin user of the adobe campaign. Please provide pointers to solve this issue.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 3
jonasn92134656
Level 3

Likes

28 likes

Total Posts

38 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
jonasn92134656
Level 3

Likes

28 likes

Total Posts

38 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
jonasn92134656
Level 3

25-03-2019

Hi,

Possibly related to the access level of the DB account being used (ie the one that is set up in the external DB that ACC uses to access it).

Regards,

Jonas

Answers (1)

Answers (1)

Avatar

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Validate 250
Level 10
pablo_rosero1
Level 10

Likes

81 likes

Total Posts

348 posts

Correct reply

77 solutions
Top badges earned
Validate 250
Validate 100
Validate 50
Validate 25
Validate 10
View profile
pablo_rosero1
Level 10

26-03-2019