We seem to have experienced a pretty significant increase over the last few months in the number of audit rows created for inserts and deletes on t_cust_rank. I'm seeing some accounts with dozens of inserts and deletes within a couple minutes in the middle of the same night. Initially I thought it may be related to the Membership Update Utility, which causes lp_customer_rank to fire, but we haven't changed our schedule or parameters so I don't know what would have caused the sudden uptick. Has anybody else experienced something similar?
The only apparent issue so far is that it's more challenging to find useful information on somebody's audit tab when one has to scroll through hundreds of t_cust_rank rows, especially considering that we're not currently using the ranking functionality, (though we may start.)
Related question: I assume it would not be a best practice to modify the triggers on t_cust_rank. Is it safe to periodically delete the t_cust_rank rows from the audit table?
I am very new to Tessitura but have ran into this already. We have turned off the triggers, for the time being. We also purged the audit table of duplicates.
In researching this a little further, I believe there is a nightly sql agent job that updates rank as well as a trigger on the t_customer table that updates it when a customer record is updated. You can start to see more if you use select object_name(id) from syscomments where text like '%t_cust_rank%' .
I can send you the script we are going to use (still testing it) to purge the audit table, if you'd like, just let me know.