4 Replies Latest reply on Jul 11, 2019 3:57 PM by iArchSolutions-Joe

Slowness in Data retrievals from HFM

DarshanJ Jun 12, 2019 3:33 PM

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

1. Re: Slowness in Data retrievals from HFM

Madhusudhan. M Jun 13, 2019 2:37 AM (in response to DarshanJ)

Check out DB server/Schema space and server performance once.

Try to clear temp files and cache from managed servers and try retrievals once.

Thanks,
Mady
Like Show 0 Likes(0)

Actions
2. Re: Slowness in Data retrievals from HFM

DarshanJ Jun 16, 2019 4:17 PM (in response to Madhusudhan. M)

Hi Mady,

Thanks fot the reply,

Let me check schema space in DB.
We have tried to clear temp file but still we are facing issue.

Thanks,
Darshan
Like Show 0 Likes(0)

Actions
3. Re: Slowness in Data retrievals from HFM

DarshanJ Jun 17, 2019 1:29 PM (in response to DarshanJ)

Hi Mady,

Our DB team always monitors the schema space, but how much space is recommended?

Thanks,
Darshan
Like Show 0 Likes(0)

Actions
4. Re: Slowness in Data retrievals from HFM

iArchSolutions-Joe Jul 11, 2019 3:57 PM (in response to DarshanJ)

DarshanJ - Hi Darshan - Diagnosing performance changes is always a tricky one. To start you should make sure you don't have any obvious issues in your way with testing performance. To start, I would look at the database indexes - ensure all is good there, maybe reindex if needed. Also - take a look at the HFM Error log, data-audit and task_audit tables in the DB - do some truncating/purging if needed. Once you do these little cleanup tasks, do some more testing and let us know the results, good/bad/ugly. I always advise to have client's do cleanup when the system its cold so schedule and outage, take good backups of everything and then cleanup and retest.

Again: Don't forget to always backup EVERYTHING before deleting or changing anything.

You can use the HFMEventViewer utility to cleanup the file system based event log and the database stored event/error log tables:

Oracle Support Document 1084998.1 (How to Extract Hyperion Financial Management (HFM) ErrorLog Entries from Database Using HFMErrorLogViewer.exe) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1084998.1

Here's a little link to an Oracle housekeeping article.

https://blogs.oracle.com/cealteam/epm-1112-hfm-database-housekeeping

Let us know!!

--Joe
Like Show 0 Likes(0)

Actions

Go to original post