When Creating a Venue Recovery there is a timeout warning and the Venue Recovery.bak is not created.

Overview

Problem:

• When Creating a VenueRecovery for a Venue that might contain a large qty of Transactions and Translines and TransPayments, you might be presented with the following warning/error message resulting in the VenueRecovery not being created. 

This is caused due to system resources not being able to complete two queries at the end of the Venue Recovery Database create it executes the following two queries 

UPDATE ProdStore set CurrentStockID = 0, FirstStockID = 0, LastStockId = 0 

 

UPDATE Transactions SET Processed = 4

The Limitation here is that these two queries have to execute within intervals of 60 seconds (1 minute)

If for some reason the queries do not run within 1 min, then they will be terminated. 

 

---

Solution:

To work around the system resource issue the following step can be taken to create a Venue Recovery.

 

• Run Database.exe

• Create VenueDataRecovery for VenueID 

• When you get the timeout message shown above 

• Ok, the prompt and close Database.exe

• Open SSMS

• Run the following query

USE VenueRecovery 

UPDATE ProdStore set CurrentStockID = 0, FirstStockID = 0, LastStockId = 0 

UPDATE Transactions SET Processed = 4 

--Create full backup of VenueRecovery

BACKUP DATABASE VenueRecovery
TO DISK = 'C:\\Bepoz\\Backup\\VenueRecovery.bak'
GO 

 

• Zip the VenueRecovery.bak

• Copy to VenueRecovery to Remote Site 

• Restore the Database as per normal

• Run Update Tables within Database.exe - to ensure StoredProcedures are created correctly.

• Job Done

 

---

Linked Issues: