Call Reports Suddenly end

Discussion in '3CX Phone System - General' started by TWC-3cx, Nov 1, 2017.

Thread Status:
Not open for further replies.
  1. TWC-3cx

    Joined:
    Aug 28, 2014
    Messages:
    13
    Likes Received:
    0
    Greetings

    Each month on the 1st of the month 3cx Email our receptionist a call report for each extension.
    The report should cover the whole of the previous month.

    However this time all the reports end on the 10th.
    I setup a brand new report. Same thing.

    I have gone into the "call log" menu.
    No logs.
    If i set the filter to "the last month" or "last 30 days" i have call logs up till the 10th of October.
    Then Blank, nothing.

    Has anyone seen this before?
    Any ideas what i should look at?

    Thank you
     
  2. NickD_3CX

    NickD_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Jun 2, 2014
    Messages:
    1,344
    Likes Received:
    78
    V14 and V15.5 SP1 installations have a default maximum number of results they will query against the DB for each single report which is 10000 entries. The amount of actual amount of entries might be slightly less depending on the report you run as some reports require lookups against multiple tables.
    If this is the case, in the email you receive, you should see a message and the bottom in red stating "* Report not generated in full because query contains too many records.".

    This limit is imposed because on low-spec servers, it could interfere with other operations as it does slightly stress the disk and CPU.

    If this is what is happening, the way I see it you have 2 options:
    • "Break" the month into smaller parts, so e.g. you schedule 4 reports and break the month into 4 parts.
    or
    • * Go to Settings Parameters, find parameter "REPORT_ROW_LIMIT" and increase the value to a bigger number, e.g. 35000.

      * Important note: From a 3CX perspective, you can set the value to 80000 if you want, but I highly recommend you do this if you have hardware resources to spare, and if you have recordings enabled, make sure you have fast disks because if a large report is being generated while a call is being recorded, the disk might not cope with both, and while the report will just take longer, I don't think "gaps" in the recording audio is acceptable. Also if you go this route consider generating all reports at low traffic times.
     
  3. TWC-3cx

    Joined:
    Aug 28, 2014
    Messages:
    13
    Likes Received:
    0
    Thanks for the reply Nick.

    But There is no error type message at the end of the report.
    It just ends like it should.

    2017-10-10 08:08 Kerry Scott (101) Lynn Wood (104) answered 00:00:03 00:00:25 00:00:28 0
    Totals Calls - 50 00:08:08 00:47:10 00:55:18 7.71
    3CX Ltd
    .
    Those are the last three lines of the report.
    Which is how they have always ended.

    As far as the Call Log is concerned there are no Logs after the 10-10-2017 09:35.
    There are no error message in the Call Log interface/view.
    I cannot see an error message anywhere that can explain this
     
  4. NickD_3CX

    NickD_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Jun 2, 2014
    Messages:
    1,344
    Likes Received:
    78
    The message would not be in the actual report file, it would be in the email you receive when generating the report:
    upload_2017-11-1_16-50-41.png
     
  5. TWC-3cx

    Joined:
    Aug 28, 2014
    Messages:
    13
    Likes Received:
    0
    Hi Nick.

    Sorry about that.
    No error indicated in the body of the email either.

    Subject: 3CX Phone System - Test
    Your call report - Test is ready for download.


    Download your report from here.
    If you are in the office you can also download it locally from here
    .

    after the second here it is all just blank.
     
  6. NickD_3CX

    NickD_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Jun 2, 2014
    Messages:
    1,344
    Likes Received:
    78
    OK, have you tried generating a report for let's say that 11th of October only? Just to see if it has something to do with the "Last 30 days" or if indeed 3CX thinks there are no entries for that day. Also, try the "Call Reports" type of report which is the most basic.
     
  7. TWC-3cx

    Joined:
    Aug 28, 2014
    Messages:
    13
    Likes Received:
    0
    Greetings

    I have now.
    Everything come back Blank/empty.
     
  8. NickD_3CX

    NickD_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Jun 2, 2014
    Messages:
    1,344
    Likes Received:
    78
    In that case there is a chance that there are indeed no entries in the DB for those days. Did any service stop at those days? Or did you clear any Call Logs for those days? One way you could check this is to make a full backup of the system now, donwload the .zip file, open it and go to the DbTables folder and check the files that start with "cl_". Are there any entries in their for the dates that come back blank?
     
  9. TWC-3cx

    Joined:
    Aug 28, 2014
    Messages:
    13
    Likes Received:
    0
    No services are listed as stopped on the server.
    Hotel Service - is listed as disabled.

    I did no work on the 3cx server on the 10th.
    So no i did not clear any logs.

    There are no call logs FROM the 10th Till Today.
    There are no Call logs FOR today either.
    It is not just the 10th
    - i am not sure i made that clear in the original post.

    I will do the backup and check the ZIP as you suggest.
     
  10. TWC-3cx

    Joined:
    Aug 28, 2014
    Messages:
    13
    Likes Received:
    0
    So in the CL_Calls.CSV file
    the last 2 lines are
    167005 2017-10-10 07:34:35+00 2017-10-10 07:35:28+00 t 00:07.4 00:45.2
    167006 2017-10-10 07:33:25+00 2017-10-10 07:35:35+00 t 00:02.3 02:07.5


    Does this mean the Database is "full" @ a 167 006 entries?
     
  11. TWC-3cx

    Joined:
    Aug 28, 2014
    Messages:
    13
    Likes Received:
    0
    Right.
    I think i fixed it. but am not 100% sure what the fix was.

    So i looked in the Backup.Zip > DbTables > CL_Calls.csv

    I saw 167006 records, of which some where from 2016.

    So i went to Call Report > Settings > Clear Call Logs
    And cleared out all calls from 2016 Jan to Dec.

    Went back to call logs - No Change
    Ran a test report - No Change

    Se went to Services and restarted 3CX PhoneSystem Database Server This caused "all" the 3cx services to want to restart.
    After everything had restarted Both Call log and Call Reports now had data for today.

    So i am not sure if the restart fixed it or the purge and restart fixed it.

    Should the system not have Warned me in some manner that the - logs were full - system had stopped logging calls?
     
  12. NickD_3CX

    NickD_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Jun 2, 2014
    Messages:
    1,344
    Likes Received:
    78
    To be honest 167.006 entries is far from what the DB can handle, so if I had to guess it was the restart, but again that should not have been necessary. In SP2 there has been an improvement to the DB that is used on the back-end which addresses some issues that existed. These were mainly focused around the creation of backups and not about the reports however.

    Please upgrade to V15.5 SP2 when it comes out officially (or go to the beta if you want) and please monitor this and report back if anything like this happens again.
     
Thread Status:
Not open for further replies.