Test execution results are no longer coming up in the DevTest Portal

Document ID : KB000129938
Last Modified Date : 25/03/2019
Show Technical Document Details
Issue:
In the DevTest Portal when selecting Monitor -> Tests, the results of previously run tests are no longer being displayed.
The Registry service is using the default Derby database.

Other Symptoms:
The Registry process is showing high CPU usage.
The Derby database in the lisa.db folder is using a lot of disk space. More than 15 GB. for example.
Environment:
The Registry is configured with the default Derby database.
Resolution:
The Apache Derby database that is included with DevTest is adequate only for small deployments that do not require load and performance testing, and is not supported.
For all other scenarios, configure DevTest to use an external database.

The maintenance that can be done on a Derby database is limited but it is easy to start with a new clean database by following these steps: 
- Stop the DevTest services 
- In the DevTest home, database sub folder, rename the lisa.db folder to lisa.db.backup 
- Restart the services

When the Registry starts, it will create a new lisa.db folder with a new Derby database.

The impact of starting with a new database is that the userids and roles that were added will be lost.
The default users like admin, will be recreated. 
Also all existing test reports will be removed.
Additional Information:
To reduce amount of reporting data generated by a test, update the type of report in the staging document from 'Default Report Generator' to 'Load Test Report Generator'.

By default old reports will be cleaned up after 30 days. 
To clean up old reports sooner (after 5 days for example) set the following in local.properties:
perfmgr.rvwiz.whatrpt.expireTimer=5d 

For more background see: 
https://docops.ca.com/devtest-solutions/10-4/en/administering/database-administration/database-maintenance