000037826 - Getting an error in RSA Archer when trying to save a record permission field: "Relationship is inactive - Inherited fields contain unrelated levels"

Document created by RSA Customer Support Employee on Sep 6, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037826
Applies ToRSA Product Set: Archer
RSA Version/Condition: 6.x
IssueWhen trying to save a record permission field that is set up as a restricted field the following error is thrown:

"Relationship is inactive - Inherited fields contain unrelated levels"
User-added image
CauseIf the record permission field references a cross-reference/related field that has been inactivated it can start throwing this error.
ResolutionThere is no indication in the error or the screen of which field is inactive. You can use the following query to find the fields referenced by the record permission field that fails to be modified: 

select mt.module_name,lt.level_name,ft.field_name,fd.active from tblCalcField cf
join tblIVFieldDef fd on cf.ref_field_id=fd.field_id
join tblFieldTranslation ft on fd.field_id=ft.field_id
join tblLevel l on fd.level_id=l.level_id
join tblLevelTranslation lt on l.level_id=lt.level_id
join tblModuleTranslation mt on l.module_id=mt.module_id
where cf.field_id = <insert failed fieldID here>

Once you identify all of the inactive fields you will need to activate them so that they can be removed from the record permission field. Once they have been removed the fields can be set back to inactive.