Rep Het SQL to SQL column varchar(max) issue

[Former Member]

Hi people, someone has this happened?

In a production environment heterogeneous replication MSSQL to MSSQL, We have tables in the database with columns datatypes varchar(max), these tables are replicating good but if any table is unmarked and marked again, table replicates all columns except the columns varchar(max).

Thanks for your help

Regards

Leandro

[former_member89972]

Leandro

Did you get time to pursue this further ?

Avinash

[Former Member]

Hi Avinash, thanks for your help, initially replicated before unmak/mark table with varchar(8000) in the RepDef and I did the test changing in the RepDef varchar(8000) by text in the columns but didn´t replicate, I found the following error:

E. 2016/01/11 16:51:31. ERROR #1027 DSI EXEC(133(1) SRWV0209_DC.Sentinel_Intermedia) - \dsiutil.c(421)

Open Client Client-Library error: Error: -99999, Severity 5 -- 'Error processing default values at position [3] in statement text'.

E. 2016/01/11 16:51:31. ERROR #5215 DSI EXEC(133(1) SRWV0209_DC.Sentinel_Intermedia) - \dsiutil.c(433)

The interface function 'RCIPrepare' returns FAIL for database 'SRWV0209_DC.Sentinel_Intermedia'. The errors are retryable. The DSI thread will restart automatically. See messages from the interface function for more information.

W. 2016/01/11 16:53:33. WARNING #13110 DSI(133 SRWV0209_DC.Sentinel_Intermedia) - ul\cmapp.c(2136)

'SRWV0209_DC.Sentinel_Intermedia' does not return native errors. Error action mapping may not be correct.

W. 2016/01/11 16:53:34. WARNING #13110 DSI EXEC(133(1) SRWV0209_DC.Sentinel_Intermedia) - ul\cmapp.c(2136)

'SRWV0209_DC.Sentinel_Intermedia' does not return native errors. Error action mapping may not be correct.

E. 2016/01/11 16:53:34. ERROR #2056 DSI EXEC(133(1) SRWV0209_DC.Sentinel_Intermedia) - /prs/sql.y(21448)

Line 1, character 144: Incorrect syntax with '~'.

E. 2016/01/11 16:53:34. ERROR #5035 DSI EXEC(133(1) SRWV0209_DC.Sentinel_Intermedia) - \dsiutil.c(4508)

Error from unpacker or parser. See previous message for more information.

I. 2016/01/11 16:53:34. The DSI thread for database 'SRWV0209_DC.Sentinel_Intermedia' is shutdown.

queue outbound transaction:

begin transaction

A0158 05cp850_ds 0,~"!,1 _ap _st = 128 owner=~"$dbo 0x01050065000007e9 ~!/dr243_tabla200.~!*rs_insert _yd _af 1 12,2 ~"$P12,3 ~*620160111 16:51:14.577,4 ~.!!,pruebalob12,5 ~"$P12

commit transaction

And creating the RepDef with the command "rs_create_repdef" is the same, in the repdef take the column as text.

Regards

Leandro

[former_member89972]

Not dealt with SQL to SQL replication..

But going by the symptom it seems like varchar(max) column is getting treated as "text" or "blob" type of column. You can try equivalent of sp_setrepcol to set the column for replication to check if it helps.

HTH

Avinash