cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1901
Views
0
Helpful
3
Comments
shalushar
Level 7
Level 7

 

 

Introduction

 

CUPC 7.x has issues connecting to the Presence Engine.  In the Client logs you will see a SIP 500 Internal Server Error in response to the initial SIP register message.

 

Error:- SIP 500 Internal Server Error

 

OR

 

Log files show
10/12/2010 11:25:56.160 ESP|PID(31894)
sip_find_user_registration_i():error accessing in memory db10/12/2010 11:25:56.160 ESP|
mod_sip_ttdb.cpp(537) check_return_code(): TimesTen ODBC Error 10/12/2010 11:25:56.160 ESP|[Tue Oct 12 11:25:56 2010] PID(31894)
mod_sip_ttdb.cpp(558) check_return_code(): *** [TimesTen][TimesTen
7.0.5.0.0 ODBC Driver][TimesTen]TT0907: Unique constraint (AOR) violated
at Rowid <0x00146608> -- file "ttree.c", lineno 4227, procedure
"sbTtInsert"

 

OR

 

Error:- Connection limited

 

 

 

Solution:-

 

Run the below CLI commands to remove records for a specific user:-
 
 
 

Step 1:-

Open an SSH/CLI connection to the presence server
 

Step 2:-

 

run pe sql ttreg delete from contact where fk_aorpkid like '%userID%' (please note that userID is case sensitive)

 


Step 3:-

 

run pe sql ttreg delete from registration where fk_aorpkid like '%userID%'  (please note that userID is case sensitive)

 

Step 4:-

 

run pe sql ttreg delete from aor where aorpkid like '%userID%' (please note that userID is case sensitive)

 

Example:-

 
Step 1:-
 
Admin: run pe sql ttreg delete from contact where fk_aorpkid like '%pharry%';
Step 2:-
 
Admin: run pe sql ttreg delete from registration where fk_aorpkid like '%pharry%';
Step 3:- 
 
 
Admin: run pe sql ttreg delete from aor where aorpkid like '%pharry%';

where pharry is the userid.

 

Related Links

 

CUPS Support for 7.x

Comments

Thank you !!!!

shalushar
Level 7
Level 7

Thanks Leonardo !

tikhonovoleg
Level 1
Level 1

And this is why we all hate CUPS.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: