Step 1: Go to local webcheckin database.
Step 2: Verify the mail has sent or not by the system in process tracking table.
Execute the query:
select * from tbprocesstracking where reservationnumber='----'
Step 3: Verify the nlog to check if any error occured.
Execute the query:
select * from tbnlog where reservationnameIDr='----'