Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

CUPC 7.x - SIP 500 Internal Server Error

 

 

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

Version history
Revision #:
2 of 2
Last update:
‎08-28-2017 12:15 AM
Updated by:
 
Contributors
Everyone's tags (3)
Comments

Thank you !!!!

Silver

Thanks Leonardo !

New Member

And this is why we all hate CUPS.