Re: Service cannot be Activated or Deactivated due to Database U

Nguyen KeThuc · ‎07-01-2013

Hi all,

I am using CUCM version 7.1. After I install subscribers, I can not start any services in Sevice Activation page. The publisher is ok. Error message:

"...Service cannot be Activated or Deactivated due to Database Update Failure".

Any ideas for me.

Aman Soi · ‎07-01-2013

Hi Thuc,

What is the exact CUCM version u are using?

can u share the output of utils dbreplication runtimestate or from Cisco Unified Reporting , shgare DB status report?

regds,

aman

Nguyen KeThuc · ‎07-01-2013

Hi,

I am using version 7.0.2.10000-18. Out put of utils dbreplicate status:

admin:utils re

utils remote_account

utils reset_ui_administrator_name

utils reset_ui_administrator_password

admin:utils db

admin:utils dbreplication

utils dbreplication clusterreset

utils dbreplication dropadmindb

utils dbreplication forcedatasyncsub

utils dbreplication repair

utils dbreplication reset

utils dbreplication setrepltimeout

utils dbreplication status

utils dbreplication stop

admin:utils dbreplication st

utils dbreplication status

utils dbreplication stop

admin:utils dbreplication stat

admin:utils dbreplication status

****************************************************************************************************

This command reads and writes database information from all machines and will take quite some time...please be patient.

****************************************************************************************************

-------------------- utils dbreplication status --------------------

Output is in file cm/trace/dbl/sdi/ReplicationStatus.2013_07_02_11_05_56.out

Please use "file view activelog cm/trace/dbl/sdi/ReplicationStatus.2013_07_02_11_05_56.out " command to see the output

admin:file view activelog cm/trace/dbl/sdi/ReplicationStatus.2013_07_02_11_05_56.out

connect to cucmsub1_ccm7_0_2_10000_18 failed

Enterprise Replication not active (62)

command failed -- unable to connect to server specified (5)

-------------------------------------------------

No Errors or Mismatches found.

Replication status is good on all available servers.

utils dbreplication status output

To determine if replication is suspect, look for the following:

(1) Number of rows in a table do not match on all nodes.

(2) Non-zero values occur in any of the other output columns for a table

connect to syscdr@cucmsub1_ccm7_0_2_10000_18 failed

Enterprise Replication not active (62)

command failed -- unable to connect to server specified (5)

Error Details:

options: q=quit, n=next, p=prev, b=begin, e=end (lines 1 - 20 of 32) :

admin:

Thuc

Aman Soi · ‎07-01-2013

Hi Thuc,

Please refer the link for resolving DBReplication problem.Was this working earlier or faced the replication problem now

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

From Cisco Unified Reporting , can u share the snapshot of CM Database Status report.

regds,

aman

Nguyen KeThuc · ‎07-01-2013

Hi

Please review screen capture for DB reporting:

Thuc

Aman Soi · ‎07-01-2013

Hi Thuc,

It seems that you have three servers in a cluster out of which two Subscribers are facing the issue of DBReplication.

Can u try the commands to fix the issue.

utils dbreplication stop on all subscribers. This command can be run on all subscribers at the same time but needs to complete on all subscribers prior to being run on the publisher. The amount of time this command takes to return is based on your cluster's repltimeout. This can be seen through the Command show tech repltimeout and by default is 300 seconds or 5 minutes. At the end of this document I will provide a calculation for determining what you should set your repltimeout (via utils dbreplication setrepltimeout) in your cluster and how this value affects replication. (If utils dbreplication stop all is available (7.X and later) then step 1 and step 2 can be accomplished in this one command)
utils dbreplication stop on publisher. Again this command can be done through the utils dbreplication stop all if available. This also will wait the repltimeout as said above.
utils dbreplication reset all - This command will take an hour to complete or longer depending on your cluster. You can monitor the status through the utils dbreplication runtimestate or through the procedure following the examples portion of this document.

You won't be able to use utils dbreplication rumtimestate. So, use Cisco unified reporting tool to check the Count.It should be 2 if replication is fine.[Expand View details]

regds,

aman

Nguyen KeThuc · ‎07-01-2013

Hi Aman,

Thanks for help.

I tried to fix DB replication issue. But I still can not activate any services.

admin:utils dbreplication status

****************************************************************************************************

This command reads and writes database information from all machines and will take quite some time...please be patient.

****************************************************************************************************

-------------------- utils dbreplication status --------------------

Output is in file cm/trace/dbl/sdi/ReplicationStatus.2013_07_02_12_36_13.out

Please use "file view activelog cm/trace/dbl/sdi/ReplicationStatus.2013_07_02_12_36_13.out " command to see the output

admin:file view activelog cm/trace/dbl/sdi/ReplicationStatus.2013_07_02_12_36_13.out

SERVER ID STATE STATUS QUEUE CONNECTION CHANGED

-----------------------------------------------------------------------

g_cucmpub_ccm7_0_2_10000_18 2 Active Local 0

g_cucmsub1_ccm7_0_2_10000_18 3 Active Connected 0 Jul 2 11:32:03

-------------------------------------------------

No Errors or Mismatches found.

Replication status is good on all available servers.

utils dbreplication status output

To determine if replication is suspect, look for the following:

(1) Number of rows in a table do not match on all nodes.

(2) Non-zero values occur in any of the other output columns for a table

command failed -- undefined replicateset (11)

Error Details:

The specified replicate name does not exist.

options: q=quit, n=next, p=prev, b=begin, e=end (lines 1 - 20 of 26) :

admin:

I also resintalled one subscriber with same IP address and Hostname. It is working fine. The other one is kept troubleshooting.

How about the log file to diagnose the activation issue? Could you suggest for me?

Tha

Aman Soi · ‎07-01-2013

Hi Thuc,

Was this working setup ?

Hope u have enough Node Licenses on Call manager and u have added SUb2 in Pub.

regds,

aman

Nguyen KeThuc · ‎07-01-2013

Hi Aman,

I checked the license report:

With rebuilded subscriber server, now I can activate the services.

Thuc

Aman Soi · ‎07-02-2013

Hi Thuc,

Thanks for update.

Finally , u had to rebuild both the subscribers.

regds,

aman

Nguyen KeThuc · ‎07-02-2013

Hi Aman,

So, I want to find why I can not activate the services. Could you suggest me for log trace or debug or something like that?

Thuc.

Aman Soi · ‎07-02-2013

Hi Thuc,

Now, since u have re-installed SUB, u won't be able to get the logs.

regds,

aman

Nguyen KeThuc · ‎07-02-2013

Hi,

I just rebuilded one subscriber server. The other is still there. We can get the log files if we want.

Thuc

Aman Soi · ‎07-02-2013

Hi Thuc,

I thought u have rebuilt the second SUB as well.

Please follow the link to enable traces.

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

regds,

aman

Aman Soi · ‎07-02-2013

Hi Thuc,

Please provide the snapshot from

Cisco unified reporting tool -> Database Status -> Replication Server List

regds,

aman