Load Ingest Data
Results 1 to 7 of 7

Thread: tables not replicated. getting stuck

  1. #1
    ram
    ram is offline Junior Member
    Join Date
    Jan 2015
    Posts
    23
    Rep Power
    0

    tables not replicated. getting stuck

    hi,

    1)I am trying to replicate data from SQL server to Redshift.
    There are about 155 tables. but the replication is stuck after 3%( 17 tables).
    the i tried to replicate only 28 tables again the replication got stuck.
    Finally i tried with 5 tables and replication was successful.
    I tried to restart, still no use.

    Please note these tables are almost empty, so thers no much data also.

    Can you please why this happens? if there is a solution or how to debug?

    2) and is there any way to check if tables are replicated successfully.

    kindly reply as soon as possible.

    regards
    ram

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    297
    Rep Power
    6
    Quote Originally Posted by ram View Post
    hi,

    1)I am trying to replicate data from SQL server to Redshift.
    There are about 155 tables. but the replication is stuck after 3%( 17 tables).
    the i tried to replicate only 28 tables again the replication got stuck.
    Finally i tried with 5 tables and replication was successful.
    I tried to restart, still no use.

    Please note these tables are almost empty, so thers no much data also.

    Can you please why this happens? if there is a solution or how to debug?

    2) and is there any way to check if tables are replicated successfully.

    kindly reply as soon as possible.

    regards
    ram
    Hello Ram,

    1. Is this a full load only or full load with CDC. It could be that the task complete and now finalize and not refresh and seems stuck.

    2. Could you check the log for this task under ~\replicate\data\logs\task_name , look at the end of the log and working back to the top, does it provide any error or warning messages?

    3. if possible provide log of the task for review.

    Thanks,
    Steve

  3. #3
    ram
    ram is offline Junior Member
    Join Date
    Jan 2015
    Posts
    23
    Rep Power
    0
    Quote Originally Posted by stevenguyen View Post
    Hello Ram,

    1. Is this a full load only or full load with CDC. It could be that the task complete and now finalize and not refresh and seems stuck.

    2. Could you check the log for this task under ~\replicate\data\logs\task_name , look at the end of the log and working back to the top, does it provide any error or warning messages?

    3. if possible provide log of the task for review.

    Thanks,
    Steve


    hi steve,

    thanks for your reply.

    no its not refresh problem cos it stuck even after restarting and that too at 3 %.
    I checked log too, no error in log. only the load and unload statements.

  4. #4
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    297
    Rep Power
    6
    Quote Originally Posted by ram View Post
    hi steve,

    thanks for your reply.

    no its not refresh problem cos it stuck even after restarting and that too at 3 %.
    I checked log too, no error in log. only the load and unload statements.
    Ram,

    Please send the log to repliweb.support@attunity.com for review.

    Thanks,
    Steve

  5. #5
    ram
    ram is offline Junior Member
    Join Date
    Jan 2015
    Posts
    23
    Rep Power
    0
    Quote Originally Posted by stevenguyen View Post
    Ram,

    Please send the log to repliweb.support@attunity.com for review.

    Thanks,
    Steve

    hi Steve,

    I have sent the mail.
    Kindly let me know your input.

  6. #6
    ram
    ram is offline Junior Member
    Join Date
    Jan 2015
    Posts
    23
    Rep Power
    0
    Quote Originally Posted by ram View Post
    hi Steve,

    I have sent the mail.
    Kindly let me know your input.
    Let me know if you find anything. have sent mail with log file to the mentioned address.
    thanks in advance

  7. #7
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    297
    Rep Power
    6
    Just an update on the issue.

    "The replication is successful now, even with data.
    The issue was the AMI EC2 server was in private ip.
    I attached public ip and now its working proper."

Posting Permissions

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