Error while creating a New Environment in TDM Portal

Products

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

Issue/Introduction

Installed TDM Portal version 4.11.159 from 4.10, after logging into the Portal, getting below error when creating a new environment:

Environment

All supported TDM environments.

Cause

The problem seemed to be the OrientDB was offline, the screenshot shows that TDM isn't finding the environment.

Looking in the TDMDataReservation.log:

2025-03-27 09:30:42.248 GMT [ERROR] [Catalina-utility-4       ] --- [U:][M:][P:]                  c.c.t.d.DataReservationJobLoader:  Exception caught while loading Data Reservation Job 
java.net.ConnectException: Connection refused: connect
    at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
    at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
    at 

Verified that the OrientDB service was up and running. Closed the browser and after bringing up the browser again seeing this error:

HTTP Status 404 - Not Found

Viewing the TdmWeb.log file seeing this error:

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2025-04-24 15:22:06.610 UTC [ERROR] [Catalina-utility-4       ] --- [U:][M:][P:]                           o.s.b.SpringApplication:  Application run failed
java.sql.SQLException: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

The ORA-02391 error indicates that a user has exceeded the maximum number of concurrent database sessions allowed by their profile. This means that the user is trying to open too many connections to the Oracle database simultaneously. To resolve this, you can either close some existing connections or have the Database Administrator (DBA) increase the SESSIONS_PER_USER limit for the user's profile. 

 

 

Resolution

Verify the OrientDB is always running while the Portal is up.

DBA increased the SESSIONS_PER_USER limit to unlimited.

After starting the Portal service, was was able to login to Portal, activate the product, create a new Project, Connection Profile and Environment.