Iaorana !

I have an error when i try to delete a record in table tcmcs023.
I have table lrilr249 (specific) with a reference to tcmcs023.citg (attachement file).

When i want to delete the record tcmcs023.citg = 128 i have this error :

2014-07-10[09:21:17]:E:meth3: ******* S T A R T of Error message *******
2014-07-10[09:21:17]:E:meth3: Log message called from /view/port.6.1c.07.17/vobs/tt/lib/dbc/c_func.c: #423 keyword: domain_check
2014-07-10[09:21:17]:E:meth3: Pid 20904 Uid 208 Euid 208 Gid 125 Egid 125
2014-07-10[09:21:17]:E:meth3: user_type S language 4 user_name meth3 tty ote locale ISO88591/NULL
2014-07-10[09:21:17]:E:meth3: Errno 0 bdb_errno 520 (Error during buffered updates)
2014-07-10[09:21:17]:E:meth3: Log_mesg: lrilr249.citg->tcmcs023.citg ; '128 '
2014-07-10[09:21:17]:E:meth3: ******* E N D of Error message *******
2014-07-10[09:21:17]:E:meth3:
2014-07-10[09:21:17]:E:meth3: ******* S T A R T of Error message *******
2014-07-10[09:21:17]:E:meth3: Log message called from /view/port.6.1c.07.17/vobs/tt/mir/mir/bdb_fun.c: #1127 keyword: DB error
2014-07-10[09:21:17]:E:meth3: Pid 20904 Uid 208 Euid 208 Gid 125 Egid 125
2014-07-10[09:21:17]:E:meth3: user_type S language 4 user_name meth3 tty ote locale ISO88591/NULL
2014-07-10[09:21:17]:E:meth3: Errno 0 bdb_errno 605 (Cannot delete record, because reference exists)
2014-07-10[09:21:17]:E:meth3: Log_mesg: Error 605 (Cannot delete record, because reference exists) on tcmcs023400 in db_delete(51)
2014-07-10[09:21:17]:E:meth3: ******* E N D of Error message *******

The record lrilr249.citg = 128 doesn't exists !
I don't understand what happen :eek:

Thanks

françois

Hi,

reorganize tcmcs023 (ttaad4225m000) with option referential integrity selected.

After that, try to delete the record.

Regards,

Red.

Also,

repair reference counters.

Thanks, now it's work fine !