Guest

Cisco Unity Connection

Unity Connection User is Not Available When You Import from LDAP

Document ID: 117737

Updated: Jun 20, 2014

Contributed by Scott Hills, Cisco TAC Engineer.

   Print

Introduction

This document describes an issue encountered when you integrate Cisco Unity Connection with Active Directory to be able to import users from Lightweight Directory Access Protocol (LDAP) and offers a solution to the problem.

Problem

When you attempt to import a user via LDAP in Unity Connection, the user does not show as available for import. The user does not show as an existing user when you run a user search in the GUI.  In this case, there is a stale entry in a table about this user that prevents it from being imported.

This document provides examples of searches for User: cisco test and for Userid: ciscotest.

Steps to Troubleshoot

  1. Verify that the user is not available when you try to import from LDAP.

  2. Verify that the user is on the LDAP server.

  3. Navigate to the users page on Unity Connection and search for the user in order to verify that users are not already present on Unity Connection.

  4. Check if the user is available in EndUser table with this Structured Query Language (SQL) query:

    admin:run sql SELECT pkid, firstname, lastname, userid, telephonenumber
    FROM EndUser u WHERE userid='ciscotest'

    pkid                                 firstname lastname userid    telephonenumber
    ==================================== ========= ======== ========= ===============
    e88525ef-ebce-4af1-bddb-ef58c8389700 Cisco     Test      ciscotest (444)555-6666


  5. Verify that the same user is not available in tbl_user:

    admin:run cuc dbquery unitydirdb select * from tbl_user where ldapccmpkid=
    'e88525ef-ebce-4af1-bddb-ef58c8389700'

    No records found
    2011-09-21 15:07:28,383 ERROR [ClassExecutionThread] cli.CucUtils -
    Results array is empty!


  6. Check the enduserappservermap table for the same user. Take the pkid from Step 4 and use it as fkenduser.

    admin:run sql select * from enduserappservermap where fkenduser=
    'e88525ef-ebce-4af1-bddb-ef58c8389700'
    pkid                                 fkenduser
    fkappserver                          content
    ==================================== ====================================
    ====================================
    3725fca8-1b99-47cb-96f0-fd5641d13753 e88525ef-ebce-4af1-bddb-ef58c8389700
    cd183532-15c3-4065-bd09-30991cf1bd1c b99b4440-1c64-4c30-9dee-3c8bd8808448
    cbd62377-9a2a-4a8e-8685-220ba0af747d e88525ef-ebce-4af1-bddb-ef58c8389700
    cd183532-15c3-4065-bd09-30991cf1bd1c b99b4440-1c64-4c30-9dee-3c8bd8808448


    There are two records in this table. There should not be any records in order to make this user available for import. You must delete these records.

    Before you delete the records, make sure that no entry is present in the Unity Connection tables.

  7. Take the content from the enduserappservermap table and use it as the objectid in these queries. All must return empty results.

    admin:run cuc dbquery unitydirdb select * from tbl_globaluser where objectid=
    'b99b4440-1c64-4c30-9dee-3c8bd8808448'

    No records found
    2011-09-21 15:12:37, 866 ERROR [ClassExecutionThread] cli.CucUtils -
    Results array is empty!

    admin:run cuc dbquery unitydirdb select * from tbl_user where ldapccmuserid=
    'ciscotest'

    No records found
    2011-09-21 15:09:13, 195 ERROR [ClassExecutionThread] cli.CucUtils -
    Results array is empty!

    admin:run cuc dbquery unitydirdb select * from tbl_user where objectid=
    'b99b4440-1c64-4c30-9dee-3c8bd8808448'

    No records found
    2011-09-21 15:12:49, 213 ERROR [ClassExecutionThread] cli.CucUtils -
    Results array is empty!

Solution

Delete the entries from enduser servermap table so that the user can be imported from the GUI.

admin:run sql delete from enduserappservermap where fkenduser=
'e88525ef-ebce-4af1-bddb-ef58c8389700'

Related Information

Updated: Jun 20, 2014
Document ID: 117737