Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Deleted User Still Has License Allocated And Token Cannot Be Deallocated !!

During Testing various security rule and access modes I deleted a user before deactivating the license.

When I navigate over the the license information the user is displayed as 'deleted user' and the status is allocated.

Now I don't have any tokens due to which cannot access the apps

I am unable to deactivate the license....the button is grayed out.

Request to help to resolve the same.

6 Replies
Anonymous
Not applicable
Author

As suggested I have upgraded to Qliksense SR4 version now available token count has increased but still the deleted user can bee seen and the Deallocate button is greyed out.

Please help if there's a way to deallocate the token for a deleted user.

korsikov
Partner - Specialist III
Partner - Specialist III

recreate deleted user and dealocate license

or goto DB and delete record here

Anonymous
Not applicable
Author

Hi Alexander,

I will try the option of recreating the User and deallocate but it would be helpful if you can provide the detailed step for deletion from DB

korsikov
Partner - Specialist III
Partner - Specialist III

use pgadmin for connect to localhost:4432 and look on tables name starts as useraccesslicense*

miguel_rojas_i2
Partner - Contributor II
Partner - Contributor II

I used this script

update public."Users" set "Deleted" = false where "ID" = 'user-id' using pgAdmin

And then restart the Qlik Sense Repository Service.

After that you can deallocate the token in the QMC

lotfiblo
Creator
Creator

You can resolve your problem by using this script (on pgAdmin)

delete from public."LicenseUserAccessTypes"

where public."LicenseUserAccessTypes"."ID" = 'XXXXX'

'XXXXX' is the id of the deleted user.

Lotfi

Use Qalyptus for your Qlik Sense on-premise and Qlik Sense SaaS Reporting
Connect with me on Linkedin