MediaCP Manual
    1. Getting Started
    2. Sales Questions
    3. Frequently Asked Questions
    4. Transcoder System Benchmarks
    5. Start your own streaming platform
    1. Change account currency
    2. Product Licensing
    1. Introduction
    2. Installation & Upgrade
      1. System Requirements
      2. Versions & Releases
      3. Installation
      4. Upgrading
      5. Streaming Servers
        1. Nginx-Rtmp Video Server
        2. Wowza Streaming Engine
        3. Flussonic Media Server
        4. Video Feature Comparison
        5. Icecast 2 / Icecast KH
      6. SSL Certificates
    3. Billing Integration
      1. WHMCS Integration Guide
      2. Clientexec Integration Guide
      3. Blesta Integration Guide
    4. Migrate from other software
      1. Migrate from Centovacast
    5. Backup & Restoration
      1. Backup MediaCP
      2. Restore MediaCP
      3. Transfer to another server
    6. Administration
      1. Custom Web Service Configurations
      2. Reset Admin Password
      3. Port 80 / 443 Proxy
      4. MediaCP System Commands
      5. Change MediaCP domain name
      6. Move media to another hard disk
      7. Secure your server
      8. Troubleshooting Login Errors
      9. Custom Facebook App
    7. Scaling
      1. Scale with Wowza and CloudFront CDN
      2. Nginx-Rtmp with CloudFront CDN
    8. Troubleshooting
      1. Grant access to support team
      2. Troubleshooting Wowza Streaming Engine
      3. FTP Troubleshooting
      4. MySQL Database Troubleshooting
      5. Reporting Troubleshooting
      6. Troubleshooting Liquidsoap AutoDJ
      7. Video Relay Troubleshooting
    1. Introduction
    2. Administrators Dashboard
    3. System Configuration
      1. General
      2. Services
      3. Video Players
      4. Albums
      5. Email
      6. Plugins
      7. Statistics
      8. Backups
      9. Custom HTML
      10. Misc
    4. Customer Accounts
      1. Managing existing Customers
      2. Create a new Customer
      3. Deleting a Customer
      4. Login as another Customer
      5. Send email to Customer
      6. Reset Customer Password
    5. Reseller Accounts
      1. Reseller Plans
      2. Create a Reseller Account
    6. Media Services
      1. Creating a Media Service
      2. Deleting a Media Service
    7. Announcements
      1. Managing Announcements
      2. Creating Announcement
      3. Deleting Announcement
    8. Statistics
    9. Software Health
    10. Software Updates
    11. Email Templates
    12. API
    1. Introduction
    2. Audio Operation Manual
      1. Basics 101
      2. Station Overview
      3. Media Library
      4. Playlists
        1. General Rotation
        2. Jingles & Advertising
        3. Scheduling
        4. Repeat Protection
      5. Live DJ Connections
      6. Live Stream Recording
      7. DJ Manager
      8. Country Blocking
      9. Stream Proxy
      10. Widgets & Links
      11. Reporting
    3. Reseller Operations Manual
      1. Reseller Dashboard
      2. Customers
      3. Media Services
    1. API Documentation
    2. Custom Domain Names
    3. Shoutcast 2 Admin Guide
    4. Wowza and Flussonic on same system
    5. Submit a feature request
    6. Wowza Custom Properties
    1. Shoutcast 2 Live Broadcasting
    2. DJ Priorities
    3. HTML5 Audio Player
    4. Broadcasting with AutoDJ
    5. Shoutcast 2 Premium
    6. Mount Points
    1. Getting started with video streaming
    2. Live Streaming Overview
    3. TV Station Overview
    4. Ondemand Video Streaming
    5. Relay & IP Camera
    6. GeoIP Country Locking
    7. VAST Advertising
    8. Stream Recording
    9. Connecting your encoder
    10. Managing your media files
    11. Understanding Video Playlists
    12. Embedding player on your website
    13. Smooth Streaming and Content Transition
    14. Video Transcoding (Adaptive Bitrate Streaming)
    15. Image Logo or Watermark Overlay on Video Stream
    16. DVR Rewind
    17. Statistics
    18. Facebook Live Streaming
    19. Youtube Stream Publishing
    20. Twitch Stream Publishing
    21. Shoutcast 2 Stream Publishing
    22. Icecast Stream Publishing
    23. RTMP Stream Publishing
    1. Cloud Video Overview
    2. Admin Manual - Cloud Video
      1. Login to your cloud platform
      2. Dashboard - A First Look
      3. Branding your platform
      4. Team & Staff Members
      5. Plans & Customers
      6. WHMCS Billing Provisioning Module
      7. Activating VOD on Customer Plan
    3. User Manual - Cloud Video
      1. Login to your video platform
      2. First Look
      3. Creating a Channel
      4. Channel Overview
      5. Broadcasting
      6. Recording
      7. Fallback Video
      8. TV Channels - 24x7 UGC
      9. Video on Demand
      10. VOD Playlists
      11. Publishing
      12. Viewing Analytics
      13. Publish Zoom Meetings
      14. Advertising
      15. Restreaming IP Cameras
    4. Video Guide Series
    5. Streaming Best Practices
    6. Feature Comparison
    7. Roadmap & Release Notes
Reporting Troubleshooting

Last updated 8 months ago

Downloading of report shows error or times out

If you receive an error such as “An error has occured” or similar when attempting to download the CSV file of a report, it is likely due to the request taking too long to process. The error occurs when there is a lot of records in the database and it is unable to extract the records within the default timeout of 30 seconds.

There are some solutions to this problem:

  1. The cause is limited read performance on the disk, increasing disk performance by using a Raid with SSD or NVMe is a more permanent solution.
  2. Disabling Advanced Reporting on some services can also help to reduce the amount of records, especially services with lots of active listeners/viewers.
  3. Increase PHP Timeout to 300 seconds (5 minutes) to prevent the page to timeout:
    echo "max_execution_time = 300" > /usr/local/mediacp/php/php.d/custom.ini; mediacp restart php;
  4. Increase nginx timeouts by adding the following in the http{} block of /usr/local/mediacp/nginx/conf/nginx.conf after the line containing fastcgi_cache_key
    fastcgi_read_timeout 600;
    fastcgi_send_timeout 600;
    fastcgi_connect_timeout 600;
    proxy_connect_timeout 600s;
    proxy_send_timeout 600s;
    proxy_read_timeout 600s;
    
  5. Restart nginx
    mediacp restart nginx

Table of Contents