Forum Stats

  • 3,827,255 Users
  • 2,260,751 Discussions
  • 7,897,192 Comments

Discussions

Automate EPMA Transaction History Deletion

1973708
1973708 Member Posts: 3
edited Apr 6, 2016 2:56AM in Planning and Budgeting

Hi,

We usually run the "EPMA_database_cleanup_utility.exe" utility in <EPM_ORACLE_INSTANCE>products\Foundation\BPMA\AppServer\DimensionServer\ServerEngine\bin location to clean up the logs accumulated over the week. This is a GUI based application and I was wondering if this could be automated.

I have read that running the "database_cleanup_utility -u -p" in command prompt to fire it up. However, while using the utility (GUI), after logging in, we are supposed to STOP the EPMA Server service, and once the purge is completed, to START the servive again. How could this be done, since in GUI, there are prompts for the same?

Could I clarify further? Please let me know.

Tagged:
Dayalan Punniyamoorthy1973708

Best Answer

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Apr 5, 2016 6:21AM Answer ✓

    As usual with EPMA it makes no sense , when running from command line the utility you will see this:

    otn.PNG

    The utility does not run

    It runs if you start EPMA, start the utility, stop EPMA, click "y"

    You can suppress the prompts but that doesn't make any sense

    Dayalan Punniyamoorthy1973708
«1

Answers

  • Dayalan Punniyamoorthy
    Dayalan Punniyamoorthy Member Posts: 1,516 Gold Trophy
    edited Apr 5, 2016 1:53AM

    It is explained here How to Schedule the EPMA DatabaseCleanupUtility using Microsoft Windows task Manager (Doc ID 1329427.1)

    i believe you don't have to stop and start the EPMA services during the purge process.

    HTH,

    Dayalan P.

    1973708
  • 1973708
    1973708 Member Posts: 3
    edited Apr 5, 2016 4:00AM

    Thanks Dayalan.

    I have a query though - Why is it not necessary to stop/start the services?

    When I fire up the utility, it shows a pop-up that informs to *stop* the EPMA service. Additionally, once it is done, it is therefore necessary to start the service again (since we had to stop it in the first place).

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Apr 5, 2016 4:15AM

    I think the reason to stop the service is so there is no activity or locks on the database tables, it is your choice whether you want to follow the instructions of stopping/starting the service.

    Cheers

    John

  • Dayalan Punniyamoorthy
    Dayalan Punniyamoorthy Member Posts: 1,516 Gold Trophy
    edited Apr 5, 2016 4:58AM

    Let me rephrase myself, what i was trying to convey is that the EPMA server needs to be running to run this utility,

    1.jpg

    So you don't have to stop the services, the utility will stop the EPMA service during its action. So in your batch file for calling the utility include a last line for starting the EPMA service like  eg: call net start EPMA_Server.exe

    HTH,

    Dayalan P.

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Apr 5, 2016 5:47AM

    Just to be clear the service has to be started to log into the utility or you will receive.

    otn.PNG

    Once logged in you will receive the following message

    otn2.PNG

    If you click start the above message will appear again so you will need to stop the service.to be able to continue.

    Cheers

    John

    Dayalan Punniyamoorthy
  • Dayalan Punniyamoorthy
    Dayalan Punniyamoorthy Member Posts: 1,516 Gold Trophy
    edited Apr 5, 2016 6:03AM

    Wow, thanks John for the clear explanation. But, i am unclear on this.

    The utility needs the EPMA server to be running to login, so once its logged in the service needs to go down. So if we automate by calling the utility via a batch, i am not sure how we will stop the service once the utility is logged in (at what stage)

    Regards,

    Dayalan P.

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Apr 5, 2016 6:21AM Answer ✓

    As usual with EPMA it makes no sense , when running from command line the utility you will see this:

    otn.PNG

    The utility does not run

    It runs if you start EPMA, start the utility, stop EPMA, click "y"

    You can suppress the prompts but that doesn't make any sense

    Dayalan Punniyamoorthy1973708
  • Dayalan Punniyamoorthy
    Dayalan Punniyamoorthy Member Posts: 1,516 Gold Trophy
    edited Apr 5, 2016 6:33AM

    Yes . Thanks a lot for your time John.

  • 1973708
    1973708 Member Posts: 3
    edited Apr 5, 2016 10:02PM

    Thanks for the insight John!

    So now, in a nutshell, is this what you're trying to convey?

    1. Start the EPMA Server service - call net start EPMA_Server.exe

    2. Start the "database_cleanup_utility -u -p" in command prompt, login using username and password.

    3. Once logged in, it'll ask for the EPMA SERVER service to be shut down. So we have to shut it down - call net stop EPMA_Server.exe
    4. Start the purge process - database_cleanup_utility -d04/06

    5. Once the purge completes, start the service again - call net start EPMA_Server.exe

    1973708
  • Dayalan Punniyamoorthy
    Dayalan Punniyamoorthy Member Posts: 1,516 Gold Trophy
    edited Apr 6, 2016 12:47AM

    Yes, exactly.

    Regards,

    Dayalan P.

This discussion has been closed.