Itgenclr083: De externe server heeft een fout geretourneerd: (422) Unprocessable Entity

When synchronizing a list of contacts from memory with ActiveCampaign, an error message occurs:

itgenclr083: De externe server heeft een fout geretourneerd: (422) Unprocessable Entity.
itgenacn045: duplicate email: E-Mail-Adresse existiert bereits im System. (email =, phone = +99 12 345 67 89, firstName = John, lastName = Doe).

However, the following query returns no result for

select *
from   v3.contacts
where  email = ''

The error message can also be triggered via:

insert into v3.contacts
( email
( ''

How can I solve / avoid this?

The duplicate email addres check in ActiveCampaign is a little bit special.

The column Email shows the email address loaded, but the equality comparison seems to be done case-insensitive (see Ist bei E-Mail-Adressen die Groß- und Kleinschreibung wichtig? | Mailchimp).

It seems that the formal meaning can be different, but this is not a good practice.

The following email addresses are different for the Invantive synchronize statement:


Both email addresses are considered equal by ActiveCampaign, leading to the “duplicate email” error.

It is highly recommended to make sure all contacts have a lower-case email address.

The following code makes all contacts have a lower-case email address:

  l_cnt_casing pls_integer;
  create or replace table Contacts_Ist@inmemorystorage
  select *
  from   v3.Contacts
  l_cnt_casing := 0;
  for r in
  ( select
    ,      t.Email
    from   Contacts_Ist@inmemorystorage t
    where  t.Email != lower(t.Email)
    by     t.Email
    dbms_output.put_line('Correct casing of ' || r.Email || ' (ID #' || to_char(r.Id) || ').');
    update Contacts
    set    Email = lower(r.Email)
    where  id =
    l_cnt_casing := l_cnt_casing + 1;
  end loop;
  ( 'Corrected casing of ' 
    || to_char(l_cnt_casing) 
    || ' contact email addresses.'

Dit topic is 7 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.