Pulling error reports from SQL
To be able to pull error reports (to export) from SQL follow this link:
https://atlas.travelctm.com/jira/secure/attachment/51788/failed-rail.sql
select i.id, i.debtoridentifier, i.email, ip.email, ip.itinerarystatusid, ip.clientid, ipr.carriername, ip.createdon, ipr.sabrerailreservationxml, ipr.*, ip.*
from ItineraryPassenger ip
inner join itinerary i
on ip.ItineraryId = i.Id
inner join ItineraryPassengerRail ipr
on ipr.ItineraryPassengerId = ip.Id
where ip.itinerarystatusid in (3) and
i.createdon > '2018-04-23' and i.createdon < '2018-04-24'
order by ip.Id desc
Put the dates you want to search for the errors in, highlight the box and click execute. The data will then appear below and can be copied into Excel.