Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-13138

reports: unable to generate PDF/CSV when there are a large number of searchable fields

    Details

    • Type: Bug
    • Status: Won't Do
    • Priority: Major
    • Resolution: Won't Do
    • Affects Version/s: 4.3.5
    • Fix Version/s: Unscheduled
    • Component/s: CiviReport
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)

      Description

      It appears that if an installation has a large number of custom fields that are flagged as searchable, you will reach a point where reports may not generate PDF/CSV exports.

      I though the issue was that we store ALL of the report's criteria/filter fields as a serialized array in the form_values column. That column is a TEXT type field, and consequently if our serialized value exceeds the max size, it is truncated, which would cause problems. However, increasing the form_values column type doesn't fix the issue. So there is something else going on as well, but I've been unable to determine what.

      FYI –
      It definitely relates to the volume of custom fields. If I disable a few groups the PDF/CSV generation will start working again.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lcdweb Brian Shaughnessy
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: