Delete Message Viewer in BSI

Sort:
You are not authorized to post a reply.
Author
Messages
TJ Mann
Veteran Member
Posts: 70
Veteran Member

    after i deleted a records from Message Viewer thru BSI client, i noted it deleted from 2 tables: bsirun and bsimesa.

    i tried to:

    SQL> delete from bsirun where rundate=20140925;
    delete from bsirun where rundate=20140925
    *
    ERROR at line 1:
    ORA-02292: integrity constraint (TF10.SYS_C004589166) violated - child record
    found

    it won't let me due to bsirun ties up to bsimesa. i need to find a way to delete from bsimesa. bsimesa has no unique field for me to delete.

    if anyone has done this, would you like to share ?

    reason - i want to automate this process so i don't have to login to BSI client, and delete them daily/weekly/monthly.

    You are not authorized to post a reply.