CDRs sftp to billing server failure after upgrade to 7.0

wesleyj84 · ‎05-26-2009

After I upgraded to CUCM 7.0, cdrs are no longer being sent to our remote billing server. The call manager is able to ping the box and the billing server user name and password are correct. Looking at the trace logs shows that the call manager believes it's getting a null user name.

2009-05-26 13:09:41,376 INFO [main] cdrrep.FtpManager (FtpManager.java:78) - FtpManager constructor 0: Establish server connection to host [10.20.1.111] successfully!

2009-05-26 13:09:41,377 INFO [main] cdrrep.CDRRepClass (CDRRepClass.java:179) - CDRSender 1 is created

2009-05-26 13:09:41,377 INFO [main] cdrrep.CDRRepClass (CDRRepClass.java:181) - CDRSender 1 is started

2009-05-26 13:09:41,377 INFO [main] sftpapi.ftpClient (ftpClient.java:204) - UserName is NULL; Can't get the connection

I've done an axl database query and the username is defined in the billingserver table. Has any one else experienced this problem?

wesleyj84 · ‎05-26-2009

This might also be part of it.

2009-05-25 13:53:24,182 INFO [Thread-8] cdrrep.FtpManager (FtpManager.java:78) - FtpManager constructor 1: Establish server connection to host [10.20.1.111] successfully!

2009-05-25 13:53:24,191 ERROR [Thread-8] sftpapi.SFTPConnection (SFTPConnection.java:126) - Sftp Status Exception : com.maverick.sftp.SftpStatusException: No such file

2009-05-25 13:53:24,191 ERROR [Thread-8] sftpapi.ftpClient (ftpClient.java:473) - SFTP error in transferring file to another machine.

2009-05-25 13:53:24,191 ERROR [Thread-8] sftpapi.ftpClient (ftpClient.java:474) - com.maverick.sftp.SftpStatusException: No such file

2009-05-25 13:53:24,191 ERROR [Thread-8] sftpapi.ftpClient (ftpClient.java:493) - Exception while sending files: com.maverick.sftp.SftpStatusException: No such file

2009-05-25 13:53:24,191 ERROR [Thread-8] cdrrep.FtpManager (FtpManager.java:223) - SFTP/FTP failed: cdr_StandAloneCluster_02_200905242115_455838 to 10.20.1.111

2009-05-25 13:53:24,192 ERROR [Thread-8] cdrrep.LogConfig (LogConfig.java:157) - Java Exception happened in my CDRSender, with Exception:

java.lang.Exception: SFTP/FTP failed: cdr_StandAloneCluster_02_200905242115_455838 to 10.20.1.111

at com.cisco.ccm.cdrdlv.cdrrep.FtpManager.sendFile(FtpManager.java:225)

at com.cisco.ccm.cdrdlv.cdrrep.CDRSender.run(CDRSender.java:336)

bhalchandrarane · ‎05-28-2009

Hi

I am also facing the same issue that cdr is not going to sftp in billing server.

whereas connectivity is ok.

Plz let me know if you find the solution

wesleyj84 · ‎05-28-2009

Yeah, I found a work around. Apparently the path is getting messed up somewhere in the code. If you don't specify a directory, the cdrs will begin to transfer again, but only to the billing server's root sftp directory.