Error: F_JD023F: DBMS Error [ERROR: Must Be Owner of Table Address]

Issue

Activation fails with the following error:

F_JD023F: DBMS error [ERROR: must be owner of table address]. Last query [alter table <table> replica identity full].
F_JR0015: The previous error was detected during generation of objects for channel <channel>. It is possible that objects have been left incomplete.

Environment

• DSS 6
• Source: PostgreSQL

Resolution

To resolve this issue, execute the following statement for all applicable tables:

alter table <em>tbl</em> replica identity full;

Cause

This issue occurs when you are trying to perform log-based capture on replicated tables where you have not applied the above statement. See section Grants for Log-Based Capture in our PostgreSQL requirements for more information.