okneb1
11th September 2016, 14:41
I'm getting Error 605, Cannot delete record because reference exists.

I inserted this record myself (In table A), and additional data to three other tables (B, C, D) that have reference to A.

Tables B,C,D are now all empty (in all companies), but I still can't delete the record in A. Table A also has no DAL!

I also tried deleting record with "general table maintenance" and checking eventlog for any information about table that is referencing this record, but no luck. Is there any other LOG that tells what record/table is causing the problem?

mark_h
11th September 2016, 18:23
I don't know about windows os, but in UNIX there is an oracle log in the $BSE/log directory. It might contain more information.

okneb1
12th September 2016, 11:50
Ok, solved it. I used session 'Print References To Parent' (ttaad4229m000) to show all tables that have reference to certain field value.