End of Day Hangs on Rolling the Business Date
Problem: Night audit is freezing on Roll business date - No error received.
Cause: This issue can be caused by hanging sessions or cashier-related issue.
Solution :
- To address this issue: Kill all sessions - Try running the Night audit
If problem persists
Check the night audit tables:
- BUSINESSDATE
- NIGHT_AUDIT_JURNAL
- NIGHT_AUDIT_JURNAL_DETAILS
If problem persists
- Check All No Shows
If problem persists
- Check the status of the cashier
select * from cashiers$ where resort='XXXX' (Replace XXXX with the Hotel's resort code)
- If there are cashiers that are still open
Update the status to "closed"
update cashiers$ set state='C' where cashier_id='YYYY' and resort='XXXX' ( Replace YYYY with the cashier ID and XXXXwith the resort code)
- Log back into the Night Audit and run