TDM Portal Slowness or Unresponsiveness Due to OrientDB Connection Refused

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Users may experience significant slowness or unresponsiveness when accessing the Self Service Catalog in the TDM Portal. This issue often persists until services are restarted but eventually returns.

Environment

• Product: CA Test Data Manager (TDM)
• Component: TDM Portal / OrientDB
• Version: 4.11.x (Specifically observed in 4.11.5046.0)

Cause

Reviewing the logs reveals the following error signatures:

TDMDataReservation.log

[ERROR] c.c.t.d.g.GraphAPI: Failed to create or access the graph database at: remote:localhost:2424/ReservationDB. 
Error: Cannot connect to the remote server/database 'remote:localhost:2424/ReservationDB' 
java.net.ConnectException: Connection refused: getsockopt

orientdbStartup.log

[OServerConfigurationLoaderXml]Invalid syntax. 
javax.xml.bind.UnmarshalException - with linked exception: 
[org.xml.sax.SAXParseException; ... The end-tag for element type "listener" must end with a '>' delimiter.]

 

The OrientDB service fails to initialize its network listeners (binary on port 2424 or HTTP on port 2480) because of a syntax error in the `orientdb-server-config.xml` file. A missing `>` delimiter on a `<listener>` tag prevents the XML parser from unmarshalling the configuration, causing OrientDB to refuse connections from the TDM Portal.

Resolution

To resolve this issue, manually correct the XML syntax in the OrientDB configuration file:

1. Stop Services

   • Open Windows Services (`services.msc`).
   • Stop the CA Test Data Manager Portal service.
   • Stop the OrientDB service.
     
     

2. Edit Configuration

   • Navigate to: `C:\Program Files\CA\CA Test Data Manager Portal\orientdb\config\`.
   • Create a backup of `orientdb-server-config.xml`.
   • Open the original file in a text editor (e.g., Notepad++) as Administrator.
     
     

3. Fix Syntax Error

   • Locate the `<listeners>` section (usually near the end of the file)
   • Find the `<listener>` tag (often the binary protocol on port 2424).
   • Ensure the tag is properly closed with a `>` character.
     Example Corrected Tag: `<listener protocol="binary" socket="0.0.0.0" port-range="2424-2430" />`
     
     

4. Clear Logs

   • Navigate to `%ProgramData%\CA\CA Test Data Manager Portal\logs`. Delete or move all existing log files to a backup location.
   • Navigate to `%ProgramData%\CA\CA Test Data Manager Portal\orientdb\logs`. Delete or move all existing log files to a backup location.

5. Restart Services

   • Start the OrientDB service first and verify it stays running.
   • Start the CA Test Data Manager Portal service.
     
     

6. Verification

   • Access the Self Service Catalog in the TDM Portal and verify the performance is restored.