lisadb has filled up

Products

• Service Virtualization

Issue/Introduction

Is it possible to delete old records from lisa DB as it is almost run out of space?

Environment

All supported DevTest releases.

All supported DevTest databases.  

Resolution

You can run a DevTest utility called Report Cleaner.

Here are the properties to add:

Add these two properties in the local.properties file of where the Registry is running to control how often old VSE metric data is scanned and deleted:

lisa.vse.metrics.delete.cycle=1h 
lisa.vse.metrics.delete.age=3d

Add these two properties in the local.properties file of where the Registry is running to control how often old Test/Suite data is scanned and deleted:

perfmgr.rvwiz.whatrpt.autoExpire=true
perfmgr.rvwiz.whatrpt.expireTimer=3d

The default is 30 days and changed it to 3 days.

After change restart the Registry.

This will take time to lower the row counts since the tables are so large.

Additional Information

Refer to documentation sections "Database Maintenance and Application Insight Properties" of the release you are running for more information.