topic Re: Deleted User Still Has License Allocated And Token Cannot Be Deallocated !! in Management & Governance https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328509#M9692 <HTML><HEAD></HEAD><BODY><P>Hi Alexander,</P><P>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</P></BODY></HTML> Thu, 25 May 2017 09:27:39 GMT Anonymous 2017-05-25T09:27:39Z Deleted User Still Has License Allocated And Token Cannot Be Deallocated !! https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328506#M9689 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">During Testing various security rule and access modes I deleted a user before deactivating the license.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">When I navigate over the the license information the user is displayed as 'deleted user' and the status is allocated.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Now I don't have any tokens due to which cannot access the apps</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I am unable to deactivate the license....the button is grayed out.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Request to help to resolve the same.</P></BODY></HTML> Wed, 24 May 2017 11:45:34 GMT https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328506#M9689 Anonymous 2017-05-24T11:45:34Z Re: Deleted User Still Has License Allocated And Token Cannot Be Deallocated !! https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328507#M9690 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Please help if there's a way to deallocate the token for a deleted user.</P></BODY></HTML> Thu, 25 May 2017 08:23:04 GMT https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328507#M9690 Anonymous 2017-05-25T08:23:04Z Re: Deleted User Still Has License Allocated And Token Cannot Be Deallocated !! https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328508#M9691 <HTML><HEAD></HEAD><BODY><P>recreate deleted user and dealocate license </P><P>or goto DB and delete record here</P></BODY></HTML> Thu, 25 May 2017 09:00:46 GMT https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328508#M9691 korsikov 2017-05-25T09:00:46Z Re: Deleted User Still Has License Allocated And Token Cannot Be Deallocated !! https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328509#M9692 <HTML><HEAD></HEAD><BODY><P>Hi Alexander,</P><P>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</P></BODY></HTML> Thu, 25 May 2017 09:27:39 GMT https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328509#M9692 Anonymous 2017-05-25T09:27:39Z Re: Deleted User Still Has License Allocated And Token Cannot Be Deallocated !! https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328510#M9693 <HTML><HEAD></HEAD><BODY><P>use pgadmin for connect to localhost:4432 and look on tables name starts as useraccesslicense*</P></BODY></HTML> Fri, 26 May 2017 05:51:00 GMT https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328510#M9693 korsikov 2017-05-26T05:51:00Z Re: Deleted User Still Has License Allocated And Token Cannot Be Deallocated !! https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328511#M9694 <HTML><HEAD></HEAD><BODY><P>I used this script</P><P></P><P>update public."Users" set "Deleted" = false where "ID" = 'user-id' using pgAdmin </P><P></P><P>And then restart the Qlik Sense Repository Service.</P><P></P><P>After that you can deallocate the token in the QMC</P></BODY></HTML> Tue, 06 Jun 2017 19:31:05 GMT https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328511#M9694 miguel_rojas_i2 2017-06-06T19:31:05Z Re: Deleted User Still Has License Allocated And Token Cannot Be Deallocated !! https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328512#M9695 <HTML><HEAD></HEAD><BODY><P>You can resolve your problem by using this script (on pgAdmin)</P><P>delete from public."LicenseUserAccessTypes"</P><P>where public."LicenseUserAccessTypes"."ID" = 'XXXXX'</P><P>'XXXXX' is the id of the deleted user.</P><P></P><P>Lotfi</P></BODY></HTML> Wed, 11 Apr 2018 16:06:20 GMT https://community.qlik.com/t5/Management-Governance/Deleted-User-Still-Has-License-Allocated-And-Token-Cannot-Be/m-p/1328512#M9695 lotfiblo 2018-04-11T16:06:20Z