No CDR data returned from server


I just got started using this and have not had it work yet, with the above error.  The log file for the program shows that it can see all of the CDR records on the FTP site, but when I parses them, it shows the following error:

"

2013-02-20 16:10:01,817 [17] ERROR SolarWinds.FreeTools.Logging.Logger - Cannot parse data from csv: System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

   at System.Guid..ctor(String g)

   at VoIPHelpersLib.CdrCmrCsvFileReader.CreateCommonTableRow(DataTable table, IEnumerable`1 headers, CsvReader csv)

   at VoIPHelpersLib.CdrCmrCsvFileReader.CreateCdrTableRow(DataTable table, IEnumerable`1 headers, CsvReader csv, Int32 ccmMonitoringId, IDictionary`2 deviceNameRegionPairs, String filename, TimeSpan filter)

"

It does this for every CDR record....anyone have any ideas on how to fix this or why the Record Tracker is having trouble reading the files?

Parents
  • So give this a try ... IF you have the field below populated with a path to a directory ... delete it .. clear it out.

    pastedImage_0.png

    If your test is successful ..

    pastedImage_1.png

    Try loading calls again. This worked for me.

  • Kbeno,

    Thanks for the response but that is not the issue.  My file path field is empty and my tests are successful.  I have a feeling that the test is simply verifying whether or not it can connect to the sftp or ftp server.  My problem is that when I click next, it gives an error having to do with not finding any files.  When I look at the log file that is created, I see what was posted by rtsantor.  It looks to me like the program is trying to read the fields in from the CDR files and it is failing because of a data type or length mismatch or something similar.

    Keith

  • Keith,

    Thanks for the response, apologies for my easy fix not resolving your issue. Just to confirm, you have the latest version of the CDR tracker? You mention clicking "next" and that's a button I do not have on the version I'm using.

    Also, this is a screen shot of the CDR files on our FTP server, do your file names follow the same naming convention?

    pastedImage_0.png

    And .. connect to your FTP server with another client. We used FileZilla. Ensure your other client can connect.

    pastedImage_1.png

    And see if these fields populate:

    pastedImage_2.png

    Hope this helps. Have a great weekend!

    Keith

  • I hit send too soon. I get the exact log errors you do when I have the LOAD DATA NO OLDER THAN to something like 15 minutes. So, change it to 2 days. This CDR Tracker application does not do UTC time conversions on the CUCM CDR file. So, try changing this to 2 days and give it a shot.

    2013-04-19 14:03:26,835 [29] ERROR SolarWinds.FreeTools.Logging.Logger - Cannot parse data from csv:System.NullReferenceException: Object reference not set to an instance of an object.

       at VoIPHelpersLib.CdrCmrCsvFileReader.CreateCmrTableRow(DataTable table, IEnumerable`1 headers, CsvReader csv, Int32 ccmMonitoringId, String filename)

    2013-04-19 14:03:26,786 [29] ERROR SolarWinds.FreeTools.Logging.Logger - Cannot parse data from csv: System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

       at System.Guid..ctor(String g)

       at VoIPHelpersLib.CdrCmrCsvFileReader.CreateCommonTableRow(DataTable table, IEnumerable`1 headers, CsvReader csv)

       at VoIPHelpersLib.CdrCmrCsvFileReader.CreateCdrTableRow(DataTable table, IEnumerable`1 headers, CsvReader csv, Int32 ccmMonitoringId, IDictionary`2 deviceNameRegionPairs, String filename, TimeSpan filter)

  • Capture.JPG

    Kbeno,

    My CDR file names appear to be similar.  I do have the latest version and was mistaken when I mentioned clicking Next.  What I actually click is "Save".  I changed the "Load data no older than:" option to "Last 2 days" and clicked "Test".  The connection test was successful but I still had not data.  I checked the sftp log and see the following info.  It looks like the app is downloading the files.

    04-19-2013 15:01:55 IP 10.5.0.218 SFTP administrator is listing / (C:\Program Files (x86)\freeFTPd\sftproot\CDR\cmr_StandAloneCluster_01_201304191959_183027)

    04-19-2013 15:01:55 IP 10.5.0.218 SFTP administrator is downloading /cmr_StandAloneCluster_01_201304191959_183027 (C:\Program Files (x86)\freeFTPd\sftproot\CDR\cmr_StandAloneCluster_01_201304191959_183027)

    04-19-2013 15:01:55 IP 10.5.0.218 SFTP administrator transfer complete

    Do I need to have some sort of minimum number of CDR files in the folder for it to return data?

    Keith

  • I'm not aware of a minimum number of CDR files limitation, so not much help there.

    On the call detail record tracker log file do you see entries like the below?

    2013-04-19 15:16:17,617 [9] INFO  SolarWinds.FreeTools.Logging.Logger - Reading file: /cmr_StandAloneCluster_02_201304191937_98393

    2013-04-19 15:16:17,620 [9] INFO  SolarWinds.FreeTools.Logging.Logger - Loading file: /cmr_StandAloneCluster_02_201304191937_98393

    2013-04-19 15:16:18,026 [9] INFO  SolarWinds.FreeTools.Logging.Logger - Getting result table

    Or is it still complaining about not being able to parse data?

    I would try another ftp client. See my screen shots for filezilla above. Can't hurt.

    It's the end of my day, good luck. emoticons_happy.png

    Keith

  • I have the same issue.  It looks like the tool isn't parsing the date correctly to me; but hey, I'm not a programmer:

    2013-05-06 11:17:47,798 [21] INFO  SolarWinds.FreeTools.Logging.Logger - Checking file: #/cmr_StandAloneCluster_02_201305061610_438007 124/130

    2013-05-06 11:17:47,808 [21] INFO  SolarWinds.FreeTools.Logging.Logger - File Time:01/01/1970 00:00:00 DateTime with TimeZone-TimeSpan: 05/04/2013 16:17:47 TimeSpan: 2.00:00:00

    2013-05-06 11:17:47,816 [21] INFO  SolarWinds.FreeTools.Logging.Logger - Checking file: #/cmr_StandAloneCluster_02_201305061611_438008 125/130

    2013-05-06 11:17:47,824 [21] INFO  SolarWinds.FreeTools.Logging.Logger - File Time:01/01/1970 00:00:00 DateTime with TimeZone-TimeSpan: 05/04/2013 16:17:47 TimeSpan: 2.00:00:00

    2013-05-06 11:17:47,832 [21] INFO  SolarWinds.FreeTools.Logging.Logger - Checking file: #/cmr_StandAloneCluster_02_201305061612_438009 126/130

    2013-05-06 11:17:47,841 [21] INFO  SolarWinds.FreeTools.Logging.Logger - File Time:01/01/1970 00:00:00 DateTime with TimeZone-TimeSpan: 05/04/2013 16:17:47 TimeSpan: 2.00:00:00

    2013-05-06 11:17:47,848 [21] INFO  SolarWinds.FreeTools.Logging.Logger - Checking file: #/cmr_StandAloneCluster_02_201305061613_438010 127/130

    2013-05-06 11:17:47,856 [21] INFO  SolarWinds.FreeTools.Logging.Logger - File Time:01/01/1970 00:00:00 DateTime with TimeZone-TimeSpan: 05/04/2013 16:17:47 TimeSpan: 2.00:00:00

    2013-05-06 11:17:47,863 [21] INFO  SolarWinds.FreeTools.Logging.Logger - Checking file: #/cmr_StandAloneCluster_02_201305061614_438011 128/130

    2013-05-06 11:17:47,872 [21] INFO  SolarWinds.FreeTools.Logging.Logger - File Time:01/01/1970 00:00:00 DateTime with TimeZone-TimeSpan: 05/04/2013 16:17:47 TimeSpan: 2.00:00:00

    2013-05-06 11:17:47,878 [21] INFO  SolarWinds.FreeTools.Logging.Logger - Checking file: #/cmr_StandAloneCluster_02_201305061615_438012 129/130

    2013-05-06 11:17:47,888 [21] INFO  SolarWinds.FreeTools.Logging.Logger - File Time:01/01/1970 00:00:00 DateTime with TimeZone-TimeSpan: 05/04/2013 16:17:47 TimeSpan: 2.00:00:00

    2013-05-06 11:17:47,895 [21] INFO  SolarWinds.FreeTools.Logging.Logger - Checking file: #/cmr_StandAloneCluster_02_201305061616_438013 130/130

    2013-05-06 11:17:47,903 [21] INFO  SolarWinds.FreeTools.Logging.Logger - File Time:01/01/1970 00:00:00 DateTime with TimeZone-TimeSpan: 05/04/2013 16:17:47 TimeSpan: 2.00:00:00

    2013-05-06 11:17:47,911 [21] INFO  SolarWinds.FreeTools.Logging.Logger - Filteting old files: Ended

    Also my dateTimeConnect is coming up as 0 in the CDR:

    dateTimeConnectdateTimeDisconnect
    INTEGERINTEGER
    01367855481
    01367855481

    Max

    System version: 8.6.2.22040-1

  • Hello,

    Unfortunately CDR Tracker uses dateTimeConnect and dateTimeDisconnect fields and if one of this fields is out of chosen date/time range - it can't show results.

    In your case we don't have dateTimeConnect field - it's the problem. I think something is wrong with Call Manager settings, please check them.

    Best regards

Reply
  • Hello,

    Unfortunately CDR Tracker uses dateTimeConnect and dateTimeDisconnect fields and if one of this fields is out of chosen date/time range - it can't show results.

    In your case we don't have dateTimeConnect field - it's the problem. I think something is wrong with Call Manager settings, please check them.

    Best regards

Children
No Data