TDM 4.8 Portal AuthenticateUser NullPointerException

Products

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

Issue/Introduction

In our TDM Portal production environment, users can login, but the system has no response after click "NEW REQUEST". Below is some error log we caught:-

==TDMSerice.log:==

2022-05-24 05:12:09.349 UTC [ERROR] [https-jsse-nio-443-exec-3] --- [U:][M:][P:]                 c.c.t.s.e.i.AuthenticationService:  AuthenticateUser: exception caught: public class java.lang.NullPointerException

2022-05-24 05:12:09.350 UTC [ERROR] [https-jsse-nio-443-exec-3] --- [U:][M:][P:]                       c.c.t.s.TDMServiceException:  TDMServiceException: RequestID: 251, Module: TDMSERVICE, Exception: AuthenticateUser: failed to authenticate user p837983: : NullPointerException

==TDMWeb.log:==

2022-05-24 04:28:56.980 UTC [ERROR] [https-jsse-nio-443-exec-11] --- [U:p849408][M:GET][P:/api/ca/v1/tdod/projects/2572/versions/2573/levels/2576/visualTestFlow/357]                             c.c.t.t.d.TDODSession:  TDoD Authentication failed. Error:

org.apache.axis.AxisFault: AuthenticateUser: failed to authenticate user p849408: : NullPointerException

 

==Startup.log:==

com.ca.tdm.publ.exception.TDMPublishActionException: exitVal: 1 error output: time data '27052022' does not match format '%m/%d/%Y'

com.ca.tdm.publ.exception.TDMPublishActionException: exitVal: 1 error output: time data '27/05/2022' does not match format '%m/%d/%Y'

com.ca.tdm.publ.exception.TDMPublishActionException: Action returned non-zero exit code: 2

 

Environment

Release : 4.8

Component : TDM Web Portal

Resolution

After further investigation, the we found for the users suffering issue, in table [gtrep].[dbo].[gtrep_security_user], their SU_BLOB_ID column was all NULL. Their ID worked after the customer added some values to this column.

This column value will be added automatically during the creation of the user. We have seen this issue in older versions for LDAP users. This column should not be NULL. Therefore, try inserting a value in this column for the user profile and test it, as a possible work-around.
 
 A long-term solution is to upgrade the environments to the latest TDM version. Because Engineering has resolved many issues in TDM Portal and added new features between 4.8 and 4.10 versions.

Please refer to the below link for upgrading TDM components

https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/installing/upgrade-product-components.html

Additional Information

Things to Consider When Upgrading TDM - https://knowledge.broadcom.com/external/article?articleId=193849