Forum Discussion

sanker1984's avatar
sanker1984
Copper Contributor
Oct 04, 2023

SQL Server Replication (PUSH) insert bulk copy into subscription issue

SQL Server 2016 versions on both sides.  we pushed mutiple articles from Publisher to Subscriber. All the tables got transferred data to subscriber except one table.

 

Here is the error. Please help.

Error messages:

2023-10-04 02:01:13.352 Bulk copying data into table 'ProcDetails'

2023-10-04 02:01:14.383 Agent message code 20037. The process could not bulk copy into table '"dbo"."ProcsDetails"'.

2023-10-04 02:01:14.398 Category:NULL

Source:  Microsoft SQL Server Native Client 11.0

Number: 

Message: End of file reached, terminator missing or field data incomplete

2023-10-04 02:01:14.398 Category:NULL

Source: 

Number:  20253

Message: 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.

2023-10-04 02:01:14.398 Category:NULL

Source: 

Number:  20253

Message: bcp "gSFT_CENTRAL"."dbo"."ProcDetails" in "E:\Program Files\Microsoft SQL Server\MSSQL13.SQLESSATAIGAP\MSSQL\ReplData\unc\P10$SQIGAP_GSFT_DISTRIBUTED_TO_CENTRAL24493d9c\20231004074717\ProceEvefe573ecd_30.bcp" -e "errorfile" -t"\n<x$3>\n" -r"\n<,@g>\n" -m10000 -S01018\SQL01P -T -w

  • ErniqueVanD66's avatar
    ErniqueVanD66
    Copper Contributor
    Hello, I am facing the same kind of issues. First times the replication was ok but this time we also receive error code 20037.
    Did you find a cause or a solution for this?

Resources