vicidial.org

ERSION: 2.12-555a
BUILD: 160508-1948
© 2016 ViciDial Group
Asterisk 1.8
Ubuntu Server 12.04.5 LTS 64bit

HI guys i would like to ask regarding generating Report for a longer period like time Range of August 01 -31 (A Month), and im getting the this page isn't Working and timeout. tried several times. I can only generate up to 3 days as per checking and i can download it. the report is Export call Reporting and Leads call Reporting.

Any idea guys

You might need to raise the php.ini timeout variables and restart apache on your webserver.

@Matt,

max_input_time = 360
max_execution_time = 630
memory_limit = 128M
post_max_size = 48M
upload_max_filesize= 42M
default_socket_timeout = 360

And this are my data on my vicidial list : Rows_examined: 12607094

Any suggestion Matt what to do somehow..?

Adjusted further to this:

max_input_time = 360
max_execution_time = 3600
memory_limit = 128M
post_max_size = 400M
upload_max_filesize= 42M
default_socket_timeout = 360

Still page gets timeout, what could i do further more..? any help

That report for over 12 million records could take hours to process. You have the limit set to 1 hour, so I'd say raise that quite a bit and see if it will load. You also might need to raise the memory limit.

@Matt,

When you say this:

'You have the limit set to 1 hour'

You mean the max_execution_time..?

Code: Select all

tail -20 /var/log/apache2/error_log

Check your apache error log and see what error it is tossing, this should tell you specifically what value you need to increase (or bug you need to fix).

@William

The Report is now loading somehow, after i made adjustment on my php.ini, im able to generate 1 month Report with this config:

max_input_time = 360
max_execution_time = 3600
memory_limit = 512M
post_max_size = 800M
upload_max_filesize = 64M

Excellent postback! Kudos