While you make updates to the Cisco Unified Communications Manager
5.x/6.x, the update fails with the Update Failed
error message. This document discusses how to troubleshoot this issue.
There are no specific requirements for this document.
The information in this document is based on the Cisco Unified
Communications Manager 5.x/6.x.
The information in this document was created from the devices in a
specific lab environment. All of the devices used in this document started with
a cleared (default) configuration. If your network is live, make sure that you
understand the potential impact of any command.
Technical Tips Conventions for more information on document
An existing IP phone is replaced by a new one. In the Cisco Unified
Communications Manager 6.x configuration, when you try to replace the MAC
address with the new IP phone MAC address, the update fails. After you click
OK for the changes to take effect, the web page reloads with a
large red X in the Status field, and this error message appears:
Update failed. Could not update a row in the table.
This issue can occur when there is a duplicate entry for the new MAC
address in the Cisco Unified Communications Manager configuration. In order to
resolve the issue, you need to remove the unnecessary duplicate MAC
If you receive this error when you edit extensions with BAT, make sure
you delete the rows that do not have any information.
When you attempt to make an update to any of the Cisco Unified
Communications Manager 5.x nodes with CCMAdministration, this error returns:
Update failed. java.sql.SQLException: No UPDATE
permission. This occurs after the creation of a new pilot point
for the Attendant Console (AC), which can cause the publisher to become
unresponsive. Additionally, this can occur after the AC has run for some time.
This problem potentially does not appear in RTMT, but it shows in logs. These
errors appear in the CCM.log:
listener-thread: err = -25580: oserr = -1: errstr = : System error occurred in
This issue is documented by Cisco Bug ID
(registered customers only)
The workaround is to disable the AC services and reboot the server.
Any one of these error messages appear when you try to make any changes
or updates to any of the Cisco Unified Communications Manager 5.x nodes through
This issue occurs because the database is in read only mode.
Excute this command in a CLI prompt of the publisher in order to
resolve the issue:
run sql execute procedure
When you try to copy an existent Directory Number (DN) to a new DN,
this error message is returned:
Add failed. java.sql.SQLException: Character to numeric conversion error
This error message occurs if you attempt to add a range of Directory
Numbers (DNs) over existent DNs.
Before you copy the DN, make sure that the destination DN (or range of
DNs) has not been previously stored on the Cisco Unified Communications
Manager. Check the list of DNs that have been used under Call
Routing > Route Plan Report.
When you attempt to change the user password and pin from the Cisco
Unified Communications Manager user page, this error message appears:
Update failed. Missing key in referenced table for referential constraint
This error message occurs if these three parameters are set under the
Cisco Unified Communications Manager User page:
System > Enterprise Parameter
> CCMUser parameters > Show Locale for Web Pages
Settings is set to False
CCMUser > User options >
User settings > User locale is set to
NOT AN OPTION
User Management > End User >
End User Configuration is set to
This issue is documented in Cisco bug ID
(registered customers only)
In order to resolve this issue, complete these steps:
In the Cisco Unified Communications Manager Administartion Page,
choose System > Enterprise Parameter >
CCMUser parameters > Show Locale for Web Pages
Settings and set it to
login with the user ID. Choose User options > User
settings > User locale and set this to
Go to User Management > End User
> End User Configuration and set this to