×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

CUCM 8.0 - Problem with the database

Unanswered Question
Dec 6th, 2013
User Badges:

Hi


I have a problem with the database of our CallManager 8.0.3.22900-5.


I remember that in previous version, there was DbWalker to help correct this problem with my current version is there an application that would help me ?


I have the distinct impression that we have a problème with delimiter fields.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Chris Deren Fri, 12/06/2013 - 12:25
User Badges:
  • Super Silver, 17500 points or more
  • Hall of Fame,
  • Cisco Designated VIP,

    2017 IP Telephony, Contact Center, Unified Communications

There are dbreplication commands on CLI and your can check the status from RTMT and Unfied Reporting, here is good doc on appliance based CUCM dbreplication:


https://supportforums.cisco.com/docs/DOC-13672



HTH,


Chris

Murali Dharan Sun, 12/08/2013 - 15:01
User Badges:

"utils dbreplication runtimestate" will run and will provide you the exact DB status with all SUBs. If you see other than "2" in relication DB status then you have DB problem.



-Murali

Dany Fortin Mon, 12/16/2013 - 05:41
User Badges:

When I ran "utils dbreplication runtimestate", I had a status "2" for DB replication status.


admin:utils dbreplication runtimestate


DB and Replication Services: ALL RUNNING


Cluster Replication State: BROADCAST SYNC Completed on 2 servers at: 2012-11-20-19-51
     Last Sync Result: SYNC COMPLETED  519 tables sync'ed out of 519
     Sync Errors: 1 Errors or failures were found
     Use this command to see the output - file view

                                                                  activelog /cm/trace/dbl/2012_11_20_19_50_09_dbl_repl_cdr_Broadcast.log


DB Version: ccm8_0_3_22900_5
Number of replicated tables: 519


Cluster Detailed View from PUB (3 Servers):


                                                  PING             REPLICATION REPL.   DBver&  REPL.   REPLICATION SETUP
SERVER-NAME  IP ADDRESS   (msec) RPC?  STATUS          QUEUE TABLES  LOOP?   (RTMT) & details
-----------     ------------    ------  ----    -----------     -----   ------- -----   -----------------
pubccm01           ###.##.##.##    0.031   Yes     Connected        0           match   N/A     (2) PUB Setup Completed
subccm02           ###.##.##.##    0.181   Yes     Connected        0           match   N/A     (2) Setup Completed
subccm01          ###.##.##.##     4.17     Yes     Connected        0           match   N/A     (2) Setup Completed

Dany Fortin Mon, 12/16/2013 - 06:00
User Badges:

And in the file /cm/trace/dbl/2012_11_20_19_50_09_dbl_repl_cdr_Broadcast.log


I have

Setting Partial - numcommand failed -- Template is already realized

Dany Fortin Mon, 12/16/2013 - 10:22
User Badges:

admin:show perf query class "Number of Replicates Created and State of Replication"
==>query class :

- Perf class (Number of Replicates Created and State of Replication) has instances and values:
    ReplicateCount  -> Number of Replicates Created   = 519
    ReplicateCount  -> Replicate_State                = 2

Nadeem Ahmed Mon, 12/16/2013 - 10:25
User Badges:
  • Cisco Employee,

Dany,


Everything is fine from database prospecitve looks ok.


What's exactly the issue you are facing or trying to get ?



Br,
Nadeem 

Please rate all useful post.

Dennis Mink Sun, 12/08/2013 - 16:35
User Badges:
  • Blue, 1500 points or more

What exactly is your issue?




=============================
Please remember to rate useful posts, by clicking on the stars below. 

=============================

Nadeem Ahmed Mon, 12/16/2013 - 07:31
User Badges:
  • Cisco Employee,

Hello Dany,


Dbwalker used in Cisco Unity not for CUCM for any database issue in CUCM, you have to follow the procedure as said by Chris and Jamie in this thread.



"The Cisco Unity Directory Walker (DbWalker)  utility checks each call handler, subscriber, subscriber template,  interview handler, location object, and directory object in the  Cisco Unity database for missing values, broken links, and other  problems. DbWalker must be run on the Cisco Unity server"





Br,
Nadeem 

Please rate all useful post.

Aman Soi Mon, 12/16/2013 - 08:31
User Badges:
  • Purple, 4500 points or more
  • Cisco Designated VIP,

    2017 IP Telephony

Hi Dany,


your replication seems to be good since the value is 2.


Hard to say about the error u are getting .Suggest opening TAC case .


Hi Nadeem,


I remember using DBWalker is also used in Call Manager 4.x.


regds,

aman

Aman Soi Mon, 12/16/2013 - 09:02
User Badges:
  • Purple, 4500 points or more
  • Cisco Designated VIP,

    2017 IP Telephony

Hi Nadeem,


My mistake....


It is DBHelper which is used in CUCM  not DBWalker.


regds,

aman

Dany Fortin Mon, 12/16/2013 - 11:41
User Badges:

When I want to delete a Voice Mail Profile that is no longer used. It does not remove himself. If I look at the Dependency, the system gives me 13 Device template and 20 Directory Numbers.


If I explode 20 Directory Number Dependency, I get a strange result.

Actions

This Discussion