Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 Message

Image RemovedImage Added

Log Entries Entries

Code Block
themeMidnight
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

...

ApplicationConfluence
Version6.13.4
AppExcel for Confluence
App Version6.8.0

Cause

Panel
bgColor#f9ecc5

 The The content of the excel file is displayed whenever the page is viewed for the first view, but if time. If the page is viewed multiple times the , outofmemory exception and the occurs. An error message “unable to construct record” appears on the UI and in the logs . Then the system crashes.

...

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:

  1. Make sure the excel file with the size is below <1MBless than 1 MB.
  2. Please refer to this document on Excel for Confluence document Configuration, which highlights about the Maximum xslx file  file size.
Info

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 . But it does not look within the <confluence home directory>/temp/directory.

...