<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=idOWAReplyText5192 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Thanks,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>the program name is CDRInsert Module...
Shoul I kill this process? I have also PID 83 as CDRInser module...</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>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>De:</B> Ryan Ratliff
[mailto:rratliff@cisco.com]<BR><B>Enviado el:</B> mié 02/08/2006
14:57<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>
<P><FONT size=2>In SQL EM go to Tools->SQL Query Analyzer (or under
Start-<BR> >Programs). Login to the local server with Windows
authentication. <BR>Then just type sp_who2 in the query box and
execute.<BR><BR>-Ryan<BR><BR>On Aug 2, 2006, at 8:55 AM, Ruben Montes ((EU))
wrote:<BR><BR>Hi Ryan,<BR><BR>how and where do I execute this command? I'm a
complete SQL dummie...<BR><BR>Thanks,<BR><BR>Ruben<BR><BR>De: Ryan Ratliff [<A
href="mailto:rratliff@cisco.com">mailto:rratliff@cisco.com</A>]<BR>Enviado el:
mié 02/08/2006 14:51<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>One of the columns in the output of the sp_who2 will be the
program<BR>name. Should be just before SPID.<BR><BR>-Ryan<BR><BR>On Aug 2,
2006, at 8:46 AM, Ruben Montes ((EU)) wrote:<BR><BR>Hi,<BR><BR>I'm not sure how
to look at it: could it be CCMCDR sp_unprepare;1
?<BR><BR>Regards,<BR><BR>Ruben<BR>De: Ryan Ratliff [<A
href="mailto:rratliff@cisco.com">mailto:rratliff@cisco.com</A>]<BR>Enviado el:
mié 02/08/2006 14:40<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>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><BR><BR><BR><BR></FONT></P></DIV>
</BODY>
</HTML>