Backup and restore system error CCM

bernards · ‎06-20-2008

The following error is reported in the backup and restore log

09:00:12 PM] Dumping CDR database on xxx

[09:01:24 PM] Database backup verified.

[09:01:24 PM] Staging database dump from xxx to staging directory.

[09:01:24 PM] Truncating transaction logs for CDR database on xxx.

[09:01:25 PM] No CDR file exists.

no CDR file exiests??

never came across this before. The backup completes 100% but with errors. can anyone shed any light?

cheers

Rob Huffman · ‎06-20-2008

Hi Steven,

This error is due to the fact that you have configured BARS to backup the CDR Database but no files existed during this particular run. This is informational only and more of a "heads up" to check your CDR Service. If you are collecting CDR's on a regular basis check things like CDR Insert to make sure things are running.

Hope this helps!

Rob

bernards · ‎06-20-2008

Thanks for the resopnse. The CDR insert is running. this has been checked. at a loose end!!

cheers

steven

Jaime Valencia · ‎06-21-2008

on which server are you doing the backup? PUB or SUB?

You can have the CDR insert running but if you do not enable the CDR flag there won't be records, have you checked that indeed you have records under the CDR tables?

also which version we talking about?

HTH

javalenc

if this helps, please rate

HTH

java

if this helps, please rate

bernards · ‎06-23-2008

thanks for the response

cdr is running on the PUB

cdr flag is enabled

i have records under the cdr tables

version 4.1

could it be a possibility the cdr table is full. ie 1.5million record is the limit

cheers

Jaime Valencia · ‎06-23-2008

you could find that out by doing a select count(*) from TABLE_NAME (sorry, i'm tired and can't remember the name of the table =) )

do that on CDR and TBL_BILLING_DATA from ART, there should be 1.5M as max in CDR and 2M under ART

HTH

javalenc

if this helps, please rate

HTH

java

if this helps, please rate