SG-11530 GDPR Administration | Errors -ORA-02292: integrity constraint (R5FOK1_GVL) violated - child record found - HxGN EAM - 12.1.1.2 - Release Notes/Bulletin - Hexagon

HxGN EAM Release Notes for 12.1.1.2

Language
English
Product
HxGN EAM
Search by Category
Release Notes/Bulletin
HxGN EAM Version
12.1.1.2

 Description 

When revoking an Employee that has previously used GIS Layer info, the employee reference in R5GISVISIBLELAYER table causes an error in the process - in GDPR Administration | Errors we have

ORA-02292: integrity constraint (R5FOK1_GVL) violated - child record found

Steps to reproduce:

# Job Setup - FORGETME job active and running.

# Employees - Click on Revoke icon to revoke the employee record that has previously used GIS and has an entry in the R5GISVISIBLELAYER table.

# Wait until the FORGETME driver runs.

# GDPR Administration | Errors - see the error ‘ORA-02292: integrity constraint (R5FOK1_GVL) violated - child record found’ is shown for this record.

Current result: Employee record not revoked, error ORA-02292 shown.

Expected result: Employee record revoked, no errors shown.