Friday, August 10, 2012

ERROR 14151 Replication Distribution

Error : 14151, Severity: 18, State: 1.    Replication-Replication Transaction Queue Reader Subsystem: agent [Server_Name].5 failed. The Queue Reader Agent has encountered the error ''There is insufficient system memory to run this query.'' when connecting to ''distribution'' on ''Server_Name''. Ensure that the publication and subscription are defined properly.

This error usually is a result of replication rollback when network traffic is heavy. Normally this wouldn't be a problem, but some of the subscribing tables had triggers for data redistribution. The replication command failed and rolled back, but the trigger did not. This caused integrity problems that appeared to be reported incorrectly by replication when it retried.

Suggested Actions:
1. Check the Connection, its required faster connection.
2. Stop the users surfing on the same connection
3. Re-write the triggers to be integrity friendly
4. Replace trigger functionality with scheduled batch processing
5. Reduce the default replication batch size from 100 to < 10 (reduces no. of transactions tried in one batch, thus reducing the possibility of timeouts). This will reduce replication throughput on a busy system. Open the SQL Agent distribution task for the publication affected and change the -c100 to -c10 (check in SQL BOL).
Error: 14151. Severity: 18. State: 1. Access to the path is denied. Error 14151. SQLSTATE 42000. Replication Error. Error 14151 (0x3747) Information - Error Code 14151. The subscription fails to Sync with the Publisher and marked inactive. Fun little replication error. sql error 14151 severity 18 state 1. error 14151 severity 18 state 1 replication. error 14151 severity 18 state 1 sql 2008. error 14151 sql server replication. error 14151 severity 18 state 1 sql 2005. sql server error 14151. error 14151 queue reader. 1 error when reinitialising a publication. SQL Server 2012. SQL Server 2008. SQL Server 2008 R2. SQL Server 2005. SQL Server 2000.

0 comments:

Post a Comment