ONH file recovery mechanism

To recover ONH files:

1. Obtain batch IDs of failed batch processes by executing DB query:

   SELECT distinct BatchId 
   FROM TDS_RequestChannels
   WHERE RequestStatusId = 7
   AND Immediacy = 'B'
   AND BatchId is not null
   AND DomainId = (select Domain_ID from System_Domain where Domain_Name = '{community name}');

2. Run batch ONH recovery command for the first BatchID:

   run.bat –domain {community name} –batch {batch process identifier} –recover

3. Resume the batch process for the first BatchID:

   resume-batch.bat {community name} {batch process identifier}

On completion, repeat steps 2-3 for each BatchID returned by the DB query.