We are having issues exporting the CDR files to a Billing Application server from the Publisher call manager (version 7.1.5) with four servers in the cluster. We have configured the CDR Management Billing Application Server Parameters properly. We confirmed network/SFTP connectivity by backing up the CCM database (using DRF) to that Billing server and the same credentials, so we know the servers can talk to each other. However, we do not see any CDR files being copied over the SFTP root directory. All servers in the clustomer are set to "Enable CDR = Yes", and all services that should be running are active. The CDR load interval is set at 5 minutes.
Any ideas as to what we may have missed?
I increased the CDR Repository Manager Trace level to "Debug" and collected the log file from the Publisher. It's attached to this post. I read through the log file and couldn't see anything descriptive, but hopefully it will make more sense to you.
Also, we program the CDR Management only on the Publisher, correct? AFAIK, all CDR data is copied over from all the nodes to the publisher, so there is no need to configure each node individually. Please let me know if that sounds right.
Message was edited by: jessakhanian Didn't see the attachment.
Could you get the screen output of the following commands from CUCM publisher?
file list activelog cm/cdr_repository/destination1
file list activelog cm/cdr_repository/destination1/20100802
file list activelog cm/cdr_repository/destination1/20100801
Here it is. It doesn't look like there is anything in the subdirectories:
admin:file list activelog cm/cdr_repository/destination1
It looks like you don't have any CDR files on the detination1 folder. That's why you don't have any files transferred to billing server.
Run the commands below to see if you have any CDR files generated at all:
file list activelog cm/cdr_repository/preserve/20100803
file list activelog cm/cdr_repository/preserve/20100802
file list activelog cm/cdr_repository/preserve/20100801
Yes, I see files in the 20100803 folder, but nothing previous to that. We have been collecting CDR from when the servers were installed (in Early July), although we just went into production last weekend. I still don't see anything copied over to the Billing Server, however. Here is a snapshot of the commands you asked for. Thanks for all your help.
admin:file list activelog cm/cdr_repository/preserve/20100801
dir count = 0, file count = 0
admin:file list activelog cm/cdr_repository/preserve/20100802
dir count = 0, file count = 0
admin:file list activelog cm/cdr_repository/preserve/20100803
....... Ommited .................
dir count = 0, file count = 295
After I posted my previous message, I logged on to the Billing server and restarted the SFTP application, and boom, all the files in that folder were copied over to the root directory. We have over 300 since the time interval was set to 2. I just increased it to 60 for testing, and it will be changed to 720 later on so that we get the file twice a day.
Looks like once the files are copied over, they are deleted from the call manager. Is this normal/default behaviour? Can we change it so that those files stay on the server (at least for a while) just in case? I realize there could be HDD space implications, so that may be why. Also, we have no idea where the files for the previous day's folder have gone as we just added the Billing server yesterday. I don't think this will be too big of an issue for our customer since they just went live yesterday, so worse case scenario, we only lose 1 day's worth of data.
It depends where you looked at.
The original place for CDR file was in the "preserve" folder. Once they are processed by CDR Loader (loaded into database), those files will be moved to "processed" folder.
For external billing servers, CDR files were copied from "preserve" folder to "destination" folder. Then moved from "destination" folder to SFTP server.
Perfect. I still see the older CDR files in the "processed" folder. I'm certain these are overwritten on the backend (the oldest) once a certain threshold is reached. Can we copy the older files that we didn't get (I see quite a few files for the previous days in the "processed/
You may use command:
file get activelog cm/cdr_repository/processed/20100803/*
Repeat that for each folder you like to copy.
Or if you like to copy everything in "processed" folder, use command:
file get activelog cm/cdr_repository/processed/* recurs