Sample Header Ad - 728x90

Transactional Replication Snapshot Agent - Error 3616 - Ideas?

1 vote
1 answer
72 views
I got a server with 5 transactional database replication, first 4 are working fine. However, on the last one, the snapshot agent keeps failing with this message. I've checked permissions on the database, and I am just trying to pinpoint what could be causing it, any ideas? I noticed that if I remove all objects and create an article for just one table, the snapshot agent works fine. 2025-03-19 03:13:40.03 [0%] The replication agent had encountered an exception. 2025-03-19 03:13:40.03 Source: Replication 2025-03-19 03:13:40.03 Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException 2025-03-19 03:13:40.03 Exception Message: An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back. 2025-03-19 03:13:40.03 Message Code: 3616
Asked by Marcelo Castro (23 rep)
Mar 19, 2025, 03:40 AM
Last activity: Mar 19, 2025, 06:27 PM