[cisco-voip] URGENT - Error in Unity connection "Unable tocommunicate with service control center"

[ROZA, Ariel]

Guys,

 

In case someone else falls into this, we solved this with a TAC case.

 

This is a description of the problem and how it was solved:

 

++ Action Plan for the Web/page problem ++

 

The key is to get the objectid of the affected account

 

run cuc dbquery unitydirdb select alias, displayname, objectid  from vw_user where alias ='<administrator username alias>'

7f6374ac-886f-401d-bd97-512cedba0285

 

run cuc dbquery unitydirdb select objectid, userobjectid, credentialtype, encryptiontype from tbl_credential where userobjectid = "7f6374ac-886f-401d-bd97-512cedba0285"

 

The troubleshooting document ´s SQL query was incomplete, missing the WHERE clause

  

objectid                              userobjectid                          credentialtype  encryptiontype

------------------------------------  ------------------------------------  --------------  --------------

7f6374ac-886f-401d-bd97-512cedba0285  bfa942e2-4ac8-44ab-9823-91dda12fbbac  3         3

01121181-aae6-4cbe-91b6-f41cfba130fb  bfa942e2-4ac8-44ab-9823-91dda12fbbac    4         4

 

Once you hace the objectid, you can update the encryptiontype table row with the correct value

 

run cuc dbquery unitydirdb update tbl_credential set encryptiontype = "4" where objectid ="f431174d-106e-4ac3-b9f1-53d06b319af1"

 

Hope this helps someone in the future.

 

Regards,

 

Ariel.

 

From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of ROZA, Ariel
Sent: miércoles, 20 de julio de 2011 03:49 p.m.
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] URGENT - Error in Unity connection "Unable tocommunicate with service control center"

 

Guys,

 

A coworker upgraded a Unity Connection server from v. 2.x to v 8.7, and is having problems. Unity does not record the voicemails in the user´s mailbox, and when he tries to log on to the Service Control Center he gets the error "Unable to communicate with service control center. The password for administrator (the administration account that was created during installation) may be locked out or expired."

 

The troubleshooting guide hast the following solution, but it seems incomplete:

 

Error: Unable to communicate with service control center

When logging in to the Serviceability page, this error message is received:

Unable to communicate with service control center. The password for appadministrator (the administration account that was created during installation) may be locked out or expired.

Solution

The cause of this error is that the value of encryptiontype in tbl_credential for the appadministrator is set to 3 instead of 4. Complete these steps in order to make it as a valid application user:

1.     In order to verify that the encryption type should not be 3 for the appadministrator user, run this command: run cuc dbquery unitydirdb select encryptiontype,objectid from tbl_credential

2.     In order to change this value to 4, issue this command: run cuc dbquery unitydirdb update tbl_credential set encryptiontype = "4" where objectid = "e875ec01-c090-475d-b7d2-af3be863eedd".

where Objectid is the ID obtained from the above step.

3.     Reset the password with this command: utils cuc reset password appadministrator

4.     Restart the Cisco Tomcat service.

The first step seems incomplete, as it has no WHERE clause to select the individual record of the administrator user. (It returns a full table with the encryptiontype of all the users defined, instead of one record) and I am not familiar with the database schema to complete the missing parts

Has anyone ran into a situation like this?

Thanks,

Ariel.

 

 

 

 

 

ARIEL ROZA
Advanced Engineering

 

LOGICALIS
Perú 327 1er Piso - C.A.B.A. - Argentina - C1067AAG
Tel/Fax: +54 (11) 4344-0300
ariel.roza at la.logicalis.com
www.la.logicalis.com
www.logicalisnow.com

	Por favor, piense en el medioambiente antes de imprimir este email. 
La presente información se envía únicamente para el destinatario, y contiene información de carácter CONFIDENCIAL o PRIVLEGIADA.
La modificación, retransmisión, difusón, copia u otro uso de esta información por cualquier medio, por personas distintas al destinatario, están estrictamente prohibidas.

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110722/463656fa/attachment.html>