Q0019 – Excel report is shown as partial even though content rows are less than the maximum rows available in excel

Summary

When executing an excel report in AC or UM the report return with a partial result even though it has now used all available rows in the excel sheet.

The error occurs due to the server running out of memory while executing the report. This can occur as a result of the server not being equipped with enough RAM, and when the paging file is not large enough and the server is unable to extend the paging file during runtime.

There are two resolutions to this problem

Solution a

Extend the amount or RAM available in the server

1. Add more RAM to server
2. In the configuration file “apm.ini“, change the value of the parameter “resources.java.memory“ to <RAM in server> – 4GB
3. In the configuration file “php.ini“, change the value of the parameter “memory_limit” to <RAM in server> – 2GB
4. Restart the apache service

---

Solution b

Change the way the paging file is handled in the system. If the paging file is maintain by the OS, then perhaps assign a large value manually instead to ensure the paging file is large enough.

It you encounter this type of problem it is advised that you equip your server with 32 GB ram or above.