Data Replication 2
Results 1 to 6 of 6

Thread: SQLServer replication problem

  1. #1
    Nik
    Nik is offline Junior Member
    Join Date
    Nov 2017
    Posts
    4
    Rep Power
    0

    SQLServer replication problem

    Hi All,


    I have installed Attunity Replication Express and SQL Server 2016(Sp1 cu5) in Windows Server 2016 VM in Azure environment.
    I try to do SQLServer 2016 replication to SQLServer 2016 with no result. (currently the source and the target DB are same)


    Thanks for the response.


    The error message is the follows:


    .
    .
    .
    00004228: 2017-11-14T08:41:53 [SOURCE_UNLOAD ]I: NLS configuration sampled: Associated code page=1250 (sqlserver_endpoint_imp.c:1828)
    00005640: 2017-11-14T08:41:53 [TARGET_LOAD ]I: Bulk is set to ignore max row size warnings (sqlserver_endpoint_imp.c:1351)
    00005640: 2017-11-14T08:41:53 [TARGET_LOAD ]I: Going to connect to server localhost database Omdw (sqlserver_endpoint_imp.c:1394)
    00000956: 2017-11-14T08:41:53 [SOURCE_CAPTURE ]E: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3703)
    00005640: 2017-11-14T08:41:53 [SOURCE_CAPTURE ]I: NLS configuration sampled: Associated code page=1250 (sqlserver_endpoint_imp.c:1828)
    00000956: 2017-11-14T08:41:53 [SOURCE_CAPTURE ]E: Unknown '0' native error detected while SQL_ERROR is flagged / SQLSTATE is not empty. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3704)
    00000956: 2017-11-14T08:41:53 [SOURCE_CAPTURE ]E: sqlserver_capture_source_loop(...) encountered an unexpeceted error. [120102] Stream Component recoverable error. (sqlserver_endpoint_capture.c:749)
    00000956: 2017-11-14T08:41:53 [SOURCE_CAPTURE ]E: Error executing source loop [120102] Stream Component recoverable error. (streamcomponent.c:1489)
    00002180: 2017-11-14T08:41:53 [TASK_MANAGER ]E: Task error notification received from subtask 0, thread 0 [120102] Stream Component recoverable error. (replicationtask.c:2047)
    00002180: 2017-11-14T08:41:53 [TASK_MANAGER ]I: Task 'SQL1 to SQL2' encountered a recoverable error (repository.c:4411)
    00005360: 2017-11-14T08:41:53 [SORTER ]I: Final saved task state. Stream position 0000002E:00006C30:0006, Source id 1, next Target id 1, confirmed Target id 0 (sorter.c:556)
    00000956: 2017-11-14T08:41:53 [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_SQLServer [120102] Stream Component recoverable error. (subtask.c:1345)
    00000956: 2017-11-14T08:41:53 [SOURCE_CAPTURE ]E: Stream component 'st_0_SQLServer' terminated [120102] Stream Component recoverable error. (subtask.c:1510)
    00002180: 2017-11-14T08:41:57 [TASK_MANAGER ]I: Subtask #0 ended (replicationtask_util.c:933)
    00002180: 2017-11-14T08:41:57 [TASK_MANAGER ]I: Subtask #1 ended (replicationtask_util.c:933)
    00002180: 2017-11-14T08:41:58 [SERVER ]I: Stop server request received internally (server.c:2577)
    00002180: 2017-11-14T08:41:58 [TASK_MANAGER ]I: Task management thread terminated (replicationtask.c:2802)
    00005608: 2017-11-14T08:41:59 [SERVER ]I: Client session (ID 31869) closed (dispatcher.c:194)
    00005608: 2017-11-14T08:41:59 [UTILITIES ]I: The last state is saved to file 'C:\Program Files\Attunity\Replicate\data\tasks\SQL1 to SQL2/StateManager/ars_saved_state_000002.sts' at Tue, 14 Nov 2017 08:41:53 GMT (1510648913548913) (statemanager.c:673)
    00000776: 2017-11-14T08:41:59 [SERVER ]I: The process stopped (server.c:2701)
    00000776: 2017-11-14T08:41:59 [SERVER ]I: Closing log file at Tue Nov 14 08:41:59 2017 (logger.c:1972)

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    301
    Rep Power
    6
    1. i assume that the test connection for the source endpoint and target endpoint , test successfully.

    2. since you are using the SQL db same as source and target, i assume you change the table name in the task setting.

    3. Also, i assume that this is a standard SQL DB not some type of azure sql .

    4. have you try to replicate a small table , full load only does that work?

  3. #3
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    301
    Rep Power
    6
    Also, notes that older version of 5.xx does not support SQL 2016,

    supported version for SQL 2016 is 5.2.0266 and newer.

  4. #4
    Nik
    Nik is offline Junior Member
    Join Date
    Nov 2017
    Posts
    4
    Rep Power
    0
    Quote Originally Posted by stevenguyen View Post
    1. i assume that the test connection for the source endpoint and target endpoint , test successfully.
    Yes, it's successfully

    2. since you are using the SQL db same as source and target, i assume you change the table name in the task setting.
    Yes, the table name is changed

    3. Also, i assume that this is a standard SQL DB not some type of azure sql .
    Yes, it's a standard type. Microsoft SQL Server 2016 (SP1-CU4) (KB4024305) - 13.0.4446.0 (X64)

    4. have you try to replicate a small table , full load only does that work?
    Yes, I tried it, but doesn't work.

    Thanks for the reply.

  5. #5
    Nik
    Nik is offline Junior Member
    Join Date
    Nov 2017
    Posts
    4
    Rep Power
    0
    Quote Originally Posted by stevenguyen View Post
    Also, notes that older version of 5.xx does not support SQL 2016,

    supported version for SQL 2016 is 5.2.0266 and newer.
    I use the Attunity trial version 5.0.2.49, how can I download the latest version of Attunity?

    Thank you for your help.

  6. #6
    Nik
    Nik is offline Junior Member
    Join Date
    Nov 2017
    Posts
    4
    Rep Power
    0
    Quote Originally Posted by Nik View Post
    I use the Attunity trial version 5.0.2.49, how can I download the latest version of Attunity?

    Thank you for your help.
    Hi Steve,
    The new 5.2.0.266 fix the issue!

    Thank You!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •