3015129 - "A runtime exception has occurred while trying to process the result set... Allocation failed" error when opening a Model in AO

When opening a model from SAC in Analysis for Office, the following exception/error occurs:

----------------------------------------------------------
A runtime exception has occurred while trying to process the result set.
The following messages are thrown:\nMessage 42014
Caught exception : exception 1000002: message not found
\$message\$=
message not found;exception 1000002:
ltt/impl/memory.cpp:89
Allocation failed ;
: calcEngine search on olapIndex failed.
----------------------------------------------------------

SAP BusinessObjects Analysis, edition for Microsoft Office

1. Start Analysis Office;
2. Insert Data Source;
3. Logon to SAC;
4. Open the SAC Model;
5. Confirm the exception/error "A runtime exception has occurred while trying to process the result set... Allocation failed";

The issue occurs because when opening the SAC Model in AO, the default selection is to have all Versions in the Columns and all Measures/Accounts in the Rows. This can be too much based on the Model's design.

In order to avoid the memory issue, the steps below can be followed:

1. In Analysis Office, click on "Pause Refresh" before inserting the SAC Model;
2. Insert the Model;
3. Apply the desired filters;
4. Click again on "Pause Refresh" to unpause the refresh.

inserting, running, import, imported, exception; 1000002; calcEngine search on olapIndex failed, memory , KBA , BI-RA-AO-XLA , Excel Addin , Problem