Iam model_sync error on

Hi Mark, 

I’ve applied them now.. but made a version this morning.
We will know on Tuesday now. Will let you know. 

Thanks! 

Blommetje

Hi Erwin, 

No, it still occurred. Not sure why. I did patch the sf and iam. 

We also applied new right to a report. Perhaps something went wrong.. but alas. 

Any thoughts on how to fix this? 

Blommetje 

Hey Blommetje,

We need to determine where the exact cause of the issue lies. The code of the Table-valued function "i_sync_role_tab_variant_report” is responsible for returning the dataset that IAM will receive. Can you verify that the select statements do indeed return correct data and that tab_variant_id has a value for every record?

Code of the TVF; please correct the value for @model_id and @branch_id prior to executing:

declare @model_id         "model_id"  = '[model_name]',
        @branch_id        "branch_id" = '[branch_name]'

-- Role tab variant report
select r.role_id,
       t.tab_id,
       t.tab_variant_id,
       t.report_id,       
       t.show_tab_report as granted
  from tab_variant_report_overview t
  join role r
    on r.model_id   = t.model_id
   and r.branch_id  = t.branch_id
  join role_tab_report rt
    on rt.model_id  = t.model_id
   and rt.branch_id = t.branch_id
   and rt.role_id   = r.role_id
   and rt.tab_id    = t.tab_id
   and rt.report_id = t.report_id
  join role_report t1
    on t1.model_id  = t.model_id
   and t1.branch_id = t.branch_id
   and t1.role_id   = r.role_id
   and t1.report_id = t.report_id
  join role_tab t2
    on t2.model_id  = t.model_id
   and t2.branch_id = t.branch_id
   and t2.role_id   = r.role_id
   and t2.tab_id    = t.tab_id
 where t.model_id   = @model_id
   and t.branch_id  = @branch_id
   and r.all_rights = 0
   -- Only sync roles that are included in the selected modules, or else always 1 
   and dbo.is_sync_role(r.model_id, r.branch_id, r.role_id) = 1
   and rt.granted        = 1
   and t1.granted        = 1
   and t2.select_granted = 1

union all

-- All rights
select r.role_id,
       t.tab_id,
       t.tab_variant_id,
       t.report_id,       
       cast(1 as bit) as granted
  from tab_variant_report_overview t
  join role r
    on r.model_id  = t.model_id
   and r.branch_id = t.branch_id
 where t.model_id = @model_id
   and t.branch_id = @branch_id
   and r.all_rights = 1
   and t.show_tab_report = 1
   -- Only sync roles that are included in the selected modules, or else always 1 
   and dbo.is_sync_role(r.model_id, r.branch_id, r.role_id) = 1

Yes! 

I reran all the hotfixes and checked this, and not sure exactly but did see a capital. 
Somehow the hotfix wasn’t applied (or rolled back due to a restore or something), but after that it was solved! 

Thanks! 

Blommetje