Skip to Content
author's profile photo Former Member
Former Member

Rep Het SQL to SQL column varchar(max) issue

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 08, 2016 at 09:31 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 14, 2016 at 10:30 PM

    Leandro

    Did you get time to pursue this further ?

    Avinash

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.