Skip to content

    • Workbench

    Workbench

    ERROR [42P01] Workbench

    Member
    in Workbench

    Hi All,

     

    One of my dataset got into error and I would like to know the cause of it and how to resolve it. Below is the screenshot of the error in workbench. 

    The error is -  ERROR [42P01] ERROR: relation "company_setting" does not exist; Error while executing the query

    sadsaf.png

    Thank you,

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Domo Employee
      Answer ✓

      This appears to be on the DataBase side. It sounds like relationships don't exist on the DataBase. 

      You will want to speak with your DataBase Administrator in this case. They will be able to investigate what is causing this behavior. 

       

    Answers

    • Contributor

      Are you querying a SQL table or a SQL view?

    • Member

      SQL Table

    • Contributor

      Ok thanks. And what kind of database are you trying to query?

       

      At first glance, this looks like a PostgreSQL error, and specifically something structural with the table itself.

       

      Can you query the table successfully in a local query environment? 

    • Domo Employee
      Answer ✓

      This appears to be on the DataBase side. It sounds like relationships don't exist on the DataBase. 

      You will want to speak with your DataBase Administrator in this case. They will be able to investigate what is causing this behavior. 

       

    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories