Postgre exceptions after migrating to GCP

Products

• Clarity PPM SaaS

Issue/Introduction

Postgre exceptions when running customer reports and processes.

See examples below:

ERROR: operator does not exist: bigint = character varying Hint. No operator matches the given name and argument types. You might need to add explicit type casts.

ERROR: operator does not exist: numeric = character varying Hint: No operator matches the given name and argument types. You might need to add explicit type casts.

Cause

Reports and processes were running on Oracle.

Now they are running on Postgre.

Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Resolution

Custom reports and processes will need to be reviewed/corrected.