<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1">
<TITLE>Re: [cisco-voip] CDR flat files not being deleted</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText81350 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hi,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>I'm not sure how to look at it: could it be
CCMCDR sp_unprepare;1 ?</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Ruben</FONT></DIV>
<DIV dir=ltr>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B>De:</B> Ryan Ratliff
[mailto:rratliff@cisco.com]<BR><B>Enviado el:</B> mié 02/08/2006
14:40<BR><B>Para:</B> Ruben Montes (EU)<BR><B>CC:</B>
cisco-voip@puck.nether.net<BR><B>Asunto:</B> Re: [cisco-voip] CDR flat files not
being deleted<BR></FONT><BR></DIV></DIV>
<DIV>
<P><FONT size=2>Looks like you are right on. What process is pid 80
for? The only <BR>other things that should be accessing CDR are
CDRInsert, Aupair, and <BR>SQL EM. Anything else is most likely the
CIPT job.<BR><BR>-Ryan<BR><BR>On Aug 2, 2006, at 4:14 AM, Ruben Montes ((EU))
wrote:<BR><BR>Hi Ryan,<BR><BR>you are right with your description of the
problem: CIPT Optimization <BR>is still running since the day I am having
the eventviewer error. To <BR>manually kill the pid for this job, this only
affects the CDR, am I <BR>right? As the CDR is not yet being used, I assume
I can do what you <BR>suggest without impacting the other jobs in the
database, right?<BR><BR>I think the pid for the job that is causing problems is
80, that is <BR>blocking pid 62 and pid 62 is blocking some other jobs. Is
pid 80 the <BR>CIPT optimization?<BR><BR>I have only used Enterprise
Manager to validate that the replication <BR>between Pub and Sub is ok and
running, so all this stuff is new for <BR>me...<BR><BR>By the way, we're
running CCM 4.1(3)SR3A: should this problem be <BR>fixed in this
version?<BR><BR>Thanks in advance,<BR><BR>Ruben<BR><BR>De: Ryan Ratliff [<A
href="mailto:rratliff@cisco.com">mailto:rratliff@cisco.com</A>]<BR>Enviado el:
mar 01/08/2006 15:08<BR>Para: Ruben Montes (EU)<BR>CC:
cisco-voip@puck.nether.net<BR>Asunto: Re: [cisco-voip] CDR flat files not being
deleted<BR><BR>Most likely you are running into an issue with sql
deadlock.<BR><BR>There are a couple bugs out there, CSCsd95330 being one of
them.<BR><BR>Basically Aupair and the CIPT Optimize SQL job get into a deadlock
on<BR>the CDR database. Aupair is trying to remove old records to
bring<BR>the number of CDR records down to the max (1.5 million by
default)<BR>and the CIPT Optimize job is doing it's thing. This deadlock
keeps<BR>CDRInsert from inserting new records.<BR><BR>If you look in SQL
Enterprise Manager under Management->SQL Server<BR>Agent->Jobs the CIPT
Optimizations job will still be running. A<BR>quick check of the history
shows it normally only runs for a few<BR>minutes. Manually killing the pid
in SQL for the job will recover<BR>everything and once Aupair finishes it's
thing CDRInsert will run<BR>normally.<BR><BR>If you are at all unsure about
doing this please open a TAC SR and<BR>unicast me the SR
number.<BR><BR>-Ryan<BR><BR>On Aug 1, 2006, at 9:01 AM, Ruben Montes ((EU))
wrote:<BR><BR>Hi,<BR><BR>I've tried to restart the CDRInsert and I've had this
"nice" message:<BR><BR>No response to restart the server<BR><BR>I supoose it's
time to open a TAC SR??<BR><BR>Regards,<BR><BR>Ruben<BR><BR><BR>-----Mensaje
original-----<BR>De: Ryan Ratliff [<A
href="mailto:rratliff@cisco.com">mailto:rratliff@cisco.com</A>]<BR>Enviado el:
mar 01/08/2006 14:37<BR>Para: Ruben Montes (EU)<BR>CC:
cisco-voip@puck.nether.net<BR>Asunto: Re: [cisco-voip] CDR flat files not being
deleted<BR><BR>Is the CDRInsert service running on your publisher? If so
try<BR>restarting it. If it is slow to restart (or fails to stop at
all)<BR>then it could be that some database activity has blocked
CDRInsert.<BR><BR>You can use the command sp_who2 to find out which sql pid has
locked<BR>the CDR database. If you get to that point and need
assistance<BR>still please open a TAC SR.<BR><BR>-Ryan<BR><BR>On Aug 1, 2006, at
6:11 AM, Ruben Montes ((EU)) wrote:<BR><BR>Hi,<BR><BR>I'm having some trouble
with CDR service. I've noticed that the last<BR>three weeks I have an
Eventviewer error every night telling that the<BR>CDR files are being backed up
and not deleted.<BR>Nothing has been changed and this has never happened before.
What<BR>could have happened?<BR>I have enabled detailed traces but
traces/DBL/DCRinsert files are<BR>empty (0Kb)<BR><BR>Thanks in
advance,<BR><BR>Ruben<BR>_______________________________________________<BR>cisco-voip
mailing list<BR>cisco-voip@puck.nether.net<BR><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR><BR><BR><BR><BR><BR><BR></FONT></P></DIV>
</BODY>
</HTML>