Purge the EdiInt_InboundMessageIdentity Table RRS feed

  • Question

  • We used to have a solution using EDI/AS2, but this application is no longer in use /existence - but this Table has over 2 million records in it.

    I can't see any reason why this table can't be truncated to remove all the redundant data - i can't see any links to it, it's just used in the SP's to add a new record or query existing data.

    Am i missing something - or is it really this simple?
    Tuesday, June 25, 2019 12:10 PM

All replies

  • I'm pretty sure this table supports the non-repudiation features of AS2.  So, it's not totally surprising it isn't cleaned up automatically.

    Now, 2 million records isn't really a lot but if the app isn't used anymore, the data should be cleaned up.

    My recommendation would be during a downtime, backup MsgBoxDb, export the table and truncate.

    Tuesday, June 25, 2019 9:00 PM