11. Limitations

Limitations when using the application.

 

Template File Limitations

Template Layout

Not all layouts and output patterns are supported. Complex layouts are not supported. Check with your templates and output contents in the Sandbox.

 

Template File Size

Template file size should not exceed 1 MB. The Office file consists of multiple XML files, compressed in a ZIP file, and the file size limit before compression is 4 MB.

 

Application for Creating Templates

  • Template files should be created in the Microsoft Office desktop version.
  • Templates created in other applications such as online version, Google Spreadsheet, Google Docs, etc. are not supported.

 

Office Features

    Office features are not supported. Some Office features are available, but not all templates are supported. Complex patterns are not supported.

     

    Available Office Features

    File Type Details
    Excel Excel Formulas, Data Validation, Conditional Formatting, Table, and Shapes are available.
    Word Table, Text Box, Watermark, Shapes and Field Codes are available.
    PowerPoint Table, Text Box and Shapes are available.
    PDF Table is available.

    *Text Box, Watermark, Shapes and Field Codes are not available.

    *Tables are for layout only, excluding aggregate functions.

     

    Notes on available Office features

    • Not all templates are supported. Complex patterns are not supported.
    • When opening the file, if the message "We found a problem with some content in 'XXX.xlsx'. Do you want us to try to recover as much as we can?" or other error messages, remove the Office features in the template.
    • Office features are outside the scope of support. Check with your templates and output contents in the Sandbox.

     

     

    Salesforce Governor Limits

    The following are the main limitations that may conflict with Salesforce limitations when using the application

     

    Major Limitations

    Type Limit Value
    Apex Governor Limits Total heap size 6 MB
    Maximum CPU time on the Salesforce servers 10,000 milliseconds（10 seconds）
    Visualforce Limits Maximum size of HTML response before rendering, when Visualforce page is rendered as PDF Less than 15 MB
    Maximum PDF file size for a Visualforce page rendered as a PDF 60 MB
    Maximum total size of all images included in a Visualforce page rendered as a PDF 30 MB

     

    Examples of Violation of Limitations

    • Template file size exceeds 1 MB.
    • Template contains high quality images.
    • Template or record value contains a large number of characters (the number of characters includes the XML tags that consist the file).

     

    Reference

    Apex Governor Limits

    Visualforce Limits

     

     

    Salesforce Subquery Limitations

    If the child records contain Long text Area/Rich Text Area merge fields, the subquery limitation of Salesforce is applied.

    • If the template contains Long Text Area/Rich Text Area merge fields of the child object, the maximum number of child records is approximately 50-200 records.
    • The maximum number of records depends on the length of the fields and the number of fields.
    • The limit is applied when Long Text Area/Rich Text Area fields are included, regardless of the number of characters in the record value.
    • If the upper limit is exceeded, the output process is aborted, and an error message "Aggregate query has too many rows for direct assignment" is displayed.

     

    Salesforce Help

    Aggregate query has too many rows for direct assignment but less than 200 rows

    *The application cannot be avoided by using For Loop as described in the Salesforce Help due to the various processes.

     

    Workaround

    • Use Advanced Relationship Settings. When using advanced relationship settings, child objects are not retrieved in a subquery, so subquery restrictions do not apply. (OFC Pro feature)
    • Limit the maximum number of child records output. (OFC Pro feature)
    • Set output conditions for child records and output them multiple times.

     

    Reference

    Advanced Relationship Settings

    Settings Minimum/Maximum Number of Child Records

    Filter Output Conditions for Child Records

     

     

    Object/Field/Record Number Limitations

    Limitations on file output. Output is possible within Salesforce limits, such as governor limits.

     

    Type Limitations
    Number of Merge fields There is no limit on the number of merge fields in the application.
    Number of child objects

    (Related object）

    		 There is no limit on the number of objects in the application.
    Number of child records There is no limit on the number of records in the application.

    *If the child records contain Long text Area/Rich Text Area merge fields, the subquery limitation of Salesforce is applied.
    Number of Bulk Output Files There is no limit to the number of batch file outputs in the application. There is no governor limit based on the number of outputs since transactions are split per file.
    Image Record Limitations

    (OFC Pro)
    • The maximum file size limit for one image is 4.28 MB.
    • There is no limit to the number of images output per file.
    • If the total size of images exceeds 4.28 MB, they will be split up to 4.28 MB per transaction and will not violate Salesforce's heap size and CPU time governor limits.
    • Output time is proportional to the total size of the image. If the total image size exceeds 10 MB, it will take several tens of seconds.

     

    Approximate maximum number of child records

    The approximate maximum number of child records verified in the sample template output is 480 records. The maximum number of child records varies depending on the template, record values, and number of fields, so check with your template and output content in the Sandbox.

     

    Maximum number of child records (Sample template: Word)

    Number of Child Record Results
    480 records Success
    490 records Heap size governor limit errors occurred.