Overview
Within BEPOZ-3831
There was an enhancement for an additional transaction check within the Transprocessor to ensure that Duplicate transaction are prevented within a Multivenue system setup.
This check now validates the RemoteTransID and check if it already exists within the HO Database before continuing to process the transaction.
Potential Outcomes:
On sites that have already been upgrade to 4.6.1.22 and above there is the situation where a false positive is detected because in the past Remote Venue databases have been restored without the VenueDataRecovery process. This results in an inconsistency with regards to TransactionID’s sequential numbering which results in the HO having RemoteTransID that are non-unique
When using a VenueDataUSB the Database is created without any transactional data and so the TransactionID starts from 1 again, resulting in duplicated RemoteTransID's which are then blocked by the new TransProcessor check.
Example:
Below highlights that at some point in this remote venues life it was restored using VenueDataUSB as now the HO has non sequential RemoteTransID's
DATEBASE.EXE - VenueDataRecovery
VenueDataRecovery has been implemented in Database.exe from BEPOZ 4.5.1 and should be the only form of Remote Venue Database Restoration if the Original Remote Venue Database is lost. The Reason for this option is because when the VenueDatabase is created it includes the Transactional Data, this is to ensure that the RemoteIDs at HO stay unique.
The VenueDataRecovery process should also be used for any NEW Multivenues, VenueDataUSB should NEVER be used at all and is decapitated since BEPOZ 4.5.1
Additional Guides:
Planning an upgrade to 4.6.1.22 and above please perform the following RemoteTransID check at HO first to identify if you have duplicated RemoteTransID's
SQL - Check Headoffice (HO) Database for Duplicated RemoteTransID
Remote Venue sales no longer polling after Upgrade? How to Reseed RemoteTransID at HO and Perform a VenueDataRecovery.
Pending Sales on Smartcontroller after Upgrade to BEPOZ 4.6.1.22 and above
Database.exe - Create Venue Data Recovery