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. And see here for current known issues.

New Member

Service cannot be Activated or Deactivated due to Database Update Failure

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.

27 REPLIES
VIP Purple

Service cannot be Activated or Deactivated due to Database Updat

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

New Member

Service cannot be Activated or Deactivated due to Database Updat

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


VIP Purple

Service cannot be Activated or Deactivated due to Database Updat

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

New Member

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

Hi

Please review screen capture for DB reporting:

Thuc

VIP Purple

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

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.

  1. 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)
  2. 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.
  3. 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

New Member

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

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

VIP Purple

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

Hi Thuc,

Was this working setup ?

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

regds,

aman

New Member

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

Hi Aman,

I checked the license report:

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

Thuc

VIP Purple

Service cannot be Activated or Deactivated due to Database Updat

Hi Thuc,

Thanks for update.

Finally , u had to rebuild both the subscribers.

regds,

aman

New Member

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

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.

VIP Purple

Service cannot be Activated or Deactivated due to Database Updat

Hi Thuc,

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

regds,

aman

New Member

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

Hi,

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

Thuc

VIP Purple

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

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

VIP Purple

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

Hi Thuc,

Please provide the snapshot from

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

regds,

aman

New Member

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

Hi Aman,

Please review screen capture:

Thuc

VIP Purple

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

Hi Thuc,

How many subscriber servers u have in cluster ?

regds,

aman

New Member

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

Hi Aman

I have two subscriber servers (10.15.242.65/66) in my cluster. The Publisher is 10.15.242.64.

Thuc

VIP Purple

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

Hi Thuc,

The reason why I asked since the Subscriber hostnames have been SUB1 and SUB3 , SUB2 was missing.

regds,

aman

New Member

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

Hi Aman,

As I mentioned, I have two subscriber servers first(sub1 and sub2) and then I I shutdown  sub2 and install a new subscriber server(sub3) with same sub2's IP address. So, you just see sub1 and sub3.

Thuc

VIP Purple

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

Hi Thuc,

Now when u try to start CCM service on SUB3 , what is the message u are getting ? please share if any.

Any reason why u changed the hostname to SUB3 even though IP adddress is same.

regds,

aman

New Member

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

Hi Aman,

When I activate the services on sub3, the message displays : Update Operation Successful

None of reason for changing hostname. Just for test.

Thuc

VIP Purple

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

Hi Thuc,

Can u try restarting the SUB3 server and check whether CCM service is starting or not?

regds,

aman

New Member

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

Hi Aman

After I restart Sub3, the CCM service is still started properly.

Thuc

VIP Purple

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

Hi Thuc,

Did not understand, is CCM service working now after restarting SUB3 server?

regds,

aman

New Member

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

Hi Aman,

No. I mean that CCM service in Sub3 is working, not working with Sub1.

Regards,

Thuc

New Member

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

Hi Aman,

A good news ! Now I can activate all services in Sub1. I checked network configuration in Publisher server and Sub1 and see that: DNS is not enable in Publisher server but it is set in Sub1. I removed DNS configuration from Sub1 and run Utils dbreplicate reset all. Then, I restart Sub1. Now DB replication status is 2 for all servers.

I wonder how to debug this issue? I just guess and check again and again. That is not good way. Could you share your experience with me?

Regards,

Thuc

VIP Purple

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

Hi Thuc,

What I can say is that if u enable DNS on one server in a cluster and not on others, the IP phones won't register because of  hostanem to IP address or vice versa resolution.

Either u disable on all servers or enable on servers. Also, have u configured hostname in CUCM or IP addresses.

Do u have DNS in setup?

regds,

aman

683
Views
8
Helpful
27
Replies