question

DymekPL-1892 avatar image
0 Votes"
DymekPL-1892 asked Cathyji-msft answered

Problem with SQL Server Managment Studio 2012 (Replication)

Hi

I have a problem with replication in SQL Server Managment Studio 2012.

I have to replicate 140 locations and when I start from beginning (0 locations) everything is fine. I do 70-80 replications for 2-3 days and there is no problem with that. The problem appears after some time (about 2 weeks) when I want to add another location.

I add another location, the agent starts, I check "View synchronization status" and gets this information:

79274-error1.jpg

"The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. "

And it will keep trying forever.

If I started from beginning everything works again ...

Any suggestions?

greetings

Damian


sql-server-general
error1.jpg (72.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @DymekPL-1892,

2021-03-19 10:00:01.315 The merge process failed to execute a query because the query timed out. If this failure continues, increase the query timeout for the process.

Please try to increase the default time out period for “–QueryTimeOut” then restart the Merge agent.

81456-screenshot-2021-03-25-162709.jpg

Did you see any other useful error information from replication monitor?



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DymekPL-1892 avatar image
0 Votes"
DymekPL-1892 answered Cathyji-msft converted comment to answer

More logs with parameters:
-output c:/log.txt -outputverboselevel 3

79600-logs-level-3.txt



logs-level-3.txt (1.4 MiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DymekPL-1892 avatar image
0 Votes"
DymekPL-1892 answered DymekPL-1892 edited

Hi,

Thanks a lot for qucik answer!!

These logs will be automatically saved (where can I find them)? Or I need to add the "-output c: /log.txt" parameter? Or something?

79496-output.jpg


I added the agent run logs (photo above) but it is probably not about these logs :)

79577-logs.txt



output.jpg (86.0 KiB)
logs.txt (1.5 MiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @DymekPL-1892,

The problem appears after some time (about 2 weeks) when I want to add another location.

Did you mean add a new subscriber to merge replication? Then the replication sync failed?

Please share us more related error message from replication monitor as below screenshot.

79480-screenshot-2021-03-19-161219.jpg

The error message that you offered is a general error message. You can maximize the history logging by selecting 3 for the –HistoryVerboseLevel property of the Snapshot Agent and Merge Agent as below screenshot. The more log information you will have, it will be better to find out and identify the merge replication problems.

79538-screenshot-2021-03-19-161320.jpg

79564-screenshot-2021-03-19-161829.jpg

79593-screenshot-2021-03-19-161908.jpg

To enable detailed logging by the Replication Agent. You will need to stop and restart the Replication Agent for the setting to take effect.


If the response is helpful, please click "Accept Answer" and upvote it, thank you.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.