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

SA-53220

Summary



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.


Resolution

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.

Suggest Edit

Published March 21, 2018 - Updated October 8, 2020

Did you find this content helpful? Yes No

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.

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