Executions_visibility does not exist

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