Our UCCE has stopped replicating data from AWDB to to B, no change has been made, the Database, Server, files, etc has enough space, we have noticed that when restarting the Distributor it inserts a fraction of the data in the Database, but after a few seconds it stops replicating and shows these messages for all tables:
Thread [16532] Function Replication is Paused by LogWatch in CheckForFunctionPause
Total log pages allocated 393215, log pages used 171016
20:51:34:966 dis-rpl Trace: Log Watch found that SQL Server log was %43 full
20:51:34:966 dis-rpl Trace: Log Watch will pause some functions and dump the SQL Server Transation Log
20:51:34:966 dis-rpl Trace: Functions Paused
20:51:34:966 dis-rpl Trace: Waiting 120 seconds before Dumping the Log
20:51:35:977 dis-rpl Trace: DbBind::DbBind: Column name = DateTime, Var Length passed to dbbind = 100
20:51:35:977 dis-rpl Trace: DbBind::DbBind: Column name = StartTime, Var Length passed to dbbind = 100
20:51:35:977 dis-rpl Trace: DbBind::DbBind: Column name = EndTime, Var Length passed to dbbind = 100
20:51:35:977 dis-rpl Trace: IcmOdbc::CDbProcess::SQLExecDirect sr = 0 select * from Recovery where RecoveryKey = (select min (RecoveryKey) from Recovery where TableName = 'Agent_Logout' and FromRecoveryKey IS NULL and Type != 'UnReplicated' and Type != 'UnableToRecover')
20:51:36:586 dis-rpl Trace: Completed Scan For Replication Requests for Dialer_Detail
Process::SQLExecDirect sr = 0 select * from Recovery where RecoveryKey = (select min (RecoveryKey) from Recovery where TableName = 'Agent_Skill_Group_Interval' and FromRecoveryKey IS NULL and Type != 'UnReplicated' and Type != 'UnableToRecover')
20:51:40:001 dis-rpl Trace: DbBind::DbBind: Column name = DateTime, Var Length passed to dbbind = 100
20:51:40:001 dis-rpl Trace: DbBind::DbBind: Column name = StartTime, Var Length passed to dbbind = 100
20:51:40:001 dis-rpl Trace: DbBind::DbBind: Column name = EndTime, Var Length passed to dbbind = 100
20:51:40:001 dis-rpl Trace: IcmOdbc::CDbProcess::SQLExecDirect sr = 0 select * from Recovery where RecoveryKey = (select min (RecoveryKey) from Recovery where TableName = 'Agent_Skill_Group_Logout' and FromRecoveryKey IS NULL and Type != 'UnReplicated' and Type != 'UnableToRecover')
20:51:41:089 dis-rpl Trace: IcmOdbc::CDbProcess::SQLExecDirect sr = 0 dbcc showfilestats
Hope someone can help us on this.
Thanks in advance.
