DOTS Customer Support

•    Go to the WebCheckin database and open tables.

•    Execute the following query:

Select top 10 * from tbReservationDetails where ReservationNumber= ‘137329151’ 

•    From that we will get the ReservationNameID  1903821

•    Next check on the tbAuditTrailHeader:

select top 100 * from TbAuditTrailHeader where GeneralIdentifier='137326918'

•    Take the reflected logs and expand the time.

•    Execute the following query:

SELECT TOP (1000) [ID]

      ,[ReservationNameID]

      ,[MachineName]

      ,[Logged]

      ,[Level]

      ,[Message]

      ,[Logger]

      ,[Exception]

      ,[ActionName]

      ,[HostName]

      ,[ApplicationName]

      ,[ActionGroup]

  FROM [KIOSKLOG].[dbo].[tbNLog] where  ActionName='guestCheckin' and Logged between '2023-12-17 21:09:26.763' and '2023-12-17 21:11:26.763'

•    From we understood that failed to payment and the payment type is NO.

•    Then go to kiosk log and using logged between, check the log.

•    There will be a OWS request and OWS response.

•    When we reviewed the request, we discovered that the payment type is cash.

•    This is why the check in failed, despite the fact that we had put the payment type cash on ACI