Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Error when a repost definition has an identifier type property



Error occurs when a repost definition has an Identifier type property in the filter conditions.

Error Messages

No operator exists: Numeric to Character Varying comparison. Use explicit type casts.

Steps to Reproduce

  1. Migrated from Oracle to Postgres
  2. Create a Identifier type property
  3. Configure a report definition with a filter on the property, that is, compare with an integer
  4. Run the report definition

Root Cause

In Oracle, the Identifier type property is mapped to a Number type column. This worked in Oracle because it has implicit conversions to convert a number to a varchar, and a varchar to a number. After migration, the Number type was replaced with Numeric. These conversions are not supported in Postgres which resulted in the failure.


Perform the following local-change:
  1. Map the Identifier property to a character varying or varchar type column in the database
  2. Modify all the incorrectly mapped columns of Numeric type to character varying.

Published March 21, 2018 - Updated October 8, 2020

Was this useful?

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us