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
Release : 4.8
Component : TDM Web Portal
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
Things to Consider When Upgrading TDM - https://knowledge.broadcom.com/external/article?articleId=193849