Load Ingest Data
Results 1 to 3 of 3

Thread: How to find the reason of the Suspended Table

  1. #1
    akanksha.1787 is offline Junior Member
    Join Date
    Nov 2016
    Posts
    22
    Rep Power
    0

    Question How to find the reason of the Suspended Table

    Hi Experts,

    We have a situation, where one of the tables failed to replicate during full load and got suspended as par the log.
    We could not find any significant error in the log file.

    We got to know from the user manual that the suspended table details are stored in a table called 'attrep_suspended_tables'.

    Can you help with where exactly does this table gets created. We currently do not have access to the target database and the person who does have says he doesn't see any such table in the schema where others tables got replicated.

    Any help would be appreciated.


    Regards
    Akanksha

  2. #2
    akanksha.1787 is offline Junior Member
    Join Date
    Nov 2016
    Posts
    22
    Rep Power
    0

    More Information on the Suspended table

    Hi Experts,

    Just to add, our table got partially loaded and the replication process stopped after encountering an error.
    The log says, stopped due to previous error, no other information.

    Regards,
    Akanksha

    Quote Originally Posted by akanksha.1787 View Post
    Hi Experts,

    We have a situation, where one of the tables failed to replicate during full load and got suspended as par the log.
    We could not find any significant error in the log file.

    We got to know from the user manual that the suspended table details are stored in a table called 'attrep_suspended_tables'.

    Can you help with where exactly does this table gets created. We currently do not have access to the target database and the person who does have says he doesn't see any such table in the schema where others tables got replicated.

    Any help would be appreciated.


    Regards
    Akanksha

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

    the log of the task could have rollover.

    1. try to review all the task logs for this one task to see why the suspend of the table.

    2. if you can not feature out why this table fail, try to remove out of the task and create a separate task for this one table, to see if still fail, and if fail much easy to view the logs.

    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
  •