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
Last activity: Mar 19, 2025, 06:27 PM