Error Publishing Data Provider post upgrade

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Post-upgrade from Clarity 16.4.1 to version 16.4.2 on a PostgreSQL database environment, users are unable to copy and publish a data provider for Time Entries and Timesheets.

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

Steps to Reproduce:

1. Upgrade a Clarity On-Premise environment from v16.4.1 to v16.4.2 using a PostgreSQL database.
2. Navigate to the Data Provider publishing interface.
3. Attempt to copy and publish the Data Provider for Time Entries and Timesheets.
4. Run a DWH Full Load job and check if the database types reconcile automatically.

Expected Results: The Data Provider should publish successfully without database mapping exceptions, and schema definitions (DWH_INV_TASK) should align perfectly with the data warehouse metadata configurations (DWH_META_COLUMN).

Actual Results: The publication fails with a toast 'This Data Provider cannot be published.'

Environment

Clarity 16.4.2

Cause

Due to DE208069

Resolution

Engineering is reviewing DE208069