corrupt?? checks on micros 3700

[PaulaBean]

I ran the following command:
select * from micros.chk_dtl
order by chk_open_date_time

It shows that I have 500 checks open. There is one old one from Aug.11/16, and the rest of the transactions range from Mar. 10 to Mar.24, 2017. How do I get rid of these troublesome checks?

I ran: call micros.sp_purgehistory
because I was getting warning messages that 1458 checks hadn't been purged. I had to run it a lot of times before I got that purge check warning to stop, but it finally did. However, these checks are still showing as open.

I ran: select count(*) from micros.trans_dtl
and it shows that I have 14679 -- that number does not go down after running call micros.sp_purgehistory
Shouldn't it be going down?

Can anyone help me please?
TIA

 

[POSN]

Hi Tia,
You will need to close out the 500 checks that are open in the system before you can purge those. If you still receive the 14679++ checks need to be purged error and you ran the purge history stored procedure, you may need a database rebuild. Try closing all open checks and running the purge after to see if this solves the issue.
Good luck!
POSN

 

[PaulaBean]

Thank you for replying!!

When I try to open these checks on the micros POS, it doesn't show any open checks. I could reopen them, but I don't want any of the payments to be voided off, and there's no way to close them once they've been reopened, other than entering a tender. Does that make sense? I'm stuck!

 

[POSN]

what so you get when you run:
select * from MICROS.chk_dtl where chk_open = 't'

 

[PaulaBean]

Just ran it - I get no results

 

[POSN]

That's good. So there are no open checks. Just un-purged checks.
You will need to run micros.sp_purgehistory several times to clear this up.

 

[PaulaBean]

I did that...probably 100 times, and when I run
select * from micros.chk_dtl
it's still showing the same 500 checks in the results field.
When I go to the Plan tab, it says there are 668 number of rows returned, and that number doesn't go down after running the purge.

Any other ideas?

 

[POSN]

It won't get to zero. The purge procedure removes checks after a certain period. The most recent checks don't get purged.
Also, make sure your EOD has purging enabled.

 

[PaulaBean]

Ok thanks so much! So will those rows always be there now, or is there any way to get rid of those?