Problem Statement
This article will help you fix the Out of Memory issues that you may encounter when 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 for the first view, but if the page is viewed multiple times the outofmemory exception and the error message “unable to construct record” appears on the UI and in the logs. Then the system crashes.
Solution
When the size is set to a value >1 MB, the user may encounter unexpected errors while uploading an excel file.
- Make sure the excel file with the size is below <1MB
- Please refer to this Excel for Confluence document which highlights about Maximum xslx file size.
The Excel macro look for the excel file attached to the page(using Name of attachment parameter) or looks for 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.