DESTA - Database files growing out of control

[RedLimey]

ZIM --- Useful info to have if the DB does ever need housekeeping, however as I think you're saying, with DESTA behaving the way it is, it all just comes back in quick fashion.

Teem --- Did a reinstall help any? That's still a poor solution from HP. They have no idea why this has started to happen with their product at multiple locations??

[Manfred Schilling]

Database still growing... Source is WEBES on CV-Server after an EVA8400 update to Version 09534000 (seem to be always the same entrys). How to reset EVA Controller-Eventlog ?

[Manfred Schilling]

Our problem is now solved by resetting cache for that EVA on the CV EVA-Server.

[RedLimey]

It turns out we too have an EVA that had a faulty component and was flooding alerts. Both our HPSIM instances were referencing it, hence both were symptomatic.

The following steps were supposedly used by an HP tech to reset the the DB for 6.0.

1. On the CMS launch SEA UI and login with "admin-adv"
2. Go to the Managed Entities Page and click the "Export" button. This will launch another window that displays the process of the Managed Entity data being saved in XML format.
3. Close the window when this completes
4. Close the SEA UI

Then from the CLI on the CMS:

5. stop the desta_service.

net stop desta_service

6. cd C:\Program Files\HP\svctools\common\database\bin
7. Run the following command:

psql -h localhost -U WEBES -d postgres -p 7950

8. The psql window will appear with the following command prompt:

postgres-#

9. To drop existing databases perform the following:

DROP DATABASE IF EXISTS destadb;

10. To recreate the databases perform the following:

CREATE DATABASE destadb WITH OWNER = "WEBES" ENCODING = 'UTF8';

11. To exit type: \q

12. Start Desta Service

net start desta_service

[Teem]

Didn't get a chance to use the HP recommendations. Server was rebooted after patching and the problem hasn't come back yet...still monitoring.

[datacenter]

Hi,

i tried to delete the table, because my desta db growing up 6GB, i stop the desta service but when i try to logon in DB i received the request for a password of WEBES user, i didn't know it, so i tried to logon with administrator of local machine, but nothing to do. is there a default username and password?

Thanks to all

[MikeWachholz]

So I got to step 7, and it's asking for a password? Does anyone know what the default WEBES password is???

Thanks!
Mike

7. Run the following command:

psql -h localhost -U WEBES -d postgres -p 7950