SDE DBMS Error: -1015 ERROR: trigger "gdb_items_xxx_xx" for table "gdb_items" does not exist

Error Message

When upgrading an enterprise geodatabase stored in PostgreSQL to ArcGIS Enterprise 11.x, the following errors are seen in the setup.log file, even though the enterprise geodatabase upgrades successfully:

SDE DBMS Error: -1015 ERROR: trigger "gdb_items_tab_tr" for table "gdb_items" does not exist.

SDE DBMS Error: -1015 ERROR: trigger "gdb_items_rel_tr" for table "gdb_itemrelationships" does not exist.

SDE DBMS Error: -1015 ERROR: trigger "gdb_item_rel_typ_tr" for table "gdb_itemrelationshiptypes" does not exist.

SDE DBMS Error: -1015 ERROR: trigger "gdb_item_typ_tr" for table "gdb_itemtypes" does not exist.

SDE DBMS Error: -1015 ERROR: trigger "gdb_rep_log_tr" for table "gdb_replicalog" does not exist.

Cause

In a PostgreSQL enterprise geodatabase, similar triggers exist, but with slightly different names: (the triggers have a suffix '_iu' and '_d'):

In a SQL Server enterprise geodatabase, the triggers do exist.

When performing an upgrade of a SQL Server enterprise geodatabase, these errors are not getting logged since the triggers exist in SQL Server.

The errors are therefore erroneously logged for PostgreSQL, as the triggers do exist but have different names than they have in SQL Server. 

Solution or Workaround

The enterprise geodatabase upgrades successfully. The errors are being logged erroneously for PostgreSQL and can safely be ignored.

When upgrading a PostgreSQL enterprise geodatabase to 12.0 or newer, these errors are no longer logged in the setup.log file.