Error: F_JD2204: Insert Unexpectedly Affected Zero Rows

Issue

While running Activate Replication, the following errors appear:

• F_JD2204: Insert unexpectedly affected zero rows whereas one row was expected.
• F_JT04A1: The previous error occurred between child version <version> executable and a parent version <version> executable.
• F_JT04A0: The previous error occurred while starting coprocess.
• F_JT04C2: The previous error occurred on line <line> of script <script>.
• 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
• Hub or Target: SQL Server

Resolution

To resolve this issue, do the following:

1. Define action Environment with the following parameters:
   • Name=DSS_SQL_INIT
   • Value="SET NOCOUNT OFF"
2. Run Activate Replication with the Jobs option selected.

Cause

This issue occurs when queries don't return a row count because your SQL Server instance's SET NOCOUNT setting is set to ON.