Postgre exceptions after migrating to GCP

book

Article ID: 196190

calendar_today

Updated On:

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.