Request Database Access via Fresh for [NSB.Communications.Writer.Sagas] and [NSB.Communications.Writer.Timeouts] live databases (both hosted on nServBusAGL).
When access has been granted run the following SQL to check for any sagas that have been processed:
USE [NSB.Communications.Writer.Sagas]
GO
SELECT *
FROM ProposalsSagaData saga
LEFT JOIN [NSB.Communications.Writer.Timeouts].[dbo].[TimeoutEntity] tim ON saga.Id = tim.sagaId
WHERE ClientReferenceNumber IN (*Client Refs from Email Attachment*)
If this query returns any rows you need to action the following steps:
1. Download the attached SQL query template and open it in SQL Server Management Studio
2. Launch Service Insight and connect to live on http://vmnsbpro1app01:33333/api/
3. Copy & paste the saga id into the search text box and press [enter]
4. This should bring back a TimeoutById message
5. Click on the [Headers] tab at the bottom of the screen
6. Follow the instructions provided on the SQL script
7. Repeat steps 3-6 for each affected saga
8. Test the final script against VM01NSBPRODBA01
9. Get a colleague (ideally Mike Clarke) to peer review the script
10. Send to DBAs to be run into live
11. When the ticket comes back to the team re-run the above SQL to confirm the sagas have all processed successfully.