We have received support tickets for clients using Magento as their shopping cart software who receive exporting errors when exporting large amounts of data using Magento Mass Export Tool.

The common error is: “Internal server error” or “500 Internal Server Error”

when you try to export large number of item from the Magento admin area the server requires a lot of time to process all this data.

For this particular client they had over 10,000 products.

The first place to check is the apache error logs, this should shed some reason for the Internal Server Error.

LOGS:
[warn] [client xx.xx.xx.xx] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server,
[error] [client xx.xx.xx.xx] Premature end of script headers: index.php, referer: http://domain-name.com.au/index.php/admin/system_convert_gui/edit/id/1/key/b5d2b7970a07e989016674fd9a84687c/

REASON:
If you see something like above then it’s due to phpfastcgi timeout.

SOLUTION:
So the solution for this is to increase the timeout values. You should add below lines to your php config file or change the existing values if they exist: /usr/local/apache/conf/php.conf and restart the apache for the settings to take effect.

FcgidMaxRequestLen 1073741824
IdleTimeout 1800
BusyTimeout 1800
ProcessLifeTime 7200
IPCConnectTimeout 1800
IPCCommTimeout 7200
FcgidMaxRequestLen 1073741824
FcgidBusyTimeout 10800
FcgidIOTimeout 1800
FcgidProcessLifeTime 10800
FcgidIdleTimeout 10800
FcgidConnectTimeout 60
FcgidIdleScanInterval 300
FcgidBusyScanInterval 300
FcgidZombieScanInterval 60

If are hosting with Nerdster, please contact our support team who can manage this for you.

Tagged:

Leave a Reply