[-9046]: System error: BD No converter entry

[Former Member]

Hi,

when i try to execute

delete person where oid = 'AAAAAZAT'

i get the message

: System error: BD No converter entry

this table, have many references back, all foreign keys are DELETE CASCADE, i executed many deletes for other tables, and all works, i disabled the redo log, too, any idea?

thanks

Clóvis

[Melanie · Accepted solution]

Hello Clovis,

did you already run a 'CHECK DATA' to check if there are any inconsistencies in your database?

[https://wiki.sdn.sap.com/wiki/x/fSo |https://wiki.sdn.sap.com/wiki/x/fSo ]

Regards,

Melanie

[Former Member · Accepted solution]

Hi Melanie,

I checked the database, and dont have any problem, but i think that i discover the problem, think something like having a table:

CREATE TABLE Person (
    oid VARCHAR(8) NOT NULL,
    my_Parent VARCHAR(8),
    primary key (oid)
)
//
ALTER TABLE Person ADD FOREIGN KEY my_Parent REFERENCES Person(oid) ON DELETE CASCADE
//

Then if i delete a person that can cascade delete many rows from other tables and the same table, and that maybe overflow the system, then the error occurs, if i just set my_Parent to null where my_Parent is equals the Person to be deleted, the commands works well.

best regards

Clóvis

[Melanie · Accepted solution]

Hello Clovis,

could you provide all related table definitions that we can try to reproduce the issue?

Which database version do you use?

Regards,

Melanie