Versions Compared

Key

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

Problem Statement

...

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

Image RemovedImage Added

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
a value >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.
Info

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