Only Project1 opens in MSP

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Clarity project never loads when opening in MSP.  Only the default Project1 opens.

The app-ca.log file shows error - 

Error during GetProjectRequest
com.niku.union.persistence.PersistenceException: 
SQL error code: 0
Error message: ERROR: operator does not exist: character varying = bigint
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.

Cause

The data type for an attribute was 'Lookup - Number' but the database field is defined as varchar

Resolution

Deactivated the incorrect lookup attribute.