Get Data Moving 1
Results 1 to 2 of 2

Thread: attunity is hanging on the last table during full load

  1. #1
    mprast is offline Junior Member
    Join Date
    Sep 2015
    Posts
    1
    Rep Power
    0

    attunity is hanging on the last table during full load

    Hi all,
    We're running full table loads with multiple tables (~50) every morning and are encountering an issue where attunity will hang on one table after it has loaded everything else (see attached image). The dangling table is sometimes stuck in the loading state and sometimes stuck in the queued state. It's a different table each time and there are no apparent patterns in the failures, except that they seem to be on larger tables. A job can stay stuck for days at a time (in which case it will block future loads). A (maybe?) related issue is that it takes a very long time to stop stuck jobs - on the order of an hour. Any idea what this could be? This doesn't happen on every load but it happens on most. Thank you!

    -Matt
    Attached Images Attached Images  

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    297
    Rep Power
    6
    Hello mprast,

    This look like a refresh issue on full load.

    1. Could you check on the Redshift target to see if all the record could for the hang table is the same on the source?

    2. Could you check on the Redshift Cluster manager to see if any hang query or commit ?

    3. What version of Replicate are you running?

    4. On the Attunity Cloudbeam server, could you open up add/remove problem and provide us more detail on the Attunity software / version?

    Thanks,
    Steve

Posting Permissions

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