6 Replies Latest reply: Dec 6, 2017 11:59 PM by Samir Unni RSS

    Create select statement fails on retrieving list of owners

    Samir Unni

      I've set up a connection from QlikView to a Postgres database using the Qlik Database Connectors (Create a PostgreSQL connection ‒ Qlik Connectors). Everything works fine if I manually write a select statement. But if I try to use Create Select Statement, then I get this error:

       

      qlikview_error.png

       

      It's not able to get the list of database owners. How can I fix this? I have no issues manually retrieve the list of owners from the same database with the same user with a manual SQL query, like this:

       

      Screen Shot 2017-12-04 at 9.58.58 PM.png