issue exporting call reports

General and Support topics relating to ViciDialNow and GoAutoDial ISO installers

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

issue exporting call reports

Postby Merchant007 » 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
VERSION: 2.12-548a
BUILD: 160331-2204
asterisk 11.21.0-vici
Revision:2504
Merchant007
 
Posts: 58
Joined: Sat Oct 03, 2015 11:34 am

Re: issue exporting call reports

Postby Twigster » 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.
Twigster
 
Posts: 11
Joined: Tue Oct 27, 2015 10:49 am

Re: issue exporting call reports

Postby Vince-0 » Tue Oct 27, 2015 2:51 pm

Check your web server error log.
Vince-0
 
Posts: 272
Joined: Fri Mar 02, 2012 4:27 pm
Location: South Africa

Re: issue exporting call reports

Postby Merchant007 » 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 ,
VERSION: 2.12-548a
BUILD: 160331-2204
asterisk 11.21.0-vici
Revision:2504
Merchant007
 
Posts: 58
Joined: Sat Oct 03, 2015 11:34 am

Re: issue exporting call reports

Postby Merchant007 » 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
VERSION: 2.12-548a
BUILD: 160331-2204
asterisk 11.21.0-vici
Revision:2504
Merchant007
 
Posts: 58
Joined: Sat Oct 03, 2015 11:34 am

Re: issue exporting call reports

Postby Vince-0 » 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.
Vince-0
 
Posts: 272
Joined: Fri Mar 02, 2012 4:27 pm
Location: South Africa

Re: issue exporting call reports

Postby Merchant007 » 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 ?
VERSION: 2.12-548a
BUILD: 160331-2204
asterisk 11.21.0-vici
Revision:2504
Merchant007
 
Posts: 58
Joined: Sat Oct 03, 2015 11:34 am

Re: issue exporting call reports

Postby Vince-0 » 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?
Vince-0
 
Posts: 272
Joined: Fri Mar 02, 2012 4:27 pm
Location: South Africa

Re: issue exporting call reports

Postby Merchant007 » 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
VERSION: 2.12-548a
BUILD: 160331-2204
asterisk 11.21.0-vici
Revision:2504
Merchant007
 
Posts: 58
Joined: Sat Oct 03, 2015 11:34 am

Re: issue exporting call reports

Postby Twigster » Fri Oct 30, 2015 12:54 pm

How long does it take to do a export for 2 days?
Twigster
 
Posts: 11
Joined: Tue Oct 27, 2015 10:49 am

Re: issue exporting call reports

Postby Merchant007 » Fri Oct 30, 2015 7:40 pm

few seconds , like 10-15 seconds , max 20
VERSION: 2.12-548a
BUILD: 160331-2204
asterisk 11.21.0-vici
Revision:2504
Merchant007
 
Posts: 58
Joined: Sat Oct 03, 2015 11:34 am


Return to ViciDialNow - GoAutoDial

Who is online

Users browsing this forum: No registered users and 40 guests