REPORT WHITE PAGE

[ruben23]

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

[mflorell]

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

[ruben23]

@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..?

[ruben23]

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

[mflorell]

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.

[ruben23]

@Matt,

When you say this:

'You have the limit set to 1 hour'

You mean the max_execution_time..?

[williamconley]

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).

[ruben23]

@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

[williamconley]

Excellent postback! Kudos