Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Slowness in Data retrievals from HFM

DarshanJJun 12 2019 — edited Jul 11 2019

Hi All,

We are on EPM 11.1.2.1 HFM

And suddenly from Feb, we noticed slowness during fetching data from HFM application.

Observations are as below : -

1) The Data retrievals from HFM are being very slow. Previously it would take only 1-2 Minutes It takes 8-9 mins to retrieve the data from all the entities and for all reports.

2) We started to see the slowness since beginning of Feb this year. Earlier it was not that bad. We think that Network is the bottleneck.

3) App server fetches at the speed of ~10 Mbps and the Total Bandwidth between those two servers is 10 Gbps. Not sure why it is not efficiently utilizing the bandwidth.

4) Our test environment also has the issue with SV refresh. We have already tried (two weeks ago) with Cache values (MinDataCacheSizeInMB). There was not much improvement.

5) How do we improve the transaction speed between HsvDataSource & DB especially for SV or Data grids refreshes?

6) Do you think the slowness might be due to accumulation of temp files or logs?

Thanks in Advance,

Darshan

Comments

Eric.Sacramento

User Interface Details

2019-04-29_9-34-34.png

User_EI49E

When I change 101 to LOGIN_DESKTOP I get

Sorry, this page isn't available

Application "30101" Page "LOGIN_DESKTOP" not found.

Contact your application administrator.

Eric.Sacramento

you probably deleted this pages, create another application and copy this page to your application.

User_EI49E

Yes, I deleted the new login page, but not the original 101. How do I set LOGIN_DESKTOP back to 101. Is that an application item? Thanks.

Pete

Eric.Sacramento

in the image that I sent to you, try to replace LOGIN_DESKTOP for the number of the page that you want

Neil Clare
Answer

LOGIN_DESKTOP is an alias to your login page.

When you create a new application (or new scheme) the logon page is automatically given that alias.

If you manually delete the page, then the alias does not point to anything.

All you have to do is manually add the alias back in to your original login page.

Capture.PNG

Marked as Answer by User_EI49E · Sep 27 2020
1 - 6