Getting the below issue operating replication with EDA.
Hoping someone can shed some light on how to resolve our issue below.
U2\BIN\RW.ERRLOG u2\bin\rw.errlog
EDA SQL Server Driver: [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: An existing connection was forcibly closed by the remote host.
Mon Aug 24 06:20:53
RW(0,7460) report:
Mon Aug 24 06:20:53
RW(0,7460) report:
In E:\U2\sys\CTLG\c\CXG.WRITE.EDA.BI.DATA at line 404 Mon Aug 24 06:20:53
RW(0,7460) report:
EDA_write_tuple error, id = 'A143088'
Mon Aug 24 06:20:53
RW(0,7460) report:
The EDA file is CXSFILE stored on the Unidata Subsciber. We get the above error attempting to write to CXSFILE (EDA file) with a
Trigger on CXFILE as below configuration.
CREATE.TRIGGER CXFILE CXG.WRITE.EDA.BI.DATA AFTER UPDATE
CREATE.TRIGGER CXFILE CXG.WRITE.EDA.BI.DATA AFTER DELETE
Some evidence supports: client-side dead-handle defect, stale held connections are not detected and never re-established.
I believe we have covered off root cause with Subscriber (Server configuration, Network configuration, Collexus configuration, EDA configuration, Virus scanning configuration) & SQL (Server configuration, Dead locks, Table configuration).
The below outlines the sequence of events.
Trigger fires -> EDA_write_tuple -> Several successful writes -> EDA_write_tuple fails -> Trigger process is now in error state - > Subsequent trigger write fail.
Normal Unidata write -> Successful.
UniData 8.3.1
↓
EDA 4.33.0
↓
Microsoft ODBC Driver 18 for SQL Server
↓
SQL Server 2022.
