Versions Compared

Key

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

...

Problem statement

This article helps in fixing the the Out of Memory issues that issues that you may encounter while viewing a Confluence page which includes Excel macro.

Error

...

message

Image Modified

Log

...

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

Environment

ApplicationConfluence
Version6.13.4
AppExcel for Confluence
App Version6.8.0

Cause

...

bgColor#f9ecc5

...

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 the below points:

  • 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.
Info

The An Excel macro look looks for the excel file attached to the page (using using Name of attachment parameter parameter) or a file path (Name of attachment in the path) located in <confluence in <confluence home directory>/script/directory. But it does not look You may not find the file within the <confluence home directory>/temp/directory path.