DISTINCT is not allowed in queries moved by replication transfers Explanation: The user entered the DISTINCT keyword in a query as part of a CREATE TRANSFER statement which defined a replication transfer. User Action: Re-enter the statement without the DISTINCT keyword.