Results 1 to 4 of 4

Thread: CDC State Continually Going to Aborted

  1. #1
    dempsterj is offline Junior Member
    Join Date
    Oct 2013
    Posts
    7
    Rep Power
    0

    CDC State Continually Going to Aborted

    I am setting up a test environment for CDC with an Oracle system. I have everything set up to the point where logs are being read and data appears to be getting added to the CDC tables in SQL Server. However, at different times during the day, the status of the service goes to Aborted and the service is completely stopped. The first time I start the service, it will run for about 1 hour, before it aborts. After that, it only takes 2 or 3 minutes, sometimes less, before this happens again.

    I'm guessing there is a setting I'm missing, but I don't know what it is.

    Attached are logs from the last time I started the service, until it aborted.

    Version information:
    Oracle: 10.2.0.5.0
    CDC Service: SQL Server 2012 SP 1 CU 6
    SQL Server Database Engine: 11.0.3128

    Any help is appreciated, even if it's to an existing post that solves this problem. I haven't seen this same issue posted, but I may not have looked hard enough. :-)
    Attached Files Attached Files

  2. #2
    adsahadeo is offline Junior Member
    Join Date
    Nov 2013
    Posts
    1
    Rep Power
    0

    Any luck with this

    Any luck with this? I'm having a similar issue.

    Thanks,
    Allan.

  3. #3
    dempsterj is offline Junior Member
    Join Date
    Oct 2013
    Posts
    7
    Rep Power
    0
    I haven't found a resolution to this problem, yet. I did apply SQL Server 2012 SP1 CU6 to my server, and it appears to have a different behavior, where it still aborts, but the instance restarts 7 times before finally giving up. This is a change for my environment, but it doesn't fix the overall problem I'm having.

  4. #4
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14
    Pls get the latest CU version available from teh Microsoft team (CU8) - it should have the fix for a similar problem that was encountered.

    Quote Originally Posted by dempsterj View Post
    I haven't found a resolution to this problem, yet. I did apply SQL Server 2012 SP1 CU6 to my server, and it appears to have a different behavior, where it still aborts, but the instance restarts 7 times before finally giving up. This is a change for my environment, but it doesn't fix the overall problem I'm having.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

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