« Back to Call Detail Records Questions

Strange CUCM7 CDR Agent Behavior

Combination View Flat View Tree View
Threads [ Previous | Next ]
Strange CUCM7 CDR Agent Behavior
Answer
2/12/10 10:36 PM
Hi,
 
I have setup an external billing server in UCM 7.01 via SFTP. I use freeFTPD on the billing server to receive the CDR files. I can see the CDR agent successfully accesses its FTP home folder and uploads files.
 
However, the problem is that it doesn't do that consistently. Sometimes it does upload the CDR file and some other times it doesn't. Instead, it does something very strange, it stays logged in to the SFTP server and keeps sending the same file over and over. Sometimes it just connects and disconnects without doing anything. In all cases I usually make a call and monitor the CDR agent behavior.
 
 
 
 
 
Here is a copy of the FTP daemon log:
 
05-31-2009 19:21:15 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:21:15 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:21:15 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:21:15 IP 192.168.1.5 SFTP ccm7 is changing dir to /cdr\ (C:\Ucm\CCM7\cdr\\)
05-31-2009 19:21:15 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:21:15 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:21:58 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:22:01 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:22:01 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:22:01 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:22:01 IP 192.168.1.5 SFTP ccm7 is changing dir to /cdr\ (C:\Ucm\CCM7\cdr\\)
05-31-2009 19:22:01 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:22:01 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905220805_44)
05-31-2009 19:22:01 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905220805_44)
05-31-2009 19:22:01 IP 192.168.1.5 SFTP ccm7 is uploading /cdr/cdr_StandAloneCluster_01_200905220805_44 (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905220805_44)
05-31-2009 19:22:01 IP 192.168.1.5 SFTP ccm7 transfer complete
05-31-2009 19:26:35 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:26:35 IP 192.168.1.5 SFTP ccm7 access denied
05-31-2009 19:26:35 IP 192.168.1.5 SFTP ccm7 access denied
05-31-2009 19:26:35 IP 192.168.1.5 SFTP ccm7 access denied
05-31-2009 19:26:35 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:26:53 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:26:53 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:26:53 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:26:53 IP 192.168.1.5 SFTP ccm7 is changing dir to /\cdr\ (C:\Ucm\CCM7\\cdr\\)
05-31-2009 19:26:53 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:26:53 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:27:09 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:27:13 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:27:13 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:27:13 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:29:47 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:29:51 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:29:51 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:29:51 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:29:51 IP 192.168.1.5 SFTP ccm7 is changing dir to /\cdr\ (C:\Ucm\CCM7\\cdr\\)
05-31-2009 19:29:51 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:29:51 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:29:51 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:29:51 IP 192.168.1.5 SFTP ccm7 is uploading //cdr/cdr_StandAloneCluster_01_200905261433_166 (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:29:51 IP 192.168.1.5 SFTP ccm7 transfer complete
05-31-2009 19:32:31 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:32:33 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:32:34 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:32:34 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:32:34 IP 192.168.1.5 SFTP ccm7 is changing dir to /\cdr\ (C:\Ucm\CCM7\\cdr\\)
05-31-2009 19:32:34 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:32:34 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:32:34 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:32:34 IP 192.168.1.5 SFTP ccm7 is uploading //cdr/cdr_StandAloneCluster_01_200905261433_166 (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:32:34 IP 192.168.1.5 SFTP ccm7 transfer complete
05-31-2009 19:35:13 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:35:16 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:35:17 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:35:17 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:35:17 IP 192.168.1.5 SFTP ccm7 is changing dir to /\cdr\ (C:\Ucm\CCM7\\cdr\\)
05-31-2009 19:35:17 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:35:17 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:35:17 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:35:17 IP 192.168.1.5 SFTP ccm7 is uploading //cdr/cdr_StandAloneCluster_01_200905261433_166 (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:35:17 IP 192.168.1.5 SFTP ccm7 transfer complete
05-31-2009 19:38:10 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:38:12 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:38:12 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:38:12 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:38:12 IP 192.168.1.5 SFTP ccm7 is changing dir to /\cdr\ (C:\Ucm\CCM7\\cdr\\)
05-31-2009 19:38:12 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:38:12 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:38:12 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:38:12 IP 192.168.1.5 SFTP ccm7 is uploading //cdr/cdr_StandAloneCluster_01_200905261433_166 (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:38:12 IP 192.168.1.5 SFTP ccm7 transfer complete
05-31-2009 19:41:07 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:41:11 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:41:11 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:41:11 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:41:11 IP 192.168.1.5 SFTP ccm7 is changing dir to /\cdr\ (C:\Ucm\CCM7\\cdr\\)
05-31-2009 19:41:11 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:41:11 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:41:11 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:41:11 IP 192.168.1.5 SFTP ccm7 is uploading //cdr/cdr_StandAloneCluster_01_200905261433_166 (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:41:11 IP 192.168.1.5 SFTP ccm7 transfer complete
05-31-2009 19:44:08 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:44:12 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:44:12 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:44:12 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:44:12 IP 192.168.1.5 SFTP ccm7 is changing dir to /\cdr\ (C:\Ucm\CCM7\\cdr\\)
05-31-2009 19:44:12 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:44:12 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:44:12 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:44:12 IP 192.168.1.5 SFTP ccm7 is uploading //cdr/cdr_StandAloneCluster_01_200905261433_166 (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:44:12 IP 192.168.1.5 SFTP ccm7 transfer complete
05-31-2009 19:47:08 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:47:11 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:47:11 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:47:11 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:47:11 IP 192.168.1.5 SFTP ccm7 is changing dir to /\cdr\ (C:\Ucm\CCM7\\cdr\\)
05-31-2009 19:47:11 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:47:11 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:47:11 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:47:11 IP 192.168.1.5 SFTP ccm7 is uploading //cdr/cdr_StandAloneCluster_01_200905261433_166 (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:47:11 IP 192.168.1.5 SFTP ccm7 transfer complete
05-31-2009 19:50:05 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:50:09 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:50:09 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:50:09 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:50:09 IP 192.168.1.5 SFTP ccm7 is changing dir to /\cdr\ (C:\Ucm\CCM7\\cdr\\)
05-31-2009 19:50:09 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:50:09 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:50:09 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:50:09 IP 192.168.1.5 SFTP ccm7 is uploading //cdr/cdr_StandAloneCluster_01_200905261433_166 (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:50:09 IP 192.168.1.5 SFTP ccm7 transfer complete
05-31-2009 19:53:04 IP 192.168.1.5 SFTP ccm7 disconnected
05-31-2009 19:53:08 IP 192.168.1.5 SFTP connection attempt
05-31-2009 19:53:08 IP 192.168.1.5 SFTP ccm7 connected
05-31-2009 19:53:08 IP 192.168.1.5 SFTP ccm7 is changing dir to / (C:\Ucm\CCM7\)
05-31-2009 19:53:08 IP 192.168.1.5 SFTP ccm7 is changing dir to /\cdr\ (C:\Ucm\CCM7\\cdr\\)
05-31-2009 19:53:08 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\)
05-31-2009 19:53:08 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:53:08 IP 192.168.1.5 SFTP ccm7 is listing /cdr (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:53:08 IP 192.168.1.5 SFTP ccm7 is uploading //cdr/cdr_StandAloneCluster_01_200905261433_166 (C:\Ucm\CCM7\cdr\cdr_StandAloneCluster_01_200905261433_166)
05-31-2009 19:53:08 IP 192.168.1.5 SFTP ccm7 transfer complete
Flag

RE: Strange CUCM7 CDR Agent Behavior
billing application
Answer
2/12/10 10:36 PM as a reply to Walid Azab.
Walid, it is interesting to see the path alternate like that- is it possible that you edited the path of the billing app after initial setup/creation?
     If so, you may want to try deleting your billing application setup and creating a new one- I ran into a problem once where when I did an edit to an existing setup, and for whatever reason, it had trouble recreating the RSA fingerprint to complete the handshake between the systems for the data transfer- erasing the existing setup and creating a new one generated a new fingerprint and resolved the issue.
Flag

RE: Strange CUCM7 CDR Agent Behavior
Answer
2/12/10 10:36 PM as a reply to Dan Dilbeck.
Very odd...I would have first suspected that UCM is experiencing some kind of failure during upload, and is retrying continously - however I would not expect it to work occasionally.  If logging is available from the FTP server software, that may prove helpful.  I would also suggest trying another FTP server (I test using FileZilla.) 
 
Also: are you configuring delivery to use SFTP (instead of regular FTP?)  AFAIK this refers to SSH file transfer protocol (as in the unix 'scp' command,) not one of the 'FTP+secure features' variants.
Flag

RE: Strange CUCM7 CDR Agent Behavior
Answer
2/12/10 10:36 PM as a reply to David Staudt.
thanks for your posts..
 
It works perfectly now. But only when I deleted all billing servers which I did edited after the initial setup. Then I created an FTP billing server with the same path and changed the FTP server software to FileZilla. It now works. I do suspect that the use of SFTP was the problem. But I am relieved it is working stably now.
 
Thanks
Flag