ERROR [42P01] 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
Thank you,
Welcome!
Best 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.
0
Answers
-
Are you querying a SQL table or a SQL view?
0 -
SQL Table
0 -
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?
0 -
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.
0
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 778 Automate
- 190 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive