How to troubleshoot out of memory issues when an excel macro is loading

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

Cause

The excel file content 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 with the logs: Unable to construct record. There may be a possibility of an instance crash.

When the size is set to >1 MB, the user may encounter unexpected errors while uploading an excel file.

Solution

Refer to:

• Make sure the excel file size is less than 1 MB.
• Refer to this document on Excel for Confluence Configuration, which highlights the Maximum file size.