I was in a task of configuring Merge replication on SQL Server 2005. But unfortunately, during the synchronization(took around 8 hours) i encountered an error stating 'The Merge Agent failed to enumerate retry information. This can occur when there is too much activity on the tempdb system database. Increase the -QueryTimeOut parameter and restart the synchronization.'
Summary: - SQL server out of diskspace. This cause by replication issue. Replication fail and space in transaction log not release. I solve the problem, create a sharing folder, for example: sgdev161 SQLservertest and grant the control rights to the login domain user. When create the publisher, set the snapshot file folder to.
What does it mean? Why it happened? How i can resolve it?Updated(2010-11-18):Initially i tired ti configured a pull subscription and got the error. When i tried Push subscription, that issue was resolved.
Distributor_admin Is Not Defined As A Remote Login At The Server
Now i m in to a new problem, I got the following issues1. When i checked the 'view Synchronization status' can see the message 'The server 'X' is not a Subscriber. (.Net SqlClient Data Provider)'.1. When i checked the replication monitor, the synchronization is on progress, but i got the following error messageError messages:- The merge process was unable to access row metadata at the 'Subscriber'. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to write to, or use SQL Profiler to determine the source of the failure. (Source: MSSQLREPL, Error number: MSSQLREPL-)Get help: TCP Provider: An existing connection was forcibly closed by the remote host. (Source: MSSQLServer, Error number: 10054)Get help: Communication link failure (Source: MSSQLServer, Error number: 10054)Get help: The process was successfully stopped.
(Source: MSSQLREPL, Error number: MSSQLREPL-)Get help: publisher is running under non trusted environment and my subscriber is on trusted. This might happen if you have records in the child tables referencing subscriber parent records which no longer exist. You can try to run the agent with-output somefilepath -OutputVerboseLevel desiredlevelThe output verbose level should be 0, 1, or 2:- 0 to print only error messages- 1 to print all progress report messages- 2 (default and most useful when debugging) to print all error and report messages.It goes without saying that these switches have a very negative impact on performance, but in your case, they might be useful to identify the actual source of the problem as it is entirely possible that the problem has nothing to do with FK integrity violations and could be something else. I don't believe though that it has anything to do with the tempdb activity (despite what the error message says).Oleg.
Command attempted:C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLReplDatauncSGDEV161DEMOSGDEV0140602t2.pre( Transaction sequence number: 0x0000FD00, Command ID: 5)Error messages:The process could not read file 'C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLReplDatauncSGDEV161DEMOSGDEV0140602t2.pre' due to OS error 3. I have encountered a similar scenario as the original post. I have followed the suggested steps by specifying a UNC-naming file location.