Not able to Pull Any Reports from Portal

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)
• Service Virtualization

Issue/Introduction

Not able to pull any reports from Portal.

When any reports are chosen, Portal just shows "Loading..." indefinitely.

Environment

All supported DevTest releases.

Cause

Corrupted files:
prodDb.mv.db 
prodDb.trace.db 

We do not know at this time why these files get corrupted, development is working to resolve, so the resolution is a workaround at this time.  This applies to the Registry database being used and can happen with all supported databases.

Resolution

Shutdown the Registry along with DevTest components on Registry machine.

Delete, move or rename DevTest_Home/prodDb.mv.db
Delete, move or rename DevTest_Home/prodDb.trace.db (if present)

Start Registry along with DevTest components on Registry machine.

You will be able to pull reports now from the Portal.

Additional Information

DevTest is unable to create a pool of database connections.

The following error is found in the registry.log:

ERROR org.apache.tomcat.jdbc.pool.ConnectionPool - Unable to create initial connections of pool.
org.h2.jdbc.JdbcSQLException: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-192]