[SOLVED in CU 7] Limited user can only write to 2 tables (not 3) because of Job Queue Entry

Answers

• Options

  xStepa Member Posts: 106

  2017-10-12 edited 2017-10-12

  Hi, it seems, that you are modifing more tables than you expect - it could be somethnig during start of NAV. For counting of tables try the permissions recorder - you will see all the accesses (except the ones when NAV starts).
  
  for example here:

  https://www.gofastpath.com/blog/permissions-recorder-nav-2017
  

  Regards
  xStepa

  0
• Options

  iSad Member Posts: 5

  2017-10-12 edited 2017-10-12

  hi @xStepa. Seems like a reasonable conclusion but that is not yet proven to be true
  So far I got to a strange point where the line in the middle fails. Codeunit 5000 does 3 modifications.
  If this is logical in any way ...
  
  
  You might say that WRITEPERMISSION might actually write and consume 1 licensed table.
  That is also false, if I try with my own tables.
  
  

  0
• Options

  xStepa Member Posts: 106

  2017-10-12

  I don't think that the permission check consumes any licensed tables and I don't know whats in your codeunit, so just last few hints:

  • as I see from the name of the function, you may call the CreateTask function - this also consumes a table
  • maybe you are trying to modify a prohibited table (like G/L Entry)
  • maybe there is another functionality OnLoginStart before your functions

  
  Try to post your cu50000 ...

  Regards
  xStepa

  0
• Options

  iSad Member Posts: 5

  2017-10-13

  FIXED. It is a bug from MS. They fixed it in NAV 2017 CU 7:
  
  So, somehow WRITEPERMISSION consumes a license table for a limited user. That's the conclusion.
  
  CU 7 issues that solves it:
  213221 A job queue entry is always retained for a limited user when you open a company.
  COD 455
  All the thanks are appreciated
  

  0