My Oracle Support Banner

Unable to Compact an Aggregate Storage (ASO) Outline. May Get "Error compacting Outline Paging File //Hyperion/AnalyticServices/app/appname/dbname/dbname.otl." (Doc ID 1291128.1)

Last updated on AUGUST 09, 2023

Applies to:

Hyperion Essbase - Version 7.1.2.0.00 to 11.1.2.2.000 [Release 7.1 to 11.1]
Information in this document applies to any platform.
This knowledge document is a replacement for Documents 1072289.1, 600925.1, 1065992.1, 781456.1, 1150715.1, 1088001.1, which have been deleted.

Symptoms

When deleting members from an ASO outline and restructuring the outline the outline file size grows.

When trying to compact the outline using Essbase Administration Services (EAS) or MaxL, the outline does not compact completely.

You have tried to compact the outline by doing the following:

1. Using EAS to compact the outline, by right-clicking on the outline and select Compact.

2. Using MaxL to compact the outline, by using the following command:

You may also see the following error if the outline was built on a Windows machine and then saved onto a Unix Essbase Server:

"Error compacting Outline Paging File //Hyperion/AnalyticServices/app/xxx/xxx/xxx.otl. Compacted and original outline byte order do not match. Please compact it where it was created."

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.