How to remove or delete license for Performance Center Server and Hosts

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).

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s