Problem Statement
This article helps in fixing the Out of Memory issues that you may encounter while viewing a Confluence page which includes Excel macro.
Error Message
Log Entries
2020-03-03 15:03:51,100 ERROR [http-nio-8080-exec-101 url:/confluence/pages/viewpage.action username:user2] [swift.confluence.excel.ExcelMacro] execute Unable to construct record instance -- url: /confluence/pages/viewpage.action | page: 290851108 | traceId: 76e3d8df88ab0fdb | userName: user2 | referer: https://example.com/confluence/display/<Space key>/<page name> | action: viewpage
Environment
| Application | Confluence |
|---|---|
| Version | 6.13.4 |
| App | Excel for Confluence |
| App Version | 6.8.0 |
Cause
The content of the excel file is displayed whenever the page is viewed for the first time. If the page is viewed multiple times, outofmemory exception occurs. An error message appears on the UI and in the logs as well: Unable to construct record. There may be a possibility of the instance crash.
When the size is set to >1 MB, the user may encounter unexpected errors while uploading an excel file.
Solution
Refer to the below points:
- Make sure the excel file with the size is less than 1 MB.
- Please refer to this document on Excel for Confluence Configuration, which highlights the Maximum file size.
The Excel macro look for the excel file attached to the page (using Name of attachment parameter) or a file path (Name of attachment in the path) located in <confluence home directory>/script/directory. But it does not look within the <confluence home directory>/temp/directory.