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 Distribution Agent Failure "memory mapped file read failed" Expand / Collapse
Author
Message
Posted Thursday, June 27, 2013 1:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2014 12:11 PM
Points: 1, Visits: 62
Please advise on resolution steps that worked for you for the below error description while delivering snapshot data to subscriber server through Distribution Agent.

Error messages:
• The process could not bulk copy into table '"dbo"."Table"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)
Get help: http://help/MSSQL_REPL20037
• memory mapped file read failed
• To obtain an error file with details on the errors encountered when initializing the subscribing table, execute the bcp command that appears below. Consult the BOL for more information on the bcp utility and its supported options. (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253
• bcp "DB"."dbo"."Table" in "\etworkpath\Table_69.bcp" -e "errorfile" -t"<x$3>" -r"<,@g>" -m10000 –S<Subscriber Server Name> -T -w (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253
• Query timeout expired (Source: MSSQLServer, Error number: HYT00)
Get help: http://help/HYT00

Post #1468305
Posted Sunday, June 30, 2013 12:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 6:41 AM
Points: 197, Visits: 729
• Query timeout expired (Source: MSSQLServer, Error number: HYT00)

Don't have a idea, but looking at this part of the error message: analyse the processes running on the subscriber. Seems that the insert operation is blocked by some other processes.
Post #1468843
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse