Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Error thrown while accessing data from existing table

varunb19240133
Level 2
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
jonasn92134656
Correct answer by
Level 4
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
jonasn92134656
Correct answer by
Level 4
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