Error 32044

Incorrect definition of LOB column datatypes in the replication definition.

Symptom

Replication Server error 32044 is reported in the Replication Server error log:
00:0003:00000:00031:2013/01/10 00:17:43.20 server  
RepAgent(4): Error in passthru packet: 'distribute 4
0x000100000000256400003ddd000500003ddd00020000a1420004dd9400000000,6
0x000100000000256400027265706c325f323434333874646232
 applied owner =~"$dbo ~"%tbl3.~!-rs_writetext append first last changed with log textlen =2 ~$-unitext_fld1=~.!!#aa'.

00:0003:00000:00031:2013/01/10 00:17:43.20 server  
RepAgent(4): Received the following error message from the Replication Server: Msg 32044.
The datatype ('4') for 'tbl3.unitext_fld1' is not convertible to the required type ('5').

Explanation

In the last line of the error message: The datatype ('4') for 'tbl3.unitext_fld1' is not convertible to the required type ('5')., datatype 4 is text which is not convertible to datatype 5 which is image.

If you incorrectly define the column datatypes for the LOB columns in the replication definition, subscription materialization works but RepAgent cannot process data replication and therefore shuts down.

The datatype for text, unitext, and image columns in the Adaptive Server database is carried in the modification Log Transfer Language (LTL) commands that the RepAgent sends to the Replication Server. If the these datatypes do not match in both the Adaptive Server database and the replication definition, Replication Server detects the inconsistency when the modification is being replicated, and the RepAgent shuts down. The Replication Server records a warning message for the RepAgent in the Adaptive Server error log.