when trying to browse the workflow through the admin portal, getting error :
ListOpenWorkflowExecutions operation failed. Select failed: pq: relation “executions_visibility” does not exist
any advice on what could be missing? We are using postgress DB.
Hello @knk_101
The ListWorkflow API hits the visibility DB (temporal_visibility) to query the workflows. It looks like your visibility DB does not have the right structure.
How are you setting up the Temporal server and the database?
Tables in temporal_visibility DB were not created correctly. Now it is working fine. Thanks
1 Like