vicidial.org

Posted: **Mon Oct 26, 2015 5:46 am**

Goautodial 3.3 -fully updated via yum
VERSION: 2.9-441a
BUILD: 140612-1628

Sir , i am trying to Export Calls Report but when i try exporting like more than 2 days i am getting "Server Error 500" so temporary solution i found is manually export Report for every 2 days like if i want to export Export Calls Report for last month i need to export like 1 to 2nd , then 2nd to 3rd

Posted: **Tue Oct 27, 2015 10:55 am**

Hi,

I think the problem you are getting is that the max php execution time is too short and the download limit is too low.

Posted: **Tue Oct 27, 2015 2:51 pm**

Check your web server error log.

Posted: **Wed Oct 28, 2015 2:10 am**

Twigster wrote:Hi,

I think the problem you are getting is that the max php execution time is too short and the download limit is too low.

my current setting is default

max_execution_time = 600 ; Maximum execution time of each script, in seconds
max_input_time = 360 ; Maximum amount of time each script may spend parsing request data
;max_input_nesting_level = 64 ; Maximum input variable nesting level
memory_limit = 64M ; Maximum amount of memory a script may consume (16MB)

; Default timeout for socket based streams (seconds)
default_socket_timeout = 360

per day max call will be like 5k max , so 5k x 30 =150k numbers ,

Posted: **Wed Oct 28, 2015 4:31 am**

Vince-0 wrote:Check your web server error log.

Code: Select all: [Tue Oct 27 20:11:13 2015] [notice] caught SIGTERM, shutting down [Wed Oct 28 08:52:01 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) [Wed Oct 28 08:52:01 2015] [notice] SSL FIPS mode disabled [Wed Oct 28 08:52:01 2015] [notice] Digest: generating secret for digest authentication ... [Wed Oct 28 08:52:01 2015] [notice] Digest: done [Wed Oct 28 08:52:02 2015] [notice] SSL FIPS mode disabled [Wed Oct 28 08:52:02 2015] [notice] Apache/2.2.3 (CentOS) configured -- resuming normal operations [Wed Oct 28 09:32:32 2015] [notice] caught SIGTERM, shutting down [Wed Oct 28 09:34:36 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) [Wed Oct 28 09:34:36 2015] [notice] SSL FIPS mode disabled [Wed Oct 28 09:34:36 2015] [notice] Digest: generating secret for digest authentication ... [Wed Oct 28 09:34:36 2015] [notice] Digest: done [Wed Oct 28 09:34:37 2015] [notice] SSL FIPS mode disabled [Wed Oct 28 09:34:37 2015] [notice] Apache/2.2.3 (CentOS) configured -- resuming normal operations sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied sh: vitals.st: Permission denied

Posted: **Wed Oct 28, 2015 4:36 am**

Is that log from the same time your pulled a report that failed?

I have no idea what vitals.st is, it must be GoAuto specific.

Posted: **Thu Oct 29, 2015 11:11 am**

Vince-0 wrote:Is that log from the same time your pulled a report that failed?

I have no idea what vitals.st is, it must be GoAuto specific.

yes, mostly it shows permission denied , i tried searching for that file , it was related to goautodial

Today i tried Exporting LEad details from 1st to today , faced same issue so i tried narrowing export details , when i select only few filter like "NA" instead of selecting all option NA,DC,etc i was able to export
lead details , so i think its might b due to some issues when exporting large numbers, apart from httd log is there any Asterisk log or mysql log i can check ?

Posted: **Thu Oct 29, 2015 11:16 am**

No other logs that I can think of.

You could make your apache settings much bigger because these are usually what prevent large exports but there is no indication of errors for those variables in your error log so I don't really know.

Perhaps the query is taking long for your database server settings and timing out or something?

Posted: **Thu Oct 29, 2015 11:58 am**

it mayb , we are using Intel Dual core CPU ( goautodial usage shows below 50% most of time)
Ram 4GB , usage 98 -99% ( 75 % cache)
Swap - 10-15 MB
using all in one setup

Posted: **Fri Oct 30, 2015 12:54 pm**

How long does it take to do a export for 2 days?

Posted: **Fri Oct 30, 2015 7:40 pm**

few seconds , like 10-15 seconds , max 20

vicidial.org

issue exporting call reports

issue exporting call reports

Re: issue exporting call reports

Re: issue exporting call reports

Re: issue exporting call reports

Re: issue exporting call reports

Re: issue exporting call reports

Re: issue exporting call reports

Re: issue exporting call reports

Re: issue exporting call reports

Re: issue exporting call reports

Re: issue exporting call reports