issue exporting call reports

[Merchant007]

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

[Twigster]

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.

[Vince-0]

Check your web server error log.

[Merchant007]

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 ,

[Merchant007]

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


[Vince-0]

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.

[Merchant007]

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 ?

[Vince-0]

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?

[Merchant007]

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

[Twigster]

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

[Merchant007]

few seconds , like 10-15 seconds , max 20