dbhelper to fix broken sql replication

Unanswered Question
Jan 27th, 2009
User Badges:

trying to fix broken sql replication. republish popup window displays

"republish must be run in the directory with replication scripts. this is usually c:\programs\cisco\bin" Is it possible DBHelper was installed to the wrong location? thanks

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
Jaime Valencia Tue, 01/27/2009 - 08:39
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

could be, make sure the actual dblhelper file is on the folder mentioned by the error


HTH


java


if this helps, please rate


testeven Tue, 01/27/2009 - 08:52
User Badges:
  • Cisco Employee,

Hi!


Remember you can only run the DBLhelper tool in the publisher server and as he said, it must be installed under:

C:\Program Files\Cisco\Bin


Also, these links might help, the first one talks about using DBLhelper and the second one can be used when the subscription needs to be fixed (recreated) manually.


*** Using DBLHelper to Reestablish a Broken Cisco CallManager Cluster SQL Subscription ***


http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801e7ddf.shtml


*** Reestablishing a Broken CallManager Cluster SQL Subscription with Cisco CallManager ***


http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d11a6.shtml


Have a nice day!


Teresa.

balitewiczp Tue, 01/27/2009 - 12:59
User Badges:

As a follow up question, am i correct in my thinking that a broken sql replication could contribute to cdr records not working?

Jaime Valencia Tue, 01/27/2009 - 13:08
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    2011

depends, were they working before??


most usually CDRs not working might be caused by passwords out of sync or misconfiguration


HTH


java


if this helps, please rate

testeven Tue, 01/27/2009 - 20:27
User Badges:
  • Cisco Employee,

Yes, a broken SQL replication can break CDR too. If it was working before and replication failed, the CDR data will not be uploaded to the ART/CDR Database, therefore the CDR reports can fail. Probably you'll see only past records and not the recent ones.


Regards,


Tere.

Actions

This Discussion