Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication issue Expand / Collapse
Author
Message
Posted Friday, July 19, 2013 5:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:43 AM
Points: 11, Visits: 335
We are currently in the process of migrating our environments. We have multiple publication servers, a central distributor, and multiple subscribers. We are migrating all parts of the environments.

The first step happened a couple of weeks ago, we migrated a publishing server to a new host and changed the distributor, replication was dropped and recreated without any problems.

The second step is just to change the distributor of another server, this consists of 4 transactional publications. Three went in with any problems the final one was created without issues, the snapshot generated, but the subscription failed with the following error:

The distribution agent failed to create temporary files in blah\blah\COM

I have given the distribution agent account access to the directory on the subscriber but it still fails as we have other servers working this way I do not understand why this is failing.

It think that this may be down to the qreader agent, we didn't use one of these for the first server, which I believe is used for transactional replication with updateable subscriptions which we are not using.

My next step, as this is now affecting production reporting, is to strip out the replication and start from scratch but this time without the qreader agent.

Any comments or recommendations would be appreciated.
Post #1475390
Posted Saturday, July 20, 2013 11:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:43 AM
Points: 11, Visits: 335
20-July-2013

Taken out replication overnight, disabled qreader job on distributer.
Recreated all four publications - no problems all snapshots created.
Three subscriptions work fine.
The last one again fails because of the following error:

The distribution agent failed to create temporary files in 'c:\Program Files\Microsoft SQL Server\110\COM' directory. System returned errorcode 5. (Source: MSSQL_REPL, Error number: MSSQL_REPL21100)

This is not an updateable subscription, the snapshot is over 35GB which shouldn't be an issue. I believe that the c: drive referred to is that on the subscriber - which the distribution agent has full access to.

Any ideas?
Post #1475762
Posted Tuesday, July 23, 2013 1:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:43 AM
Points: 11, Visits: 335
Now resolved. The drive replication required access to was on the C: drive of the distributor.

I can't see why it would need it for this specific publication/subscription and not for the other 4 transactional and 4 snapshot publications using this distributor, unless it was down to size as the snapshot for this one was over 35GB.

This does add an extra problem as this is a virtual instance on a cluster so I now have to give the account access to the directory on the C: on all 4 cluster nodes.

any suggestions anyone?

Thanks
Post #1476383
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse