We installed TDM Portal and chose PLA licensing by mistake how can we change this back to Standard licening?

Products

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

Issue/Introduction

Hello, we have installed TDM in our production environment and started using it.
We have data and setups we can not afford to lose.
During the install, we chose PLA licensing by mistake.
How can we change this back to standard licensing?

 

Cause

 

Incorrect options are chosen during installation

 

Environment

 

TDM Portal 4.8.X 4.9.X

Resolution

In order to reset your Production environment, you would need to do the following.
1) connect to your SQL server that hosts the GTREP database with a user with full rights
2) then run the following SQL query:
delete from  gtrep_system_settings where ss_name ='LICENSING_MODEL'
3) if you are logged into the portal logout and close the browser
4) open a new browser and log back into the portal with the administrator username and password.
5) you should then get the activation screen to come up which you can walk through again.
6) Make sure you enter your License key in the enterprise site ID field as per the documentation below:

Activate Test Data Manager (broadcom.com)