<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=idOWAReplyText6440 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hi Ryan,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>you are right with your description of the
problem: CIPT Optimization is still running since the day I am having the
eventviewer error. To manually kill the pid for this job, this only affects the
CDR, am I right? As the CDR is not yet being used, I assume I can do what you
suggest without impacting the other jobs in the database, right?</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>I think the pid for the job that is causing
problems is 80, that is blocking pid 62 and pid 62 is blocking some other jobs.
Is pid 80 the CIPT optimization? </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>I have only used Enterprise Manager to
validate that the replication between Pub and Sub is ok and running, so all
this stuff is new for me...</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>By the way, we're running CCM 4.1(3)SR3A:
should this problem be fixed in this version?</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Thanks in advance,</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> mar 01/08/2006
15:08<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>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></FONT></P></DIV>
</BODY>
</HTML>