dqwdkq

Hi all,

Need your valuable assistance,

This report has been working since 3 years but suddenly the report is not working at top level entity and it's running forever ..I have increased hardware resource and bumped registry as per Oracle HFM tuning guide recommendations but still we are experiencing the issue. In the log, the below memory utilizations parameter and  registries  setup....I have raised an SR 2 months ago but no response from them hence I posting here..

Registry Settings: LogDebugInfo = 0; SQLCommandTimeout = 60; EnableEntireCubeReloading = 0; NumMinutesBeforeCheckingLRU = 15; MaxNumCubesInTemporaryCache = 100; NumCubesLoadedBeforeCheckingLRU = 100;

UseOldAlgorithmForFreeLRU = 1; MaxNumCubesInRAM = 500000; MaxNumDataRecordsInRAM = 30000000; MaxNumDataRecordsInRAMForConsol = 500000; MultiThreadDataload = 1; FilterInvalidRecords = 1; MultiThreadCalcStatus = 0; MaxNumRecordsInCalcStatusCache = 1000; UseSQLBinding = 1; NumEAThreads = 4; NumConsolidationThreads = 8; NumVBScriptEngines = 32; MaxNumConcurrentConsolidations = 8; EnableRulesCaching = 1; seRecursiveUnlock = 1; UseServerSideCursorForAuditExtract=1; MaxCubeUpdateThreadWaitInSeconds=900; SubCubeProgressUnits = 10; CSUseSQLBinding=Yes; MaxNumCommitThreads=8; UseClientSideCursors=0; ADODefCacheSize=100; ADOSmallCacheSize=10; ADOLargeCacheSize=1000