Post reply

Replication Error

  • November 14, 2005 at 11:18 am

    #90812

    I have created a publisher and subscriber etc but whenever I try to sync the subscriber I get the following message:

    exec dbo.sp_MSset_subscription_properties @publisher = N'BRACKNELL\COMSHARE',@publisher_db = N'MSStatistics', @publication = N'', @subscription_type = 0, @allow_subscription_copy = 0, @queue_id = N'', @update_mode = 0, @attach_version = 0xee02e6f1a60bba4e850407261cb34d6c, @queue_server = N''

    Does anyone know the resolution to this?

    Thanks

  • November 15, 2005 at 2:43 am

    #603831

    Hi,

    Need a bit more information on the process you went through to set up your replication. 

    Did you synchronise before adding the subscriber or did you push out a new snapshot after adding the subscriber ?

    Regards..Graeme

  • November 15, 2005 at 2:47 am

    #603832

    Hi Graeme,

    I configured one server as the distributor and then configured it as the publisher. The second server was then added as a subscriber. I ran the snapshot agent and when that completed I ran the agent that pushes the article to the subscriber. It was when I ran this agent that the error occured.

    Thanks

    David

  • November 15, 2005 at 2:57 am

    #603835

    I take it this is Transactional replication ??

    Is this error in the Distribution agent ?

    Graeme

  • November 15, 2005 at 3:00 am

    #603836

    The replication type is snapshot, I don't have access to the server at the moment but yes, I believe the error is in the distribution agent.

    David

  • November 15, 2005 at 3:15 am

    #603840

    Hello David,

    Are your article defaults set to DROP and recreate the table at the subscriber?

    And your servers are on the same network and one server can be registered with the other??? Hmmm

    Can you remove replication and reapply it using say the wizard ?

    Apologies for being vague !...this is seems quite odd.

    Regards..Graeme

  • November 15, 2005 at 3:21 am

    #603843

    Hi Graeme,

    The two servers are on the same network and each server is able to register the other in EM. I have tried disabling publication and distribution on the one server and then restarting the whole process using the wizard from Tools - Replication but still get the same thing. I cannot check at the moment whether DROP and recreate flags are set but will check as soon as the server is available.

    Thanks

    David

  • November 15, 2005 at 9:28 am

    #603966

    Hi Graeme,

    The 'DROP exisiting table and re-create it' flag has been set. I've run through the steps again but still cannot get it to work. I set one server up as a distributor, publisher and subscriber and found that the replication worked perfectly.

  • November 15, 2005 at 10:31 am

    #603988

    I tried setting the other server up as the publisher, distributor and subscriber. When I tried to create either a push or pull subscription I got the following message:

    Error 14053: Cannot load the DLL replincrementlsn extended procedure, or one of the DLLs it references. Reason: 126(error not found).
    The subscription could not be updated at this time.
    The subscription could not be created.
    SQL Server Enterprise Manager could not create a pull subscription to publication XXXX
    Error 14053: Cannot load the DLL replincrementlsn extended procedure, or one of the DLLs it references. Reason: 126(error not found).
    The subscription could not be updated at this time.
    The subscription could not be created.

     

  • November 29, 2005 at 1:06 pm

    #606525

    for the last error install sql sp4

  • November 30, 2005 at 1:33 am

    #606629

    Hi Marco,

    My server already had sp4 installed but I found that re-installing the sp cured the problem. Thanks for your help.

     

Viewing 11 posts - 1 through 10 (of 10 total)

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