When activating TDM Portal for PLA telemetry fails and are stuck in a loop.

Products

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

Issue/Introduction

Did a clean install of TDM Portal.

Log into the Portal for the first time and asked to activate the product.

Provide the required Telemetry information, it fails and it starts the process over again.

 

Environment

All supported TDM releases.

Cause

There was a failure in one of the microservices.

Resolution

1) Stop the TDM Portal service
2) Go to the webapps directory default location:   C:\Program Files\CA\CA Test Data Manager Portal\tomcat\webapps
3) Delete all folders except ROOT, (do not delete the .war files)
4) Start the TDM Portal service and test again.

Additional Information

From the startup logs:
FINEST|5888/0|22-03-22 09:18:35|WARNING: Error of type 404 occurred while sending queue event
FINEST|5888/0|22-03-22 09:18:35|com.ca.tdm.eventserviceclient.exception.EventPostException: Failed to post event, returned response code was 404 and reason 
FINEST|5888/0|22-03-22 09:18:35|        at com.ca.tdm.eventserviceclient.EventServiceClient.postEventEx(EventServiceClient.java:104)
FINEST|5888/0|22-03-22 09:18:35|        at com.ca.tdm.eventserviceclient.EventServiceClient.postEventsFromQueue(EventServiceClient.java:141)
FINEST|5888/0|22-03-22 09:18:35|        at com.ca.tdm.eventserviceclient.EventServiceClient$1.run(EventServiceClient.java:167)
FINEST|5888/0|22-03-22 09:18:35|        at java.util.TimerThread.mainLoop(Timer.java:555)
FINEST|5888/0|22-03-22 09:18:35|        at java.util.TimerThread.run(Timer.java:505)

from the event service logs

Wrapped by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'usage_flyway' defined in class path resource [com/ca/tdm/usage/config/UsageFlywayConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.flywaydb.core.Flyway]: Factory method 'usageFlyway' threw exception; nested exception is org.flywaydb.core.internal.dbsupport.FlywaySqlException: 
Unable to check whether table [dbo].[schema_version_usage] exists
-----------------------------------------------------------------
SQL State  : 40001
Error Code : 1205
Message    : Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.