Expand my Community achievements bar.

SOLVED

Error thrown while accessing data from existing table

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Level 4

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 4

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