Merge Replication failure message

I'm getting the error message below when trying to synchronise a sql compact database to a sql server 2005 db. Can anyone suggest a reason for this?

RDA works fine, permissions look ok. I've run process monitor and can see the IN/OUT files being created, no ACCESS DENIED messages etc. help!

New Subscription Wizard

- Beginning Synchronization (Success)

- Synchronizing Data (100%) (Error)

Messages

Initializing SQL Server Reconciler has failed. Try again.
HRESULT 0x80045901 (29045)

The merge process could not initialize the message file from Subscriber 'D:\Inetpub\wwwroot\Sync\30.59FA6BD9893A_9BFA53BB-1D7C-4E84-967A-799C6FEBFCE3.IN:D:\Inetpub\wwwroot\Sync\30.59FA6BD9893A_9BFA53BB-1D7C-4E84-967A-799C6FEBFCE3.OUT'.
HRESULT 0x80045901 (0)

The operation could not be completed.

- Finalizing Synchronization (Stopped)

- Saving Subscription Properties (Stopped)

Bill, the SQL Server Reconciler is unfortunately one of the less stable parts (IMHO) of merge replication and there seems to be a number of things that can go wrong with it (and the errors are still not that useful). This said, there are a couple of things I would look for. Firstly, are you partitioning your data with filters - each partition will create its own snapshot which takes time, during which repeated syncs will fail - you might want to try a simple publication first. The other thing I would look at is the snapshot agent status (right-click your publication and select View Snapshot Agent Status. From this dialog you can kick off and monitor the creation of snapshots.

Hope this helps

|||Hi Nick,
Thanks for response. I'm not using any filters, so the "simple" :) merge is not working. Also checked the agent status but its just showing me the same error message.

I've looked on google groups since and there are few people who had the same issues in previous versions of CE. Looks like the error code is a "general security failure". So I'm going to over this area once again but i'm not hopeful.
bill.|||Question: Can you access the sync url (eg http://<server>/<virtualdir>/sqlcesa30.dll)? This should return the text string "SQL Server Mobile Server Agent 3.0"|||Accessing the dll works fine.

Will come back to this and try again on a clean machine but I'll have to leave this for now. Thanks for your help.|||

HI Nick, I hope you can help me with my errors....

Synchronizing Data (100%) (Error)

Messages

Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)

The remote server "TOSHIBA-USER" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers.
HRESULT 0x00003700 (0)

{call sp_helpdistpublisher (N'TOSHIBA-USER') }
HRESULT 0x00000000 (0)

You do not have the required permissions to complete the operation.
HRESULT 0x0000372E (0)

The operation could not be completed.

I have no idea how to solve all this and hope that you can advice me on this...

Your help are sincerely appreciated, thk you..

|||It seems that the account used for SQL Server access does not have the required permissions. Please test with a sa/administrator account to determine that this might be the problem.|||Hi Erik thanks for the reply,
I had the SQL server 2005 reinstall followed by I had this new error HResult 0x80004005 (29061).

Can I just check with do you know how to solve this error:

SQLCeException was unhandled
HResult 2147217865
Native error 0|||

Information about this error is available at: http://msdn2.microsoft.com/en-us/library/ms172357.aspx

Your SQL Server name/credentials are not working:

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the computer running SQL Server, or the password is incorrect.

|||THks for the information, I am a newbie to SQL do you have any idea how to solve this part?

Many thanks, appreciated it

Merge Replication failure message

I'm getting the error message below when trying to synchronise a sql compact database to a sql server 2005 db. Can anyone suggest a reason for this?

RDA works fine, permissions look ok. I've run process monitor and can see the IN/OUT files being created, no ACCESS DENIED messages etc. help!

New Subscription Wizard

- Beginning Synchronization (Success)

- Synchronizing Data (100%) (Error)

Messages

Initializing SQL Server Reconciler has failed. Try again.
HRESULT 0x80045901 (29045)

The merge process could not initialize the message file from Subscriber 'D:\Inetpub\wwwroot\Sync\30.59FA6BD9893A_9BFA53BB-1D7C-4E84-967A-799C6FEBFCE3.IN:D:\Inetpub\wwwroot\Sync\30.59FA6BD9893A_9BFA53BB-1D7C-4E84-967A-799C6FEBFCE3.OUT'.
HRESULT 0x80045901 (0)

The operation could not be completed.

- Finalizing Synchronization (Stopped)

- Saving Subscription Properties (Stopped)

Bill, the SQL Server Reconciler is unfortunately one of the less stable parts (IMHO) of merge replication and there seems to be a number of things that can go wrong with it (and the errors are still not that useful). This said, there are a couple of things I would look for. Firstly, are you partitioning your data with filters - each partition will create its own snapshot which takes time, during which repeated syncs will fail - you might want to try a simple publication first. The other thing I would look at is the snapshot agent status (right-click your publication and select View Snapshot Agent Status. From this dialog you can kick off and monitor the creation of snapshots.

Hope this helps

|||Hi Nick,
Thanks for response. I'm not using any filters, so the "simple" :) merge is not working. Also checked the agent status but its just showing me the same error message.

I've looked on google groups since and there are few people who had the same issues in previous versions of CE. Looks like the error code is a "general security failure". So I'm going to over this area once again but i'm not hopeful.
bill.|||Question: Can you access the sync url (eg http://<server>/<virtualdir>/sqlcesa30.dll)? This should return the text string "SQL Server Mobile Server Agent 3.0"|||Accessing the dll works fine.

Will come back to this and try again on a clean machine but I'll have to leave this for now. Thanks for your help.|||

HI Nick, I hope you can help me with my errors....

Synchronizing Data (100%) (Error)

Messages

Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)

The remote server "TOSHIBA-USER" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers.
HRESULT 0x00003700 (0)

{call sp_helpdistpublisher (N'TOSHIBA-USER') }
HRESULT 0x00000000 (0)

You do not have the required permissions to complete the operation.
HRESULT 0x0000372E (0)

The operation could not be completed.

I have no idea how to solve all this and hope that you can advice me on this...

Your help are sincerely appreciated, thk you..

|||It seems that the account used for SQL Server access does not have the required permissions. Please test with a sa/administrator account to determine that this might be the problem.|||Hi Erik thanks for the reply,
I had the SQL server 2005 reinstall followed by I had this new error HResult 0x80004005 (29061).

Can I just check with do you know how to solve this error:

SQLCeException was unhandled
HResult 2147217865
Native error 0|||

Information about this error is available at: http://msdn2.microsoft.com/en-us/library/ms172357.aspx

Your SQL Server name/credentials are not working:

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the computer running SQL Server, or the password is incorrect.

|||THks for the information, I am a newbie to SQL do you have any idea how to solve this part?

Many thanks, appreciated it

Merge replication failure

After working for about 30 minutes (delivering the snapshot) the replication
failed
I checked the Session details of the subscription and I found Action Message
saying the 'The process could not deliver the snapshot to the Subscriber.'
In the error information under Data Source I found the following message
'General network error. Check your network documentation.'
Checking the network log I got the following message: SQL Server Scheduled
Job 'SERVER\SERVER1-MRN1-MRN1_rep-XYZSERVER.ABC.LOCAL-12'
(0x97E3EAE1F1106144B16C808A6492CB9C) - Status: Failed - Invoked on:
2006-09-28 20:23:00 - Message: The job failed. The Job was invoked by
Schedule 35 (Replication agent schedule.). The last step to run was step 3
(Detect nonlogged agent shutdown.).
Any clue?
Samuel
Samuel,
what happens if you restart the agent - normally this'll solve a network
outage.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||It happens consistantly during the initial stage when the entire database
was replicated
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uN7b$g84GHA.1188@.TK2MSFTNGP05.phx.gbl...
> Samuel,
> what happens if you restart the agent - normally this'll solve a network
> outage.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
|||Samuel,
I'd enable logging to see if this gets more info
(http://support.microsoft.com/?id=312292), especially if the failure is at
the same point each time. Otherwise I'd look at monitoring the network for
outages - network connectivity problems.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Merge Replication Failure

I was adviced to turn Logging on to spot the problem with the consistantly
failing Merge Replication
Below is the end of the log. I you need the entire log I will add it
Percent Complete: 31
select * from "dbo"."tblUser" where 1 = 2
Bulk copying data into table 'tblSolsFeeEarner'
[9/30/2006 9:26:01 PM]LEEDSSERVER.MRN.LOCAL\MRNLEEDS.MRN1: select * from
"dbo"."tblUser" where 1 = 2
Percent Complete: 32
The process could not deliver the snapshot to the Subscriber.Bulk copying
data into table 'tblStaff'
Percent Complete: 33
[9/30/2006 9:26:01 PM]SERVER\SERVER1.MRN1: {call sp_reinitmergesubscription
(N'MRN1_rep', N'LEEDSSERVER.MRN.LOCAL\MRNLEEDS', N'MRN1', 'FALSE')}
Bulk copying data into table 'tblTeam'
Percent Complete: 34
Bulk copying data into table 'tblTeamMembers'
Percent Complete: 35
Bulk copying data into table 'tblTest'
Percent Complete: 36
Bulk copying data into table 'tblUser'
Reinitialized subscription to publication 'MRN1_rep' at subscriber
'LEEDSSERVER.MRN.LOCAL\MRNLEEDS:MRN1'Percent Complete: 0
The subscription has been marked for reinitialization. Reinitialization will
occur the next time you synchronize this subscription.
Percent Complete: 0
The process could not deliver the snapshot to the Subscriber.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The process could not deliver the snapshot to the Subscriber.
Percent Complete: 0
Category:AGENT
Source: LEEDSSERVER.MRN.LOCAL\MRNLEEDS
Number: 20037
Message: The process could not bulk copy into table
'"dbo"."MSmerge_contents"'.
Percent Complete: 0
Category:SQLSERVER
Source: LEEDSSERVER.MRN.LOCAL\MRNLEEDS
Number: 11
Message: General network error. Check your network documentation.
Disconnecting from Subscriber 'LEEDSSERVER.MRN.LOCAL\MRNLEEDS'
Disconnecting from Subscriber 'LEEDSSERVER.MRN.LOCAL\MRNLEEDS'
Disconnecting from Publisher 'SERVER\SERVER1'
Disconnecting from Publisher 'SERVER\SERVER1'
Disconnecting from Distributor 'SERVER\SERVER1'
Microsoft SQL Server Merge Agent 8.00.2039
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent:
SERVER\SERVER1-MRN1-MRN1_rep-LEEDSSERVER.MRN.LOCAL-12
It appears that your network connection has failed in the middle of your
snapshot deployment. Restart your merge agent and it should progress further
or complete the next time.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:%23JqkyKN5GHA.1252@.TK2MSFTNGP04.phx.gbl...
>I was adviced to turn Logging on to spot the problem with the consistantly
>failing Merge Replication
> Below is the end of the log. I you need the entire log I will add it
> Percent Complete: 31
> select * from "dbo"."tblUser" where 1 = 2
> Bulk copying data into table 'tblSolsFeeEarner'
> [9/30/2006 9:26:01 PM]LEEDSSERVER.MRN.LOCAL\MRNLEEDS.MRN1: select * from
> "dbo"."tblUser" where 1 = 2
> Percent Complete: 32
> The process could not deliver the snapshot to the Subscriber.Bulk copying
> data into table 'tblStaff'
> Percent Complete: 33
> [9/30/2006 9:26:01 PM]SERVER\SERVER1.MRN1: {call
> sp_reinitmergesubscription (N'MRN1_rep',
> N'LEEDSSERVER.MRN.LOCAL\MRNLEEDS', N'MRN1', 'FALSE')}
> Bulk copying data into table 'tblTeam'
> Percent Complete: 34
> Bulk copying data into table 'tblTeamMembers'
> Percent Complete: 35
> Bulk copying data into table 'tblTest'
> Percent Complete: 36
> Bulk copying data into table 'tblUser'
> Reinitialized subscription to publication 'MRN1_rep' at subscriber
> 'LEEDSSERVER.MRN.LOCAL\MRNLEEDS:MRN1'Percent Complete: 0
> The subscription has been marked for reinitialization. Reinitialization
> will occur the next time you synchronize this subscription.
> Percent Complete: 0
> The process could not deliver the snapshot to the Subscriber.
> Percent Complete: 0
> Category:NULL
> Source: Merge Replication Provider
> Number: -2147201001
> Message: The process could not deliver the snapshot to the Subscriber.
> Percent Complete: 0
> Category:AGENT
> Source: LEEDSSERVER.MRN.LOCAL\MRNLEEDS
> Number: 20037
> Message: The process could not bulk copy into table
> '"dbo"."MSmerge_contents"'.
> Percent Complete: 0
> Category:SQLSERVER
> Source: LEEDSSERVER.MRN.LOCAL\MRNLEEDS
> Number: 11
> Message: General network error. Check your network documentation.
> Disconnecting from Subscriber 'LEEDSSERVER.MRN.LOCAL\MRNLEEDS'
> Disconnecting from Subscriber 'LEEDSSERVER.MRN.LOCAL\MRNLEEDS'
> Disconnecting from Publisher 'SERVER\SERVER1'
> Disconnecting from Publisher 'SERVER\SERVER1'
> Disconnecting from Distributor 'SERVER\SERVER1'
> Microsoft SQL Server Merge Agent 8.00.2039
> Copyright (c) 2000 Microsoft Corporation
> Microsoft SQL Server Replication Agent:
> SERVER\SERVER1-MRN1-MRN1_rep-LEEDSSERVER.MRN.LOCAL-12
>
|||That is what is happening for days
Is it possibly because it is over VPN?
I did set the time out to 1000. Is it not enough?
This is the script of the Run Agent step:
-Publisher [SERVER\SERVER1] -PublisherDB [MRN1] -Publication
[MRN1_rep] -Subscriber [LEEDSSERVER.MRN.LOCAL\MRNLEEDS] -SubscriberDB
[MRN1] -Distributor [SERVER\SERVER1] -DistributorSecurityMode 1
-QueryTimeout 1000 -Output
C:\ShmuelShulman\OUTPUTFILE1.txt -Outputverboselevel 2
Thank you for your help,
Samuel
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uyDqc9N5GHA.3836@.TK2MSFTNGP06.phx.gbl...
> It appears that your network connection has failed in the middle of your
> snapshot deployment. Restart your merge agent and it should progress
> further or complete the next time.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
> news:%23JqkyKN5GHA.1252@.TK2MSFTNGP04.phx.gbl...
>
|||run this script, it will tell you if there is a network hiccup and when
between your publisher and subscriber.
Save this as keepalive.sql on your publisher.
WHILE 1<>2
BEGIN
SELECT GETDATE()
WAITFOR DELAY '00:00:01'
END
GO
Here is the batch file that I use to run this script:
osql -S yourSubscriberName -E -i c:\keepalive.sql -n
date /t
time /t
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:%23knLfHO5GHA.3308@.TK2MSFTNGP04.phx.gbl...
> That is what is happening for days
> Is it possibly because it is over VPN?
> I did set the time out to 1000. Is it not enough?
> This is the script of the Run Agent step:
> -Publisher [SERVER\SERVER1] -PublisherDB [MRN1] -Publication
> [MRN1_rep] -Subscriber [LEEDSSERVER.MRN.LOCAL\MRNLEEDS] -SubscriberDB
> [MRN1] -Distributor [SERVER\SERVER1] -DistributorSecurityMode 1
> -QueryTimeout 1000 -Output
> C:\ShmuelShulman\OUTPUTFILE1.txt -Outputverboselevel 2
>
> Thank you for your help,
> Samuel
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uyDqc9N5GHA.3836@.TK2MSFTNGP06.phx.gbl...
>

Merge replication failure

Hello,
I have an SQL2000 server, which acts as the distributor and as the
publisher. The clients are Pocket PC's, using SQL Server CE. I have the
latest SP for both. The replication is a merge replication, with a lot of
join filters, more than 100 articles (only tables, no views or procedures
included). The average size of the database on the clients is about ~7MB.
Sometimes, following a massive delete on several tables (delete from table,
than insert into table select from sthing), I have got the following error
message during replication:
1. "a call to the sql server reconciler has failed"
2. "failed to enumerate changes"
3. "select permission denied on column <pk> of object MS_<long-long guid>"
The error occurs in the stored procedure sp_MSsetupbelongs.
Actually, the message is right, the user has no rights to the referred
table. But. This is a generated table, created by the replication itself (I
think this is the table used for deletion). After I've added the rights, the
error disapperared. Reinitialize also helps.
Do I have to do this all for the tables in the publication? I could not do
this, because of the generated table names.
Or this is a bug?
Thanks for replies,
Tamas Beri
Funny, but I can't find anything better solution than this one:
select
'grant select on '+sysobjects.name+' to sales;'
from
sysobjects
where
name like 'MS_bi%_v_%'
order by
sysobjects.name;
After you ran this generated script, the whole problem described down there
disappears.
Do You have any information about the Service Pack 4? I have a lot of
problems with sql server ce and merge replication.
Regards,
Tamas Beri
"Beri Tamas" <gfoyle@.freemail.hu> az albbiakat rta a kvetkezo zenetben
news:uYP%23YL89EHA.2984@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have an SQL2000 server, which acts as the distributor and as the
> publisher. The clients are Pocket PC's, using SQL Server CE. I have the
> latest SP for both. The replication is a merge replication, with a lot of
> join filters, more than 100 articles (only tables, no views or procedures
> included). The average size of the database on the clients is about ~7MB.
> Sometimes, following a massive delete on several tables (delete from
table,
> than insert into table select from sthing), I have got the following error
> message during replication:
> 1. "a call to the sql server reconciler has failed"
> 2. "failed to enumerate changes"
> 3. "select permission denied on column <pk> of object MS_<long-long guid>"
> The error occurs in the stored procedure sp_MSsetupbelongs.
> Actually, the message is right, the user has no rights to the referred
> table. But. This is a generated table, created by the replication itself
(I
> think this is the table used for deletion). After I've added the rights,
the
> error disapperared. Reinitialize also helps.
> Do I have to do this all for the tables in the publication? I could not do
> this, because of the generated table names.
> Or this is a bug?
> Thanks for replies,
> Tamas Beri
|||Hi Beri,
Replication shouldn't require you to issue the explicit select on this
particular object. Can you please provide some more info so that we can try
to create the repro in our test environment?
1. What kind of permission have you provided to publisher and distributor
login?
2. What's the type of object 'MS_bi%_v_%' - view, SP, etc?
3. Can you please provide the content of following tables - sysmergearticles
& sysmergepublications?
4. In case you are okay - can you post your scripts which you used to setup
your replication?
thanks - Deepak
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Beri Tamas" <gfoyle@.freemail.hu> wrote in message
news:Ocybvt%239EHA.2984@.TK2MSFTNGP09.phx.gbl...
> Funny, but I can't find anything better solution than this one:
> select
> 'grant select on '+sysobjects.name+' to sales;'
> from
> sysobjects
> where
> name like 'MS_bi%_v_%'
> order by
> sysobjects.name;
> After you ran this generated script, the whole problem described down
there[vbcol=seagreen]
> disappears.
> Do You have any information about the Service Pack 4? I have a lot of
> problems with sql server ce and merge replication.
> Regards,
> Tamas Beri
> "Beri Tamas" <gfoyle@.freemail.hu> az albbiakat rta a kvetkezo zenetben
> news:uYP%23YL89EHA.2984@.TK2MSFTNGP09.phx.gbl...
of[vbcol=seagreen]
procedures[vbcol=seagreen]
~7MB.[vbcol=seagreen]
> table,
error[vbcol=seagreen]
guid>"[vbcol=seagreen]
> (I
> the
do
>
|||Same error here, but I run the script and still get it.
Any more on this one?

Merge Replication Error: 'Failure to connect to SQL Server with provided connection

Hi!
Im trying to create a merge replication publication for a SQL Mobile
Application .
Everything works fine creating the publication and I'm able to do
the
http://xxx.xxx.xxx.xxx/aaaaaaa/sqlcesa30.dll, and it display's the
"sql server mobile server agent 3.0".

But when I run the application on the PDA and its doing the
replication it appears the following error:
'Failure to connect to SQL Server with provided connection
information . SQL Server does not exist , access is denied because
the
IIS user is not a valid user on the SQL Server , or the password is
incorrect' .

any idea of which could be the reason...?

Thanks in advance!!!We found the solution: to put also the name of the Sql Server Instance
as the publisher: Sql_Server\Sql_Server_Instance

On Mar 5, 9:11 am, "CFTK" <crodriguezdepa...@.gmail.comwrote:

Quote:

Originally Posted by

Hi!
Im trying to create a merge replication publication for a SQL Mobile
Application .
Everything works fine creating the publication and I'm able to do
thehttp://xxx.xxx.xxx.xxx/aaaaaaa/sqlcesa30.dll, and it display's the
"sql server mobile server agent 3.0".
>
But when I run the application on the PDA and its doing the
replication it appears the following error:
'Failure to connect to SQL Server with provided connection
information . SQL Server does not exist , access is denied because
the
IIS user is not a valid user on the SQL Server , or the password is
incorrect' .
>
any idea of which could be the reason...?
>
Thanks in advance!!!