[cisco-voip] kErrorCDRFilesBackingUp - CDR flat files are backingup.

[Erick Bergquist]

Ok, Looks like adjusting time of database layer
monitor job to run from 5am to 7am got rid of the
error. I moved the time back and the error came back
just to make sure it wasn't something else.

So, my question is, how come the default times for
these jobs conflict with other SQL jobs being done by
other applications?

Database layer monitor default setting is 12am to 2am
CDR load default time is 12am to 5am

Seems like issues may happen like this customer had if
you are loading and purging at same time by two
different processes. 

I did not change the time of the CIPT SQL Optimization
yet. Does this job touch the CDR database or just CCM
database?

Thanks,
Erick

--- Wes Sisk <wsisk at cisco.com> wrote:
> Check the cdr insert log around that time. Looks
> like SQL may be dropping
> offline or too busy to process the cdr insert
> request.  could be the service
> stopping i guess.  make sure the PID does not change
> day to day for
> cdrinsert.  any change would reflect a crash or
> service restart for some
> reason.  check the SQL server logs around that time
> and see if it reported
> any events.
> 
> this may be due to the IPT optimization job running,
> or the CDR purge
> process running.  the 1st is a job in sql - when is
> it scheduled to run?
> The 2nd is done by database layer monitor and timing
> is set by the dblm
> service parameters.  what time is it set to run?
> 
> on that same line the ART cdr purge could cause the
> same issue.  is ART/CAR
> configured to purge the CDR database and if so, what
> time?
> 
> /Wes
> 
> -----Original Message-----
> From: cisco-voip-bounces at puck.nether.net
> [mailto:cisco-voip-bounces at puck.nether.net]On Behalf
> Of Erick Bergquist
> Sent: Thursday, May 19, 2005 10:16 PM
> To: cisco-voip at puck.nether.net
> Subject: [cisco-voip] kErrorCDRFilesBackingUp - CDR
> flat files are
> backingup.
> 
> 
> Hi,
> 
> Has anyone had the below in Application event log
> and
> know a fix for issue? I found a bug id that matches
> on
> this (CSCeg37424) but the workaround is not working.
> 
> The InsertCDR detailed trace is turned on and the
> error happens at 12:24am and the entry in trace file
> is at 12:34am saying 10 minute timeout occurred.
> Nothing in trace between 12:24 and 12:34.
> 
> Issue was found in CCM 4.0(1)ES 17.1 and marked as
> unreproducable.  This is on Call Manager
> 4.0(2a)Sr1a.
> 
> Workaround from bug id is to kill the insertcdr
> process using c:\utils\kill command then restart the
> CDR insert service.
> 
> These errors are occuring at 12:24am and 1:24am
> nightly like clockwork. Not during day and CDR is
> working fine. BARS runs earlier before midnight.
> There
> are no CDR flat files in the CDR folder either. They
> show up briefly then get inserted and deleted. We
> have
> a few files in the bad folder but not from this time
> period. Maybe 1-2 bad cdr flat files a day.
> 
> 
> Event Type:	Error
> Event Source:	Cisco Database Layer Monitor
> Event Category:	None
> Event ID:	3
> Date:		5/18/2005
> Time:		1:24:32 AM
> User:		N/A
> Computer:	CCM1
> Description:
> Error: kErrorCDRFilesBackingUp - CDR flat files are
> backing up.
>   App ID: Cisco Database Layer Monitor
>   Cluster ID: CCM1-Cluster
>   Node ID: 172.16.2.20
> Explanation: CDR flat files are not being removed. 
> On
> the primary CDR
> server, verify that the InsertCDR service is running
> and properly
> configured. On a server not the primary, verify that
> the location for
> collecting CDR files is accessible via the network.
> Recommended Action: Set trace for InsertCDR service
> to
> detailed and
> look
> for errors in the trace.  Check enterprise CDR
> parameters for
> accuracy..
> 
> 
> 
> 
> __________________________________
> Yahoo! Mail Mobile
> Take Yahoo! Mail with you! Check email on your
> mobile phone.
> http://mobile.yahoo.com/learn/mail
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
> 
> 


		
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html