Call Manager publisher database problem

Answered Question
Oct 10th, 2007
User Badges:

Hi all,


I've got a very strange problem in my publisher server. Any updates done from this server will not be executed to the phones. It seems that this server has write problem to database. But strangely, when I do updates from subscribers, the updates are executed to the phones, and publisher can recognize the updates. There is no replication problem between subscriber to publisher.


The other observable effect is that users can forward call but cannot cancel their forward from the phone. But it can be cancelled from the subscriber.


I'm using CCM 4.1(3)SR5b.


Can someone help me what should I do beside rebooting the server ?


Thanks a lot


Wiyandi

Correct Answer by Rob Huffman about 9 years 5 months ago

Hi Wyandi,


Just to add a note to the good information you received from Zin,Ajaz and Bill, these docs have some possible solutions to this problem;


Unable to Cancel Call Forward All from an IP Phone


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


Cisco CallManager Issues with Call Forward All


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


Hope this helps!

Rob


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Zin.Karzazi Thu, 10/11/2007 - 00:20
User Badges:
  • Silver, 250 points or more

Restarting CCM service? checking what the eventviewer is showing when you try to update/change some phone setting.

sr2290723 Thu, 10/11/2007 - 01:51
User Badges:

Event viewer show nothing. I tried to change CSS of a phone, the page shows that the CSS changes, but the CSS change doesn't happen at the phone. It still use the old CSS. That's what happen if I update the CSS from the publisher. Everything is normal and working if I change it from the subscriber.


Wiyandi

AJAZ NAWAZ Thu, 10/11/2007 - 02:19
User Badges:
  • Silver, 250 points or more

There's a Cisco utility tool called DBhelper.exe for CallManager - have you ever used that?


This will identify any DB replication issues (If they exist), between the cluster.


Ajaz



Hi, have you checked that the extended functions service is started and running (call forwarding issue). As far as the database is concerned, the only time I have seen this type of problem without databse replication issues was when we had to restore a 4.1.3 server from a backup and used BARS 4.0.8. This version of BARS messed with the rights on the SQL database and we saw symptoms very similar tou yours. It required a TAC case to resolve. All tools (DBLHelper etc, showed no replication issues, but the Pub database more or less ended up RO)


HTH


Bill.

Correct Answer
Rob Huffman Thu, 10/11/2007 - 05:04
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Hi Wyandi,


Just to add a note to the good information you received from Zin,Ajaz and Bill, these docs have some possible solutions to this problem;


Unable to Cancel Call Forward All from an IP Phone


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


Cisco CallManager Issues with Call Forward All


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


Hope this helps!

Rob


sr2290723 Tue, 10/16/2007 - 18:23
User Badges:

Hi all,


Thanks for all precious information that you gave. Cisco Extended Function is active. I read Rob's document, and I found that the debug trace configuration of CCM service in publisher is set to detailed. As recommended, I tried to deactivate, delete the trace file, and reactivate the trace with debug set to error. Still no change. May be I'll try to restart CCM service and DBL service then.

Do you have phones that are active on the publisher?


What kind of changes were you making on the subscriber?


If your publisher is not working, your phones will not be able to forward/unforward, or do any other state changes for that matter.


Check to see if all services are running and then check your system logs to make sure that nothing crashed.

sr2290723 Sun, 10/21/2007 - 18:53
User Badges:

Dear all,


I tried to restart Cisco Database Layer Monitor service in every server, and everything goes back to normal 30 minutes after I restarted the service. Thanks all for your feedbacks and inputs. Those are really helpful.


Wiyandi

Dear All, I have very similar issue with Wiyandi at 9th Oct, my Publisher cannot update phone status, such as add another line to IP Phone, click "Reset", Phone did not response...Mobility could not work as well...But I did not try at Subscriber...I have to reboot Publisher and restart AuPair.exe service to resolve the issue...But Reported to Cisco TAC, SR 607053779, they still trying to find out root cause....I have been told could it be BARS version conflict with my recently upgraded to ccm4.1(3)Sr5b, my BARS version is 4.0.11?


Please help us, expert...

sr2290723 Sun, 10/21/2007 - 22:33
User Badges:

Hi,


The same problem happens to me twice. Extension Mobility could not work suddenly, and I have to reboot the publisher. It seems that there is something wrong with 4.1(3)SR5B. All this problem appear after I upgrade to SR5B. I'm using BARS 4.0.9.


Wiyandi

sr2290723 Mon, 10/22/2007 - 01:20
User Badges:

You're right. The replication job in SQL shows an error. But actually, the replication transaction is OK, because every change I do now is replicated in the other servers. May be I have missed that part when upgrading to SR5b, or Cisco doesn't state that part ?


Wiyandi


sr2290723 Mon, 10/22/2007 - 01:43
User Badges:

Hi,


By the way, where did you download BARS 4-0-14. I searched and only get BARS 4-0-13. Thanks.

hussam1984 Mon, 10/22/2007 - 00:21
User Badges:

Dear Wiyandi,


If you change for example phone extension on the publisher, does the subscriber take that change?



Hussam

Actions

This Discussion