I also reduced batch size to 5000 on the last run .. I like using this SImplySql because it's a script I can launch, so that's why I chose that solution... I'm using it to load a History Env.
THanks again. On Wed, Feb 5, 2025 at 4:05 PM Andy Hartman <hartman60h...@gmail.com> wrote: > nothing in log from mssql side and no anti-virus > > On Wed, Feb 5, 2025 at 2:06 PM Adrian Klaver <adrian.kla...@aklaver.com> > wrote: > >> >> >> On 2/5/25 9:46 AM, Andy Hartman wrote: >> > [6992] ERROR: unexpected EOF on client connection with an open >> transaction >> > 2025-02-05 12:19:44.919 EST [6992] CONTEXT: COPY sqlt_data_1_2022_03, >> > line 24431524, column dataintegrity >> > 2025-02-05 12:19:44.919 EST [6992] STATEMENT: COPY sqlt_data_1_2022_03 >> > (tagid, intvalue, floatvalue, stringvalue, datevalue, dataintegrity, >> > t_stamp) FROM STDIN (FORMAT BINARY) >> > 2025-02-05 12:19:44.919 EST [6992] FATAL: terminating connection >> > because protocol synchronization was lost >> >> You need to look at the other end of the connection also, in other words >> what is happening on the MS SQL Server 2016/Windows Server 2019 side? >> >> Also is there anti-virus software running on either end? >> >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> >
