Cannot assign data access profiles in BPC 10.0 production
We are facing a wierd issue with BPC 10.0 Data Access Profiles. We have transported 3 DAP thru Dev -> QA -> Prd. It is working fine till Quality but in production we can see the new data access profiles but we cannot assign them to the users.
This is not a security authorization issue as we can assign other data access profiles to the users successfully. I checked UJE_PROFILE_AGR table and entries are present but table AGR_1251 doesn't have any entries for the PFCG role generated by the Data access profile like other data access profiles.
I ran report UJE_VERIFY_SECURITY_DATA in production and it shows new data access profiles doesn't exist which is not true because I see them in table UJE_PROFILE_AGR. I have not tried by checking Fix Security data option in this report as I am not 100% sure of the impact.
Could anyone please advise or guide me why we cannot assign either from front end or backend ?
I tried to find some KBA/OSS notes on marketplace but could not find anything related this issue