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 JULY 29, 2016

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.
***Checked for relevance on 24-Jul-2012***

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:

alter database appname.dbname compact outline;

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms