VICIPanel
Troubleshooting/Report times out loading
MediumDatabase

Report times out loading

Running a report (especially on large date ranges) times out before returning data.

Symptoms

  • •Report page hangs then returns connection timeout
  • •PHP error log shows `max_execution_time` exceeded
  • •Smaller date ranges work fine

Common causes

  • •Missing indexes on CDR tables at scale
  • •Report query pulling full table into memory
  • •PHP max_execution_time too short for the query

How to fix it

  1. 1
    Run `EXPLAIN` on the report query to identify missing indexes
  2. 2
    Add indexes for commonly-filtered columns (campaign_id, call_date, status)
  3. 3
    Increase PHP max_execution_time in php.ini
  4. 4
    Archive older CDR data to a separate table
Database health and operational view in VICIPanel
How VICIPanel helps

VICIPanel reports run against pre-aggregated summary tables so even multi-year date ranges return in under 2 seconds. Raw CDR queries stay fast because we index intelligently.

Related issues

More Database errors

Database connection lost

VICIdial cannot reach MySQL/MariaDB, everything stops.

Lead list not loading to hopper

Imported list exists but leads never appear in the hopper for dialing.

Callback not firing at scheduled time

Scheduled callback is set but never re-enters the hopper at the expected time.

Time synchronization error

Server clock drift is causing auth failures, SSL issues, or report inconsistencies.

Stop troubleshooting. Start operating.

VICIPanel's health dashboard catches most of these issues before they impact your agents — with plain-English diagnostics and one-click remediation.

Try the live demoError reference