error "Unexpected EOF encountered in BCP data-file" when initializ

Susan,

I've got the exect same situation. How did you resolve it?

When we encountered this issue, we found cr/lf in one of the columns. Fixing that resolved the issue.

> On Monday, August 03, 2009 4:52 PM Susan Cooper wrote:

> Hi,
>
> I have run into an error trying to initialize one table in transactional
> replication. The error is:
>
> "Error messages:
> The process could not bulk copy into table '"dbo"."New_AutoTecIssuesBase"'.
> (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 "Online_Vehicle_Exchange_MSCRM"."dbo"."New_AutoTecIssuesBase" in
> "D:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\ReplData\unc\OVE-QACRM02_ONLINE_VEHICLE_EXCHANGE_MSCRM_AUTO\20090803163626\New_AutoTecIssuesBase_2#3.bcp"
> -e "errorfile" -t"\n\n" -r"\n<,@g>\n" -m10000 -SOVE-CDRSQL01 -T -w
> (Source: MSSQLServer, Error number: 20253)
> Get help: http://help/20253"
>
> When I copy the bcp command from the error message into a command prompt and
> run, I get the following error:
>
> X:\>bcp "Online_Vehicle_Exchange_MSCRM"."dbo"."New_AutoTecIssuesBase" in
> "D:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\ReplData\unc\OVE-QACRM02_ONLINE_VEHICLE_EXCHANGE_MSCRM_AUTO\20090803163626\New_AutoTecIssuesBase_2#3.bcp"
> -e "errorfile" -t"\n\n" -r"\n<,@g>\n" -m10000 -SOVE-CDRSQL01 -T -w
>
> Starting copy...
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP
> data-fil
> e
>
> 0 rows copied.
> Network packet size (bytes): 4096
> Clock Time (ms.) Total : 140
>
>
> Each time I have tried to initialize a subcription to this table (I have tried
> in different publications), I get the same error on the same file name:
> ..\New_AutoTecIssuesBase_2#3.bcp
>
> How do I resolve this problem? There is 140+GB free on the drive that the
> snapshots are written to, so it is not a space problem.
>
> Thanks for the help!!
> -Susan


>> On Thursday, August 27, 2009 7:34 PM Worried in Warren wrote:

>> Susan,
>>
>> I have got the exect same situation. How did you resolve it?


>>> On Thursday, April 07, 2011 9:46 AM Parveen Siwach wrote:

>>> Please check if table structure is same on publication and subscriber i.e.Like Column order and Data type if table already existed on subscriber and publication property is "Truncate if name is already in use". This work for me . Transactional Replication:
>>>
>>>
>>>
>>> Thanks
>>>
>>> Parveen Siwach
>>>
>>> MS SQL Server DBA

When we encountered this issue, we found cr/lf in one of the columns. Fixing that resolved the issue.

> On Monday, August 03, 2009 4:52 PM Susan Cooper wrote:

> Hi,
>
> I have run into an error trying to initialize one table in transactional
> replication. The error is:
>
> "Error messages:
> The process could not bulk copy into table '"dbo"."New_AutoTecIssuesBase"'.
> (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 "Online_Vehicle_Exchange_MSCRM"."dbo"."New_AutoTecIssuesBase" in
> "D:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\ReplData\unc\OVE-QACRM02_ONLINE_VEHICLE_EXCHANGE_MSCRM_AUTO\20090803163626\New_AutoTecIssuesBase_2#3.bcp"
> -e "errorfile" -t"\n\n" -r"\n<,@g>\n" -m10000 -SOVE-CDRSQL01 -T -w
> (Source: MSSQLServer, Error number: 20253)
> Get help: http://help/20253"
>
> When I copy the bcp command from the error message into a command prompt and
> run, I get the following error:
>
> X:\>bcp "Online_Vehicle_Exchange_MSCRM"."dbo"."New_AutoTecIssuesBase" in
> "D:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\ReplData\unc\OVE-QACRM02_ONLINE_VEHICLE_EXCHANGE_MSCRM_AUTO\20090803163626\New_AutoTecIssuesBase_2#3.bcp"
> -e "errorfile" -t"\n\n" -r"\n<,@g>\n" -m10000 -SOVE-CDRSQL01 -T -w
>
> Starting copy...
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP
> data-fil
> e
>
> 0 rows copied.
> Network packet size (bytes): 4096
> Clock Time (ms.) Total : 140
>
>
> Each time I have tried to initialize a subcription to this table (I have tried
> in different publications), I get the same error on the same file name:
> ..\New_AutoTecIssuesBase_2#3.bcp
>
> How do I resolve this problem? There is 140+GB free on the drive that the
> snapshots are written to, so it is not a space problem.
>
> Thanks for the help!!
> -Susan


>> On Thursday, August 27, 2009 7:34 PM Worried in Warren wrote:

>> Susan,
>>
>> I have got the exect same situation. How did you resolve it?


>>> On Thursday, April 07, 2011 9:46 AM Parveen Siwach wrote:

>>> Please check if table structure is same on publication and subscriber i.e.Like Column order and Data type if table already existed on subscriber and publication property is "Truncate if name is already in use". This work for me . Transactional Replication:
>>>
>>>
>>>
>>> Thanks
>>>
>>> Parveen Siwach
>>>
>>> MS SQL Server DBA


>>>> On Wednesday, May 04, 2011 12:36 PM Chuck Hottle wrote:

>>>> When we encountered this issue, we found cr/lf in one of the columns. Fixing that resolved the issue.