Export calls report unable to export

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Export calls report unable to export

Postby dhijrwn » Wed Aug 24, 2022 11:39 am

Hi, we are facing this issue when exporting call logs in the export calls report.
What I know that we have so many calls per day and if we extracted 1 month or 3 months, it will fail, timeout returns 500 status.

Variables and filters:
We are averaging 700k outbound calls on this month of august.
Total leads: 7764195
Campaign: 1 campaign
Inbound groups: inbound groups related to the selected campaign
List: All lists (165 lists)
Status: All
User Group: All
Cluster setup i7-9700 cpu @ 3.00ghz 32GB ram 1xDB WEB ARCH 11xTEL 4core
ViciBox v.9.0.3 ISO VERSION:2.14-853a BUILD: 220328-1420
SVN: 3595 DB Schema: 1657 | Asterisk 13.29.2-vici
Zoiper 5 | VICIPhone| No Digium/Sangoma Hardware
dhijrwn
 
Posts: 149
Joined: Tue Jan 07, 2020 6:12 am

Re: Export calls report unable to export

Postby carpenox » Mon Aug 29, 2022 9:51 pm

try adding this to the bottom of your /etc/php.ini

error_reporting = E_ALL & ~E_NOTICE
memory_limit = 448M
short_open_tag = On
max_execution_time = 6330
max_input_time = 3360
post_max_size = 448M
upload_max_filesize = 442M
default_socket_timeout = 6360
date.timezone = America/New_York


hope this helps

Chris
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: Export calls report unable to export

Postby dhijrwn » Tue Aug 30, 2022 1:51 am

carpenox wrote:try adding this to the bottom of your /etc/php.ini

error_reporting = E_ALL & ~E_NOTICE
memory_limit = 448M
short_open_tag = On
max_execution_time = 6330
max_input_time = 3360
post_max_size = 448M
upload_max_filesize = 442M
default_socket_timeout = 6360
date.timezone = America/New_York


hope this helps

Chris


Hi Nox, It works but needed to modified the memory_limit to 8000MB. Thank you.
Cluster setup i7-9700 cpu @ 3.00ghz 32GB ram 1xDB WEB ARCH 11xTEL 4core
ViciBox v.9.0.3 ISO VERSION:2.14-853a BUILD: 220328-1420
SVN: 3595 DB Schema: 1657 | Asterisk 13.29.2-vici
Zoiper 5 | VICIPhone| No Digium/Sangoma Hardware
dhijrwn
 
Posts: 149
Joined: Tue Jan 07, 2020 6:12 am

Re: Export calls report unable to export

Postby carpenox » Tue Aug 30, 2022 3:52 am

no problem bro, glad to help, imn the future check out my blog at http://vicidial.blog - it handles most issues people have on here
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: Export calls report unable to export

Postby dhijrwn » Tue Aug 30, 2022 1:12 pm

carpenox wrote:no problem bro, glad to help, imn the future check out my blog at http://vicidial.blog - it handles most issues people have on here


When I open the text file copied the content and pasted it to excel, it only contains 1million+ records? I'm expecting it to be 15 millions+ of call logs.
Cluster setup i7-9700 cpu @ 3.00ghz 32GB ram 1xDB WEB ARCH 11xTEL 4core
ViciBox v.9.0.3 ISO VERSION:2.14-853a BUILD: 220328-1420
SVN: 3595 DB Schema: 1657 | Asterisk 13.29.2-vici
Zoiper 5 | VICIPhone| No Digium/Sangoma Hardware
dhijrwn
 
Posts: 149
Joined: Tue Jan 07, 2020 6:12 am

Re: Export calls report unable to export

Postby carpenox » Sat Sep 03, 2022 1:22 am

try increasing the memory_limit
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL


Return to Support

Who is online

Users browsing this forum: No registered users and 87 guests