Call Manager publisher database problem

Answered Question
Oct 10th, 2007

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

I have this problem too.
0 votes
Correct Answer by rob.huffman about 9 years 2 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

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

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

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

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

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

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

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

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

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

Dear Wiyandi,

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

Hussam

Actions

This Discussion