If you are unable to create a new account, please email support@bspsoftware.com

 

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

Started by rodrigosborges, 05 Jul 2010 02:37:13 PM

Previous topic - Next topic

rodrigosborges

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