Access Denied, The server has no user CAL for your account .

[Anonymous]

Dear Gurus,

We are using Qlikview 11.2

we are having 10 Named CALs and 25 Document CALs.

I have added 10 users(whom I want to give Named CALs) under system-->licenses->Qliviewserver-->Assigned CALs.

I have checked Allow License leasing and Dynamic CAL assignment. We are using DMS authorization. Using custom auhentication.

Issue: 9 users are able to lease lincese in their desktop . Except one user.

WHile trying to lease the lincense he is is getting error as "Access Denied. the server has no user CAL for your account"

But this user is able to login access point with the same ID and I can see the Last Used (UTC) as showing the login time to Access Point.

Also under general tab of Linceses, I can see "Named User CALs: 10 assigned (10 in license)"

Now I'm trying to understand,

1.why that user is not able to lease lincese.?

2. If some one else already leased available lincese, whey I can see only 10 users whome I added(along with this user) under assigned CALs

3. How I can differentiate which user is using Named CAL and which user is using Document CAL

4. How I can force a particular user to use Named CAL?

Please help me to understand and let me know if you need any info.

Many thanks in advance .....

Best Regards,

Chinna

[jagan]

Hi Chinna,

You can easily identify the CAL assinged to user by using the below script

// Variables

LET vLogFilesPath = 'C:\ProgramData\QlikTech\Qvs';

Sessions:

LOAD

  Capitalize(LOWER(SubField(Document,'\',-1))) as Dashboard,

  Time(Timestamp) as SessionsTime,

  if(len([QlikView User]) = 0 ,[Authenticated user], [QlikView User]) as UserID, 

  [Cal Type],

    [Cal Usage Count],  

     Date(Floor(Timestamp)) AS Date,

     Year(Date(Floor(Timestamp))) AS Year,

     Month(Date(Floor(Timestamp))) AS Month,

     Date(MonthStart(Timestamp), 'MMM YYYY') AS MonthYear,

     'Q' & Ceil(Month(Date(Floor(Timestamp)))/3) AS Quarter,

     [Session Duration]  as SessionDuration,     

     Calls as SessionCalls, 

     [Session Start]

FROM $(vLogFilesPath)\Sessions_*.log

(txt, utf8, embedded labels, delimiter is '\t', msq);

Cal Type field will have assigned CAL details

Hope this helps you.

Regards,

Jagan.

[jagan]

I think for the User Named CAL is not assigned, may be doc CAL is assigned.

Regards,

jagan.

[jagan]

Hi Chinna,

Check this link hope it helps you.

Qlikview Server CAL Manager

Regards,

Jagan.

[jafari_ervin]

are you sure that one user did not lease license from two machine? Lease license is dependent to machine name.

[ashfaq_haseeb]

Hi,

As you are using DMS authorization with Custom users.

Here is the tricky part with custom users Qlik will be case sensitive and may be qlik treat him as another user as there are no more CALS left therefore you get that error.

All that you have to make sure is you use same user with exact Case that you created in Custom directory and give a try

Now I'm trying to understand,

1.why that user is not able to lease lincese.?

Could be due to case sensitivity, try to use exact user for license leasing.

2. If some one else already leased available lincese, whey I can see only 10 users whome I added(along with this user) under assigned CALs

Same goes here as well. MAy be its case sensitive.

3. How I can differentiate which user is using Named CAL and which user is using Document CAL

All the users that are assigned/ allocated in below path are named users

system-->licenses->Qliviewserver-->Assigned CALs.

If this user is allocated a doc cal I will try to remove his Doc Cal and check if that fixes this issue.

4. How I can force a particular user to use Named CAL?

If you allocate users in below path then it will allocate a Named Cal.

system-->licenses->Qliviewserver-->Assigned CALs.

For more details on cal flow look at the below post.

QlikView CAL Access Flow

Hope it helps.

Regards

ASHFAQ

[Anonymous]

Hi Jagan,

I have loaded the above script and able to see this user is using Named CAL license.

However, I'm surprised why this user is not able to lease license even though he is showing as Named User in the session log with recent login date.

Please let me know what could be the probable reason? I will check if this user is tried to lease from more than 2 machines.
Br,

Chinna

[Anonymous]

Hi Ashfaq,

Thanks for the reply. we are entering the exact user ID and I can see this user as a Named User under session log with recent time stamp. How ever he cannot lease license.

BR,

Chinna

[Anonymous]

Hi Ashfaq,

One more thing I have observed, there are few named users who were not using Qlikview for Months and still I can see them, they are using Named CALs even though I have deleted them under Assigned CALs tab long back.

It seems still they are consuming Named CALs. Kindly let me know How I can remove thier Named CAL license permanantley?

Best Regards

Chinna

[ashfaq_haseeb]

Hi,

It seems like your .pgo files are corrupted.

Take proper backup and off your services

delete .pgo files and reallocate License from scratch.

Hopefully that should fix your problem

Regards

ASHFAQ