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 123»»»

Snapshot Agent Failure Expand / Collapse
Author
Message
Posted Tuesday, December 08, 2009 4:55 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 7:24 AM
Points: 877, Visits: 256
Hi,

We have created a snapshot replication from SQL 2005 to SQL 2000. After configuring the publisher, when I checked the snapshot agent status am able to see that it is not run. It is throwing the error "The system cannot find the path specified". In replication monitor it is showing the error number as 14151.

I have found many articles on the same. But nowhere giving a solution.
Please help me to solve this issue.

Thanks in Advance...


Thanks
Post #830547
Posted Tuesday, December 08, 2009 5:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 15, 2014 4:31 AM
Points: 2,808, Visits: 7,173
This could be an issue with the snapshot folder, does the agent have the correct permissions to use this folder?
Post #830557
Posted Tuesday, December 08, 2009 5:49 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 7:24 AM
Points: 877, Visits: 256
I have run the snapshot.exe in COM folder from command prompt. Then it is giving the below error.

System.TypeInitializationException: The type initializer for
'Microsoft.SqlServer.Replication.StringResources' threw an exception. ---> System.ApplicationException: The native replication resource dll failed to load.

at Microsoft.SqlServer.Replication.NativeResourceStringLoader..ctor()

at Microsoft.SqlServer.Replication.StringResources..cctor()

--- End of inner exception stack trace ---

at Microsoft.SqlServer.Replication.ReplMessage..ctor(Exception e)

at Microsoft.SqlServer.Replication.HistoryMessage..ctor(Exception e)

at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.SnapshotGeneration

AgentMessageFactory.CreateAgentMessage(Exception e)

at Microsoft.SqlServer.Replication.AgentCore.LogMessage(Exception e)

at Microsoft.SqlServer.Replication.AgentCore.ThreadFailedHandler(Exception e)


The type initializer for 'Microsoft.SqlServer.Replication.StringResources' threw an exception.


Thanks
Post #830574
Posted Tuesday, December 08, 2009 5:51 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 7:24 AM
Points: 877, Visits: 256
Could you please tell me how to check whether the agent has the correct right to the folder

Thanks
Post #830575
Posted Tuesday, December 08, 2009 5:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 15, 2014 4:31 AM
Points: 2,808, Visits: 7,173
On the folder that you selected to put the snapshots check the permissions, The account that the Agent is running should have permission to the folder.

Also if you check the Agent history you should be able to get a more verbose error message.
Post #830579
Posted Tuesday, December 08, 2009 6:31 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 7:24 AM
Points: 877, Visits: 256
In Sql server agent log also it is not updating anything. The folder have the full control permission for the user account which is used for SQL Agent to run

Thanks
Post #830600
Posted Tuesday, December 08, 2009 6:39 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 15, 2014 4:31 AM
Points: 2,808, Visits: 7,173
Can you see the files being created in the snapshot folder?
Post #830607
Posted Tuesday, December 08, 2009 6:44 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735, Visits: 1,947
Where is the directory your snapshot is storing the data.

If it is a network location, verify and see that you have correct path name.



Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #830610
Posted Tuesday, December 08, 2009 6:59 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 7:24 AM
Points: 877, Visits: 256
The snapshot folder does not contain any files. The location of the folder is D:\Program Files\Microsoft SQL Server\MSSQL\90\MSSQL.1\MSSQL\repldata

Thanks
Post #830628
Posted Tuesday, December 08, 2009 7:02 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 15, 2014 4:31 AM
Points: 2,808, Visits: 7,173
What sort of replication are you running, push or pull?

are you running a remote ditributor and if so can this access the folder?
Post #830633
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse