cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
825
Views
5
Helpful
3
Replies

Unity Conx 8.5 User re-import

Hi

We had installed Cisco Unity Conx 8.5, configured AXL user in CUCM8.5 which is integrated with AD, and imported the users say, mary.jacob and samir.doda. Everything looked fine.

After some time, we had some issues with HA and had to rebuild the Unity Conx cluster from scratch. Now again we integrated Unity Conx with CUCM8.5, created new AXL User and tried to reimport users may.jacob and samir.doda and it failed to find these users. We see that all other users are available for import EXCEPT those users which were imported previously in the old cluster of Unity Conx.

Is this the normal behaviour? How can I reimport the users mary.jacob and samir.doda?

Because Unity conx cluster is fresh, I believe that we need to do something on the callmanager side. Any guess?

1 Accepted Solution

Accepted Solutions

Brad Magnani
Cisco Employee
Cisco Employee

Hi,

There is actually a database mapping on the CUCM server that tags these users as beloning to a particular application server (in this case, UC).  These don't get "un-tagged" unless the users are properly deleted.  You can either open a case with TAC and we can take a look, or you can connect to the CUCM CLI and run the queries below to do it yourself if you feel comfortable:

The mapping needs to be removed on the CUCM side. These are the steps to do it. You will need CLI access to the CUCM server.

1) For each user, find the mapping row:

run sql select pkid from enduserappservermap where fkenduser in (select pkid from enduser where userid = 'my_user_alias') and fkappserver in (select pkid from appserver where ipaddr = 'my_connection_server_ip')

In the query above, replace my_user_alias with the alias of the end user and replace my_connection_server_ip with the IP address of the Connection server.

2) Delete the mapping row:

You should only get back one row. Replace my_pkid with the actual pkid that you got back:

run sql delete from enduserappservermap where pkid = ''my_pkid'

Hope that helps,

Brad

View solution in original post

3 Replies 3

Brad Magnani
Cisco Employee
Cisco Employee

Hi,

There is actually a database mapping on the CUCM server that tags these users as beloning to a particular application server (in this case, UC).  These don't get "un-tagged" unless the users are properly deleted.  You can either open a case with TAC and we can take a look, or you can connect to the CUCM CLI and run the queries below to do it yourself if you feel comfortable:

The mapping needs to be removed on the CUCM side. These are the steps to do it. You will need CLI access to the CUCM server.

1) For each user, find the mapping row:

run sql select pkid from enduserappservermap where fkenduser in (select pkid from enduser where userid = 'my_user_alias') and fkappserver in (select pkid from appserver where ipaddr = 'my_connection_server_ip')

In the query above, replace my_user_alias with the alias of the end user and replace my_connection_server_ip with the IP address of the Connection server.

2) Delete the mapping row:

You should only get back one row. Replace my_pkid with the actual pkid that you got back:

run sql delete from enduserappservermap where pkid = ''my_pkid'

Hope that helps,

Brad

Thanks Brad,

It works like a champ.

I pray that Cisco ever put all these in some sort of documentation.

-Saif

Great, glad it worked for you