Post reply

Merge Replication Error Failed to enumerate filtered articles

  • July 28, 2005 at 5:44 am

    #90336

    Greetings!

    I have setup Merge Replication on my server and my subscriber is pocket pc device which hosts SQL CE on it. Sql Ce server agent,IIS and publisher are on the same machine with SQL Server 2000 sp3 installed on it..Recently, I got this error "Failed to enumerate filtered articles" since last 2 months no problem..I researched on the net and found a KB Article which say u have to install the latest service pack for SQL Server 2000. there was another solution of rebooting the system..i did a reboot and oo-la my schronization again started working..i was just thinking is this a temporary solution and for a permanent one do i need to go ahead and install sp4 fpor sql 2000?? any ideas

    ..

    thanks for the time

    regards,

    dilip

  • August 1, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • August 3, 2005 at 5:06 am

    #579094

    this problem is transitory. Most of the time is will clear next time you run the agent.

    --

    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

  • August 4, 2005 at 12:32 am

    #579443

    You can get a hotfix which fixes this issue

    you dont need all of SP4 if you cant do it yet,

    I have done this and has solved the problem without rebooting

    If its the same one that i had, then it has to do with how the randomly generated name of temporary tables is created and the fact that after a given period of time (the internet posts i have seen say about 30 -40) the value used in the randomly generated name goes negative, and you cant have dashes in temp tables..

    alternatively you reboot every 30 - 40 days

    i havent seen running any agent fix the issue...yet.

    Checkout the microsoft KB about it as it specifically tells you whats going on with it.


    ------------------------------
    Life is far too important to be taken seriously

  • August 7, 2005 at 3:57 pm

    #580291

    Thanks both of you for the inputs. I actually have applied the latest service pack(SP4) on my server..

    Thanks and Regards,

    Dilip

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply