Failed to enumerate changes in filtered articles

HI, I have configured merge replication with pull subscription on sql server2000 and subscribers running personall sql server 2000. Subscribers connect through VPN. The application written in VB6 was working properly since 4 months with minor replication
problems.
A few days ago we rebuilt the publication. All subscribers got their initial snapshots succesfully while connected with UTP cables. From that time on everytime they try to synchronize through VPN they upload their changes but they can't download changes f
rom the Publisher. They receive the message:
Failed to enumerate changes in the filtered articles.
Coll. Code: x80045063=x80040000 + 20579
{call sp_MSsetupbelongs(?,?,?,?,?,1,?,?,1,?,?,?,?)}
Coll. Code: 0
Incorrect syntax near the keyword 'where'.
Coll.Code: x9C=156
Incorrect syntax near the keyword 'and'.
Coll.Code: x9C=156
We checked our join filters and everything seems OK.
Next a subscriber synchronized with UTP cable (instead of VPN) and it worked! But still everyone trying to synchronize through VPN gets the same error. We increased the timeout of the merge agent but the problem is still there.
Do anyone have found real solution for this problem?
Thanks a lot for your help!!!
Tony,
there are scant details on this on the MS site:
http://msdn.microsoft.com/library/de...odbc_72pl.asp.
The main suggestion is to increase the timeout, which you have already done.
There is a recorded error - http://support.microsoft.com/?id=814916 - which
details a fix, and hopefully this is relevant. Also, rerunning the merge
agent often fixes these issues. If none of this helps, then a PSS call might
be required.
HTH,
Paul Ibison
|||place your merge agent in an infinite loop. Most of the time the failure to
enumerate changes are solved the next time the merge agent runs.
Could you possible post your publication and table schema's here?
Could you also do logging to try to isolate which article is problematic?
http://support.microsoft.com/default...b;EN-US;312292
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uP3$BWuLEHA.2612@.TK2MSFTNGP10.phx.gbl...
> Tony,
> there are scant details on this on the MS site:
>
http://msdn.microsoft.com/library/de...odbc_72pl.asp.
> The main suggestion is to increase the timeout, which you have already
done.
> There is a recorded error - http://support.microsoft.com/?id=814916 -
which
> details a fix, and hopefully this is relevant. Also, rerunning the merge
> agent often fixes these issues. If none of this helps, then a PSS call
might
> be required.
> HTH,
> Paul Ibison
>
|||Dear Paul and Hilary thank you for your advise. We used the Microsoft Hot Fix of the KB Article Number: 814916 and it fixed our problem.
|||Thanks for the update Tony, I'll update my knowledgebase with this.
Paul
|||Could you mail that hotfix to me ?
please send it to: jk@.bestpriceeu.com
Kind regards
Janus
"Tony2000" <anonymous@.discussions.microsoft.com> wrote in message
news:45730017-39D9-445C-B71C-1B828916F5D2@.microsoft.com...
> Dear Paul and Hilary thank you for your advise. We used the Microsoft Hot
Fix of the KB Article Number: 814916 and it fixed our problem.
>
|||Could you e-mail that hotfix to me too?
please send it to this adress: iulian1978@.yahoo.com
Thank you
Julian
"Janus Knudsen" wrote:

> Could you mail that hotfix to me ?
>
> please send it to: jk@.bestpriceeu.com
> Kind regards
> Janus
> "Tony2000" <anonymous@.discussions.microsoft.com> wrote in message
> news:45730017-39D9-445C-B71C-1B828916F5D2@.microsoft.com...
> Fix of the KB Article Number: 814916 and it fixed our problem.
>
>
|||I have the same probleme here and tried everything but was unable to fix it. Could someone please send me the hotfix to this account? renx@.siol.net
Regards,
Andrej Renko, developer|||Oooh please, could someone send me the hotfix?
asolbesg@.capgemini.es
Thanks in advance.sql

Fail to start Integration Service

As part of Team Foundation Server the Integration Services are used. They are configured to start automatically but it doesn't. Status is "stopped". Trying to start the service manually fails too:

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 07.11.2006
Time: 11:11:49
User: N/A
Computer: SDOSCARBUILDSRV
Description:
The SQL Server Integration Services service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

It uses default LogOnAs NT Authority\NetworkService. Any idea what might be wrong and what to do?

Thanks

Hans-Peter

Please check if this KB applies:
http://support.microsoft.com/kb/918644|||

SP1 has not been installed yet.

Hans-Peter

|||Is the Sql Server Service started? SSIS is dependent on that service.|||

Yes, the Sql Server Service is started. Also Agent, Analysis Service, Browser, Full Text Search, Reporting Services and VSS Writer. They all are started automatically and they are up.

Hans-Peter

|||

What to do? Any hints?

Hans-Peter

Fail to start Integration Service

As part of Team Foundation Server the Integration Services are used. They are configured to start automatically but it doesn't. Status is "stopped". Trying to start the service manually fails too:

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 07.11.2006
Time: 11:11:49
User: N/A
Computer: SDOSCARBUILDSRV
Description:
The SQL Server Integration Services service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

It uses default LogOnAs NT Authority\NetworkService. Any idea what might be wrong and what to do?

Thanks

Hans-Peter

Please check if this KB applies:
http://support.microsoft.com/kb/918644|||

SP1 has not been installed yet.

Hans-Peter

|||Is the Sql Server Service started? SSIS is dependent on that service.|||

Yes, the Sql Server Service is started. Also Agent, Analysis Service, Browser, Full Text Search, Reporting Services and VSS Writer. They all are started automatically and they are up.

Hans-Peter

|||

What to do? Any hints?

Hans-Peter

Fail to connect to cluster server

I have a win 2000 cluster server with a sql 2000 instance=20
whitch is configured only with tcp/ip, and when it=20
restarted i=B4m unable to connect to the server.
The error log gives the error message "Bind failed on tcp=20
port 1434".
I can=B4t connect to the server in Entrprise manager, is=20
there any other way to configure the instance to listen to=20
naed pipes?
/Mike
Hi Mike,
By default the Clustered instance should listen on both Named Pipes and
TCP/IP. The problem here is that if we can't bind to the port,
the server doesn't come Online. If the server is not Online, then you
can't add the Named Pipes library back.
See if you can resolve why the server isn't binding to the port. Once the
server is up you can add Named Pipes back.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Fail to connect to cluster server

I have a win 2000 cluster server with a sql 2000 instance=20
whitch is configured only with tcp/ip, and when it=20
restarted i=B4m unable to connect to the server.
The error log gives the error message "Bind failed on tcp=20
port 1434".
I can=B4t connect to the server in Entrprise manager, is=20
there any other way to configure the instance to listen to=20
naed pipes?
/MikeHi Mike,
By default the Clustered instance should listen on both Named Pipes and
TCP/IP. The problem here is that if we can't bind to the port,
the server doesn't come Online. If the server is not Online, then you
can't add the Named Pipes library back.
See if you can resolve why the server isn't binding to the port. Once the
server is up you can add Named Pipes back.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.