|
Home > Archive > Voice over IP Cisco > June 2007 > SFTP to billing server frequency
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SFTP to billing server frequency
|
|
| proactiveone@gmail.com 2007-06-10, 7:11 am |
| Hi,
I have CCM 5.1 clusters. In CDR i want to send all the CDR/CMR files to the
Billing application server. For this in the CDR Management I added the IP
address of the billing application server and it is uploading the files
throught SFTP. The problem which i am getting is that after every 30 seconds
the CCM is sending the CDR file to the application billing server. How can I
change the frquency of sending the CDR files to the billing server? I would
like to change this at least to 12 hours ....
Any idea...
Thank you all in advance..
Regards,
| |
| Ryan Ratliff 2007-06-11, 1:12 pm |
| System->Enterprise Parameters, CDR File Time Interval. The default
is one minute, which means each server with CDRs enabled generates 1
flat file per minute. These files are copied up to the pub, and then
from there to the SFTP server if you have one configured. Increasing
this will cause the files to be uploaded less frequently, but also
can drastically increase file size. This will also impact system
performance as the SFTP upload has to run that much longer to upload
the files (one per server).
I would strongly recommend increasing the value slowly to make sure
the upload doesn't adversely affect the performance of your publisher.
-Ryan
On Jun 10, 2007, at 2:31 AM, proactiveone@gmail.com wrote:
Hi,
I have CCM 5.1 clusters. In CDR i want to send all the CDR/CMR files
to the Billing application server. For this in the CDR Management I
added the IP address of the billing application server and it is
uploading the files throught SFTP. The problem which i am getting is
that after every 30 seconds the CCM is sending the CDR file to the
application billing server. How can I change the frquency of sending
the CDR files to the billing server? I would like to change this at
least to 12 hours ....
Any idea...
Thank you all in advance..
Regards,
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Jefflin Choi 2007-06-12, 7:11 am |
| Can we control the time were the CCM will send the CDR files to the
billing server?
e.g. CCM will upload the CDR's to the billing server @ 12 midnight everyday.
thanks,
Jeff
On 6/11/07, Ryan Ratliff <rratliff@cisco.com> wrote:
> System->Enterprise Parameters, CDR File Time Interval. The default
> is one minute, which means each server with CDRs enabled generates 1
> flat file per minute. These files are copied up to the pub, and then
> from there to the SFTP server if you have one configured. Increasing
> this will cause the files to be uploaded less frequently, but also
> can drastically increase file size. This will also impact system
> performance as the SFTP upload has to run that much longer to upload
> the files (one per server).
>
> I would strongly recommend increasing the value slowly to make sure
> the upload doesn't adversely affect the performance of your publisher.
>
> -Ryan
>
> On Jun 10, 2007, at 2:31 AM, proactiveone@gmail.com wrote:
>
> Hi,
>
> I have CCM 5.1 clusters. In CDR i want to send all the CDR/CMR files
> to the Billing application server. For this in the CDR Management I
> added the IP address of the billing application server and it is
> uploading the files throught SFTP. The problem which i am getting is
> that after every 30 seconds the CCM is sending the CDR file to the
> application billing server. How can I change the frquency of sending
> the CDR files to the billing server? I would like to change this at
> least to 12 hours ....
>
> Any idea...
>
> Thank you all in advance..
> Regards,
>
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
| |
| Ryan Ratliff 2007-06-12, 1:11 pm |
| Not that I'm aware of. May be a knob for I just don't know about
though.
-Ryan
On Jun 12, 2007, at 5:27 AM, Jefflin Choi wrote:
Can we control the time were the CCM will send the CDR files to the
billing server?
e.g. CCM will upload the CDR's to the billing server @ 12 midnight
everyday.
thanks,
Jeff
On 6/11/07, Ryan Ratliff <rratliff@cisco.com> wrote:
> System->Enterprise Parameters, CDR File Time Interval. The default
> is one minute, which means each server with CDRs enabled generates 1
> flat file per minute. These files are copied up to the pub, and then
> from there to the SFTP server if you have one configured. Increasing
> this will cause the files to be uploaded less frequently, but also
> can drastically increase file size. This will also impact system
> performance as the SFTP upload has to run that much longer to upload
> the files (one per server).
>
> I would strongly recommend increasing the value slowly to make sure
> the upload doesn't adversely affect the performance of your publisher.
>
> -Ryan
>
> On Jun 10, 2007, at 2:31 AM, proactiveone@gmail.com wrote:
>
> Hi,
>
> I have CCM 5.1 clusters. In CDR i want to send all the CDR/CMR files
> to the Billing application server. For this in the CDR Management I
> added the IP address of the billing application server and it is
> uploading the files throught SFTP. The problem which i am getting is
> that after every 30 seconds the CCM is sending the CDR file to the
> application billing server. How can I change the frquency of sending
> the CDR files to the billing server? I would like to change this at
> least to 12 hours ....
>
> Any idea...
>
> Thank you all in advance..
> Regards,
>
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
| |
| proactiveone@gmail.com 2007-06-12, 1:11 pm |
| Hi Jeffin,
After modifying the Enterprise parameters which Ryan has told it worked....
The one about which you have told "CCM will upload the CDR's to the billing
server @ 12 midnight everyday"
it loads the CDR/CMR files to the CAR as per my limited info..
When I have changed the CDR settings from the Enterprise parameter to 60
min. Now i am able to send
the files to the billing server with the delay of 60 minutes. :-)
Thank you,
Regards,
On 6/12/07, Ryan Ratliff <rratliff@cisco.com> wrote:
>
> Not that I'm aware of. May be a knob for I just don't know about
> though.
>
> -Ryan
>
> On Jun 12, 2007, at 5:27 AM, Jefflin Choi wrote:
>
> Can we control the time were the CCM will send the CDR files to the
> billing server?
> e.g. CCM will upload the CDR's to the billing server @ 12 midnight
> everyday.
>
> thanks,
> Jeff
>
> On 6/11/07, Ryan Ratliff <rratliff@cisco.com> wrote:
>
| |
| Ryan Ratliff 2007-06-12, 1:11 pm |
| Actually I seem to remember that the time you update the parameter
has a lot to do with when the files are uploaded to the SFTP server.
CM should upload the files as they are created (IIRC). So if you set
the parameter to make 12 hour files, then 12 hours from when you
update the parameter the files will be copied up from the sub, and
then sent on the SFTP server.
-Ryan
On Jun 12, 2007, at 9:19 AM, proactiveone@gmail.com wrote:
Hi Jeffin,
After modifying the Enterprise parameters which Ryan has told it
worked....
The one about which you have told "CCM will upload the CDR's to the
billing server @ 12 midnight everyday"
it loads the CDR/CMR files to the CAR as per my limited info..
When I have changed the CDR settings from the Enterprise parameter to
60 min. Now i am able to send
the files to the billing server with the delay of 60 minutes. :-)
Thank you,
Regards,
On 6/12/07, Ryan Ratliff <rratliff@cisco.com> wrote: Not that I'm
aware of. May be a knob for I just don't know about
though.
-Ryan
On Jun 12, 2007, at 5:27 AM, Jefflin Choi wrote:
Can we control the time were the CCM will send the CDR files to the
billing server?
e.g. CCM will upload the CDR's to the billing server @ 12 midnight
everyday.
thanks,
Jeff
On 6/11/07, Ryan Ratliff <rratliff@cisco.com > wrote:
> System->Enterprise Parameters, CDR File Time Interval. The default
> is one minute, which means each server with CDRs enabled generates 1
> flat file per minute. These files are copied up to the pub, and then
> from there to the SFTP server if you have one configured. Increasing
> this will cause the files to be uploaded less frequently, but also
> can drastically increase file size. This will also impact system
> performance as the SFTP upload has to run that much longer to upload
> the files (one per server).
>
> I would strongly recommend increasing the value slowly to make sure
> the upload doesn't adversely affect the performance of your
publisher.
>
> -Ryan
>
> On Jun 10, 2007, at 2:31 AM, proactiveone@gmail.com wrote:
>
> Hi,
>
> I have CCM 5.1 clusters. In CDR i want to send all the CDR/CMR files
> to the Billing application server. For this in the CDR Management I
> added the IP address of the billing application server and it is
> uploading the files throught SFTP. The problem which i am getting is
> that after every 30 seconds the CCM is sending the CDR file to the
> application billing server. How can I change the frquency of sending
> the CDR files to the billing server? I would like to change this at
> least to 12 hours ....
>
> Any idea...
>
> Thank you all in advance..
> Regards,
>
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
| |
| Voll, Scott 2007-06-12, 1:11 pm |
| So come in at midnight and set it to 24 hours?!?
--Scott
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Ryan Ratliff
Sent: Tuesday, June 12, 2007 6:24 AM
To: proactiveone@gmail.com
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] SFTP to billing server frequency
Actually I seem to remember that the time you update the parameter
has a lot to do with when the files are uploaded to the SFTP server.
CM should upload the files as they are created (IIRC). So if you set
the parameter to make 12 hour files, then 12 hours from when you
update the parameter the files will be copied up from the sub, and
then sent on the SFTP server.
-Ryan
On Jun 12, 2007, at 9:19 AM, proactiveone@gmail.com wrote:
Hi Jeffin,
After modifying the Enterprise parameters which Ryan has told it
worked....
The one about which you have told "CCM will upload the CDR's to the
billing server @ 12 midnight everyday"
it loads the CDR/CMR files to the CAR as per my limited info..
When I have changed the CDR settings from the Enterprise parameter to
60 min. Now i am able to send
the files to the billing server with the delay of 60 minutes. :-)
Thank you,
Regards,
On 6/12/07, Ryan Ratliff <rratliff@cisco.com> wrote: Not that I'm
aware of. May be a knob for I just don't know about
though.
-Ryan
On Jun 12, 2007, at 5:27 AM, Jefflin Choi wrote:
Can we control the time were the CCM will send the CDR files to the
billing server?
e.g. CCM will upload the CDR's to the billing server @ 12 midnight
everyday.
thanks,
Jeff
On 6/11/07, Ryan Ratliff <rratliff@cisco.com > wrote:
> System->Enterprise Parameters, CDR File Time Interval. The default
> is one minute, which means each server with CDRs enabled generates 1
> flat file per minute. These files are copied up to the pub, and then
> from there to the SFTP server if you have one configured. Increasing
> this will cause the files to be uploaded less frequently, but also
> can drastically increase file size. This will also impact system
> performance as the SFTP upload has to run that much longer to upload
> the files (one per server).
>
> I would strongly recommend increasing the value slowly to make sure
> the upload doesn't adversely affect the performance of your
publisher.
>
> -Ryan
>
> On Jun 10, 2007, at 2:31 AM, proactiveone@gmail.com wrote:
>
> Hi,
>
> I have CCM 5.1 clusters. In CDR i want to send all the CDR/CMR files
> to the Billing application server. For this in the CDR Management I
> added the IP address of the billing application server and it is
> uploading the files throught SFTP. The problem which i am getting is
> that after every 30 seconds the CCM is sending the CDR file to the
> application billing server. How can I change the frquency of sending
> the CDR files to the billing server? I would like to change this at
> least to 12 hours ....
>
> Any idea...
>
> Thank you all in advance..
> Regards,
>
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Ryan Ratliff 2007-06-12, 1:12 pm |
| I'd start by setting it to 1 hour and verifying when it does the
upload. Then based on what you observe you start bumping it up.
Depending on call volume a 24 hour file can get very large.
-Ryan
On Jun 12, 2007, at 10:47 AM, Voll, Scott wrote:
So come in at midnight and set it to 24 hours?!?
--Scott
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Ryan Ratliff
Sent: Tuesday, June 12, 2007 6:24 AM
To: proactiveone@gmail.com
Cc: cisco-voip@puck.nether.net
Subject: Re: [cisco-voip] SFTP to billing server frequency
Actually I seem to remember that the time you update the parameter
has a lot to do with when the files are uploaded to the SFTP server.
CM should upload the files as they are created (IIRC). So if you set
the parameter to make 12 hour files, then 12 hours from when you
update the parameter the files will be copied up from the sub, and
then sent on the SFTP server.
-Ryan
On Jun 12, 2007, at 9:19 AM, proactiveone@gmail.com wrote:
Hi Jeffin,
After modifying the Enterprise parameters which Ryan has told it
worked....
The one about which you have told "CCM will upload the CDR's to the
billing server @ 12 midnight everyday"
it loads the CDR/CMR files to the CAR as per my limited info..
When I have changed the CDR settings from the Enterprise parameter to
60 min. Now i am able to send
the files to the billing server with the delay of 60 minutes. :-)
Thank you,
Regards,
On 6/12/07, Ryan Ratliff <rratliff@cisco.com> wrote: Not that I'm
aware of. May be a knob for I just don't know about
though.
-Ryan
On Jun 12, 2007, at 5:27 AM, Jefflin Choi wrote:
Can we control the time were the CCM will send the CDR files to the
billing server?
e.g. CCM will upload the CDR's to the billing server @ 12 midnight
everyday.
thanks,
Jeff
On 6/11/07, Ryan Ratliff <rratliff@cisco.com > wrote:
> System->Enterprise Parameters, CDR File Time Interval. The default
> is one minute, which means each server with CDRs enabled generates 1
> flat file per minute. These files are copied up to the pub, and then
> from there to the SFTP server if you have one configured. Increasing
> this will cause the files to be uploaded less frequently, but also
> can drastically increase file size. This will also impact system
> performance as the SFTP upload has to run that much longer to upload
> the files (one per server).
>
> I would strongly recommend increasing the value slowly to make sure
> the upload doesn't adversely affect the performance of your
publisher.
>
> -Ryan
>
> On Jun 10, 2007, at 2:31 AM, proactiveone@gmail.com wrote:
>
> Hi,
>
> I have CCM 5.1 clusters. In CDR i want to send all the CDR/CMR files
> to the Billing application server. For this in the CDR Management I
> added the IP address of the billing application server and it is
> uploading the files throught SFTP. The problem which i am getting is
> that after every 30 seconds the CCM is sending the CDR file to the
> application billing server. How can I change the frquency of sending
> the CDR files to the billing server? I would like to change this at
> least to 12 hours ....
>
> Any idea...
>
> Thank you all in advance..
> Regards,
>
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Jefflin Choi 2007-06-13, 1:12 am |
| So tweaking it based on the time it sends.
Before our CCM was sending @ about 2 am. Not that bad but after powering off
the CCM due to a scheduled outage. Without any changes on the configuration,
uploading to the ftp server went to about 9 am instead of 2am before.
On 6/12/07, Ryan Ratliff <rratliff@cisco.com> wrote:
>
> I'd start by setting it to 1 hour and verifying when it does the
> upload. Then based on what you observe you start bumping it up.
> Depending on call volume a 24 hour file can get very large.
>
> -Ryan
>
> On Jun 12, 2007, at 10:47 AM, Voll, Scott wrote:
>
> So come in at midnight and set it to 24 hours?!?
>
> --Scott
>
> -----Original Message-----
> From: cisco-voip-bounces@puck.nether.net
> [mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Ryan Ratliff
> Sent: Tuesday, June 12, 2007 6:24 AM
> To: proactiveone@gmail.com
> Cc: cisco-voip@puck.nether.net
> Subject: Re: [cisco-voip] SFTP to billing server frequency
>
> Actually I seem to remember that the time you update the parameter
> has a lot to do with when the files are uploaded to the SFTP server.
>
> CM should upload the files as they are created (IIRC). So if you set
> the parameter to make 12 hour files, then 12 hours from when you
> update the parameter the files will be copied up from the sub, and
> then sent on the SFTP server.
>
> -Ryan
>
> On Jun 12, 2007, at 9:19 AM, proactiveone@gmail.com wrote:
>
>
> Hi Jeffin,
>
> After modifying the Enterprise parameters which Ryan has told it
> worked....
> The one about which you have told "CCM will upload the CDR's to the
> billing server @ 12 midnight everyday"
> it loads the CDR/CMR files to the CAR as per my limited info..
>
> When I have changed the CDR settings from the Enterprise parameter to
> 60 min. Now i am able to send
> the files to the billing server with the delay of 60 minutes. :-)
>
> Thank you,
>
> Regards,
>
>
> On 6/12/07, Ryan Ratliff <rratliff@cisco.com> wrote: Not that I'm
> aware of. May be a knob for I just don't know about
> though.
>
> -Ryan
>
> On Jun 12, 2007, at 5:27 AM, Jefflin Choi wrote:
>
> Can we control the time were the CCM will send the CDR files to the
> billing server?
> e.g. CCM will upload the CDR's to the billing server @ 12 midnight
> everyday.
>
> thanks,
> Jeff
>
> On 6/11/07, Ryan Ratliff <rratliff@cisco.com > wrote:
> publisher.
>
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
|
|
|
|
|