13 Replies Latest reply on Oct 21, 2016 9:42 PM by Gianni Ceresa

    How are S_NQ_ERR_MSG/S_NQ_ACCT tables purged?

    skull

      Hi,

       

      We have noticed that the data available in S_NQ_ERR_MSG table is only for last 7 days.  We haven't defined any purge criteria or number of days anywhere while configuring OBIEE.  We would like to keep this data atleast for 30-45 days.

       

      On the other hand, S_NQ_ACCT table is growing and there is no purging mechanism.

       

      Does any one know any parameter/setting that we need to configure?

       

      Thanks.