Post reply

Snapshot Agent Failure

  • December 8, 2009 at 4:55 am

    #207039

    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

  • December 8, 2009 at 5:27 am

    #1089124

    This could be an issue with the snapshot folder, does the agent have the correct permissions to use this folder?

  • December 8, 2009 at 5:49 am

    #1089137

    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

  • December 8, 2009 at 5:51 am

    #1089138

    Could you please tell me how to check whether the agent has the correct right to the folder

    Thanks

  • December 8, 2009 at 5:56 am

    #1089142

    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.

  • December 8, 2009 at 6:31 am

    #1089159

    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

  • December 8, 2009 at 6:39 am

    #1089165

    Can you see the files being created in the snapshot folder?

  • December 8, 2009 at 6:44 am

    #1089168

    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.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 8, 2009 at 6:59 am

    #1089184

    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

  • December 8, 2009 at 7:02 am

    #1089189

    What sort of replication are you running, push or pull?

    are you running a remote ditributor and if so can this access the folder?

  • December 8, 2009 at 7:19 am

    #1089209

    push subscription.

    distributor and publisher servers are the same.

    Thanks

  • December 8, 2009 at 7:30 am

    #1089224

    Everything seems to be fine, and my initial assumption is security permissions for the Agents (which Steve has already mentioned) on that directory, check that one more time.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 8, 2009 at 10:01 pm

    #1089645

    I checked the permissions and all. It is full control only for the agent login.

    Thanks

  • December 8, 2009 at 10:04 pm

    #1089647

    I checked the permissions and all. It is full control only for the agent login.

    Thanks

  • December 8, 2009 at 10:10 pm

    #1089648

    I checked the permissions and all. It is full control only for the agent login.

    Thanks

Viewing 15 posts - 1 through 15 (of 26 total)

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