TDM Portal UI shows error "Server encountered an error processing the request. See server logs for more details", when creating new Projects

Products

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

Issue/Introduction

While creating New Project : throws/display error : "Server encountered an error processing the request. See server logs for more details"

But when the UI is refreshed, we see that the new Project was actually created.

Environment

TDM Portal 4.11.2028.0

Cause

To get a better understanding of the actual error thrown, we need to review the TDMProjectService.log, which shows the cause of the error as:

INTERNAL SERVER ERROR: Exception: Query did not return a unique result: 2 results were returned
org.hibernate.NonUniqueResultException: Query did not return a unique result: 2 results were returned

When creating the project, TDM Portal is attempting to either add or check access for LDAP groups, as indicated by the line 'tdm.security.model.jpa.SecurityLDAPGroupRepository.findByName(SecurityLDAPGroupRepository.java:75)' 

TDM Portal is trying to select based on slg_authority_name and slg_dn while ignoring the case sensitivity, and expects exactly one single record to be found. So either the LDAP Group name is not unique, or is different only by casing.  This is shown in the following line of the log: jdk.proxy16/jdk.proxy16.$Proxy2616.findBySlgAuthorityNameIgnoreCaseAndSlgDnIgnoreCase(Unknown Source). If only casing is different, for example, LDAP_Group1 and ldap_group1 would match because we are ignoring case, and result in throwing the error.

Resolution

Since the error doesn't provide the query results causing the error, the best way to do to determine the root cause is to work with the LDAP team to find the non-unique results returned, when the error is seen.