Forum Stats

  • 3,817,304 Users
  • 2,259,307 Discussions
  • 7,893,742 Comments

Discussions

EPMA service is taking more time to start

User_ABYEK
User_ABYEK Member Posts: 12 Red Ribbon
edited Jun 27, 2018 4:22AM in Planning and Budgeting

Hi All,

We are using 11.1.2.4 Hyperion and our EPMA server installed in windows VM. All of the sudden when we restart the EPMA service it is taking around 35 min to start after modifying BPMA_Server_Config file. we have applied regular PSU patches on the database in all the environments at the same time but only this environment is causing the problem.

When we looked in to the dimensionserverstartup logs the service is consuming more time at the step " Loading Master Library" .

[2018-05-09T04:18:40.178-04:00] [Debug] Loading Master Library...

[2018-05-09T04:39:36.213-04:00] [Debug] Processing System Metadata file...

Please let me know your thoughts why this step taking more time... or what exactly is happening at this step.

Thanks,

Rajesh

Tagged:

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited May 11, 2018 1:30PM

    Have you had a look to  see if purging transaction history helps with performance - Purging Transaction History

    Cheers

    John

  • User_ABYEK
    User_ABYEK Member Posts: 12 Red Ribbon
    edited May 11, 2018 1:35PM

    We are also thinking of the same.. but the database is of very less size and complete backup of the database itself is not taking 15 min.

    Do you know what these transactions are? why would it cause delay in startup?

    Appreciate your help on understanding this step.

    Thanks,

    Rajesh

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited May 11, 2018 2:15PM
    3532261 wrote:Do you know what these transactions are? 

    From the link I provided - "Performance Management Architect creates transactions in the Performance Management Architect database. This database is automatically created during installation and configuration. Since Performance Management Architect does not delete these artifacts, the database size can increase over time. The Performance Management Architect Transaction History Purge Utility enables you to remove transactions from the database to reduce database size."

    Whether this helps your situation I can't say but it is worth investigating.

    You also say that EPMA is installed on a VM, have you checked with the team that manages the VM infrastructure to see whether there is any resource connection that be causing severe performance degradation.

  • User_ABYEK
    User_ABYEK Member Posts: 12 Red Ribbon
    edited Jun 26, 2018 10:49AM

    we ran purge utility but issue is still exist

  • SureshM-Oracle
    SureshM-Oracle Member Posts: 407 Employee
    edited Jun 26, 2018 11:34AM

    What exact change have you made in the BPMA_Server_Config file?

    Have you made any recent changes in the application like added huge dimensions etc.?

    If it is VM, you can still restore the environment from the date when this worked fine for you and then test the issue again.

  • User_ABYEK
    User_ABYEK Member Posts: 12 Red Ribbon
    edited Jun 26, 2018 11:38AM

      we changed this parameter, only then we are able to start the service but is still taking around 30 minutes.

        <DimensionServerStartupTimeout>6000</DimensionServerStartupTimeout>

    only EPMA server is in VM so we cant actually restore in this case..

  • SureshM-Oracle
    SureshM-Oracle Member Posts: 407 Employee
    edited Jun 26, 2018 12:29PM

    How many EPMA applications do you have on this environment? Do see any issues in working with the existing applications at this point in time?

  • User_ABYEK
    User_ABYEK Member Posts: 12 Red Ribbon
    edited Jun 26, 2018 1:16PM

    There are 7 applications which is same in lower environments as well.. there are no issues related to performance or slowness once the epma server starts.

  • Sh!va
    Sh!va Member Posts: 1,035 Gold Badge
    edited Jun 27, 2018 4:22AM

    Can you try bouncing DB and EPMA VM. Some time this resolve such issues.

    Cheers!

    Sh!va

This discussion has been closed.