Guest

Cisco Unity Connection

Unity Connection Digital Networking Node Error: Failed calling csp_PartitionDeleted

Document ID: 117573

Updated: Apr 09, 2014

Contributed by Scott Hills, Cisco TAC Engineer.

   Print

Introduction

This document describes a problem encountered in Cisco Unity Connection (CUC) when you set up a Digital Networking Node, and provides possible solutions to the problem.

Prerequisites

Requirements

There are no specific requirements for this document.

Background Information

Digital Networking allows objects to replicate between members of networking cluster. These objects are not limited to users and partitions. You must delete objects from the home server on which it was created. After you delete and replicate the changes to other servers in the networking cluster, the object must be purged throughout. However, there are times when an unexpected event takes place and a user is not purged out completely.

Problem

When you set up a Digital Networking Node, and it displays a Failed calling csp_PartitionDeleted notification on one of the cluster nodes.

Log Analysis

Machine Name: testbox>
Severity: Error
App ID: CuReplicator
Message: : 1038: testbox.cisco.net: Feb 10 2014 01:47:54.846 UTC :
UC_UCEVNT-3-EvtReplicatorFailedDatabaseRead %[ClusterID=][NodeID=testbox]:
Database unitydirdb access error: Failed calling csp_PartitionDelete.
(ObjectId= 801a0879-4036-455d-9948-910793d30fb4). TECHNICAL DETAILS:
java.sql.SQLException:
Key value for constraint (informix.pk_tbl_partition) is still being referenced.

Log analysis shows that the partition has been removed successfully from the home server. A networking cluster member reports an error in syslog, and it includes a stale that attempts a deletion in the partition.

At some point, a user is deleted. However, the issue is encountered when it is not completely purged from the Networking Cluster Member, and this causes an issue to remove the partition.

Solution

In this issue, we see that the object ID (801a0879-4036-455d-9948-910793d30fb4) for the partition cannot be removed.

Complete these steps in order to resolve this issue:

  1. Enter this command in order to obtain the name of the partition that is mentioned in the error:
    admin:run cuc dbquery unitydirdb SELECT * from
    tbl_partition WHERE ObjectId = ''

    Note: You must know the object ID before you run this command.

    Example:

    admin:run cuc dbquery unitydirdb SELECT * from tbl_partition
    WHERE ObjectId = '801a0879-4036-455d-9948-910793d30fb4'objectid name description locationobjectid------------------------------------ ------------- ----------- ------------------------------------801a0879-4036-455d-9948-910793d30fb4 test partition 8574527c-01b7-4def-8ab4-7047120a577f
  2. Navigate to Cisco Unity Connection (CUC) administration webpage where you have the report message.

    Under Search Limits, choose Partition in the Limit search to drop down list, and select Partition returned in the Where Name Is drop down list.

  3. Enter this command in order to obtain the object ID for the alias you received from a user page:
    admin:run cuc dbquery unitydirdb
    SELECT objectid ,alias from tbl_Globaluser WHERE Alias = ''

    Note: You must enter the Alias you obtained from the previous command.

    Example:

    admin:run cuc dbquery unitydirdb
    SELECT objectid ,alias from tbl_Globaluser WHERE Alias = 'test1' objectid------------------------------------------------------f9653977-df35-43ad-8cc7-8a6252e58d70
  4. Enter this command in order to delete a user:
    admin:run cuc dbqery unitydirdb execute procedure
    csp_globaluserdelete(pobjectid='')

    Note: You must enter the object ID you obtained from the previous command in step 3.

    Example:

    admin:run cuc dbquery unitydirdb execute procedure
    csp_globaluserdelete(pobjectid = 'f9653977-df35-43ad-8cc7-8a6252e58d70')

    After you remove a user that was in the partition, run the csp_PartitionDelete command and remove the partition.

Updated: Apr 09, 2014
Document ID: 117573