Tenant Media

Lamba
Lamba Member Posts: 263
in NAV Three Tier
Dear,
I have an issue wrt datbase size. After 1 year of implementation, one of the database size has increased to 405gb, reason is the major change is size of tenant media table.

What is suppose is that attachments of documents & auto email attachments are getting saved in db.

I am thinking correct, if yes, how cani redirect the attachments to any local drive instead of db.

Thanks in advance

Answers

  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    You can navigate to Data administration and do a detachment for now.
    Enable a retention policy for future.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • asmilie2b3
    asmilie2b3 Member Posts: 40
    We have this issue too. I was not aware of the Data Administration page. Looks great, but when I refresh it it fails at about 90%. Would love it if we could set a retention policy to delete tenant media. However the object ID 2000000184 is out of the range of supported IDs BC tells me. We had to have a report made that would delete the Tenant Media based on date range. We run that every three months. We can't automate it as the DB log increases when it runs and that can make BC inoperable.

    Why does MS never seem to get these things right?
  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    @asmilie2b3 - You can execute this in the off Business hours.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • Lamba
    Lamba Member Posts: 263

    Hi @asmilie2b3,

    I still have 2 queries:

    1. After deleting the data from tenant media, is it impacting any processes, like vendor attachments/customerattachments are missing. I have used Truncate table for change log entry & have saved 200 gb of space & saved lot of time in deleting it via report, so is it fine to delete data from this table.
    2. What is the purpose of this table, i.e.; why microsoft added this table, just to record email logs

    🤔

Categories