Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

CCM SQL Subscriber replication error

This is a shot in the dark, but I figured I would ask here.

I have a subscriber which is having replication errors, and Im not sure of the proper procedure to fix, the error is this in the MS SQL distribution Agent error details screen:

' Could not drop object CallManager because it is referenced by a FOREIGN KEY constraint'

This is getting way deep in the SQL tables and indexes.

3 REPLIES
Silver

Re: CCM SQL Subscriber replication error

Hi,

I would check first if the sql subscription is really broken and fix it then..

http://www.cisco.com/warp/customer/788/AVVID/recreate_subscribe_database.html

Re: CCM SQL Subscriber replication error

Well just to update, there is not an easy way to fix this table replication problem, and TAC does not support any manual table configuring, I was able to fix the replication error by removing the references, but in the end, I had to completly remove the subscriber from the ccmadmin page, and rebuild the subscriber. This could be a long process if your publisher has been upgraded may times due to the ccm install process for a subscriber has to be build from CDs. After you build the subscriber form the CDs, you then have to proceed the upgrade path to get to the same level of the publisher. If you dont have CDs which are on the same main level of the publisher, this becomes challenging (ie: pub on 3.2, CDs are 3.0)

New Member

Re: CCM SQL Subscriber replication error

3.3 greatly simplifies the rebuild (at the moment). Once you've got over the initial 3.3 upgrade, a rebuild is much quicker due to a single W2k build, a single 3.3 build and a few Service Packs.

106
Views
5
Helpful
3
Replies