Error in Clarity Query "Status Report Indicators"
search cancel

Error in Clarity Query "Status Report Indicators"

book

Article ID: 266723

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Deleted some custom defined attributes" in the object "Project" and now the query "Status Report Indicators" failed with the error : 

PT-0103: Error when trying to execute the query. Native message: ERROR: relation "odf_project_v2" does not exist

It seems the view "odf_project_v2" does not exist.

Resolution

Since this is the Project attribute there is relationship to attributes selected in the attribute registry.

Restore the view odf_project_v2.

The view gets created when project object is saved.

Refresh your database client and run the query, select * from odf_project_v2 to make sure it's is restored.