Hi,
User trying to delete an attachment from UI. But facing this error during removal.ORA-02292:integrity constraint (OSADMIN_OSPRD1.OSFRK_OSUSR_MN0_S3REQUE1_KRQH0) violated - child record found.
Those attachment are imported via Email through power automate flow.
Anyone please help me to look into this issue by decoding this error.
Thanks,
Abirami
Hi @Abirami P,
https://www.outsystems.com/forums/discussion/63883/oracle-error/
ORA-02292 is typically accompanied with the message, “integrity constraint violated – child key not found”.
This means that you attempted to execute a reference to a certain table using a primary key or foreign key . However, in the process of doing so, the columns that you specified failed to match the primary key or foreign key.
http://www.dba-oracle.com/t_ora_02291_integrity_constraint_string_string_violated_parent_key_not_found.htm
Regards,
Rajat
Hi @Abirami P
It seems the entity where you saved and from where you want to delete record it has reference in another entity, in this case you can change delete rule either to delete or ignore from the entity which has reference of first entity.
For Example -
FileEntity - It has file and you want to delete this.FileMetaEntity - it has an attribute of type FileEntityIdentifier and so change its delete rule.
This is what i understood from your comment but if this is not the case pls elaborate more.
ThanksDeep
The error you are experiencing is an Oracle database error, specifically ORA-02292. This indicates that the integrity constraint has been violated because there is a child record associated with the record you are trying to delete. The attachment you are trying to remove from the UI may be identified by another record in another table.
To resolve this, you should either remove the child records first or adjust the delete rule in the entity's foreign key definition to automatically handle this, such as using a delete cascade.
Vipin Yadav