Automate EPMA Transaction History Deletion

1973708

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.

JohnGoodwin

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

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 Punniyamoorthy

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

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

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

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

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

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

Once logged in you will receive the following message

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

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

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

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 Punniyamoorthy

Yes . Thanks a lot for your time John.

1973708

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

Dayalan Punniyamoorthy

Yes, exactly.

Regards,

Dayalan P.