ERROR ON RECONCILE (out of memory) AND CONFIGURATION OF IMPORT DATA FROM IM

Legacy Cognos Products Cognos 8 Planning
1

Published the same topic on another forum but as there are apparently few
Experts in Planning :frowning: (at least in the forums) I’ll ask here too.

I have a application with the settings:
Number of Cubes: 1
Number of D-Link: 0
Number of cells per eList: 2.479.815
Elist itens: 964
The biggest Dimension have 1413 itens.

Table IM has about 63 million records.

Two points:
In the import process (PREPARE IMPORT) need to know if there are any
calculation to get the best configuration settings for imports.
For example, the PARALLEL = TRUE parameter should be placed? (I have a
environment with 48 processor cores). BINDSIZE, how to get the best
value?
And IMPORT_BLOCK_SIZE, must change the default value? -1?

Second:
In GTP (Reconcile), after a while the job cancels with the message Out Of Memory.

The error description is:
Unable to write data item is e.list (GUID) (E.list item name) using ‘epRT_ v.AdminServer.WriteReconcileData%’

Out of memory

Noting the server during the reconcile realized that the error occurs when the process epPlanningService exceeds the maximum allowed memory for the Java (1536 Mb).
I am limiting the number of processor cores spread over 3 to 24 servers (8 each).
Is there any way to avoid these errors without further reduce the number of Jobs parallels?

Thanks

2

Reduce the size of the application by following the Contributor Admin Guide.
An alternative is to reduce maximum concurrent job for the job server. (from -1 to half of the available cores on the server).
If reducing maximum concurrent job doesn’t solve it, then reduce the size of the application.
Steps:

  1. Open CAC, expand Job Server Clusters, , Job Servers, ;.
  2. Right-click the server and select Properties.
  3. Change ‘Maximum concurrent job’ from -1 to half of the available cores on the server.
  4. Run GTP again.

and wait… :-\