cl_calls.csv not updating

[cloudland_nz]

Hey Guys,

We've noticed that our cl_calls.csv backup isn't updating, often falling several weeks behind. All other CSV files are current.

I've reviewed the audit and event logs around the times it stopped updating but haven't found any errors or relevant changes.

• The cl_calls.csv file itself is approximately 103 MB.
• 8.1GB of disk space left on the host.
• Call log currently 587.50 MB

I see an option to optimise the database but want to get some more info before moving forward. Any help appreciated.

Cheers,

Brad

 

[paulodagraca]

Hello @cloudland_nz ,

When did you update to Version 20.0 Update 6?

Paulo

 

[cloudland_nz]

Hey Paulo,

Last cl_calls entry is July 2nd 0836 AM
Update 6 was July 3rd at 0148 AM

 

[edossantos_sipcaller]

Hello,

Since 3CX v20 U6, the CDR format has changed. Now 3CX will not populate anymore the cl_calls and related tables. Instead there is a new table in the database to store CDRs from end to end, in a single record per call.

 

[edossantos_sipcaller]

Check this:
https://www.3cx.com/blog/releases/v20-u6-cdr-output/

 

[cloudland_nz]

Awesome, thanks Ernesto. I'll have a look through the notes now.

Brad