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