Resolution | There 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. |