Campaign: PGS-220000 ERROR: operator does not exist: character varying = integer
The article provides a resolution to a Campaign Classic v7 issue where you get the PGS-220000 Error PostgreSQL: ERROR: operator does not exist: character varying = integer error, when running a workflow that contains an alert activity. Check typology rules use the correct field type.
Description description
Environment
Campaign Classic v7
Issue/Symptoms
When running a workflow that contains an alert activity, the following error displays while the alert activity runs:
PGS-220000 Error PostgreSQL: ERROR: operator does not exist: character varying = integer.
Steps to reproduce
-
Create a workflow and add an alert activity.
-
Configure the alert activity.
-
Run the workflow. The following error displays:
PGS-220000 Error PostgreSQL: ERROR: operator does not exist: character varying = integer
Resolution resolution
Review the typology rules definition used in your alert activity properties and recreate any typology rule that is not using the correct field type. For steps, refer to Apply typology rules in Campaign Classic v7 Documentation.
Cause
There is a typology rule that uses a custom field that was previously a string, but is now an integer in the database. To see details on this process, in the log activate -verbose for the wfserver module, and execute the workflow with the debugging option Execute in the engine selected. For steps on executing this workflow, refer to Workflow properties > Execution tab in Campaign Classic v7 Documentation.