error message:
THE MERGE PROCESS WAS UNABLE TO CREATE A NEW GENERATION AT THE “SUBSCRIBER”. TROUBLESHOOT BY RESTARTING THE SYNCHRONIZATION WITH VERBOSE HISTORY LOGGING AND SPECIFY AN OUT PUT FILE TO WHICH TO WRITE.
I tried "update sysmergepublications set [generation_leveling_threshold] = 0"
on both Subscriber and Publisher, still it didn't work.
Then I tried "select count (*) from dbo.MSmerge_contents" and "select count (*) from dbo.MSmerge_genhistory" on the Subscriber
The both query was running indefinely with no results, instanly I realised there is some Locking problem.
In desperation I restarted the Subscriber Database Engine and started the Agent.
Magic! Replication was successfull.
on both Subscriber and Publisher, still it didn't work.
Then I tried "select count (*) from dbo.MSmerge_contents" and "select count (*) from dbo.MSmerge_genhistory" on the Subscriber
The both query was running indefinely with no results, instanly I realised there is some Locking problem.
In desperation I restarted the Subscriber Database Engine and started the Agent.
Magic! Replication was successfull.