cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
3964
Views
5
Helpful
8
Replies

CDR is getting generated in CUCM but not pushed into SFTP server

Vignesh Mani
Level 1
Level 1

Callmanager version is 7.0. The CDR is getting generated in CUCM but its not getting pushed into the SFTP server. It gets pushed only when the services like CDR Repository and CDR Agent is restarted. After that it again gets hanged soon and the services has to be restarted again. this was working fine before but now this issue has started. Please suggest a solution.

8 Replies 8

htluo
Level 9
Level 9

Please get "CDR Repository Manager" logs.

Michael

http://htluo.blogspot.com

I have the same problem. How to get "CDR Repository Manager" logs? thanks

1) Log into CUCM Admin

2) Go to Application > Plugins. Download and install "RealTime Monitoring Tool -Windows" (RTMT).

3) Run RTMT and log in.

4) Trace & Log Central > Collect Files. Find "CDR Repository Manager"

Michael

I've got the same problem with callmanager 7.1.2 now. Has there a resolution been found?

kindly regards,

Bernhard

We have the same problem with UCM 7.1.3.32900-4

We are using Aurenz CDR Software since 3 Years and we have these problems since some days:

When the error occured we could connect to the FTP-Server of the CDR-Server (Aurenz) without any problems.

Here are the Logfiles from Publisher:

2010-09-20 09:19:13,952 INFO  [Thread-8] cdrrep.CDRSender (CDRSender.java:166) - There was file delivery failure for destination 1 in last round, re-connect server now!
2010-09-20 09:19:13,952 ERROR [Thread-8] cdrrep.CDRSender (CDRSender.java:174) - Caught ftpManager.ftpClnt.disconnect() Exception: java.net.SocketException: Connection reset
2010-09-20 09:19:13,963 ERROR [Thread-8] sftpapi.ftpClient (ftpClient.java:236) - java.net.ConnectException: Connection refused
2010-09-20 09:19:13,964 ERROR [Thread-8] cdrrep.FtpManager (FtpManager.java:75) - FtpManager constructor 0: Establish server connection to host [192.168.209.31] failed!
2010-09-20 09:19:13,967 INFO  [Thread-8] cdrrep.CDRSender (CDRSender.java:345) - CDRREP before sending the file: JVM status: [Max = 246.56MB, Total = 7.00MB, Free = 6.10MB (87.15%), Used = 0.90MB (12.85%)]
2010-09-20 09:19:14,970 ERROR [Thread-8] cdrrep.FtpManager (FtpManager.java:216) - java.lang.NullPointerException
2010-09-20 09:19:14,970 ERROR [Thread-8] cdrrep.FtpManager (FtpManager.java:223) - SFTP/FTP failed: cdr_SYDEGO-CM-CLUSTER_10_201009200718_517745 to 192.168.209.31
2010-09-20 09:19:14,971 ERROR [Thread-8] cdrrep.LogConfig (LogConfig.java:157) - Java Exception happened in my CDRSender, with Exception:
java.lang.Exception: SFTP/FTP failed: cdr_SYDEGO-CM-CLUSTER_10_201009200718_517745 to 192.168.209.31
    at com.cisco.ccm.cdrdlv.cdrrep.FtpManager.sendFile(FtpManager.java:225)
    at com.cisco.ccm.cdrdlv.cdrrep.CDRSender.run(CDRSender.java:349)

2010-09-20 09:19:14,971 INFO  [Thread-8] cdrrep.CDRSender (CDRSender.java:364) - sendSuccess=false, numOfFailure=2
2010-09-20 09:19:14,971 ERROR [Thread-8] cdrrep.CDRSender (CDRSender.java:365) - java.lang.Exception: SFTP/FTP failed: cdr_SYDEGO-CM-CLUSTER_10_201009200718_517745 to 192.168.209.31
2010-09-20 09:19:14,971 ERROR [Thread-8] cdrrep.CDRSender (CDRSender.java:366) - Unable to successfully send file to outside billing server 192.168.209.31
2010-09-20 09:19:14,987 INFO  [Thread-8] alarmutil.AlarmSender (AlarmSender.java:41) - constructor
2010-09-20 09:19:14,987 INFO  [Thread-8] alarmutil.AlarmSender (AlarmSender.java:63) - _alarms = new com.cisco.alarmutil.GenericAlarmWrapper.getGenericAlarms(Cisco CDR Repository Manager, CDRRepAlarmCatalog, dbcdrrep)

Hi,

Does anyone have any resolution for this issue.I am using CUCM 10.5.2 and I restarted the CDR repository service,also re saved the passwords but still the same

get the following issue

ERROR [Thread-13] sftpapi.SFTPConnection (SFTPConnection.java:182) - sendFileThroughSFTP: SftpException error_code : 4

ERROR [Thread-13] sftpapi.SFTPConnection (SFTPConnection.java:183) - sendFileThroughSFTP: SftpException : 4: java.io.IOException: inputstream is closed

ERROR [Thread-13] sftpapi.ftpClient (ftpClient.java:562) - SFTP error in transferring file to another machine

ERROR [Thread-13] sftpapi.ftpClient (ftpClient.java:563) - 4: java.io.IOException: inputstream is closed

Java Exception happened in my CDRSender, with Exception:
java.lang.Exception: SFTP/FTP failed: cmr_StandAloneCluster

Kindly let me know

Regards,

DJ

Same issue on 11.5 - I'm getting the same error reason.  Anyone have a solution?

2017-05-25 16:58:09,072 ERROR [Thread-11] sftpapi.ftpClient (ftpClient.java:624) - in transferring file to remote.
2017-05-25 16:58:09,072 ERROR [Thread-11] sftpapi.ftpClient (ftpClient.java:625) - java.net.SocketException: Connection reset
2017-05-25 16:58:09,072 ERROR [Thread-11] cdrrep.FtpManager (FtpManager.java:223) - SFTP/FTP failed: cdr_StandAloneCluster_02_201705051430_1 to uc-mca01.domain.net
2017-05-25 16:58:09,072 ERROR [Thread-11] cdrrep.LogConfig (LogConfig.java:157) - Java Exception happened in my CDRSender, with Exception:
java.lang.Exception: SFTP/FTP failed: cdr_StandAloneCluster_02_201705051430_1 to uc-mca01.kclife.net
    at com.cisco.ccm.cdrdlv.cdrrep.FtpManager.sendFile(FtpManager.java:225)
    at com.cisco.ccm.cdrdlv.cdrrep.CDRSender.run(CDRSender.java:358)

peter.matuska1
Level 1
Level 1

Hi,

I have the similar problem. In the logs I see following 6 lines occuring.

 

2018-01-29 11:10:56,280 INFO [ConnectionPoolCleaner] dbl.ConnectionPool (ConnectionPool.java:151) - There are 3 entries in the connection pool
2018-01-29 11:10:56,281 INFO [ConnectionPoolCleaner] dbl.ConnectionPool (ConnectionPool.java:156) - Auditing connections for pool entry <dblog4j,jdbcurl>
2018-01-29 11:10:56,281 INFO [ConnectionPoolCleaner] dbl.ConnectionPool$ConnectionPoolEntry (ConnectionPool.java:491) - There are no available connections in <com.cisco.ccm.dbl.ConnectionPool$ConnectionPoolEntry@1c61fb5>
2018-01-29 11:10:56,281 INFO [ConnectionPoolCleaner] dbl.ConnectionPool$ConnectionPoolEntry (ConnectionPool.java:498) - There are no used connections in <com.cisco.ccm.dbl.ConnectionPool$ConnectionPoolEntry@1c61fb5>
2018-01-29 11:10:56,281 INFO [ConnectionPoolCleaner] dbl.ConnectionPool (ConnectionPool.java:156) - Auditing connections for pool entry <dbcdrrep,jdbcurl2>
2018-01-29 11:10:56,281 INFO [ConnectionPoolCleaner] dbl.ConnectionPool$ConnectionPoolEntry (ConnectionPool.java:491) - There are no available connections in <com.cisco.ccm.dbl.ConnectionPool$ConnectionPoolEntry@4baf3e>
2018-01-29 11:10:56,281 INFO [ConnectionPoolCleaner] dbl.ConnectionPool$ConnectionPoolEntry (ConnectionPool.java:498) - There are no used connections in <com.cisco.ccm.dbl.ConnectionPool$ConnectionPoolEntry@4baf3e>
2018-01-29 11:10:56,281 INFO [ConnectionPoolCleaner] dbl.ConnectionPool (ConnectionPool.java:156) - Auditing connections for pool entry <dbcdrrep,jdbcurl>
2018-01-29 11:10:56,282 INFO [ConnectionPoolCleaner] dbl.ConnectionPool$ConnectionPoolEntry (ConnectionPool.java:491) - There are no available connections in <com.cisco.ccm.dbl.ConnectionPool$ConnectionPoolEntry@de109f>
2018-01-29 11:10:56,282 INFO [ConnectionPoolCleaner] dbl.ConnectionPool$ConnectionPoolEntry (ConnectionPool.java:498) - There are no used connections in <com.cisco.ccm.dbl.ConnectionPool$ConnectionPoolEntry@de109f>

 

Restart of CUCM always helps.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: