<div><font color="#000000">You can run the command </font></div>
<div><font face="Calibri" color="#000000" size="3">run sql select * from car:tbl_system_preferences</font></div>
<div><font face="Calibri" color="#000000" size="3"></font> </div>
<div><font face="Calibri" color="#000000" size="3">Look for the MAX_CDR_NUMBER value by default this is set to 2000000.</font></div>
<div><font face="Calibri" color="#000000" size="3"></font> </div>
<div><font face="Calibri" color="#000000" size="3">If need be (I would not advise this, do not change this without direction from cisco TAC) you can increase the max cdr value. Increasing this value will cause more disk space to be used. Make sure your retention policy is set beforehand. Check your automatic purge settings, I won't advise any values as I don't know how busy your system is.</font></div>
<div><font face="Calibri" color="#000000" size="3"></font> </div>
<div>You can run the command <font face="Calibri">(I would not advise this, do not change this without direction from cisco TAC)</font></div>
<div><span style="FONT-SIZE: 10pt; COLOR: #002060; FONT-FAMILY: 'Arial','sans-serif'"><font color="#000000">run sql update car:tbl_system_preferences set param_value='5000000' where param_name='MAX_CDR_NUMBER'</font></span></div>
<div><span style="FONT-SIZE: 10pt; COLOR: #002060; FONT-FAMILY: 'Arial','sans-serif'"><font color="#000000"></font></span> </div>
<div><span style="FONT-SIZE: 10pt; COLOR: #002060; FONT-FAMILY: 'Arial','sans-serif'"><font color="#000000">Restart the appropriate services like the car scheduling services.</font></span></div>
<div><span style="FONT-SIZE: 10pt; COLOR: #002060; FONT-FAMILY: 'Arial','sans-serif'"><font color="#000000"></font></span> </div>
<div><span style="FONT-SIZE: 10pt; COLOR: #002060; FONT-FAMILY: 'Arial','sans-serif'"><font color="#000000">Also check the service parameter "CDR Log Calls with Zero Duration Flag" you might be logging calls that do not need to be kept.</font></span></div>
<div><br><br> </div>
<div class="gmail_quote">On Tue, Apr 21, 2009 at 12:09 AM, VoIP Canada <span dir="ltr"><<a href="mailto:voipcanada@gmail.com">voipcanada@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">you have to add a radius just to be safe so in case there is power outage you loose all records on the cisco ,,, <a href="mailto:voipcanada@gmail.com" target="_blank">voipcanada@gmail.com</a>
<div>
<div></div>
<div class="h5"><br><br>
<div class="gmail_quote">On Mon, Apr 20, 2009 at 9:35 AM, Ryan Ratliff <span dir="ltr"><<a href="mailto:rratliff@cisco.com" target="_blank">rratliff@cisco.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">The size is a hard limit due to the max 2 million CDR records and cannot be increased. The retention period is going to be based on how many CDR records you are generating and how quickly that 2 million records is being reached.<br>
<br>-Ryan
<div>
<div></div>
<div><br><br>On Apr 20, 2009, at 5:04 AM, Mohammed Naviwala wrote:<br><br>Hi<br><br>does anyone know whats the problem with the CUCM CDR in 6.1?? somehow i am not able to allocate more than 3 GB and 30 days retention period. anybody has any solution?<br>
<br>-- <br>Best Regards<br><br>Mohammed Abdul Razzaq<br><br></div></div>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br><br>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br></blockquote></div><br><br clear="all"><br></div></div>-- <br>Ajinder Singh<br>CTO<br>
<a href="http://www.btel.ca/" target="_blank">www.btel.ca</a><br><br>151 front street, toronto, canada <br>Philippines || India || Canada || HongKong<br><br>Delhi Phone +91 98 7166 0553<br>Toronto Phone: +1 647-285-8677<br>
HK Phone: +852 9758 5459<br>efax: +1 416 273 7501<br>MSN: <a href="mailto:voipcanada@hotmail.com" target="_blank">voipcanada@hotmail.com</a><br><br>_______________________________________________<br>cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br><br></blockquote>
</div><br>