Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    31

    Unanswered: CDC 10.2 is failing, not sure why. 1713 error

    I'm testing CDC between SQL 2005 SP1 and SQL 2012, and installation went well. I installed CDC for SQL on both servers, configured the instances, installed the Access Server, then tied everything together using Management Console. I then created the subscription and started mirroring, which initially worked because the tables were created and populated on the Target server. Problem though is the subscriptions starts then fails though the logs aren't being very helpful.
    Below are the logs as I try to replicate data from AdventureWorks for testing, but the Information message before the error is from the Journal Scrape. Any suggestions on what could be causing this?
    Thanks.
    EventID 92: *** IBM InfoSphere Change Data Capture is starting.
    EventID 1520: Communication to ADVENTUR on target host Jupiter is starting on the Control channel.
    EventID 1463: +++ Subscription ADVENTUR is starting in Continuous Mirroring mode.
    EventID 1521: Communication to ADVENTUR on target host Jupiter is starting on the Data channel.
    EventID 44: Mirroring has been initiated for table Person.Address.
    .... I added about a dozen tables, won't list them all here
    EventID: 2922:
    Subscription ADVENTUREWORKS has started using the single scrape staging store. Subscription bookmark: Journal name JOURNAL Journal bookmark 000204;00000033:000017ef:0001;00000033:000017ef:00 01;00000033:000017ef:0001
    Staging store oldest bookmark: Journal name JOURNAL Journal bookmark 000204;00000033:000017ef:0001;00000033:000017ef:00 01;00000033:000017ef:0001
    Staging store newest bookmark: Journal name JOURNAL Journal bookmark 000204;00000033:000017ef:0001;00000033:000017ef:00 01;00000033:000017ef:0001
    EventID: 1713 Error - IBM InfoSphere Change Data Capture to ADVENTUR is initiating shutdown due to failure on the local system. See the previous messages for additional information.
    EventID 1465: --- Subscription ADVENTUR is terminating abnormally.
    EventID 93: *** IBM InfoSphere Change Data Capture is ending.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this is a db2 forum
    for cdc goto developerswork and look for cdc forum
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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