Common Issues seen in Data Certification Applications

Luc Johnson · 4 weeks ago

Legacy Data Certification

A functionality or a fix I am expecting is not working
- Many customers in the past have made customizations to files that then get skipped on upgrade, commonly a sys_ui_macro or sys_ui_script
Certification data is missing/disappeared
- cert_element extends cert_audit_result table, we have seen a couple of instances where customers have sys_auto_flush set on the parent table
- We do ship an Archive and Archive Destroy rule for 2 and 7 years respectively on the cert_audit_result table
Tasks won't close/reach 100%
- Synchronizing the percent complete of a task is done by an OOB business rule which can occassionally miscalculate based on the state of currently pending/certified records
- Resetting the state of one cert_element record and then retriggering a certification is one workaround we have provided, or creating a scheduled job to periodically check WIP cert_task records

Unable to view comments
- In initial versions of this application, comments left while certifying are not displayed on the /certification-review page, they are only available via the tables sn_cmdb_ws_dm_certification_task_to_document and sn_cmdb_ws_dm_certification_attribute_status. Display in UI is coming in future version
No content available when clicking "Review records to certify"
- This was breaking due to a regression introduced by list component, fixed in XP2+
Certification policy created via import from cert_schedule missing dot-walk in assignment field
- This form of assignment was missing in initial versions of Certification policy type and not broadly available for Data Manager policies. Fix was required on Glide and backported to WP10 and XP5