We recently upgraded to 5.7 from 5.4 and are getting "XX amount of checks have not been purged" warning on the WSs almost everyday. I end up having run call micros.sp_purgehistory script almost daily in dbisql. Our End of night autosequence has the step set up to purge historical totals and skip step is false yet we still have this issue. I have run the script below and it returned no result.
Select * from micros.chk_dtl
where chk_open = 't'
order by chk_seq
Local micros office has no idea, any ideas on how to resolve?
Thanks
Select * from micros.chk_dtl
where chk_open = 't'
order by chk_seq
Local micros office has no idea, any ideas on how to resolve?
Thanks