Highlighted
Acclaimed Contributor.
Acclaimed Contributor.
486 views

Performance Center Tip: Delete license for PC Server/Host

The Performance Center Server and Host licenses cannot be removed from ALM server —> Lab Management Site, though licenses are added here.

 

The licenses should be deleted from the database.

 

1. SQL Server: Go to DEFAULT_LAB_PROJECT_DB and from there choose the TD.LAB_LICENSES table.

Use the SQL delete statement to delete the rows that you want based on LIC_ID. For example,

delete * from TD.LAB_LICENSES where LIC_ID=1001;

 

If you want to delete all the rows, you can issue the truncate table command.

 

2. Oracle database: If you are accessing the oracle database using system or sys account, issue the SQL Statement

SELECT LIC_ID, LIC_FACTORY_LICENSE FROM DEFAULT_LAB_PROJECT_DB.LAB_LICENSES;

 

Then you can delete the rows that you want based on LIC_ID column value. For example,

delete * from DEFAULT_LAB_PROJECT_DB.LAB_LICENSES where LIC_ID=1001;

 

If you want to delete all the rows, you can issue the truncate table command.

 

However, if you do not have access to system or sys account, then you need to login as "DEFAULT_LAB_PROJECT_DB" user and have access to LAB_LICENSES table to delete the row(s).

Regards,

Daniela Gómez Alvarado
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation.
Labels (1)
Tags (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.